[Home] [Help] [Dependency Information]

TABLE: BOM.BOM_SMALL_EXPL_TEMP

Object Details

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

BOM_SMALL_EXPL_TEMP stores temporary, indented bill of material
structures for online processes (Indented Inquiry). The explosion
process (BOMPEXPL) populates this table when exploding a single or a
range of bills of material.
.
GROUP_ID identifies all rows generated from an explosion.
.
TOP_BILL_SEQUENCE_ID is the bill sequence id of the exploded bill.
.
The explosion process constructs SORT_ORDER that correctly determines
the node of the row in the bill structure. You must order the rows by
SORT_ORDER to retrieve the correct bill structure. The following
information shows an example of 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)
=
.
=
Component Sort_order
--------- ----------
A 001
B 001001
C 001002
D 001001001
E 001001002
F 001002001
G 001002002
=
.
When you select and order by SORT_ORDER, you get:
=
A
.B
..D
..E
.C
..F
..G
=
.
The bill loop check process uses COMPONENT_CODE to detect loops.
COMPONENT_CODE stores the concatention of item ids down any branch in
the indented structure tree. The explosion process left pads the ids
with 0s up to 16 characters. For example:
.
=
Component Component_code
--------- ---------------------------------------------
.
A 0000000000000011
B 0000000000000011000000000000012
C 0000000000000011000000000000013
D 0000000000000011000000000000012000000000000014
E 0000000000000011000000000000012000000000000015
F 0000000000000011000000000000013000000000000016
G 0000000000000011000000000000013000000000000017
=
.
The explosion and bill loop check processes set the LOOP_FLAG to 1, if
a loop is detected in the assembly.
.
.
.
.
.

Temporary Table Details

BOM.BOM_SMALL_EXPL_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_EXPL_TEMP_N1	NORMAL	NONUNIQUE		GROUP_ID COMPONENT_SEQUENCE_ID BILL_SEQUENCE_ID COMMON_BILL_SEQUENCE_ID

Columns

Query Text

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

SELECT TOP_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      ORGANIZATION_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      PLAN_LEVEL
,      EXTENDED_QUANTITY
,      SORT_ORDER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GROUP_ID
,      SESSION_ID
,      SELECT_FLAG
,      SELECT_QUANTITY
,      EXTEND_COST_FLAG
,      TOP_ALTERNATE_DESIGNATOR
,      TOP_ITEM_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      HEADER_ID
,      LINE_ID
,      LIST_PRICE
,      SELLING_PRICE
,      COMPONENT_YIELD_FACTOR
,      ITEM_COST
,      INCLUDE_IN_ROLLUP_FLAG
,      BASED_ON_ROLLUP_FLAG
,      ACTUAL_COST_TYPE_ID
,      COMPONENT_QUANTITY
,      SHRINKAGE_RATE
,      SO_BASIS
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      CHECK_ATP
,      SHIPPING_ALLOWED
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      INCLUDE_ON_BILL_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      PICK_COMPONENTS
,      PRIMARY_UOM_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      BASE_ITEM_ID
,      ATP_COMPONENTS_FLAG
,      ATP_FLAG
,      BOM_ITEM_TYPE
,      PICK_COMPONENTS_FLAG
,      REPLENISH_TO_ORDER_FLAG
,      SHIPPABLE_ITEM_FLAG
,      CUSTOMER_ORDER_FLAG
,      INTERNAL_ORDER_FLAG
,      CUSTOMER_ORDER_ENABLED_FLAG
,      INTERNAL_ORDER_ENABLED_FLAG
,      SO_TRANSACTIONS_FLAG
,      MTL_TRANSACTIONS_ENABLED_FLAG
,      STOCK_ENABLED_FLAG
,      DESCRIPTION
,      ASSEMBLY_ITEM_ID
,      CONFIGURATOR_FLAG
,      PRICE_LIST_ID
,      ROUNDING_FACTOR
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      COMPONENT_CODE
,      LOOP_FLAG
,      INVENTORY_ASSET_FLAG
,      PLANNING_FACTOR
,      OPERATION_SEQ_NUM
,      PARENT_BOM_ITEM_TYPE
,      WIP_SUPPLY_TYPE
,      ITEM_NUM
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      IMPLEMENTATION_DATE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      COMPONENT_REMARKS
,      CHANGE_NOTICE
,      OPERATION_LEAD_TIME_PERCENT
,      REXPLODE_FLAG
,      COMMON_BILL_SEQUENCE_ID
,      OPERATION_OFFSET
,      CURRENT_REVISION
,      LOCATOR
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      BASIS_TYPE
FROM BOM.BOM_SMALL_EXPL_TEMP;

Dependencies

[top of page]

BOM.BOM_SMALL_EXPL_TEMP does not reference any database object

BOM.BOM_SMALL_EXPL_TEMP is referenced by following:

APPS

BOM_SMALL_EXPL_TEMP