Search Results substitute_component




Overview
Explore in AI Chat

Overview

ENG_WEB_SUB_COMPS_V is an Oracle E-Business Suite view owned by the APPS schema and defined within the Engineering (ENG) product. It exposes revised substitute components that are intended for consumption by Oracle self-service web applications. In the context of EBS 12.1.1 and 12.2.2, this view provides a denormalized, web-friendly projection of engineering substitute component data, joining the substitute definition against inventory item master attributes and lookup meanings so that a self-service page can render the substitute item number, its action code, its primary unit of measure, and its description without performing multiple application-tier lookups.

The object is documented with a status of VALID and is classified as a view rather than a table, meaning it holds no data of its own and derives all rows from its underlying base objects. The documentation title references the revised substitute components, which indicates the view is scoped to substitute relationships that exist within a revised (change-controlled) bill of material context rather than all substitute components defined in the system. This distinction matters for reporting, since only substitutes tied to an engineering revision and its associated change notice will appear in the result set.

Underlying Base Objects

The view text defines joins across five referenced objects: BOM_SUBSTITUTE_COMPONENTS, BOM_INVENTORY_COMPONENTS, ENG_REVISED_ITEMS, MTL_SYSTEM_ITEMS_KFV, and MFG_LOOKUPS. Per the documented metadata, BOM_SUBSTITUTE_COMPONENTS, ENG_REVISED_ITEMS, and MTL_SYSTEM_ITEMS_KFV are surfaced as synonyms in the APPS schema, while BOM_INVENTORY_COMPONENTS and MFG_LOOKUPS are views.

The join conditions enforce that the component sequence and revised item sequence align and that the change notice on the substitute matches the change notice on the revised item.

Key Columns

  • COMPONENT_SEQUENCE_ID — identifier of the BOM component line to which the substitute applies.
  • ACTION — the decoded meaning of the substitute action code (ACD_TYPE) from MFG_LOOKUPS.
  • SUBSTITUTE_COMPONENT — the concatenated segment string of the substitute inventory item.
  • PADDED_CONCATENATED_SEGMENTS — the padded variant of the concatenated segments, useful for aligned display or sorting.
  • SUBSTITUTE_ITEM_QUANTITY — the quantity of the substitute item that replaces the primary component; this is the column most often referenced when users search for substitute_item_quantity.
  • PRIMARY_UOM_CODE — the unit of measure associated with the substitute item, essential for interpreting the quantity value.
  • DESCRIPTION — the item description of the substitute component.

Common Use Cases and Queries

Typical use cases include self-service engineering workbench pages displaying approved substitute components for a revised item, reporting on substitute quantities per change notice, and integration extracts feeding downstream planning or manufacturing systems. A representative query follows:

  • SELECT component_sequence_id, action, substitute_component, substitute_item_quantity, primary_uom_code, description FROM apps.eng_web_sub_comps_v WHERE component_sequence_id = :component_sequence_id;
  • Filtering by organization is achieved through the underlying revised items join; adding WHERE clauses on substitute_component supports item-specific lookups.
  • Sorting on padded_concatenated_segments provides stable, aligned ordering of substitute items in web reports.