SQL Query for Customer tax registration number in oracle apps r12

SQL Query for Customer tax registration number in oracle apps r12

In this post, We will be discuss about SQL query to extract the Customer tax registration number in oracle apps r12. I will share the Complete SQL query using Different -Different Taxes table to store the Customer Tax related information in Oracle apps.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. Here below please find below the detail SQL Query for Customer tax registration number in oracle apps r12.

 

 

 

SQL Query for Customer tax registration number in oracle apps r12 From  Customer Headers

 

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 for Customer tax registration number in oracle apps r12 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