Results for “bomfv_substitute_bom_comps”

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

Overview

The APPS.BOMFV_SUBSTITUTE_BOM_COMPS view is a Bills of Material (BOM) reporting object in Oracle E-Business Suite, available in release 12.1.1 and 12.2.2. It presents substitute component information for bills of material by combining component, bill, substitute, item, and organization attributes into a single denormalized record set. The view is documented in ETRM as a retrofitted object, meaning it was carried forward from an earlier release architecture into the current technology stack while retaining its original column semantics and public name. Its primary role is to support forms-based inquiry, discoverable reporting, and integration extracts that require substitute component detail without navigating multiple base tables directly. The presence of descriptive flexfield and key flexfield reference columns (the "_DF" and "_KF:" prefixed columns, plus the "_LA:ACD_TYPE" lookup column) confirms that the view is bound to an Oracle Forms or OA Framework block, using the standard flexfield and lookup resolution conventions. The view is granted WITH READ ONLY, so it is strictly a query object and cannot be used to modify BOM substitute data.

Underlying Base Objects

The view definition joins several documented base objects. BOM_BILL_OF_MATERIALS supplies the bill header context, including assembly item, organization, and alternate BOM designator. BOM_INVENTORY_COMPONENTS provides the component line, including component item, operation sequence, and the component sequence used as the join to substitutes. BOM_SUBSTITUTE_COMPONENTS (exposed via a synonym) is the driving table for substitute-specific attributes such as substitute item quantity and change notice. MTL_SYSTEM_ITEMS is joined three times, aliased SY1, SY2, and SY3, to validate the assembly, component, and substitute items respectively, each constrained by organization. MTL_PARAMETERS supplies the organization code, HR_ALL_ORGANIZATION_UNITS supplies the organization name, and FND_GLOBAL is referenced for the security predicate that filters by the user's accessible organizations. Joins are established on SUBSTITUTE_COMPONENT_ID, COMPONENT_ITEM_ID, ASSEMBLY_ITEM_ID, BILL_SEQUENCE_ID, COMPONENT_SEQUENCE_ID, and the common ORGANIZATION_ID across the item and organization tables.

Key Columns

• SUBSTITUTE_ITEM_QUANTITY — the quantity of the substitute item required to replace the standard component; the primary column associated with the search term.
• SUBSTITUTE_COMPONENT_ID — unique identifier of the substitute component row in BOM_SUBSTITUTE_COMPONENTS.
• COMPONENT_SEQUENCE_ID — the parent component line to which the substitute applies.
• ORGANIZATION_ID, ORGANIZATION_CODE, ORGANIZATION_NAME — the inventory organization and its descriptive identifiers.
• ALTERNATE_BOM_CODE — the alternate BOM designator from the bill header.
• OPERATION_SEQUENCE_NUMBER — the routing operation where the component is consumed.
• START_EFFECTIVITY_DATE — derived from the component effectivity date and presented as the substitute's effective start.
• CHANGE_NOTICE — the ECO or change order associated with the substitute line.
• UPDATED_ON, UPDATED_BY, CREATED_ON, CREATED_BY — standard audit columns.

Common Use Cases and Queries

Typical usage includes substitute availability reporting, bill maintenance extracts, and integration feeds to manufacturing execution or planning systems. The organization security predicate restricts results to organizations the current user may access, so the view is safe to expose in Oracle Forms and concurrent program queries. A representative query listing substitutes for a given assembly is:

SELECT organization_code, alternate_bom_code, operation_sequence_number, substitute_item_quantity, change_notice FROM apps.bomfv_substitute_bom_comps WHERE organization_id = :p_org_id ORDER BY alternate_bom_code, operation_sequence_number;

Because substitute item quantity is the measure of interest, aggregate and comparison queries are also common, such as summing substitute quantities per organization or comparing substitute quantity against the base component quantity to evaluate substitution ratios for a given bill and alternate.