Search Results bom_bill_of_materials_v




Overview
Explore in AI Chat

Overview

BOM_BILL_OF_MATERIALS_V is an APPS-owned database view within the Oracle E-Business Suite Bills of Material (BOM) module. It presents bill of material header information joined with descriptive item attributes, exposing a denormalized, reporting-friendly representation of assemblies and their BOM definitions across organizations. The view is documented as "Bills of material" and is valid in both EBS 12.1.1 and 12.2.2.

Because the view consolidates data from the core BOM header table with item master attributes and lookup meanings, it is commonly used in reports, concurrent programs, integration extracts, and ad hoc queries that need assembly-level BOM detail without manually joining the item master and lookup tables. It is not an operational transaction table; it is a read-oriented construct intended to simplify retrieval of BOM structures.

Underlying Base Objects

The view is defined over several documented base objects. The primary driver is BOM_BILL_OF_MATERIALS (documented as a VIEW in ETRM 12.2.2), which supplies assembly item identification, bill sequence, alternate designator, effectivity control, and audit columns. MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_TL (documented as SYNONYMs) supply item attributes and the language-specific description respectively. FND_COMMON_LOOKUPS and MFG_LOOKUPS are VIEWs providing decoded lookup meanings, while BOM_STRUCTURE_TYPES_B (SYNONYM) supplies structure type context. FND_GLOBAL (PACKAGE) provides session context through USERENV('LANG') for language filtering.

Joins link assembly item and organization between the BOM and item tables, apply outer joins from the item type to FND_COMMON_LOOKUPS (LOOKUP_TYPE = 'ITEM_TYPE') and from the EAM item type to MFG_LOOKUPS (LOOKUP_TYPE = 'MTL_EAM_ITEM_TYPE'), and resolve structure type through BOM_STRUCTURE_TYPES_B.

Key Columns

Common Use Cases and Queries

A frequent scenario is identifying engineering items in a given organization. The ENG_ITEM_FLAG column allows direct filtering without joining MTL_SYSTEM_ITEMS:

  • SELECT assembly_item_id, organization_id, eng_item_flag, description FROM apps.bom_bill_of_materials_v WHERE organization_id = :org_id AND eng_item_flag = 'Y';

Another common case is extracting all bill headers for an organization with decoded item types:

  • SELECT assembly_item_id, item_type, description, alternate_bom_designator FROM apps.bom_bill_of_materials_v WHERE organization_id = :org_id ORDER BY assembly_item_id;

Users may also audit BOM-enabled items or EAM-related assemblies:

  • SELECT assembly_item_id, bom_enabled_flag, eam_item_type_value FROM apps.bom_bill_of_materials_v WHERE bom_enabled_flag = 'Y';

Because the view applies language filtering via USERENV('LANG'), results reflect the session language. Queries should always constrain ORGANIZATION_ID to limit volume and ensure index use.