Oracle r12 customer tax registration number table

Oracle r12 customer tax registration number table

In this post , We will be discuss about Customer tax registrations number table. Customer Tax Registration table helps to store the Customer Tax related Information's. Oracle apps provides the flexibility in which we can register and store the customer tax relations information's like Tax registrations number in the Customer Master. We can store Customer tax registration number in Customer Header Level and Customer site Level. In this post , I will share the Most important customer tax registration number table and the SQL query to fetch the Oracle r12 customer taxes Information's.

 

2 Most Important Oracle r12 customer tax registration number table

1.ZX_PARTY_TAX_PROFILE

2.ZX_REGISTRATIONS

 

 

SQL Query to Using Oracle r12 customer tax registration number table from Customer Header

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=(select party_id from hz_cust_accounts_all where cust_account_id=:P_CUSTOMER_ID)

 

SQL Query to Using Oracle r12 customer tax registration number table from Customer Sites

 

Party_id column  in the ZX_PARTY_TAX_PROFILE store different values. For Storing Customer Header Tax Information's Party_id column in  ZX_PARTY_TAX_PROFILE

 stores Customer Party Id but to Storing Customer Site Tax Information's Party_id column in  ZX_PARTY_TAX_PROFILE stores that Customer Party Id.

 

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_PARTY_SITE_ID