Search Results source_bill_sequence_id




Overview
Explore in AI Chat

Overview

BOM_BILL_OF_MATERIALS is a read-only view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is classified under the BOM (Bills of Material) product family and is documented as a "bill of materials view." Functionally, it exposes bill of material header information rather than component lines, presenting one row per bill structure as stored in the underlying BOM_STRUCTURES_B base table. Because the view is defined with a row-filtering WHERE clause rather than simply projecting all rows, it acts as a responsibility-aware access layer: the filter references FND_GLOBAL.RESP_APPL_ID, meaning the set of bill records returned to a session is influenced by the currently logged-in responsibility and its application. This makes the view suitable for reporting, concurrent programs, and integrations that must respect the same visibility rules applied to BOM application forms.

Underlying Base Objects

The view is defined over two documented base objects. The primary source is BOM_STRUCTURES_B, referenced as a synonym; all projected columns originate from this table. The second reference is FND_GLOBAL, the standard EBS package that exposes session context values such as responsibility, application, and user identifiers. The view text filters on OBJECT_NAME being null and evaluates FND_GLOBAL.RESP_APPL_ID against 431 (the BOM application identifier), -1, and other values, while also applying an EFFECTIVITY_CONTROL condition of less than or equal to 3 when the responsibility does not belong to application 431. Only the _B (base) table is referenced; the view does not join to the translated _TL or _VL variants. Consequently, the view does not expose descriptions or flexfield meaning columns and returns only the base structure rows.

Key Columns

Common Use Cases and Queries

Typical uses include listing all bill headers for an assembly in an organization, verifying alternate designators, and confirming effectivity or preferred status before exploding a structure. The following query returns bill headers for a given assembly and organization:

  • SELECT assembly_item_id, organization_id, alternate_bom_designator, assembly_type, effectivity_control, is_preferred FROM apps.bom_bill_of_materials WHERE assembly_item_id = :item_id AND organization_id = :org_id;
  • SELECT bill_sequence_id, assembly_item_id, organization_id, alternate_bom_designator, implementation_date FROM apps.bom_bill_of_materials WHERE organization_id = :org_id AND alternate_bom_designator = :designator ORDER BY assembly_item_id;
  • SELECT assembly_item_id, COUNT(*) bill_count FROM apps.bom_bill_of_materials WHERE organization_id = :org_id GROUP BY assembly_item_id HAVING COUNT(*) > 1;

Because the result set depends on FND_GLOBAL.RESP_APPL_ID, sessions must be initialized through a valid responsibility. Direct SQL should always qualify the view as APPS.BOM_BILL_OF_MATERIALS, and callers should not assume the view exposes every structure row existing in BOM_STRUCTURES_B.