Query to get Tax Classification code in R12

Query to get Tax Classification code in R12

Hi friends , we are going to discuss about the Query to get Tax Classification code in R12.We will share the detail sql query which helps to get the tax classification informations in oracle apps r12. This is one of the important sql queries about oracle taxes in r12. Using this sql query , we can find out which are the tax classification codes created in the oracle r12 system. We will also share some of the important tax classification tables too which helps to store the tax classification informations in the oracle r12.Tax classification codes helps in the tax process. 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 Query to get Tax Classification code in R12.

Query to get Tax Classification code in R12

Important Table used by Query to get Tax Classification code in R12

ZX_PARTY_TAX_PROFILE

Detail SQL Query to get Tax Classification code in R12

SQL Query to get Supplier Header Tax classification code in r12

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

SQL Query to get Supplier site Tax classification code in r12

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

SQL Query to get Customer Tax classification code maintained at header level in r12

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)

Query to get Tax Classification code in R12