Search Results mrp_sr_source_org_v




Overview
Explore in AI Chat

Overview

MRP_SR_SOURCE_ORG_V is a PL/SQL view owned by the APPS schema and registered in Oracle E-Business Suite under the MRP (Master Scheduling/MRP) product family. It presents sourcing rule source organization data, joining the sourcing rule source table to vendor master, inter-org shipping method, and inventory organization parameter information into a single denormalized read model. The view is classified as VALID in ETRM for release 12.2.2 and is compatible with 12.1.1 and 12.2.2 environments.

The view does not store data; it is a query-only construct intended for reporting, discovery, and integration consumption. Because Oracle EBS sourcing rules drive supply planning, the fields exposed here — source type, allocation percentage, rank, shipping method, and intransit time — are the key inputs that MRP planning engines use when determining how to satisfy demand across organizations, suppliers, and vendors. Exposing this in a single view removes the need for downstream consumers to reconstruct multi-table joins across MRP, PO, and INV schemas.

Underlying Base Objects

The view is defined over the following documented objects:

  • MRP_SR_SOURCE_ORG (synonym) — the primary source of sourcing rule source organization rows, including allocation percent, rank, source type, and vendor/organization references.
  • MRP_SR_RECEIPT_ORG (synonym) — used in the correlated subquery that resolves the receipt organization for a given sourcing rule receipt.
  • PO_VENDORS (view) — supplies vendor name for outsourced source rows where VENDOR_ID is populated.
  • PO_VENDOR_SITES_ALL (view) — supplies vendor site code for rows with a VENDOR_SITE_ID.
  • MTL_PARAMETERS (synonym) — supplies the organization code for the source inventory organization.
  • MTL_INTERORG_SHIP_METHODS (synonym) — supplies shipping method and intransit time used for inter-org transfers.
  • FND_GLOBAL (package) — referenced for environment and session context used by the view's security logic.

All four lookup joins use the Oracle outer-join (+) operator, so rows in MRP_SR_SOURCE_ORG are retained even when there is no matching vendor, vendor site, organization, or shipping method. The receipt organization subquery, however, is an inner condition inside an OR predicate, so source rows whose shipping method does not resolve to the correct from/to organization pair may still be returned when SHIP_METHOD is NULL.

Key Columns

  • ROW_ID — ROWID from MRP_SR_SOURCE_ORG, providing a unique row identifier for clients.
  • SR_SOURCE_ID — primary key of the sourcing rule source line.
  • SR_RECEIPT_ID — foreign key linking the source row to its receipt organization definition.
  • SOURCE_ORGANIZATION_ID / SOURCE_ORGANIZATION_CODE — the supplying inventory organization and its code from MTL_PARAMETERS.
  • VENDOR_ID / VENDOR_NAME / VENDOR_SITE_ID / VENDOR_SITE — the vendor and site for outsourced sourcing; null for internal transfers.
  • SOURCE_TYPE — enumerated indicator distinguishing organization vs. vendor sourcing.
  • ALLOCATION_PERCENT — the percentage of demand allocated to this source.
  • RANK — priority ordering when multiple sources exist for the same rule.
  • SHIP_METHOD / INTRANSIT_TIME — the inter-org shipping method and its lead time for transfers.
  • Audit columns — LAST_UPDATE_DATE, CREATED_BY, REQUEST_ID, PROGRAM_ID and the standard WHO columns support change tracking and concurrent program lineage.
  • ATTRIBUTE1–15 and ATTRIBUTE_CATEGORY — DFF placeholder values carried through from the base sourcing table.

Common Use Cases and Queries

The view is typically queried to report on sourcing rule configuration, to audit allocation percentages and rankings, and to support custom planning and integration routines that need full source-to-vendor context.

List all sourcing sources for a given rule:

SELECT sr_source_id, source_type, source_organization_code,
       vendor_name, vendor_site, allocation_percent, rank
FROM   apps.mrp_sr_source_org_v
WHERE  sr_receipt_id = :p_receipt_id
ORDER  BY rank, allocation_percent DESC;

Identify outsourcing rules by vendor:

SELECT receipt_id, source_organization_code, vendor_name,
       vendor_site, allocation_percent
FROM   apps.mrp_sr_source_org_v
WHERE  vendor_id IS NOT NULL
AND    allocation_percent > 0;

Compare intransit lead times across shipping methods:

SELECT source_organization_code, ship_method, intransit_time
FROM   apps.mrp_sr_source_org_v
WHERE  ship_method IS NOT NULL
ORDER  BY source_organization_code, intransit_time;

Because the view is read-only and built on outer joins, consumers should treat null VENDOR_ID or SOURCE_ORGANIZATION_ID values as legitimate markers of internal or external sourcing rather than data errors. The DISTINCT keyword in the view definition already de-duplicates potentially inflated rows from the vendor and shipping-method joins.