Search Results mrp_sr_assignments_u2




Overview
Explore in AI Chat

Overview

APPS.MRP_ITEM_TASK_SR_LEVELS_V is a sourcing-rule resolution view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the APPS schema. It exposes the effective sourcing rules assigned to inventory items at the item-organization assignment level, resolving the chain from a planning organization through sourcing-rule assignments, sourcing rules, receipt organizations, and source organizations to the resulting supply source. The view is one of several MRP_ITEM_TASK_*_LEVELS_V views that together model multi-level sourcing hierarchies; this particular view returns SOURCING_LEVEL = 1, representing the first level of sourcing applicability for a plan.

The view is primarily consumed by Oracle Planning (MRP/MPS) and by sourcing-related reporting and integration logic. Because it flattens sourcing-rule configuration into a single queryable structure, it is useful whenever a developer or analyst needs to determine, for a given item and planning context, which receipt organization, source organization, vendor, or allocation percentage applies. The receipt_org search term maps directly to the MRP_SR_RECEIPT_ORG base table and the RECEIPT_ORGANIZATION_ID predicate inside the view definition, making this view a natural entry point for questions about receipt-organization assignment behavior.

Underlying Base Objects

The documented base objects referenced by the view are:

Joins are driven by indexed access paths documented in the view hint, notably MRP_SR_ASSIGNMENTS_U2, MRP_SOURCING_RULES_U1, MRP_SR_RECEIPT_ORG_U2, and MRP_SR_SOURCE_ORG_U2, with nested-loop joins across the assignment, rule, receipt-org, source-org, and item objects.

Key Columns

Common Use Cases and Queries

Typical uses include validating sourcing-rule setup for a plan, tracing which receipt organization supplies a given item, and building custom sourcing reports that mirror Planner Workbench behavior.

  • List active sourcing rules for an item in a plan organization.
  • Report the receipt organization, source organization, vendor, rank, and allocation percentage for level-1 sourcing.
  • Identify items whose sourcing rules lack a valid effective date or are disabled.

Sample query:

SELECT inventory_item_id, organization_id, sourcing_rule_name, source_type, source_organization_id, vendor_id, allocation_percent, rank, effective_date, disable_date FROM apps.mrp_item_task_sr_levels_v WHERE organization_id = :org_id AND inventory_item_id = :item_id;

To isolate rules tied to a specific receipt organization, join the view to MRP_SR_RECEIPT_ORG on SR_RECEIPT_ID-derived keys or filter using the receipt-organization context, since RECEIPT_ORGANIZATION_ID is applied internally through an NVL against ITEMS.ORGANIZATION_ID. Users searching on "receipt_org" should note this object is the documented bridge between MRP_SR_RECEIPT_ORG and the flattened sourcing output.