Supplier tax registration table in Oracle Fusion

Supplier tax registration table in oracle fusion

We will be discuss about Supplier tax registration table in oracle fusion. we will be share the supplier tax table which help to store the Supplier tax registrations informations in oracle fusion. In Oracle fusion , we have the tax registration's table which help to store the supplier tax registration's. We will also share the detail sql query to extract the supplier tax registration details in oracle fusion. To extract the supplier tax registration's details , we need to use other important supplier tax tables. We will share that complete list of tables too including the Supplier tax registration table. Here below is the details about Supplier tax registration table in oracle fusion.

Supplier tax registration table in Oracle Fusion

3 Important Tables of Supplier tax registration table in oracle fusion

1.zx_registrations

2.ZX_PARTY_TAX_PROFILE

3.poz_supplier_sites_v 

4.poz_suppliers_v 

SQL Query to Extract Supplier tax registration informations in Oracle Fusion

select distinct a4.vendor_name,a4.segment1,a1.REGISTRATION_NUMBER,a1.TAX_REGIME_CODE,a3.party_site_name from zx_registrations a1,ZX_PARTY_TAX_PROFILE a2,poz_supplier_sites_v a3,poz_suppliers_v a4

where 1=1

and a1.party_tax_profile_id=a2.party_tax_profile_id

and a2.party_id=a3.party_site_id

and a3.vendor_id=a4.vendor_id

and a3.PRC_BU_ID=:BU_ID

Supplier tax registration table in Oracle Fusion