Search Results sourcing_level




Overview
Explore in AI Chat

Overview

MSC_SCATP_SOURCES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the MSC (Advanced Supply Chain Planning) application. It exposes sourcing information at the item level for supply chain planning and available-to-promise (ATP) computations. The object holds a VALID status in both release 12.1.1 and 12.2.2 and is documented in the E-Business Suite Technical Reference Manual (ETRM).

The view is specifically designed to return the governing sourcing level for a given combination of item, ship-to site, assignment set, and planning session. Because a single item can carry multiple sourcing rules at different levels of specificity — global, category, customer, region, or site — MSC_SCATP_SOURCES_V filters the underlying data so that only the rows representing the highest-priority (lowest numeric) sourcing level are returned. This makes the view suitable for downstream planning logic, integration extracts, and custom reports that need a single deterministic sourcing answer per item and destination.

Underlying Base Objects

The view is defined over MSC_SCATP_ITEM_SR_LEVELS_V, itself a view within the Advanced Supply Chain Planning schema. Its definition performs a correlated subquery against the same underlying view, using an aliased instance (MSISLV1), to select the minimum SOURCING_LEVEL value:

  • The outer query selects from MSC_SCATP_ITEM_SR_LEVELS_V (aliased MSISLV).
  • The subquery identifies MIN(MSISLV1.SOURCING_LEVEL) for the matching SHIP_TO_SITE_ID, INVENTORY_ITEM_ID, SESSION_ID, and ASSIGNMENT_SET_ID.
  • The outer result set is filtered to rows whose SOURCING_LEVEL equals that minimum, eliminating lower-priority sourcing definitions.

Documented referenced base objects include the MSC_SATP_FUNC package, which supplies planning/ATP functional logic underpinning the item sourcing level view, and MSC_SCATP_ITEM_SR_LEVELS_V as the primary data source. Together these objects provide the planning engine with the sourcing resolution required for ATP and supply chain scheduling.

Key Columns

The view exposes the full set of sourcing attributes from the item sourcing level view:

Common Use Cases and Queries

This view is typically queried to determine the effective source of supply for an item, to validate sourcing rule resolution, or to feed custom integrations that require a single approved source. A representative query returning the resolved sourcing for an item in a given session is:

  • SELECT inventory_item_id, source_organization_id, vendor_id, sourcing_rule_name, rank, allocation_percent, sourcing_level FROM msc_scatp_sources_v WHERE inventory_item_id = :p_item AND session_id = :p_session;
  • Joining to MTL_SYSTEM_ITEMS_VL on INVENTORY_ITEM_ID to enrich reports with descriptive item attributes.
  • Filtering on SHIP_TO_SITE_ID or REGION_ID to analyze sourcing by destination or region.
  • Aggregating ALLOCATION_PERCENT and RANK to audit multi-source allocation splits for a rule.

Because SOURCING_LEVEL is already reduced to the minimum value, consumers can rely on the returned rows as the authoritative, deduplicated sourcing result without additional ranking logic.