Query to get supplier tax registration number in oracle r12

Query to get supplier tax registration number in oracle r12

In this post , We will be discuss about Query to get supplier tax registration number in oracle r12. This query will help to extract the supplier tax registrations details in oracle apps. We do maintain the supplier tax registration informations in different levels in supplier master itself. Here below we will discuss in detail about Query to get supplier tax registration number in oracle r12.

Important Tables used by Query to get supplier tax registration number in oracle r12

1.PO_VENDORS

2.ZX_REGISTRATIONS

3.ZX_PARTY_TAX_PROFILE

Click To Know More

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

Oracle supplier tax registration number Table for supplier Header 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_ID