Oracle Application Express (APEX)

Oracle Application Express - build new applications (Database or Websheet) using Application Builder.

Import / Export (from different enviornment) or create a new one from scratch.

First create workspace.

You may create the application from scratch or from Spreadsheet. It can be an instant application or copy of existing application.

Minimum one page is required in an application.

You can copy Share Components like LOVs from another application.

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;