Supplier Site Table in Oracle Fusion

Supplier Site Table in Oracle Fusion

We are going to discuss about Supplier Site Table in Oracle Fusion. We will share all the important Supplier Tables in Oracle fusion , which helps to store the supplier information's in oracle fusion. In Oracle Fusion , Supplier tables are totally changed as compared to oracle apps r12. Earlier in oracle apps , Supplier tables started with AP% but in oracle fusion , Suppliers tables started with  POZ%.In this post , i will also share the supplier site tables which helps to store the supplier site information's in oracle fusion. In Oracle fusion , Supplier architecture is  totally different as compared to Oracle apps. We will also discuss about these points in this below post. I will also try to share the Oracle Fusion sql query to extract the supplier and supplier site details in Oracle Fusion.

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

Supplier Site Table in Oracle Fusion

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

Click To Know More

Supplier Site Table in Oracle Fusion