Search Results msc_sr_view_exp_v




Overview
Explore in AI Chat

Overview

The MSC_SR_VIEW_EXP_V view is an Advanced Supply Chain Planning (MSC) reporting object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes sourcing rule detail at the receipt-organization level, combining receipt organization information with the source organizations and vendors that supply those receipts. Unlike many planning views that focus purely on demand or supply quantities, this view is oriented toward sourcing configuration data — the rules, allocations, ranks, ship methods, and in-transit times that drive how supply is sourced across the supply chain. Its specific relevance to a search for intransit_time stems from the fact that INTRANSIT_TIME is one of the columns projected directly from the underlying source-org view, making MSC_SR_VIEW_EXP_V a convenient and already-joined access point for retrieving transit-time values alongside the sourcing rule and organization context.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view references four base objects: MFG_LOOKUPS (a view aliased as LOOK), the package MSC_GET_NAME, the synonym MSC_SR_RECEIPT_ORG (aliased as REC), and the view MSC_SR_SOURCE_ORG_V (aliased as SOUR). The defining query joins MSC_SR_RECEIPT_ORG to MSC_SR_SOURCE_ORG_V on SR_RECEIPT_ID, then joins MFG_LOOKUPS with lookup type MRP_SOURCE_TYPE to translate the numeric SOURCE_TYPE code into a descriptive SOURCE_TYPE meaning. The view filters out SOURCE_TYPE = 2, meaning certain source types (typically internal transfer-style sources that are handled separately) are deliberately excluded from the result set. MSC_GET_NAME is referenced in the object definition, consistent with its role as the name-resolution utility used across MSC objects to render organization and entity names.

Key Columns

  • SOURCING_RULE_ID — Identifier of the sourcing rule header that governs the source.
  • SR_RECEIPT_ID — The receipt organization record identifier linking source and receipt organizations.
  • RECEIPT_ORGANIZATION_ID / RECEIPT_ORG_INSTANCE_ID — The receiving organization and its source-instance identifier.
  • SOURCE_TYPE — Decoded lookup meaning indicating the type of source (vendor, organization, etc.).
  • SOURCE_ORGANIZATION_ID / SOURCE_ORGANIZATION_CODE — The supplying organization; the ID is defaulted to 0 where null.
  • VENDOR_NAME / VENDOR_SITE — Vendor and site details when the source is an external supplier.
  • ALLOCATION_PERCENT — Percentage allocated to this source within the rule.
  • RANK — Priority ordering of the source within the rule.
  • SHIP_METHOD — Shipping method associated with the source.
  • INTRANSIT_TIME — The in-transit time value used by planning for this source.
  • ORG_VENDOR — A concatenation of SOURCE_ORGANIZATION_CODE and VENDOR_NAME, providing a combined display identifier.

Common Use Cases and Queries

This view is typically used to audit sourcing rules, validate allocation and rank configurations, and extract in-transit times for planning analysis. A representative query to retrieve in-transit times per source is:

  • SELECT SOURCING_RULE_ID, RECEIPT_ORGANIZATION_ID, SOURCE_ORGANIZATION_CODE, VENDOR_NAME, SOURCE_TYPE, INTRANSIT_TIME, RANK, ALLOCATION_PERCENT FROM APPS.MSC_SR_VIEW_EXP_V;

A focused lookup on transit times for a specific receipt organization:

  • SELECT SOURCE_ORGANIZATION_CODE, VENDOR_NAME, SHIP_METHOD, INTRANSIT_TIME FROM APPS.MSC_SR_VIEW_EXP_V WHERE RECEIPT_ORGANIZATION_ID = :org_id ORDER BY RANK;

Because the view already joins receipt organizations to sources and decodes the source type, it removes the need to manually join MSC_SR_RECEIPT_ORG, MSC_SR_SOURCE_ORG_V, and MFG_LOOKUPS, streamlining both ad-hoc reporting and downstream integration queries.