[Home] [Help] [Dependency Information]

TABLE: BOM.BOM_SMALL_IMPL_TEMP

Object Details

Object Name:	BOM_SMALL_IMPL_TEMP
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.BOM_SMALL_IMPL_TEMP
Subobject Name:
Status:	VALID

BOM_SMALL_IMPL_TEMP stores temporary information about where an item
is used in a bill of material structure. The item implosion process
generates this information by recursively travelling up the bill of
material structure. This table is used by the View Item Usage window.
.
SEQUENCE_ID is the unique identifier for each implosion process.
.
LOWEST_ITEM_ID is the item that you are imploding. CURRENT_ITEM_ID is
the item id of the current row. PARENT_ITEM_ID is the item id of the
parent of the current item. LOWEST_ALTERNATE_DESIGNATOR is the
alternate of each first level parent of the imploded item.
.
SORT_CODE stores information about a particular node in the indented
structure. You must order the rows by SORT_ORDER to retrieve the
correct bill structure. The following example shows how the sort
order is determined (inventory_item_ids are in parentheses).
.
=
A (11)
|
+------+------+
| |
B(12) C(13)
| |
+----+----+ +----+----+
| | | |
D(14) E(15) F(16) G(17)
|
F(16)
=
.
An implosion of item F will generate the following sort orders:
.
=
Item Sort Order
---------- ------------------------------
F 001
D 001001
C 001002
B 001001001
A 001002001
A 001001001001
=
.
When you select and order by SORT_ORDER, you get:
=
F
.D
..B
...A
.C
..A
=
.
.

Temporary Table Details

BOM.BOM_SMALL_IMPL_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_SMALL_IMPL_TEMP_N1	NORMAL	NONUNIQUE		SEQUENCE_ID
BOM_SMALL_IMPL_TEMP_N2	NORMAL	NONUNIQUE		CURRENT_ITEM_ID

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT SEQUENCE_ID
,      LOWEST_ITEM_ID
,      CURRENT_ITEM_ID
,      PARENT_ITEM_ID
,      ALTERNATE_DESIGNATOR
,      CURRENT_LEVEL
,      SORT_CODE
,      LOWEST_ALTERNATE_DESIGNATOR
,      CURRENT_ASSEMBLY_TYPE
,      COMPONENT_SEQUENCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      COMPONENT_QUANTITY
,      REVISED_ITEM_SEQUENCE_ID
,      CHANGE_NOTICE
,      IMPLEMENTED_FLAG
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      PARENT_SORT_CODE
,      CURRENT_PK1_VALUE
,      CURRENT_PK2_VALUE
,      CURRENT_PK3_VALUE
,      CURRENT_PK4_VALUE
,      CURRENT_PK5_VALUE
,      CURRENT_OBJ_NAME
,      PARENT_PK1_VALUE
,      PARENT_PK2_VALUE
,      PARENT_PK3_VALUE
,      PARENT_PK4_VALUE
,      PARENT_PK5_VALUE
,      PARENT_OBJ_NAME
,      LOWEST_PK1_VALUE
,      LOWEST_PK2_VALUE
,      LOWEST_PK3_VALUE
,      LOWEST_PK4_VALUE
,      LOWEST_PK5_VALUE
,      LOWEST_OBJ_NAME
,      TOP_ITEM_FLAG
,      IMPLOSION_DATE
,      CURRENT_GTIN_NUMBER
,      CURRENT_GTIN_DESCRIPTION
,      CURRENT_TRADE_ITEM_DESCRIPTOR
,      PARENT_GTIN_NUMBER
,      PARENT_GTIN_DESCRIPTION
,      PARENT_TRADE_ITEM_DESCRIPTOR
,      LOWEST_GTIN_NUMBER
,      LOWEST_GTIN_DESCRIPTION
,      LOWEST_TRADE_ITEM_DESCRIPTOR
,      PRIMARY_UOM_DESCRIPTOR
,      STRUCTURE_TYPE_ID
,      GTIN_PUBLICATION_STATUS
,      ACCESS_FLAG
,      COMPONENT_PATH
,      COMPONENT_ITEM_REVISION_ID
,      BASIS_TYPE
,      FROM_END_ITEM_REVISION
,      TO_END_ITEM_REVISION
,      EFFECTIVITY_CONTROL
,      IS_EXCLUDED_BY_RULE
FROM BOM.BOM_SMALL_IMPL_TEMP;

Dependencies

[top of page]

BOM.BOM_SMALL_IMPL_TEMP does not reference any database object

BOM.BOM_SMALL_IMPL_TEMP is referenced by following:

APPS

BOM_SMALL_IMPL_TEMP