Results for “replenishment_source_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.MRPFV_REPLENISHMENT_SOURCES view is a reporting and integration object within the Oracle E-Business Suite Master Scheduling/MRP (MRP) module. It presents replenishment source definitions maintained in the MRP_SR_SOURCE_ORG entity, resolving the raw identifiers stored on those records into human-readable descriptions. Specifically, the view joins source organization records to inventory organization codes and names, supplier and supplier site names, shipping method descriptions, and the lookup meaning of the source type. This makes it suitable for both operational reporting and integration extracts, particularly in environments where a replenishment source must be communicated to a planning engine, a supplier collaboration interface, or a downstream scheduling process without exposing internal numeric keys.

The view is defined with a WITH READ ONLY clause, confirming that it is intended strictly for query access and cannot be used as an updateable entity. Note the inclusion of the virtual column "_SEC:SR.SOURCE_ORGANIZATION_ID" in the WHERE clause, which enforces Multi-Org security at query execution time through FND_GLOBAL. As a result, the set of rows returned depends on the operating unit context of the session's user.

Underlying Base Objects

The view is defined over the following documented base objects:

• MRP_SR_SOURCE_ORG (synonym to the underlying table) — the primary driving object, holding replenishment source records including source type, source organization, vendor, vendor site, rank, allocation percentage, ship method, and the receipt organization reference.
• MRP_SR_RECEIPT_ORG (synonym) — referenced in a scalar subquery to obtain the RECEIPT_ORGANIZATION_ID associated with each SR_RECEIPT_ID; this parameter is used to validate the inter-org ship method join.
• MTL_PARAMETERS (synonym) — outer-joined on SOURCE_ORGANIZATION_ID to supply the organization code.
• HR_ALL_ORGANIZATION_UNITS (synonym) — outer-joined on SOURCE_ORGANIZATION_ID to supply the organization name.
• PO_VENDORS (view) and PO_VENDOR_SITES_ALL (view) — outer-joined on VENDOR_ID and VENDOR_SITE_ID respectively to resolve supplier and supplier site names.
• MTL_INTERORG_SHIP_METHODS (synonym) — outer-joined on SHIP_METHOD, with the join additionally constrained by FROM_ORGANIZATION_ID and TO_ORGANIZATION_ID when a ship method is present, so that the correct intransit time is retrieved.
• MFG_LOOKUPS (view) — outer-joined on LOOKUP_TYPE = 'MRP_SOURCE_TYPE' and LOOKUP_CODE = SOURCE_TYPE to translate the source type code into its meaning.
• FND_GLOBAL (package) — invoked to resolve the current organization context for the security predicate.

Key Columns

• SOURCE_TYPE — the raw lookup code identifying the replenishment source category (for example, organization or supplier).
• REPLENISHMENT_SOURCE_ID — the internal identifier of the replenishment source record, exposed from SR_SOURCE_ID. This is the value most commonly searched for when tracing a specific source definition.
• REPLENISHMENT_DESTINATION_ID — the destination or receipt reference associated with the source, exposed from SR_RECEIPT_ID.
• SOURCE_ORGANIZATION_ID / SOURCE_ORGANIZATION_CODE / SOURCE_ORGANIZATION_NAME — the source inventory organization identifier, its code from MTL_PARAMETERS, and its name from HR_ALL_ORGANIZATION_UNITS.
• SUPPLIER / SUPPLIER_SITE / SUPPLIER_ID / SUPPLIER_SITE_ID — supplier and supplier site identifiers with their resolved names.
• SHIPPING_METHOD / INTRANSIT_TIME — the ship method code and the related intransit time drawn from the inter-org ship methods definition.
• ALLOCATION_PERCENT — the percentage of demand allocated to this source when multiple sources are ranked.
• RANK — the priority ordering of the source within its allocation set.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard audit columns.

Common Use Cases and Queries

Typical uses include identifying all replenishment sources for a given source organization, reviewing allocation and ranking across competing sources, and auditing supplier-based sourcing. The following query lists active sources by allocation:

SELECT source_organization_code, source_type, supplier, supplier_site, allocation_percent, rank, shipping_method, intransit_time FROM apps.mrpfv_replenishment_sources ORDER BY source_organization_code, rank;

To locate a specific source by its identifier—the term most frequently searched by users—filter on the exposed key column:

SELECT * FROM apps.mrpfv_replenishment_sources WHERE replenishment_source_id = :p_source_id;

Because access is restricted by the Multi-Org security predicate, all queries must be executed in a session whose organization context includes the relevant source organizations. The READ ONLY nature of the view means it can be safely used in concurrent programs and BI Publisher data templates without risk of unintended updates.