Tax classification code table in oracle r12

Hi friends, we are going to discuss about the Tax classification code table in oracle r12. We will share the complete table detail and the sql query to get the Tax classification code details in oracle apps r12. Tax classification code table helps to extract the supplier and customer tax details in oracle r12. Using this Tax classification code table and the share the sql query we can develop the tax details related sql query in oracle apps r12. Please find below the complete detail about Tax classification code table in oracle r12.

Tax classification code table in oracle r12

Important Tax classification code table in oracle r12

Here below is the important table helps to extract the Tax classification code details in oracle fusion.

ZX_PARTY_TAX_PROFILE

SQL Query using Tax classification code table to extract the supplier and customer tax information's in oracle apps r12

For Supplier Header Tax classification code 

SELECT A1.REGISTRATION_NUMBER,a2.TAX_CLASSIFICATION_CODE

 FROM ZX_REGISTRATIONS A1,ZX_PARTY_TAX_PROFILE A2

WHERE 1=1

AND ROWNUM=1

AND A1.PARTY_TAX_PROFILE_ID=A2.PARTY_TAX_PROFILE_ID

AND A2.party_id=:P_SUPPLIER_ID

For Supplier Site Tax classification code 

SELECT A1.REGISTRATION_NUMBER,a2.TAX_CLASSIFICATION_CODE  FROM ZX_REGISTRATIONS A1,ZX_PARTY_TAX_PROFILE A2

WHERE 1=1

AND ROWNUM=1

AND A1.PARTY_TAX_PROFILE_ID=A2.PARTY_TAX_PROFILE_ID

AND A2.party_id=:P_SUPPLIER_SITE_ID

For Customer Tax classification code 

SELECT A1.REGISTRATION_NUMBER,a2.TAX_CLASSIFICATION_CODE 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)

Tax classification code table in oracle r12