Results for “msc_sr_view_make_at_v”

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

Overview

The APPS.MSC_SR_VIEW_MAKE_AT_V view is a reporting construct within the MSC – Advanced Supply Chain Planning product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its name and definition indicate that it exposes "make at" sourcing relationships, that is, sourcing rules whose associated source type resolves to a manufacturing or internal source rather than a supplier. The view joins receipt organization data to source organization data and then decorates the numeric source type with its user-facing lookup meaning.

The view is not a transactional base table; it is a read-only projection intended for querying, integration extracts, and diagnostics. Because it surfaces the decoded SOURCE_TYPE meaning, it is a convenient reference for users searching on the term mrp_source_type, the lookup type used to translate the internal source type code into readable text. Its principal value in EBS reporting is that it presents sourcing rule receipts, the supplying organization, allocation percentages, and vendor attributes in a single flattened result set, avoiding the need for callers to manually join the receipt and source views and to resolve the MFG_LOOKUPS decoding themselves.

Underlying Base Objects

The documented view is defined over four referenced objects. The primary data comes from MSC_SR_RECEIPT_ORG, accessed through a synonym and aliased as REC, and MSC_SR_SOURCE_ORG_V, a supporting view aliased as SOUR. The join is established on the receipt identifier, REC.SR_RECEIPT_ID = SOUR.SR_RECEIPT_ID. The lookup view MFG_LOOKUPS (aliased LOOK) supplies the descriptive meaning of the source type, and MSC_GET_NAME, documented as a package, is referenced in the view's dependency list for name resolution. The view text restricts the result to source records where SOUR.SOURCE_TYPE equals 2, joined against MFG_LOOKUPS with LOOKUP_TYPE = 'MRP_SOURCE_TYPE' and LOOKUP_CODE matched to the source type. In effect, the view is a filtered, decoded subset of the receipt and source hierarchy, limited to sourcing lines of that specific source type.

Key Columns

• SOURCING_RULE_ID – Identifier of the sourcing rule that governs the relationship.
• SR_RECEIPT_ID – Receipt record identifier linking the receipt and source views.
• RECEIPT_ORGANIZATION_ID – Organization receiving the sourced supply.
• SR_INSTANCE_ID – Planning instance identifier for the sourcing record.
• SR_SOURCE_ID – Identifier of the individual source line.
• SOURCE_TYPE – Decoded meaning of the numeric source type, drawn from the MRP_SOURCE_TYPE lookup.
• SOURCE_ORGANIZATION_ID / SOURCE_ORGANIZATION_CODE – The supplying organization and its code.
• VENDOR_NAME / VENDOR_SITE – Supplier attributes where applicable to the source record.
• ALLOCATION_PERCENT – Percentage of demand allocated to that source.
• RANK – Priority ordering among competing sources for the same receipt.

Common Use Cases and Queries

Typical usages include verifying that a sourcing rule resolves to the intended "make at" organization, auditing allocation percentages and rank across receipts, and feeding source organization data into planning or integration extracts. The decoded SOURCE_TYPE column makes the view self-documenting for report output.

A representative query retrieves all make-at sources for a given receipt organization:

SELECT sourcing_rule_id, sr_receipt_id, receipt_organization_id,
       source_type, source_organization_code, allocation_percent, rank
FROM   apps.msc_sr_view_make_at_v
WHERE  receipt_organization_id = :org_id
ORDER  BY sourcing_rule_id, rank;

Because the view is already filtered to the relevant source type and decodes the lookup internally, consumers searching on mrp_source_type can join or report against it directly without repeating the MFG_LOOKUPS decode or the receipt-to-source join.