Search Results bom_bill_of_materials

Overview

The BOM_BILL_OF_MATERIALS view is a critical data object within the Oracle E-Business Suite Bills of Material (BOM) module. It serves as the primary application view for accessing bill of material (BOM) header information. This view provides a filtered and secure interface to the underlying base table, BOM_STRUCTURES_B, which stores the definition of each BOM, including the assembly item, its organization, and alternate designators. Its role is to centralize access to BOM master data for reporting, integration, and application logic while enforcing data security through its WHERE clause logic, which is based on the user's responsibility application ID.

Key Information Stored

The view exposes all columns from the base table, BOM_STRUCTURES_B. The most significant columns for functional and technical analysis include:

• ASSEMBLY_ITEM_ID and ORGANIZATION_ID: The primary key identifiers for the assembly and the inventory organization where the BOM is defined.
• ALTERNATE_BOM_DESIGNATOR: Identifies an alternate or common BOM; a NULL or blank value indicates the primary bill.
• BILL_SEQUENCE_ID: The unique system-generated identifier for the BOM revision.
• ASSEMBLY_TYPE: Indicates whether the BOM is for a standard assembly (1), a model or option class (2), or a planning bill (3).
• COMMON_ASSEMBLY_ITEM_ID and COMMON_ORGANIZATION_ID: Used for common BOMs, referencing the shared master assembly definition.
• EFFECTIVITY_CONTROL: Determines how component effectivity dates are managed (e.g., 1=Item, 2=Model/Unit Effective).
• PENDING_FROM_ECN: Links to an Engineering Change Notice (ECN) if the BOM is in a pending state.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1-15: Descriptive flexfield columns for custom attributes.

Common Use Cases and Queries

This view is essential for extracting BOM master data for reports, interfaces, and data validation. Common scenarios include listing all primary BOMs for an item, identifying alternate BOMs, and analyzing BOM structures across organizations. A typical query to retrieve active BOM headers for a specific assembly would join with inventory item tables.

SELECT msib.segment1 assembly_item,
       bbm.organization_id,
       bbm.alternate_bom_designator,
       bbm.assembly_type,
       bbm.common_assembly_item_id
FROM   bom_bill_of_materials bbm,
       mtl_system_items_b msib
WHERE  bbm.assembly_item_id = msib.inventory_item_id
AND    bbm.organization_id = msib.organization_id
AND    msib.segment1 = '<ITEM>'
AND    bbm.organization_id = <ORG_ID>
AND    NVL(bbm.alternate_bom_designator, ' ') = ' ';

The view's WHERE clause, which filters based on FND_GLOBAL.RESP_APPL_ID, is crucial for understanding data access patterns in custom programs, ensuring they respect the same security model as the standard application.

Related Objects

The BOM_BILL_OF_MATERIALS view is intrinsically linked to several core BOM and inventory tables and views:

• BOM_STRUCTURES_B: The base table from which this view selects data.
• BOM_INVENTORY_COMPONENTS / BOM_COMPONENTS_B: Store the component lines associated with each BILL_SEQUENCE_ID from this view.
• MTL_SYSTEM_ITEMS_B: Provides item details for the ASSEMBLY_ITEM_ID and COMMON_ASSEMBLY_ITEM_ID.
• BOM_BILL_OF_MTLS_VIEW: A higher-level application view that may join BOM_BILL_OF_MATERIALS with item descriptions for forms and simpler queries.
• ENG_REVISED_ITEMS: Related for managing engineering changes and the PENDING_FROM_ECN column.