Search Results effectivity_control




Overview
Explore in AI Chat

Overview

The APPS.BOM_BILL_OF_MATERIALS view is a critical data object within the Oracle E-Business Suite (EBS) Bills of Material (BOM) module for versions 12.1.1 and 12.2.2. It serves as the primary application-level interface for querying bill of material header information. This view is built upon the underlying base table, BOM_STRUCTURES_B, and applies a security filter based on the user's responsibility to ensure data access control. Its fundamental role is to provide a filtered, secure representation of all BOM definitions, which specify the list of components required to build an assembly item within a specific manufacturing organization.

Key Information Stored

The view exposes numerous columns from the base table that define the properties and metadata of a bill. Key columns include ASSEMBLY_ITEM_ID and ORGANIZATION_ID, which uniquely identify the manufactured item and its plant. The BILL_SEQUENCE_ID is the unique system identifier for the BOM header. ALTERNATE_BOM_DESIGNATOR distinguishes between primary and alternate bills. ASSEMBLY_TYPE indicates if the bill is for a standard product, model, option class, or planning. Critical control columns include EFFECTIVITY_CONTROL, which manages date-effective changes, COMMON_BILL_SEQUENCE_ID for shared bills across organizations, and IS_PREFERRED to denote the default alternate. The view also includes audit columns (CREATED_BY, LAST_UPDATE_DATE) and descriptive fields like SPECIFIC_ASSEMBLY_COMMENT.

Common Use Cases and Queries

This view is central to reporting and data extraction processes related to product structures. Common use cases include generating a list of all active bills for an item, identifying alternate BOMs, and supporting product cost roll-up queries by joining to component lines (BOM_INVENTORY_COMPONENTS). A typical query pattern retrieves bill header details along with the item number from MTL_SYSTEM_ITEMS_B.

  • Sample Query: SELECT msib.segment1 Assembly_Item, bbm.* FROM apps.bom_bill_of_materials bbm, apps.mtl_system_items_b msib WHERE bbm.assembly_item_id = msib.inventory_item_id AND bbm.organization_id = msib.organization_id AND bbm.organization_id = 101;
  • Reporting: The view is essential for reports on BOM accuracy, structure comparisons, and engineering change order (ECO) impact analysis, often filtered by EFFECTIVITY_CONTROL and IMPLEMENTATION_DATE.

Related Objects

The BOM_BILL_OF_MATERIALS view has direct relationships with several core BOM and inventory tables. Its primary foreign key relationships, as inferred from the BILL_SEQUENCE_ID and item/organization columns, include:

  • BOM_INVENTORY_COMPONENTS / BOM_BILL_OF_MTL_COMPONENTS: These tables store the component lines for a bill. They join to BOM_BILL_OF_MATERIALS via BILL_SEQUENCE_ID.
  • MTL_SYSTEM_ITEMS_B: The assembly item details are joined using ASSEMBLY_ITEM_ID and ORGANIZATION_ID.
  • BOM_STRUCTURES_B: This is the base table from which the view selects data, applying the responsibility-based WHERE clause filter (e.g., FND_GLOBAL.RESP_APPL_ID = 431).
  • BOM_BILL_OF_MTL_ACTIONS: Related API table for BOM transactions.