Search Results lowest_alternate_designator

Overview

BOM.BOM_IMPLOSION_TEMP is a global temporary table in the Oracle E-Business Suite Bill of Materials (BOM) module. It stores the transient, session-scoped result set produced by the item implosion process, which recursively travels up a bill of material structure to determine every parent assembly in which a given item is used. The primary consumer of this table is the Item Where Used Report, which reads the exploded upward hierarchy and presents it as an indented, multi-level structure.

Because the table is a global temporary table with a data duration of SYS$SESSION, each concurrent implosion request receives an isolated working set: the current session sees only the rows it inserted, and all rows are removed at session termination. Storage characteristics are PCT Free 10 and PCT Used 40, reflecting a write-once, read-once workload pattern. A single implosion execution is identified by SEQUENCE_ID, allowing multiple independent runs to coexist within one session without collision.

From a dimensional modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. It is best treated as a descriptive, process-scoped satellite that records the outcome of a BOM traversal rather than as a durable hub or link, since its rows exist only for the duration of an implosion session.

Key Information Stored

The documented physical schema contains 28 columns. The most significant are:

• SEQUENCE_ID — the implosion identifier, forming the leading column of the non-unique index BOM_IMPLOSION_TEMP_N1. It is the principal surrogate grouping key for one execution of the implosion process.
• LOWEST_ITEM_ID — the item being imploded, i.e., the starting point at the bottom of the structure.
• CURRENT_ITEM_ID — the inventory_item_id of the row being described.
• PARENT_ITEM_ID — the item id of the immediate parent of the current item; also indexed in BOM_IMPLOSION_TEMP_N1.
• CURRENT_LEVEL — the depth of the current node within the indented structure; indexed for level-restricted reporting.
• SORT_CODE — encodes the position of the node in the indented tree. Ordering rows by SORT_ORDER (derived from SORT_CODE) is mandatory to reconstruct the correct bill structure.
• ALTERNATE_DESIGNATOR and LOWEST_ALTERNATE_DESIGNATOR — the alternate BOM of the current component and of each first-level parent of the imploded item, respectively.
• CURRENT_ASSEMBLY_TYPE — the assembly type classification of the current row; the column most frequently sought when filtering implosion output by assembly category.
• COMPONENT_SEQUENCE_ID — foreign key to BOM_COMPONENTS_B, tying the row to the specific component occurrence.
• REVISED_ITEM_SEQUENCE_ID — foreign key to ENG_REVISED_ITEMS, linking the row to the engineering revision record.
• ORGANIZATION_ID — the inventory organization context for the implosion.
• EFFECTIVITY_DATE and DISABLE_DATE — the effective window of the component relationship.
• COMPONENT_QUANTITY — usage quantity per parent assembly.
• OPERATION_SEQ_NUM — the routing operation sequence associated with the component.
• CHANGE_NOTICE, IMPLEMENTED_FLAG, and BASIS_TYPE — engineering change and quantity-basis attributes.
• REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID — concurrent program audit context.

No unique index is documented; uniqueness of a row is effectively defined by the combination of SEQUENCE_ID, CURRENT_ITEM_ID, SORT_CODE, and alternate designator.

Common Use Cases and Queries

The classic access pattern orders by SORT_CODE within a SEQUENCE_ID to reproduce the indented tree, optionally filtered by level to limit the depth of the display:

• Where-used reporting: retrieve all parents of an item, ordered by SORT_CODE, to build the indented output of the Item Where Used Report.
• Assembly-type filtering: query on CURRENT_ASSEMBLY_TYPE to isolate implosion results belonging to a specific assembly classification.
• Level-bounded exploration: restrict CURRENT_LEVEL to the first one or two levels of parentage.
• Component traceability: join COMPONENT_SEQUENCE_ID to BOM_COMPONENTS_B and REVISED_ITEM_SEQUENCE_ID to ENG_REVISED_ITEMS for engineering detail.

A representative query pattern is: SELECT CURRENT_ITEM_ID, PARENT_ITEM_ID, CURRENT_LEVEL, CURRENT_ASSEMBLY_TYPE FROM BOM.BOM_IMPLOSION_TEMP WHERE SEQUENCE_ID = :seq ORDER BY SORT_CODE; Because of the global temporary semantics, the query must execute in the same session that populated the table.

Related Objects

• BOM.BOM_COMPONENTS_B — referenced via COMPONENT_SEQUENCE_ID; supplies component-level detail for each implosion row.
• ENG.ENG_REVISED_ITEMS — referenced via REVISED_ITEM_SEQUENCE_ID; supplies engineering revision context.
• BOM.BOM_STRUCTURES_B — the base bill structure traversed by the implosion process.
• BOM.BOM_BILL_OF_MATERIALS — header information for the assemblies encountered during implosion.
• INV.MTL_SYSTEM_ITEMS_B — resolves LOWEST_ITEM_ID, CURRENT_ITEM_ID, and PARENT_ITEM_ID to item numbers.
• BOM.BOM_IMPLOSION_TEMP_N1 — the non-unique index on SEQUENCE_ID, CURRENT_LEVEL, and PARENT_ITEM_ID supporting ordered and/or level-filtered retrieval.
• Item Where Used Report — the primary concurrent program consuming this temporary data.
• BOM Item Implosion concurrent program — the process that populates the table.