Results for “mrp_scatp_item_sr_levels_v”

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

Overview

MRP_SCATP_ITEM_SR_LEVELS_V is an Oracle EBS APPS view belonging to the MRP (Master Scheduling/MRP) product family. It exposes Supply Chain ATP (Available-to-Promise) item sourcing levels, presenting the sourcing rules and source organizations that govern how a given inventory item is fulfilled across the supply chain. In Oracle EBS 12.1.1 and 12.2.2, this view is a critical reporting and integration object for organizations that rely on global or supply-chain ATP to promise orders against distributed inventory. Because it combines sourcing rule definitions, assignment data, receipt organization details, and item identifiers into a single queryable structure, it allows planners, order-management teams, and custom applications to determine, without reimplementing Oracle's sourcing logic, which source organizations, vendors, or customer ship-to destinations can satisfy demand for a specific item and location. The view is documented as VALID and is registered in the ETRM repository under the APPS schema.

Underlying Base Objects

The view is defined over several documented base objects. The core sourcing definitions come from MRP_SOURCING_RULES, MRP_SR_ASSIGNMENTS, MRP_SR_SOURCE_ORG, and MRP_SR_RECEIPT_ORG (all exposed as synonyms). Item context is supplied by MTL_SYSTEM_ITEMS and MTL_ITEM_CATEGORIES, while organizational and location information comes from HR_ORGANIZATION_UNITS, HR_GENERAL, and PO_LOCATION_ASSOCIATIONS_ALL. The packages MRP_SCATP_PVT and HR_SECURITY are invoked within the view's SQL to derive default intransit times, ship methods, and security-based organization filters. Notably, the WHERE clause joins source and receipt organizations through SR_RECEIPT_ID, filters on MRP_SOURCING_RULES.STATUS = 1 and SOURCING_RULE_TYPE = 1, restricts receipt organizations to those currently effective (EFFECTIVE_DATE <= SYSDATE and DISABLE_DATE in the future), and requires non-null CUSTOMER_ID and SHIP_TO_SITE_ID on the assignment, indicating that the view is oriented toward customer and ship-to-driven supply chain ATP scenarios.

Key Columns

The view exposes the following notable columns:

• INVENTORY_ITEM_ID — Identifier of the item being sourced, joined from MTL_SYSTEM_ITEMS.
• LOCATION_ID — Two location references appear: PO.LOCATION_ID (internal or supplier location from PO_LOCATION_ASSOCIATIONS_ALL) and ORG.LOCATION_ID (source organization location).
• ASSIGNMENT_TYPE, ASSIGNMENT_SET_ID, ASSIGNMENT_ID — Attributes of the sourcing rule assignment from MRP_SR_ASSIGNMENTS.
• SOURCING_RULE_TYPE, SOURCING_RULE_ID, SOURCING_RULE_NAME, DESCRIPTION — Identity and descriptive fields of the sourcing rule.
• SOURCE_ORGANIZATION_ID, SOURCE_TYPE, VENDOR_ID, VENDOR_SITE_ID, ALLOCATION_PERCENT, RANK — The source organization, source type, vendor, allocation percentage, and ranking of each sourcing entry.
• SOURCING_LEVEL — Derived via DECODE(MSRA.ASSIGNMENT_TYPE, 6, 1, 4, 8), mapping assignment types into sourcing levels.
• EFFECTIVE_DATE, DISABLE_DATE — Validity window of the receipt organization association.
• CATEGORY_ID — Category context from the assignment.
• GET_DEFAULT_INTRANSIT_TIME and GET_DEFAULT_SHIP_METHOD — Computed columns invoking MRP_SCATP_PVT to return intransit time and ship method (truncated to 30 characters).
• CUSTOMER_ID, SHIP_TO_SITE_ID — Customer and ship-to context of the assignment.

Common Use Cases and Queries

Typical uses include diagnosing why an item is or is not promising from a given source, auditing sourcing rule configuration for supply chain ATP, and building custom dashboards that display source organizations ranked by allocation percentage. A representative query is:

• List all sourcing levels for an item: SELECT INVENTORY_ITEM_ID, SOURCE_ORGANIZATION_ID, SOURCING_RULE_NAME, SOURCING_LEVEL, ALLOCATION_PERCENT, RANK FROM APPS.MRP_SCATP_ITEM_SR_LEVELS_V WHERE INVENTORY_ITEM_ID = :item_id ORDER BY SOURCING_LEVEL, RANK;
• Identify effective vendor sources: SELECT INVENTORY_ITEM_ID, VENDOR_ID, VENDOR_SITE_ID, ALLOCATION_PERCENT FROM APPS.MRP_SCATP_ITEM_SR_LEVELS_V WHERE VENDOR_ID IS NOT NULL;
• Review ship method and intransit time per source location: SELECT SOURCE_ORGANIZATION_ID, LOCATION_ID, SOURCING_RULE_NAME FROM APPS.MRP_SCATP_ITEM_SR_LEVELS_V WHERE CUSTOMER_ID = :cust_id;

Because the view filters on active sourcing rules and effective receipt organizations, direct queries return only currently actionable sourcing data, making it suitable for both ad hoc analysis and integration into planning or order-promising extensions.