CST_SCENARIO_BUILD_WU_GT
This table is used during the cost rollup background job process for where used rollup scope processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Indicates the scenario identifier based on which the request to create the snapshot for the item is created from. | |
| OUTPUT_ITEM_ORG | VARCHAR2 | 37 | Indicates the concatenated output item and organization identifiers. | |
| INPUT_ITEM_ORG | VARCHAR2 | 37 | Indicates the concatenated input item and organization identifiers. | |
| OUTPUT_INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the primary output item of the work definition snapshot. | |
| OUTPUT_INVENTORY_ORG_ID | NUMBER | 18 | Indicates the organization identifier of the primary output item of the work definition snapshot. | |
| MATERIAL_INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the material identifier of the material used in the work definition operation. | |
| MATERIAL_INVENTORY_ORG_ID | NUMBER | 18 | Indicates the organization in which the material is defined. | |
| RESOURCE_ID | NUMBER | 18 | Indicates the resource used for the work definition operation. | |
| WHERE_USED_INPUT_FLAG | VARCHAR2 | 1 | Indicates the initial start with records for where used processing. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_BUILD_WU_GT_N1 | Non Unique | SCENARIO_ID, MATERIAL_INVENTORY_ITEM_ID |
| CST_SCN_BUILD_WU_GT_N2 | Non Unique | SCENARIO_ID, RESOURCE_ID |
| CST_SCN_BUILD_WU_GT_N3 | Non Unique | INPUT_ITEM_ORG |
| CST_SCN_BUILD_WU_GT_N4 | Non Unique | WHERE_USED_INPUT_FLAG |