Supplier tax classification code table in oracle fusion

Supplier tax classification code table in oracle fusion

In this post , We will be discuss about Supplier tax classification code table in oracle fusion. We will share the Supplier Tax table which helps to store the Tax Classification code details in oracle fusion. Using this table , We will be able to get the default tax classification code details in oracle fusion. We will also share the detail sql query to extract the supplier tax classification code informations in oracle fusion.

Supplier tax classification code table in oracle fusion

2 Important Supplier tax classification code table in oracle fusion

1.poz_suppliers_v
2.ZX_PARTY_TAX_PROFILE

SQL Query to extract Supplier tax classification informations in oracle fusion

Here below is the detail sql query to extract the supplier tax classification code information's in oracle fusion.

select a1.segment1,a1.VENDOR_NAME,a2.TAX_CLASSIFICATION_CODE
 from poz_suppliers_v A1,ZX_PARTY_TAX_PROFILE A2
where 1=1
and a1.party_id=a2.party_id
and a1.vendor_id in (select vendor_id from poz_supplier_sites_v
where PRC_BU_ID=:P_BU_ID)

Supplier tax classification code table in oracle fusion