eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BOM.CST_EXPLOSION_TEMP

Object Details

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

CST_EXPLOSION_TEMP stores temporary, indented bill of material
structures and is populated during the Cost Rollup process.
GROUP_ID identifies all rows generated by an explosion. DELETED
and LOOP_COUNT are used by the exploder during the explosion process
to compute low level codes.
CST_EXPLOSION_TEMP is used only for full Cost Rollups, for all
items, and when no report is requested in the Cost Rollup.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_EXPLOSION_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSEMBLY_ITEM_ID GROUP_ID LOOP_COUNT
CST_EXPLOSION_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID COMPONENT_ITEM_ID DELETED
CST_EXPLOSION_TEMP_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID PLAN_LEVEL COMPONENT_ITEM_ID

Columns

Name	Datatype	Length	Comments
GROUP_ID	NUMBER		Explosion identifier
ASSEMBLY_ITEM_ID	NUMBER		Assembly item identifier
COMPONENT_ITEM_ID	NUMBER		Component item identifier
DELETED	VARCHAR2	(1)	Indicates if assembly has been assigned a low level code
LOOP_COUNT	NUMBER		Explosion iteration at which assembly is assigned a low level code
TOP_BILL_SEQUENCE_ID	NUMBER		Bill identifier of level 0 items
TOP_ALTERNATE_DESIGNATOR	VARCHAR2	(10)	Alternate designator for level 0
PLAN_LEVEL	NUMBER		Level in bill

Query Text

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


SELECT GROUP_ID
,      ASSEMBLY_ITEM_ID
,      COMPONENT_ITEM_ID
,      DELETED
,      LOOP_COUNT
,      TOP_BILL_SEQUENCE_ID
,      TOP_ALTERNATE_DESIGNATOR
,      PLAN_LEVEL
FROM BOM.CST_EXPLOSION_TEMP;

Dependencies

[top of page]

BOM.CST_EXPLOSION_TEMP does not reference any database object

BOM.CST_EXPLOSION_TEMP is referenced by following:

BOM: CST_EXPLOSION_TEMP#