Search Results bom_small_impl_temp_n1

Overview

BOM.BOM_SMALL_IMPL_TEMP is a global temporary table within the Oracle E-Business Suite Bills of Material (BOM) module. It stores transient, session-scoped information describing where a given item is used within a bill of material structure. The item implosion process populates this table by recursively traversing up a bill of material hierarchy from a specified lowest-level item to its top-level assembly, capturing each node encountered along the path. The table is primarily consumed by the View Item Usage window, which renders an indented "where-used" tree for the imploded item.

Because it is a global temporary table with a data duration of SYS$SESSION, rows are visible only to the session that inserted them and are discarded when that session ends. Implosion runs are segmented by SEQUENCE_ID, allowing multiple concurrent implosion processes to coexist within the same session without collision. From a dimensional modeling perspective, the mined metadata classifies this object heuristically as standalone; given its flat, denormalized node-by-node snapshot structure populated from elsewhere in the BOM model, this suggests it functions as neither a reusable hub nor a canonical link, but rather as an operational staging or derived structure for a single-session tree traversal.

Key Information Stored

The table contains 70 documented columns. The most significant are:

• SEQUENCE_ID — the unique identifier for each implosion process; it is also the indexed column of BOM_SMALL_IMPL_TEMP_N1 (nonunique, normal index).
• LOWEST_ITEM_ID — the item being imploded (the starting point at the bottom of the traversal).
• CURRENT_ITEM_ID — the item ID of the current row; indexed by BOM_SMALL_IMPL_TEMP_N2 (nonunique, normal index).
• PARENT_ITEM_ID — the item ID of the parent of the current item.
• ALTERNATE_DESIGNATOR — the alternate bill designation for the current node.
• LOWEST_ALTERNATE_DESIGNATOR — the alternate of each first-level parent of the imploded item.
• CURRENT_LEVEL — the depth of the current node within the structure.
• SORT_CODE / SORT_ORDER — stores the encoding of the node's position in the indented hierarchy; rows must be ordered by sort order to reconstruct the correct bill structure.
• CURRENT_OBJ_NAME / PARENT_OBJ_NAME / LOWEST_OBJ_NAME — the current, parent, and lowest object names respectively, the "current_obj_name" reference being of particular interest to users searching this object.
• CURRENT_PK1_VALUE … CURRENT_PK5_VALUE (and the PARENT_ and LOWEST_ variants) — flexible primary key value columns used to point at the underlying structural entity.
• COMPONENT_SEQUENCE_ID — the component's sequence within the assembly.
• TOP_ITEM_FLAG — indicates whether the row represents the top-level assembly of the implosion.
• ORGANIZATION_ID — the inventory organization context for the implosion.

No single surrogate primary key is documented for this table; SEQUENCE_ID combined with the hierarchical position serves as the de facto retrieval key. Foreign key relationships point to ENG_REVISED_ITEMS (via REVISED_ITEM_SEQUENCE_ID) and BOM_STRUCTURE_TYPES_B (via STRUCTURE_TYPE_ID).

Common Use Cases and Queries

The principal use case is rendering the "where-used" (implosion) tree in the View Item Usage window. A typical query filters by implosion run and orders by the sort code to reproduce the indented structure:

• SELECT CURRENT_ITEM_ID, PARENT_ITEM_ID, CURRENT_LEVEL, CURRENT_OBJ_NAME FROM BOM.BOM_SMALL_IMPL_TEMP WHERE SEQUENCE_ID = :seq ORDER BY SORT_CODE;
• Filtering by CURRENT_ITEM_ID leverages the N2 index to locate all rows for a specific node.
• Reporting on top-level assemblies uses WHERE TOP_ITEM_FLAG = 'Y'.
• Joining to ENG_REVISED_ITEMS on REVISED_ITEM_SEQUENCE_ID enriches each node with revision detail.

Because the table is temporary and session-bound, queries are normally issued within the same session that executed the implosion program.

Related Objects

• ENG_REVISED_ITEMS — referenced via REVISED_ITEM_SEQUENCE_ID; supplies engineering revision context.
• BOM_STRUCTURE_TYPES_B — referenced via STRUCTURE_TYPE_ID; defines the bill structure type.
• BOM_BILL_OF_MATERIALS — the primary BOM definition table underlying implosion data.
• BOM_COMPONENTS_B / BOM_INVENTORY_COMPONENTS — component-level detail from which where-used rows derive.
• MTL_SYSTEM_ITEMS_B — resolution of item IDs to user-facing item numbers.
• BOM_IMPLOSION / View Item Usage (BOMRCWU) — the program and window that generate and consume the temporary rows.