Customer tax registration number in oracle apps r12

Customer tax registration number in oracle apps r12

In this post , We will discuss about Customer tax registration number in oracle apps r12.Tax registrations means , We need to provide the Custom Tax related information in that registration window. 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 in this Post , I will provide the SQL query and share the Important Tables uses to extract the Customer tax registration number in oracle apps r12.

 

 

 

2 Important Tables for Customer tax registration number

 

1.ZX_PARTY_TAX_PROFILE

2.ZX_REGISTRATIONS

 

SQL Query to Fetch the Customer tax registration number in oracle apps r12 from Customer Header Level

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 Fetch the Customer tax registration number in oracle apps r12 from Customer Site Level

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