How to Restrict Tax Code on Invoice Line Level & Distribution Level (Site Wise or Location Wise)

http://aporaclepayables.blogspot.com/2016/08/blog-post.html

How to Restrict Tax Code on Invoice Line Level (Site Wise or Location Wise)

select g.name name, g.group_id group_id, description

  from ap_awt_groups g

 where exists

 (select 1 from ap_awt_group_taxes t where g.group_id = t.group_id

 and  t.TAX_NAME  in  ( select tc.NAME

 from ap_tax_codes_all tc , ap_supplier_sites_all st

 where  tc.ORG_ID = st.ORG_ID

 and  tc.AWT_VENDOR_SITE_ID =  st.VENDOR_SITE_ID

 and  st.VENDOR_SITE_CODE  =  :INV_SUM_FOLDER.VENDOR_SITE_CODE

 and   tc.ORG_ID = FND_PROFILE.VALUE('ORG_ID')  )

 )

   and nvl(inactive_date, sysdate + 1) > sysdate

 order by name

How to Restrict Tax Code on Invoice Distribution Level (Site Wise or Location Wise)