Oracle Fusion SQL query to Fetch Supplier Tax Related Information's

Oracle Fusion SQL query to Fetch Supplier Tax Related Information's

In this post , I will share the SQL Query and Table which help to fetch and stores the Supplier Tax related information's in the Oracle Cloud. In Oracle Cloud , We have some different tables which helps to store the Vendor Taxes Information's. Please find below the Oracle Fusion SQL query to Fetch Supplier Tax Related Information's.

 

Supplier Taxes Related Tables

1.poz_suppliers

2.poz_supplier_sites

3.zx_registrations

4.POZ_SUP_REG_PII

5.POZ_SUPPLIER_REGISTRATIONS 

6.ZX_PARTY_TAX_PROFILE

 

 

SQL query to Fetch Supplier Tax Related Information's

 

For Individual Supplier if you want to find tax details you can use below query

select HZ_P.party_id from
fusion.poz_suppliers PZ_S inner join Fusion.hz_parties HZ_P
on PZ_S.party_id=HZ_P.party_id
Where SEGMENT1 in ('<supplier Number>' ;


select  *
from fusion.ZX_TAXES_B where TAX= 'VAT'

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