Search Results alt_bom_desig




Overview
Explore in AI Chat

Overview

APPS.BOM_COPY_EXPLOSIONS_V is a reporting and integration view in Oracle E-Business Suite (12.1.1 and 12.2.2) that exposes the results of a bill of material explosion in a flattened, query-friendly form. It presents the contents of BOM_EXPLOSIONS_ALL — the transient table populated by the BOM exploder — joined to item information and augmented with a set of PL/SQL function calls from the BOM_EXPLODER_PUB and BOM_GLOBALS packages. Its purpose is to let callers read a completed explosion (component hierarchy, quantities, effectivity, revisions, and change context) without invoking the exploder API directly. The view is owned by APPS and is typically consumed by concurrent programs, custom reports, and downstream interfaces that copy or replicate exploded structures.

The user search term alt_bom_desig corresponds precisely to a derived column in this view: BOM_GLOBALS.GET_ALTERNATE(be.BILL_SEQUENCE_ID) ALT_BOM_DESIG. The alternate BOM designator identifies which alternate bill of material (for example, a specific alternate routing or engineering alternate) the explosion row belongs to, which is essential when multiple alternates exist for the same assembly.

Underlying Base Objects

  • BOM_EXPLOSIONS_ALL (SYNONYM) — the primary source of the exploded rows, aliased BE in the view text. Supplied the sequence IDs, quantities, flags, revisions, effectivity and PK columns.
  • BOM_EXPLODER_PUB (PACKAGE) — provides the scalar functions used to derive revision, revision label, revision ID, and component access flags on a per-row basis.
  • BOM_GLOBALS (PACKAGE) — supplies GET_ALTERNATE, which resolves the alternate BOM designator from the bill sequence ID.
  • MTL_ITEM_REVISIONS_B (SYNONYM) — revision definitions for items.
  • MTL_SYSTEM_ITEMS_B_KFV (VIEW) — the key flexfield view of items, joined as MSIBK to return CONCATENATED_SEGMENTS for the component item.

Key Columns

Common Use Cases and Queries

The view is used to report exploded structures, audit alternates, and validate revision/change data after a copy explosion.

  • List explosion rows for an organization and top item, showing the alternate designator:
SELECT top_item_id, component_item_id, concatenated_segments,
       component_quantity, alt_bom_desig, revision_code
FROM   apps.bom_copy_explosions_v
WHERE  organization_id = :org_id
AND    top_item_id     = :top_item_id
ORDER  BY plan_level, sort_order;
  • Filter by alternate BOM designator to isolate one alternate:
SELECT bill_sequence_id, component_item_id, alt_bom_desig
FROM   apps.bom_copy_explosions_v
WHERE  alt_bom_desig = :alt_desig;
  • Review revision and change context for affected explosion rows:
SELECT component_sequence_id, revision_code, revision_label,
       change_notice, effectivity_date, disable_date
FROM   apps.bom_copy_explosions_v
WHERE  organization_id = :org_id
AND    effectivity_date >= :from_date;