Search Results substitute_item_quantity

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.

• BOM_SUBSTITUTE_COMPONENTS supplies the substitute component definition, including SUBSTITUTE_COMPONENT_ID, SUBSTITUTE_ITEM_QUANTITY, ACD_TYPE, COMPONENT_SEQUENCE_ID, and CHANGE_NOTICE.
• BOM_INVENTORY_COMPONENTS links the component sequence to the revised item sequence, anchoring the substitute to a specific BOM component line.
• ENG_REVISED_ITEMS provides the revision context, including REVISED_ITEM_SEQUENCE_ID, CHANGE_NOTICE, and ORGANIZATION_ID.
• MTL_SYSTEM_ITEMS_KFV supplies the concatenated item key flexfield segments, padded concatenated segments, primary UOM code, and description for the substitute item.
• MFG_LOOKUPS resolves the ACD_TYPE code into a human-readable ACTION meaning using the ENG_REF_DESIG_ACTION lookup type.

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.