[Home] [Help] [Dependency Information]
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
=
.
.
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BOM_SMALL_IMPL_TEMP_N1 | NORMAL | NONUNIQUE | SEQUENCE_ID | |
BOM_SMALL_IMPL_TEMP_N2 | NORMAL | NONUNIQUE | CURRENT_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE_ID | NUMBER | 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 | (240) | 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 | 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) | ECO Identifier | |
IMPLEMENTED_FLAG | NUMBER | Indicator if component row is implemented or pending | ||
FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Indicates the first unit number to be included | |
TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Indicates the first unit number to be included | |
PARENT_SORT_CODE | VARCHAR2 | (240) | ||
CURRENT_PK1_VALUE | VARCHAR2 | (50) | ||
CURRENT_PK2_VALUE | VARCHAR2 | (50) | ||
CURRENT_PK3_VALUE | VARCHAR2 | (50) | ||
CURRENT_PK4_VALUE | VARCHAR2 | (50) | ||
CURRENT_PK5_VALUE | VARCHAR2 | (50) | ||
CURRENT_OBJ_NAME | VARCHAR2 | (50) | ||
PARENT_PK1_VALUE | VARCHAR2 | (50) | ||
PARENT_PK2_VALUE | VARCHAR2 | (50) | ||
PARENT_PK3_VALUE | VARCHAR2 | (50) | ||
PARENT_PK4_VALUE | VARCHAR2 | (50) | ||
PARENT_PK5_VALUE | VARCHAR2 | (50) | ||
PARENT_OBJ_NAME | VARCHAR2 | (50) | ||
LOWEST_PK1_VALUE | VARCHAR2 | (50) | ||
LOWEST_PK2_VALUE | VARCHAR2 | (50) | ||
LOWEST_PK3_VALUE | VARCHAR2 | (50) | ||
LOWEST_PK4_VALUE | VARCHAR2 | (50) | ||
LOWEST_PK5_VALUE | VARCHAR2 | (50) | ||
LOWEST_OBJ_NAME | VARCHAR2 | (50) | ||
TOP_ITEM_FLAG | VARCHAR2 | (1) | ||
IMPLOSION_DATE | DATE | |||
CURRENT_GTIN_NUMBER | VARCHAR2 | (25) | ||
CURRENT_GTIN_DESCRIPTION | VARCHAR2 | (240) | ||
CURRENT_TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (240) | ||
PARENT_GTIN_NUMBER | VARCHAR2 | (25) | ||
PARENT_GTIN_DESCRIPTION | VARCHAR2 | (240) | ||
PARENT_TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (240) | ||
LOWEST_GTIN_NUMBER | VARCHAR2 | (25) | ||
LOWEST_GTIN_DESCRIPTION | VARCHAR2 | (240) | ||
LOWEST_TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (240) | ||
PRIMARY_UOM_DESCRIPTOR | VARCHAR2 | (240) | Primary UOM Descriptor | |
STRUCTURE_TYPE_ID | NUMBER | Structure Type Id | ||
GTIN_PUBLICATION_STATUS | VARCHAR2 | (1) | ||
ACCESS_FLAG | VARCHAR2 | (1) | ||
COMPONENT_PATH | VARCHAR2 | (4000) | ||
COMPONENT_ITEM_REVISION_ID | NUMBER | |||
BASIS_TYPE | NUMBER | Basis type identifier | ||
FROM_END_ITEM_REVISION | VARCHAR2 | (3) | ||
TO_END_ITEM_REVISION | VARCHAR2 | (3) | ||
EFFECTIVITY_CONTROL | NUMBER | |||
IS_EXCLUDED_BY_RULE | VARCHAR2 | (1) |
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;
BOM.BOM_SMALL_IMPL_TEMP does not reference any database object
BOM.BOM_SMALL_IMPL_TEMP is referenced by following:
|
|
|