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

TABLE: BOM.CST_SC_ROLLUP_HISTORY

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


CST_SC_ROLLUP_HISTORY stores the complete set of parameters and timing statistics for every Supply Chain Rollup process.
ROLLUP_ID identifies all rows generated by a Supply Chain Rollup.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_SC_ROLLUP_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnROLLUP_ID
Columns
Name Datatype Length Mandatory Comments
ROLLUP_ID NUMBER (15) Yes Supply Chain Rollup identifier
DESCRIPTION VARCHAR2 (240)
Supply Chain Rollup Description
LIST_ID NUMBER (15)
Not currently used
COST_TYPE_ID NUMBER (15)
Cost type identifier
BUY_COST_TYPE_ID NUMBER (15)
Buy cost type identifier
ORGANIZATION_ID NUMBER (15)
Organization identifier
ASSIGNMENT_SET_ID NUMBER (15)
MRP assignment set identifier
CONVERSION_TYPE VARCHAR2 (30)
GL daily conversion type identifier
REPORT_LEVEL NUMBER (15)
Number of levels to report
EXPLOSION_LEVEL NUMBER (15)
Number of levels to explode
ROLLUP_OPTION_TYPE NUMBER (15)
Rollup option, full or single level rollup
REPORT_OPTION_TYPE NUMBER (15)
Report option, with or without print report
RANGE_TYPE NUMBER (15)
Range option
REVISION_DATE DATE

Item/bill revision date
INC_UNIMP_ECN_FLAG NUMBER (15)
Flag indicating whether to include unimplemented ECOs
ENG_BILL_FLAG NUMBER (15)
Flag indicating whether to include engineering items
QTY_PRECISION NUMBER (15)
Quantity precision
ITEM_ID NUMBER (15)
Item identifier
CATEGORY_SET_ID NUMBER (15)
Category set identifier
CATEGORY_ID NUMBER (15)
Category identifier
ALT_BOM_DESG VARCHAR2 (10)
Alternate designator
ALT_RTG_DESG VARCHAR2 (10)
Alternate routing designator
EXPLOSION_TIME NUMBER

Time of explosion in seconds
LOW_LEVEL_CODE_TIME NUMBER

Time of low level code computation in seconds
REMOVE_COSTS_TIME NUMBER

Time of cost purge process in seconds
ROLLUP_TIME NUMBER

Time of cost rollup in seconds
BOM_STRUCTURE_TIME NUMBER

Time of BOM structure generation in seconds
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Who column
PROGRAM_ID NUMBER (15)
Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
Query Text

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


SELECT ROLLUP_ID
,      DESCRIPTION
,      LIST_ID
,      COST_TYPE_ID
,      BUY_COST_TYPE_ID
,      ORGANIZATION_ID
,      ASSIGNMENT_SET_ID
,      CONVERSION_TYPE
,      REPORT_LEVEL
,      EXPLOSION_LEVEL
,      ROLLUP_OPTION_TYPE
,      REPORT_OPTION_TYPE
,      RANGE_TYPE
,      REVISION_DATE
,      INC_UNIMP_ECN_FLAG
,      ENG_BILL_FLAG
,      QTY_PRECISION
,      ITEM_ID
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      ALT_BOM_DESG
,      ALT_RTG_DESG
,      EXPLOSION_TIME
,      LOW_LEVEL_CODE_TIME
,      REMOVE_COSTS_TIME
,      ROLLUP_TIME
,      BOM_STRUCTURE_TIME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_SC_ROLLUP_HISTORY;

Dependencies

[top of page]

BOM.CST_SC_ROLLUP_HISTORY does not reference any database object

BOM.CST_SC_ROLLUP_HISTORY is referenced by following:

SchemaBOM
ViewCST_SC_ROLLUP_HISTORY#