CST_SCENARIO_ROLLUP_HEADERS_GT
This table contains the temporary results of the rollup process for input components, resources, operations, sub-assemblies and output items.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_SCN_ROLLUP_HDRS_GT_PK |
SCENARIO_ROLLUP_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Yes | Indicates the surrogate identifier generated for rollup headers. | |
| SCENARIO_ID | NUMBER | 18 | Yes | Indicates the scenario from which the rollup header records were created. | |
| INV_ORG_ID | NUMBER | 18 | Yes | Indicates the inventory organization information for which the rollup header is created. | |
| ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of rollup header. Valid values are ITEM, RESOURCE, and OPERATION. | |
| ROLLUP_HEADER_KEY | NUMBER | 18 | Yes | Indicates the identifier of the rollup header type. Valid values are the item identifier, the resource identifier, or the work definition operation identifier. | |
| ROLLUP_HEADER_LEVEL | NUMBER | 9 | Yes | Indicates the level at which the cost rollup should pick up the rollup header for processing. A value of 1 indicates a top level assembly, values greater than 1 indicate the lower level operations and subassemblies, and a value of 0 indicates a resource or input material. | |
| SCENARIO_EVENT_ID | NUMBER | 18 | Yes | Indicates the scenario event from which the rollup header records were created. | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the rollup header. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | |
| SOURCE_TYPE | VARCHAR2 | 30 | Indicates the cost rollup derived source table linked to the rollup header. | ||
| SOURCE_ID | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header. | ||
| COST_UOM_CODE | VARCHAR2 | 3 | Indicates the Costing unit of measure. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Indicates the primary unit of measure. | ||
| COST_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor for converting from the Primary UOM to the Costing UOM. | |||
| POSTED_FLAG | VARCHAR2 | 1 | Indicates if the rolled up cost has been posted to the standard costs table for publishing. Not applicable for resource costs, component costs, or operation level costs. Possible values are Y, N, or X. | ||
| WD_OPERATION_ID | NUMBER | 18 | Indicates the Fusion manufacturing operation identifier as stored in WIS_WD_OPERATIONS_VL. For CTO snapshot data, this identifier can be shared across different assemblies and therefore should only be used to reference the data stored in WIS_WD_OPERATIONS_VL. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ROLLUP_ITEM_TYPE | VARCHAR2 | 30 | Indicates whether the item being rolled up is (1) Standard (2) Purchased CTO (3) Manufactured CTO. | ||
| VAL_UNIT_ID | NUMBER | 18 | Indicates the valuation unit identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_ROLLUP_HDRS_GT_N1 | Non Unique | STATUS_CODE, ROLLUP_HEADER_TYPE, ROLLUP_HEADER_LEVEL |
| CST_SCN_ROLLUP_HDRS_GT_N2 | Non Unique | ROLLUP_HEADER_KEY |
| CST_SCN_ROLLUP_HDRS_GT_PK | Unique | SCENARIO_ROLLUP_HEADER_ID |
| CST_SCN_ROLLUP_HDRS_GT_U1 | Unique | SCENARIO_ID, INV_ORG_ID, ROLLUP_HEADER_TYPE, ROLLUP_HEADER_KEY |