Query To Get Supplier Qualification Details In Oracle Fusion - Orapoint

This query will help you to get supplier qualification details with certain columns like procurement business unit, qualification number, qualification name, supplier name, supplier site, status, qualification outcome, end date in Oracle Fusion ERP Application.

Supplier Qualification Table:

• POQ_QUALIFICATIONS
• POZ_SUPPLIERS_V
• POZ_SUPPLIER_SITES_ALL_M

SELECT     PRC_BU_ID   PROCUREMENT_BU,
         QUALIFICATION_NUMBER    QUALIFICATIONS,
         QUALIFICATION_NAME,
         SUPPLIER_ID SUPPLIER,
         SUPPLIER_SITE_ID    SUPPLIER_SITE,
         STATUS,
         QUALIFICATION_OUTCOME,
         EFFECTIVE_END_DATE  END_DATE
 FROM     POQ_QUALIFICATIONS
 WHERE    PRC_BU_ID = :1
     AND STATUS = :2
     AND QUALIFICATION_OUTCOME = :3