CST_SCENARIO_BUILD_WD1_GT
This table is used during the cost rollup background job process to create the Costing work definition snapshot.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the primary output item of the work definition snapshot. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the organization identifier of the primary output item of the work definition snapshot. | |
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | Identifies the fusion manufacturing work definition version identifier. | |
| WORK_METHOD_CODE | VARCHAR2 | 30 | Indicates the work method code of the work definition snapshot. | |
| OUTPUT_TYPE | VARCHAR2 | 30 | Indicates the output item type. Valid values are contained within the lookup ORA_CST_OUTPUT_TYPE. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_BUILD_WD1_GT_N1 | Non Unique | INVENTORY_ITEM_ID, INVENTORY_ORG_ID |