Search Results bom_implosions_v




Overview
Explore in AI Chat

Overview

BOM_IMPLOSIONS_V is a predefined Oracle E-Business Suite view owned by the APPS schema and shipped as part of the Bill of Materials (BOM) product family. In Oracle EBS 12.1.1 and 12.2.2 it exposes the "where-used" side of a bill of materials — that is, the parent assemblies in which a given component is consumed — as opposed to the standard explosion view (BOM_EXPLOSIONS_V), which walks downward from a parent to its components. ETRM documents the object as a VALID view "for displaying BOM implosions," and this single-purpose definition underpins its role in reporting and integration.

Because the view is defined over the same implosion engine used by the BOM Inquiry "Where Used" window, it is the natural source for any custom report, concurrent program, or interface that must determine where an item is used across organizations without re-implementing the indented bill logic. The view returns one row per occurrence of the current item within a parent structure, carrying both the parent identity and the current item identity, so a single query can return a component together with every assembly above it.

Underlying Base Objects

The view is defined with a driving hint (/*+ LEADING(T) */) over the implosion temporary structure BOM_SMALL_IMPL_TEMP, aliased T. This synonym holds the flattened, temporarily materialized implosion rows populated by the BOM implosion APIs and packages such as BOM_GLOBALS. The view joins that structure to descriptive and validation objects, notably:

Key Columns

Common Use Cases and Queries

The most frequent use is locating every parent consuming a component, often prompted by item number or description. A typical query filters by the current item description:

SELECT organization_code,
       concatenated_segments      parent_item,
       current_concatenated_segments component_item,
       component_quantity,
       current_level
FROM   apps.bom_implosions_v
WHERE  current_description LIKE :component_description
AND    organization_id = :org_id;

Additional scenarios include impact analysis for engineering change orders (joining on CHANGE_NOTICE), multi-level where-used reporting for cost roll-up, and data extraction for downstream planning or master-data governance. Because the view depends on organization security and implosion parameters, callers should always restrict by ORGANIZATION_ID and initialize the BOM/HR security context before querying.