Sourcing Rules

Navigation:

1. Supply Base >> Sourcing Rules

2. Supply Base >> Assign Sourcing Rules

3. Profile >> MRP: Default Sourcing Assignment Set

Query

SELECT DISTINCT aps.vendor_name,
  msso.vendor_name,
 -- msso.vendor_site_code,
  msso.allocation_percent,
  msso.rank,
  msso.vendor_id,
  msso.vendor_site_id
FROM po_approved_supplier_list pasl, 
      ap_suppliers aps,
      AP_SUPPLIER_SITES_ALL POS,
      mrp_sr_source_org_v msso
WHERE aps.vendor_id = pasl.vendor_id
  AND aps.VENDOR_ID=POS.VENDOR_ID
  AND MSSO.vendor_id=aps.VENDOR_ID
  AND aps.enabled_flag = 'Y'
  AND NVL (pasl.disable_flag, 'N') = 'N'
  AND pasl.owning_organization_id =:p_org
  AND pasl.item_id = :item_id
  AND MSSO.rank=1;