[Home] [Help] [Dependency Information]
Object Name: | CST_SC_ROLLUP_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CST_SC_ROLLUP_HISTORY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ROLLUP_ID |
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 |
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;
BOM.CST_SC_ROLLUP_HISTORY does not reference any database object
BOM.CST_SC_ROLLUP_HISTORY is referenced by following:
|
|
|