Search Results bom_bill_of_mtls_qf_v




Overview
Explore in AI Chat

Overview

BOM_BILL_OF_MTLS_QF_V is a quick-filter (QF) list of values view owned by the APPS schema in Oracle E-Bills of Material (BOM). Its documented purpose is to serve as a "View for bill of materials list of values" — that is, it drives the bill of materials selection screen and similar LOV windows so that users can pick a specific bill (identified by assembly and bill sequence) rather than querying the underlying base tables directly. In Oracle EBS 12.1.1 and 12.2.2 the object is reported VALID in the ETRM metadata, and it exposes the bill header identity together with descriptive attributes of the assembly item.

Because the view joins the bill of materials definition to the key flexfield view of the item master, it is also useful in reporting and integration contexts. A concurrent program, an Oracle Reports layout, or an outbound interface that needs a flat list of bills-of-material with the assembly item number and its BOM-relevant item attributes can select from this view instead of reconstructing the join. The presence of BOM_ENABLED_FLAG and BOM_ITEM_TYPE among the exposed columns makes it particularly relevant to searches such as "bom_enabled_flag," since the view surfaces the assembly's BOM enablement status directly alongside the bill header information.

Underlying Base Objects

The documented view text joins two objects:

The join predicate is on ORGANIZATION_ID and on ASSEMBLY_ITEM_ID equaling INVENTORY_ITEM_ID, ensuring that the item attributes returned correspond to the assembly defined by the bill, within the same organization. The metadata additionally lists FND_GLOBAL (PACKAGE) among the referenced base objects, which is consistent with standard EBS multi-org security behavior: such views typically restrict results to the current operating unit/organization context resolved through FND_GLOBAL.

Key Columns

  • ORGANIZATION_ID — the inventory organization in which the bill is defined.
  • ALTERNATE_BOM_DESIGNATOR — the alternate bill designation; NULL identifies the primary bill.
  • ASSEMBLY_TYPE — the type of assembly to which the bill applies.
  • ASSEMBLY_ITEM_ID — the inventory item identifier of the assembly (join key to MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID).
  • BILL_SEQUENCE_ID — the unique identifier of the bill header, used as the LOV return value.
  • ITEM_NUMBER — the concatenated segment string (CONCATENATED_SEGMENTS) presented to the user.
  • BOM_ENABLED_FLAG — indicates whether the assembly item is enabled for use in bills of material.
  • BOM_ITEM_TYPE — the BOM item type classification (for example, standard, model, option class, planning bill) that governs bill explosion behavior.

Common Use Cases and Queries

Typical uses include LOV validation in custom forms, data extracts that feed planning or costing processes, and ad hoc reporting that pairs a bill with its assembly's BOM attributes. A representative query filters on the assembly number and the BOM enablement flag:

SELECT organization_id,
      bill_sequence_id,
      item_number,
      alternate_bom_designator,
      bom_enabled_flag,
      bom_item_type
FROM apps.bom_bill_of_mtls_qf_v
WHERE organization_id = :p_org_id
  AND item_number = :p_assembly
  AND bom_enabled_flag = 'Y';

The returned BILL_SEQUENCE_ID can then be passed to the bill detail inquiry, while BOM_ITEM_TYPE and BOM_ENABLED_FLAG allow the caller to screen out items that are not valid BOM assemblies. In all cases, results are subject to the organization security context applied through FND_GLOBAL.