Search Results bom_copy_explosions_v




Overview
Explore in AI Chat

Overview

BOM_COPY_EXPLOSIONS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, registered as VALID in both release 12.1.1 and 12.2.2. It belongs to the Bills of Material (BOM) product family and is documented in ETRM as a "View for Multi level copy structure." Its purpose is to expose the exploded, multi-level structure of a bill of material in a denormalized form suitable for the Copy Bill of Material and Copy Structure processes, where an engineer or planner copies an entire indented assembly from a source organization to a destination organization.

The view does not store data; it is a presentation layer over the BOM_EXPLOSIONS_ALL synonym and the BOM_EXPLODER_PUB PL/SQL package. It therefore returns dynamically derived revision, alternate, and effectivity information rather than a simple projection of a base table. In reporting and integration terms, it is most often consumed by custom reports, conversion scripts, and interface programs that need an indented structure without calling the BOM exploder API directly.

Underlying Base Objects

The documented references for this view are:

Because BOM_EXPLOSIONS_ALL is a synonym over the BOM_EXPLOSIONS table, the view inherits the organization-specific data stored there and combines it with real-time package calls to resolve current revision metadata at query time.

Key Columns

Common Use Cases and Queries

The principal use case is supporting the Copy Structure function, where the exploded rows for a top assembly are read, inspected, and then re-created under a new parent. It is also used for structure comparison reports, cost rollup validation, and data migration of multi-level bills between organizations.

A typical query retrieves the indented structure for a given top item in an organization:

  • SELECT bill_sequence_id, component_sequence_id, plan_level, component_item_id, component_quantity, concatenated_segments, current_revision FROM bom_copy_explosions_v WHERE organization_id = :org_id AND top_item_id = :top_item_id ORDER BY plan_level, sort_order;

To isolate components still effective on a given date:

  • SELECT component_item_id, component_quantity, effectivity_date, disable_date FROM bom_copy_explosions_v WHERE bill_sequence_id = :bill_seq_id AND :check_date BETWEEN effectivity_date AND NVL(disable_date, :check_date);

Because revision and alternate values are resolved through PL/SQL calls, large extractions should be filtered aggressively on ORGANIZATION_ID or TOP_BILL_SEQUENCE_ID to limit the number of package invocations. The view should be treated as read-only; all maintenance is performed through the BOM copy and exploder APIs rather than against this object.