Supplier tax payer id table in oracle fusion : SQL Query to Extract the Supplier Tax Payer Id table in Oracle Fusion

Supplier tax payer id table in oracle fusion : SQL Query to Extract the Supplier Tax Payer Id table in Oracle Fusion 

In this post , we will be discuss about Supplier tax payer id table in oracle fusion. Supplier Tax payer id table helps to store the Vendor Income tax informations in oracle fusion. We will get the Supplier Income Tax id from this Supplier tax payer id table in oracle fusion . I will share the name of the table which help to store the Supplier tax payer id . This table helps in the custom BIP report creation in Oracle Fusion. Please find below the table name and the SQL Query to Extract the Supplier Tax Payer Id table in Oracle Fusion .

Important Supplier tax payer id table in oracle fusion

POZ_SUPPLIERS_PII

SQL Query to Extract the Supplier Tax Payer Id table in Oracle Fusion 

select a1.VENDOR_NAME,

a1.SEGMENT1 SUPPLIER_NUMBER,a2.INCOME_TAX_ID

 from  POZ_SUPPLIERS_PII a1,POZ_SUPPLIERS_V a2

 WHERE a1.VENDOR_ID=a2.vendor_id

and PS.SEGMENT1=:P_SUPPLIER_NUMBER