Results for “sourcing_rule_type”

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

Overview

The APPS.MRP_SCATP_SOURCES_V view is a Supply Chain ATP (Available-to-Promise) sourcing view defined in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It belongs to the MRP — Master Scheduling/MRP product family and exposes the effective sourcing rules that govern how supply is allocated against demand during ATP and supply chain planning calculations. In EBS, sourcing rules determine the ranked sequence of sources (organizations, vendors, or customers) that fulfil a given item at a given destination or ship-to location, including allocation percentages and transit lead times.

Rather than presenting every sourcing level that may exist for an item, the view deliberately resolves a single effective level per item, ship-to site, and assignment set. It achieves this through a correlated subquery that filters MRP_SCATP_ITEM_SR_LEVELS_V to the minimum SOURCING_LEVEL present for the same customer, ship-to site, item, and assignment set. This makes the view a convenient reporting and integration surface for consumers that need the authoritative, highest-priority sourcing data without reconstructing the level-selection logic themselves. The view is commonly consumed by ATP, order promising, and planning inquiry screens, as well as by custom reports and interfaces that must respect configured sourcing precedence.

Underlying Base Objects

The documented metadata identifies the following referenced base objects behind MRP_SCATP_SOURCES_V:

• MRP_SCATP_ITEM_SR_LEVELS_V (VIEW) — the primary projection source, supplying sourcing levels and the level attribute used by the minimum-level filter.
• MRP_SCATP_PVT (PACKAGE) — the supply chain ATP private package that provides the underlying logic for sourcing rule resolution.
• HR_GENERAL (PACKAGE) — the HR foundation package referenced in the dependency chain.
• HR_SECURITY (PACKAGE) — the HR security package, consistent with organization and, in some functional flows, site-level security filtering.

The view text is a straightforward SELECT ... FROM MRP_SCATP_ITEM_SR_LEVELS_V MSISLV WHERE SOURCING_LEVEL = (subquery), so all column semantics and record derivation ultimately trace to the item sourcing levels view and, beneath it, to the SCATP private package. The view owns no storage of its own; it is a pure filter-and-project layer.

Key Columns

• INVENTORY_ITEM_ID — the item being sourced.
• TO_LOCATION_ID / FROM_LOCATION_ID — destination and originating location for the sourcing assignment.
• ASSIGNMENT_TYPE / ASSIGNMENT_SET_ID — the assignment construct that groups sourcing rule assignments.
• SOURCING_RULE_TYPE, SOURCING_RULE_ID, SOURCING_RULE_NAME — identify the sourcing rule and its classification (for example, sourcing rule versus bill of distribution semantics). The SOURCING_RULE_TYPE column is the attribute most frequently queried when users search for sourcing rule type information.
• SOURCE_TYPE, SOURCE_ORGANIZATION_ID, VENDOR_ID, VENDOR_SITE_ID — describe the resolved source, whether internal organization or external supplier site.
• ALLOCATION_PERCENT and RANK — define the split and priority ordering of competing sources.
• AVG_TRANSIT_LEAD_TIME and SHIP_METHOD — transportation characteristics applied to the source.
• EFFECTIVE_DATE, DISABLE_DATE, CATEGORY_ID, ASSIGNMENT_ID — date-effectivity, category scope, and assignment identifiers.
• CUSTOMER_ID, SHIP_TO_SITE_ID — customer and ship-to context against which the minimum sourcing level is evaluated.

Common Use Cases and Queries

Typical scenarios include validating sourcing rule configuration, diagnosing ATP failures, reconciling planned supply against configured sources, and feeding downstream order-promising logic. A common query retrieves the effective sourcing rule type and source for an item at a destination:

SELECT inventory_item_id, sourcing_rule_type, sourcing_rule_name,
source_type, source_organization_id, vendor_id, vendor_site_id,
allocation_percent, rank, avg_transit_lead_time
FROM apps.mrp_scatp_sources_v
WHERE inventory_item_id = :item_id
AND to_location_id = :location_id
ORDER BY rank;

A second pattern examines sourcing rule types across an assignment set, or joins to MTL_SYSTEM_ITEMS_VL for item descriptions. Because the view already eliminates non-minimum sourcing levels, results reflect the effective configuration and are suitable for comparison against planning or order-promising output.