Oracle Fusion supplier tables

Oracle fusion supplier tables

In this post , We will be discuss about oracle Fusion supplier tables. Oracle fusion supplier tables are quite changed as compared to oracle apps r12. These supplier tables help to develop the custom bip reports and help to extract the suppliers informations in oracle fusion. In Oracle fusion , supplier tables do starts with POZ. Here below , Please find below the detail about Oracle Fusion supplier tables.

3 Most Important Oracle Fusion supplier tables

1.POZ_ALL_CONTACTS_V

2.POZ_SUPPLIERS_V

3.POZ_SUPPLIER_SITES_ALL_M

Sql Query Using Oracle Fusion supplier tables

Here below is the Oracle Fusion supplier tables sql query to extract supplier data in Oracle fusion.

SELECT PS.VENDOR_NAME,

PS.SEGMENT1 SUPPLIER_NUMBER,

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

PS.EMPLOYEE_ID,

pvs.vendor_site_spk_id, pvs.vendor_site_id, pvs.effective_end_date,

       pvs.effective_start_date, pvs.effective_sequence,

       pvs.object_version_number, pvs.inactive_date, pvs.vendor_id,

       pvs.prc_bu_id, pvs.location_id, pvs.party_site_id,

       pvs.vendor_site_code, pvs.purchasing_site_flag, pvs.rfq_only_site_flag,

       pvs.pay_site_flag, pvs.tp_header_id, pvs.services_tolerance_id,

       pvs.tolerance_id, pvs.terms_id, pvs.exclude_freight_from_discount,

       pvs.bank_charge_bearer, pvs.pay_on_code, pvs.default_pay_site_id,

       pvs.pay_on_receipt_summary_code, pvs.ece_tp_location_code,

       pvs.global_attribute_timestamp9, pvs.aging_period_days,

       pvs.aging_onset_point, pvs.consumption_advice_frequency,

       pvs.consumption_advice_summary, pvs.pay_on_use_flag,

       pvs.mode_of_transport, pvs.service_level, 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

Click To Know More