Supplier Site Table in Oracle Fusion

 

Types of Supplier Details in Oracle Fusion

In Oracle Fusion, Supplier details are divided into four parts.

1. Supplier Header

2.Supplier Addresses

3.Supplier Sites

4.Supplier Site Assignment

4 Important Supplier Tables in Oracle Fusion

1.POZ_SUPPLIER_SITES_ALL_M

2.POZ_SUPPLIERS_V

3.POZ_SUPPLIER_CONTACTS_V

4.POZ_SITE_ASSIGNMENTS_ALL_M

SQL Query to Extract Supplier detail Using Supplier Site Table 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.vendor_site_code, pvs.purchasing_site_flag,pvs.rfq_only_site_flag,

pvs.pay_site_flag,pvs.pay_on_receipt_summary_code, pvs.ece_tp_location_code,

pvs.pcard_site_flag, pvs.match_option, pvs.country_of_origin_code,

pvs.create_debit_memo_flag, pvs.supplier_notif_method,

pvs.email_address, pvs.primary_pay_site_flag, pvs.shipping_control,

pvs.hold_by,

pvs.hold_date, pvs.hold_flag, pvs.purchasing_hold_reason,

pvs.vendor_site_code_alt,pvs.attention_ar_flag, pvs.area_code,

pvs.phone, pvs.customer_num, pvs.ship_via_lookup_code,

pvs.freight_terms_lookup_code,

pvs.fax_area_code,pvs.payment_priority,

pvs.invoice_amount_limit, 

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,

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