Oracle supplier tax registration number Table

Oracle supplier tax registration number Table

In this post , we will be discuss about Oracle supplier tax registration number Table. we do maintain the Supplier tax registration informations in different locations in the supplier master itself. There are different tables involved in the supplier tax registrations information's in oracle apps. Here below is the complete detail about Oracle supplier tax registration number Table.

Oracle supplier tax registration number Information maintained at two levels.

1. Supplier Header Level

2.Supplier Site Tax Profile level.

Oracle supplier tax registration number Table for Supplier Header Level.

SELECT num_1099 "TAXPAYER_ID" ,

       p.vat_registration_num "TAX_REGISTRATION_NUM"

       FROM PO_VENDORS

Oracle supplier tax registration number Table for supplier Site Tax Profile level 

SELECT A1.REGISTRATION_NUMBER FROM ZX_REGISTRATIONS A1,ZX_PARTY_TAX_PROFILE A2

WHERE 1=1

AND ROWNUM=1

AND A1.PARTY_TAX_PROFILE_ID=A2.PARTY_TAX_PROFILE_ID

AND A2.party_id=:P_SUPPLIER_SITE_ID