Search Results assy_name




Overview
Explore in AI Chat

Overview

APPS.MRP_COMPONENTS_SC_V is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes bill of material (BOM) component data used by the Oracle Manufacturing and Supply Chain planning modules. The suffix "SC" denotes a Supply Chain context, and the view is designed primarily to feed the Planned Order / BOM component inquiry forms and concurrent programs within Oracle MRP (Material Requirements Planning) and MPS (Master Production Scheduling). The name is directly relevant to searches for "wip_supply," because the view joins to the MFG_LOOKUPS view on the WIP_SUPPLY lookup type to resolve the supply type meaning for each component.

The view returns component assembly relationships — the parent ("using") assembly and its child "component" — along with organization, designator, effectivity, and supply-related attributes. It is a read-only, security-agnostic reporting layer that consolidates data normally scattered across planning tables, item master flexfields, and manufacturing lookups. Because MRP_COMPONENTS_SC_V is defined with a UNION ALL between two SELECT statements (the second mirrored block repeats the same column list), it aggregates records from both the standard BOM component source and a parallel source to produce a complete component listing for a given query context (MFQ.QUERY_ID).

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view is owned by APPS and references the following base objects:

  • MRP_BOM_COMPONENTS (synonym, alias ASSY) — the primary fact table supplying the assembly, component, organization, designator, operation sequence, effectivity, and supply type columns.
  • MRP_SYSTEM_ITEMS (synonym, alias DRV) — supplies the driving item's inventory use-up date when a driving item is present.
  • MRP_FORM_QUERY (synonym, alias MFQ) — carries the form query identifier and context used to filter records for a specific user session or concurrent request.
  • MTL_ITEM_FLEXFIELDS (view, aliases ASSY_NAME and COMP_NAME) — joined twice to resolve the descriptive item numbers of the using assembly and the component respectively.
  • MTL_PARAMETERS (synonym, alias PARAM) — provides the organization code for the inventory organization.
  • MFG_LOOKUPS (view, alias LU) — resolves the WIP_SUPPLY_TYPE lookup code into its display meaning.

The join condition LU.LOOKUP_TYPE = 'WIP_SUPPLY' establishes the view's explicit tie to WIP supply types, filtering and decoding the supply semantics for each BOM component.

Key Columns

Common Use Cases and Queries

Typical uses include BOM component inquiry reporting, WIP supply type analysis, and reconstruction of planned component supply. A practical query filtering by organization and designator is shown below:

SELECT QUERY_ID, ITEM_NUMBER, ASSY_NAME, ORGANIZATION_CODE,
COMPILE_DESIGNATOR, OPERATION_SEQ_NUM, MEANING
FROM APPS.MRP_COMPONENTS_SC_V
WHERE ORGANIZATION_CODE = 'M1'
AND ASSY_NAME = 'AS10001';

Analysts also aggregate by supply type to audit component sourcing:

SELECT MEANING, COUNT(*)
FROM APPS.MRP_COMPONENTS_SC_V
GROUP BY MEANING;

Because the view depends on MRP_FORM_QUERY for its QUERY_ID context, it is best invoked from within the originating planning form or a concurrent program that populates that context, rather than as a standalone ad-hoc source.