Query To Get Supplier Details in Oracle Fusion - Orapoint

This query will help you to get supplier details like supplier name, supplier number, supplier site in Oracle Fusion ERP Application.

 SELECT
  PS.SEGMENT1 AS "SUPPLIER NUMBER",
  HP.PARTY_NAME AS "SUPPLIER NAME",
  PSSAM.VENDOR_SITE_CODE AS "SUPPLIER SITE"
FROM
  HZ_PARTIES HP,
  POZ_SUPPLIER_SITES_ALL_M PSSAM,
  POZ_SUPPLIERS PS
WHERE
  PSSAM.PAY_SITE_FLAG = 'Y'
AND PSSAM.VENDOR_ID   = PS.VENDOR_ID
AND PS.PARTY_ID       = HP.PARTY_ID
ORDER BY
  HP.PARTY_NAME;