POQ_ALL_BU_SUPP_ELIGIBILITY_V

Details

• Schema: FUSION

• Object owner: POQ

• Object type: VIEW

Columns

Name
SUPPLIER_ID BU_ID ELIGIBILITY_ID ELIGIBILITY_SUPPLIER_ID ELIGIBILITY_BU_ID SOURCING_ASSESSMENT_ID SOURCING_ELIGIBILITY_CODE SOURCING_COMMENTS SOURCING_ELIG_UPDATED_BY SOURCING_ELIG_UPDATE_DATE SOURCING_ELIG_UPDATE_ACTION

Query

SQL_Statement

SELECT supplier_id supplier_id, bu_id bu_id, eligibility_id, supplier_id eligibility_supplier_id, bu_id eligibility_bu_id, sourcing_assessment_id, sourcing_eligibility_code, sourcing_comments, sourcing_elig_updated_by, sourcing_elig_update_date, sourcing_elig_update_action FROM POQ_SUPPLIER_ELIGIBILITY WHERE bu_id =- 9999 UNION SELECT supp.supplier_id supplier_id, total_pbus.business_unit_id bu_id, supplier_eligibility.eligibility_id, supplier_eligibility.supplier_id eligibility_supplier_id, supplier_eligibility.bu_id eligibility_bu_id, supplier_eligibility.sourcing_assessment_id, NVL(supplier_eligibility.sourcing_eligibility_code,supp.sourcing_eligibility_code) sourcing_eligibility_code, supplier_eligibility.sourcing_comments, supplier_eligibility.sourcing_elig_updated_by, supplier_eligibility.sourcing_elig_update_date, supplier_eligibility.sourcing_elig_update_action FROM FUN_BU_USAGES_V total_pbus, POQ_SUPPLIER_ELIGIBILITY supp, POQ_SUPPLIER_ELIGIBILITY supplier_eligibility WHERE total_pbus.module_key = 'PROCUREMENT_BF' AND total_pbus.status = 'A' AND total_pbus.business_unit_id = supplier_eligibility.bu_id(+) AND supp.bu_id =- 9999 AND supplier_eligibility.supplier_id(+) = supp.supplier_id