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

TABLE: BOM.CST_PAC_EXPLOSION_TEMP

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


CST_PAC_EXPLOSION_TEMP stores distinct parent-child combinations of items for a given period and cost group. It is an intermediate table populated during the calculation of low level codes for Periodic Average Costing


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_PAC_EXPLOSION_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAC_PERIOD_ID
ColumnCOST_GROUP_ID
ColumnCOMPONENT_ITEM_ID
CST_PAC_EXPLOSION_TEMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSEMBLY_ITEM_ID
ColumnPAC_PERIOD_ID
ColumnCOST_GROUP_ID
ColumnCOMPONENT_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
PAC_PERIOD_ID NUMBER
Yes Period Identifier
COST_GROUP_ID NUMBER
Yes Cost Group Identifier
ASSEMBLY_ITEM_ID NUMBER

Parent assembly item identifier
COMPONENT_ITEM_ID NUMBER

Child item identifier
DELETED VARCHAR2 (1)
Flag, internally used during computation of low level codes
LOOP_COUNT NUMBER

Counter, internally used during computation of low level codes
Query Text

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


SELECT PAC_PERIOD_ID
,      COST_GROUP_ID
,      ASSEMBLY_ITEM_ID
,      COMPONENT_ITEM_ID
,      DELETED
,      LOOP_COUNT
FROM BOM.CST_PAC_EXPLOSION_TEMP;

Dependencies

[top of page]

BOM.CST_PAC_EXPLOSION_TEMP does not reference any database object

BOM.CST_PAC_EXPLOSION_TEMP is referenced by following:

SchemaAPPS
SynonymCST_PAC_EXPLOSION_TEMP