Supplier address table in oracle fusion

Supplier address table in oracle fusion

In this post , We will be discuss about Supplier address table in oracle fusion. Supplier address tables helps to stores the Supplier addresses in oracle fusion. In Oracle Fusion supplier addresses doesn't store in the supplier specific tables. In oracle fusion supplier address stores in the TCA 'HZ' tables. I will share the that table name the sql query to extract the supplier addresses in oracle fusion using that TCA 'HZ' table. Here below is the complete details about Supplier address table in oracle fusion.

 Supplier address table in oracle fusion

As i said , Supplier address in oracle fusion maintains in the TCA table , here below is the Table name.

1.HZ_LOCATIONS.

hz_locations is the common table  which help to store the address for all type of parties like Supplier , Customers & Others.

SQL Query Using Supplier address table in oracle fusion to extract Supplier Address details

SELECT PS.VENDOR_NAME,

PS.SEGMENT1 SUPPLIER_NUMBER,

NVL2(PS.TAX_REPORTING_NAME, 'Secure', NULL) TAX_REPORTING_NAME,

PS.EMPLOYEE_ID, pvs.vendor_site_code , hzl.address1 address_line1,

       hzl.address2 address_line2, hzl.address3 address_line3,

 hzl.address4 address_line4, hzl.address_style address_style,

hzl.address_lines_phonetic address_lines_alt, hzl.city city,
hzl.state state, hzl.county county, hzl.country country,
 hzl.postal_code zip, hzl.province province,
hzl.location_language language_code, hps.duns_number_c duns_number
FROM poz_supplier_sites_all_m pvs, hz_locations hzl, hz_party_sites hps ,POZ_SUPPLIERS_V PS
WHERE hzl.location_id = pvs.location_id
AND hps.party_site_id = pvs.party_site_id
AND pvs.vendor_id=PS.VENDOR_ID