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)
