Supplier Query
In this post, we will discuss on supplier details in oracle fusion. Supplier play a key role in supply chain management mainly in procurement (P2P process). There are few tables related to supplier which stores supplier details like vendor name, vendor number, VAT information, supplier site code, supplier addresses, supplier business unit. You will find detailed query below this post.
Tables or Views for Supplier in Oracle Fusion
POZ_SUPPLIERS
POZ_SUPPLIER_SITES
POZ_SUPPLIERS_V
POZ_SUPPLIER_SITES_V
POZ_SUPPLIER_SITES_V
SELECT psv.vendor_name,
pssv.vendor_site_code,
psv.segment1 vendor_number,
psv.vendor_id,
pssv.vendor_site_id,
pssv.prc_bu_id bu_id
FROM poz_suppliers_v psv,
poz_supplier_sites_v pssv
WHERE psv.vendor_id = pssv.vendor_id