Search Results mrp_sources_v




Overview
Explore in AI Chat

Overview

MRP_SOURCES_V is a read-only database view owned by the APPS schema within the Master Scheduling/MRP (MRP) product of Oracle E-Business Suite. As documented in the ETRM metadata, its purpose is to expose inventory item sourcing information — the rules that determine how a given item in a given organization is supplied, whether through another organization (transfer), a supplier (purchase), or a customer-facing relationship. The view is classified as VALID and is defined over the confirmed base objects MRP_ASSIGNMENT_SETS and MRP_ITEM_SOURCING_LEVELS_V.

In Oracle EBS 12.1.1 and 12.2.2, sourcing rules and assignment sets are the mechanisms that drive planned supply. Planning engines such as Oracle Master Scheduling/MRP and Advanced Supply Chain Planning rely on this sourcing data to decide where demand should be satisfied. MRP_SOURCES_V provides a denormalized, flattened presentation of the active sourcing level for each item-organization combination, which makes it suitable for reporting, integration, and custom validation logic without requiring callers to navigate the multi-level sourcing hierarchy directly.

Underlying Base Objects

The ETRM documentation confirms that MRP_SOURCES_V is defined over two referenced objects: MRP_ASSIGNMENT_SETS, accessed locally as a synonym, and MRP_ITEM_SOURCING_LEVELS_V, a view. The join is performed on ASSIGNMENT_SET_ID, and the outer query is constrained by a correlated subquery that returns the minimum SOURCING_LEVEL value from MRP_ITEM_SOURCING_LEVELS_V for matching ORGANIZATION_ID, INVENTORY_ITEM_ID, and ASSIGNMENT_SET_ID.

  • MRP_ASSIGNMENT_SETS — supplies the ASSIGNMENT_SET_ID and the assignment-set context used to identify the applicable sourcing rule set.
  • MRP_ITEM_SOURCING_LEVELS_V — supplies the item-level sourcing attributes and the SOURCING_LEVEL used to select the highest-priority (minimum level) rule.

Because the underlying view already performs sourcing-level resolution, MRP_SOURCES_V effectively returns the single governing sourcing entry per item and organization rather than the full hierarchy, which simplifies downstream consumption.

Key Columns

The exposed columns map directly to sourcing rule attributes. The principal ones include:

Common Use Cases and Queries

This view is commonly used to audit sourcing setup, to report the primary source of supply for items, and to feed custom planning or integration processes. A typical query retrieves the resolved source for a specific item and organization:

  • SELECT inventory_item_id, organization_id, source_type, source_organization_id, vendor_id, allocation_percent, rank FROM mrp_sources_v WHERE inventory_item_id = :item AND organization_id = :org;
  • Reporting the active source type distribution: SELECT source_type, COUNT(*) FROM mrp_sources_v GROUP BY source_type;
  • Validating effective sourcing: SELECT * FROM mrp_sources_v WHERE TRUNC(SYSDATE) BETWEEN effective_date AND NVL(disable_date, SYSDATE + 1);
  • Identifying vendor-based sources: SELECT inventory_item_id, organization_id, vendor_id, vendor_site_id FROM mrp_sources_v WHERE vendor_id IS NOT NULL;

Because the view encapsulates sourcing-level resolution logic, it should be preferred over direct queries against the base sourcing tables when the objective is to obtain the single governing source per item and organization.