Supplier Site tax details table in r12

Supplier Site tax details table in r12

In this post , I will share the SQL Query and Table which help to fetch and stores the Supplier Site tax details table in r12. Supplier Header and Sites Tax related information's stores in the Same table but some of the columns in that table stores different - different values for Supplier Header and Supplier Site. In Supplier Tax Detail table ZX_REGISTRATIONS' is the most important table. Please find below the Supplier Site tax details table in r12 and the SQL query to Fetch the Supplier tax Details.

 

 

6 Important Supplier Site tax details table in r12

1.poz_suppliers

2.poz_supplier_sites

3.zx_registrations

4.POZ_SUP_REG_PII

5.POZ_SUPPLIER_REGISTRATIONS

6.ZX_PARTY_TAX_PROFILE

 

For Individual Supplier if you want to find tax details you can use below query

 

select HZ_P.party_id from poz_suppliers PZ_S , hz_parties HZ_P
on PZ_S.party_id=HZ_P.party_id
Where SEGMENT1 :P_SUPPLIER_NUMBER_1;

select  *
from ZX_TAXES_B where TAX= 'VAT'

 

select  PARTY_TYPE_CODE, PARTY_TAX_PROFILE_ID, PARTY_ID, REP_REGISTRATION_NUMBER,
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE
from ZX_PARTY_TAX_PROFILE
where PARTY_ID = :party_id

 

Complete SQL Query for Supplier Site tax details table in r12

 

SELECT A1.REGISTRATION_NUMBER FROM ZX_REGISTRATIONS A1,ZX_PARTY_TAX_PROFILE A2

WHERE TAX_REGIME_CODE='IN GST'

AND EFFECTIVE_TO IS NULL

AND ROWNUM=1

AND A1.PARTY_TAX_PROFILE_ID=A2.PARTY_TAX_PROFILE_ID

AND A2.party_id=:P_SUPPLIER_SITE_ID