DBA Data[Home] [Help] [Dependency Information]

TABLE: BOM.BOM_IMPLOSION_TEMP

Object Details
Object Name: BOM_IMPLOSION_TEMP
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.BOM_IMPLOSION_TEMP
Subobject Name:
Status: VALID


BOM_IMPLOSION_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 Item Where Used Report.
.
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_IMPLOSION_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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
BOM_IMPLOSION_TEMP_N1 NORMAL NONUNIQUE Tablespace ColumnSEQUENCE_ID
ColumnCURRENT_LEVEL
ColumnPARENT_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
SEQUENCE_ID NUMBER (22) Yes Implosion identifier
LOWEST_ITEM_ID NUMBER
Yes Identifier of item to implode
CURRENT_ITEM_ID NUMBER
Yes Item identifier of current component
PARENT_ITEM_ID NUMBER

Assembly item identifier
ALTERNATE_DESIGNATOR VARCHAR2 (10)
Alternate bom designator
CURRENT_LEVEL NUMBER
Yes Implosion level
SORT_CODE VARCHAR2 (2000) Yes Sort sequence
LOWEST_ALTERNATE_DESIGNATOR VARCHAR2 (10)
Alternate bom designator of level 1 items
CURRENT_ASSEMBLY_TYPE NUMBER

Assembly type
COMPONENT_SEQUENCE_ID NUMBER

Component unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
ORGANIZATION_ID NUMBER

Organization identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number
EFFECTIVITY_DATE DATE

Effective date
DISABLE_DATE DATE

Disable date
COMPONENT_QUANTITY NUMBER

Component quantity
REVISED_ITEM_SEQUENCE_ID NUMBER

Revised item unique identifier
CHANGE_NOTICE VARCHAR2 (10)
Engineering change order number
IMPLEMENTED_FLAG NUMBER

Indicator if component row is implemented or pending
BASIS_TYPE NUMBER

Basis type identifier
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
,      BASIS_TYPE
FROM BOM.BOM_IMPLOSION_TEMP;

Dependencies

[top of page]

BOM.BOM_IMPLOSION_TEMP does not reference any database object

BOM.BOM_IMPLOSION_TEMP is referenced by following:

SchemaAPPS
SynonymBOM_IMPLOSION_TEMP