Search Results mrp_source_type




Overview
Explore in AI Chat

Overview

APPS.MRP_SR_VIEW_EXP_V is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes the sourcing rules defined for receipt organizations within Oracle's planning and sourcing engine. It is owned by the APPS schema and is built on top of the underlying sourcing-rule tables and views that support the MRP (Material Requirements Planning) sourcing hierarchy. The view flattens the relationship between a receipt organization (the destination of a supply) and its assigned sourcing sources, such as another inventory organization or a supplier, and resolves the source type to a user-friendly lookup meaning via the MRP_SOURCE_TYPE lookup.

Because sourcing rules are frequently consumed by distribution planning, replenishment, and purchasing integration processes, this view serves as a convenient, denormalized reporting and integration surface. It allows downstream reports, interfaces, and custom concurrent programs to retrieve sourcing rule details without needing to reassemble the base tables and lookups themselves. A notable characteristic is that the view deliberately excludes source type 2, so only a subset of source types is presented.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced objects:

  • MFG_LOOKUPS (VIEW): The standard EBS lookup view, filtered here on LOOKUP_TYPE = 'MRP_SOURCE_TYPE', used to translate the numeric SOURCE_TYPE code into its displayed MEANING.
  • MRP_SR_SOURCE_ORG_V (VIEW): Supplies the individual sourcing sources (SR_SOURCE_ID, organization, vendor, allocation, rank, ship method, in-transit time) associated with a sourcing rule receipt.
  • MRP_SR_RECEIPT_ORG (SYNONYM): Provides the receipt organization side of the sourcing rule (SOURCING_RULE_ID, SR_RECEIPT_ID, RECEIPT_ORGANIZATION_ID) that the sources are attached to.
  • FND_GLOBAL (PACKAGE): Referenced as a base object, consistent with EBS views that resolve the current application/user context (for example, org or responsibility security) during execution.

The view joins MRP_SR_RECEIPT_ORG to MRP_SR_SOURCE_ORG_V on SR_RECEIPT_ID, and joins MFG_LOOKUPS on the source type code, yielding one row per source assigned to each receipt organization's sourcing rule.

Key Columns

  • SOURCING_RULE_ID: Identifier of the sourcing rule header to which the receipt organization belongs.
  • SR_RECEIPT_ID: The receipt organization line identifier; the join key linking receipts to their sources.
  • RECEIPT_ORGANIZATION_ID: The destination organization that receives the supply.
  • SR_SOURCE_ID: Identifier of the individual sourcing source line.
  • SOURCE_TYPE: The lookup meaning (from MFG_LOOKUPS, MRP_SOURCE_TYPE) describing the source type.
  • SOURCE_ORGANIZATION_ID / SOURCE_ORGANIZATION_CODE: The supplying inventory organization; the ID is NVL'd to 0 when absent (that is, for vendor sources).
  • VENDOR_NAME / VENDOR_SITE: Supplier details when the source is an external vendor rather than an internal organization.
  • ALLOCATION_PERCENT: Percentage of demand allocated to this source.
  • RANK: Priority ranking among competing sources.
  • SHIP_METHOD / INTRANSIT_TIME: Shipping method and expected in-transit duration for the source.
  • SOURCE_ORGANIZATION_CODE||VENDOR_NAME: A concatenated display key combining the internal source organization code and vendor name.

Common Use Cases and Queries

Typical scenarios include auditing sourcing rules per receipt organization, validating allocation percentages and ranks, and feeding planning or purchasing integrations. A common query retrieves all sources for a given receipt organization:

  • SELECT sourcing_rule_id, receipt_organization_id, source_type, source_organization_code, vendor_name, allocation_percent, rank FROM apps.mrp_sr_view_exp_v WHERE receipt_organization_id = :org_id;
  • SELECT source_type, COUNT(*) FROM apps.mrp_sr_view_exp_v GROUP BY source_type; to profile distribution of source types.
  • SELECT * FROM apps.mrp_sr_view_exp_v WHERE vendor_name IS NOT NULL; to isolate vendor-based (external) sources.

Because the view filters out SOURCE_TYPE = 2 and relies on MRP_SOURCE_TYPE lookups, queries should account for these constraints when reconciling against the base sourcing tables. Note the metadata marks this content Oracle Proprietary and Confidential.