Tax registration number table in oracle apps

Tax registration number table in oracle apps

In this post , We will be discuss about Tax registrations number table in oracle apps. Tax registration number is the unique Number of an Entity given by the Government Authority of the country from which this entity belongs. 'ZX_REGISTRATIONS' is the most important table for storing the tax related information's. This table helps to store the Tax registration number table in oracle apps. Here below in this post, I will share the Important table to store the Tax registration number table and sql query to extract the Tax registration number in oracle apps.

 

 

5 Important table of Tax registration number  in oracle apps

1.zx_registrations

2.POZ_SUP_REG_PII

3.POZ_SUPPLIER_REGISTRATIONS

4.ZX_PARTY_TAX_PROFILE

5.ZX_TAXES_B

 

SQL Query to Extract the Tax registrations number information in oracle apps For Supplier

select  PARTY_TYPE_CODE, PARTY_TAX_PROFILE_ID, PARTY_ID, REP_REGISTRATION_NUMBER,
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE
from ZX_PARTY_TAX_PROFILE
where PARTY_ID = :party_id
 

select HZ_P.party_id from poz_suppliers PZ_S , hz_parties HZ_P
on PZ_S.party_id=HZ_P.party_id
Where SEGMENT1 :P_SUPPLIER_NUMBER_1;

 

SQL Query to Extract the Tax registrations number information in oracle apps For Customers

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)