CST_WORK_DEFINITION_ITEMS
This table contains the list of items for which the work definitions snap shot would be created.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_WORK_DEFN_ITEMS_PK |
WORK_DEFINITION_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WORK_DEFINITION_ITEM_ID | NUMBER | 18 | Yes | Surrogate key and unique identifier for costing work definition items for which snap shot is to be created. | |
| SCENARIO_ID | NUMBER | 18 | Indicates the scenario identifier based on which the request to create the snap shot for the item is created from. | ||
| SCENARIO_EVENT_ID | NUMBER | 18 | Indicates the scenario event identifier based on which the request to create the snap shot for the item is created from. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the item for which the work definition snap shot is to be created. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates the inventory organization information for the item for which the work definition snap shot is to be created. | |
| SUPPLY_TYPE | VARCHAR2 | 30 | Indicates the supply type of item. It uses the lookup WIP_SUPPLY for translation purposes. | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the explosion / snap shot process for the work definition. | |
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | Indicates the work definition version identifier from mMDM which is populated as part of the explosion process, or would be populated by cost accounting code when the explosion is required for cost accounting purposes. | ||
| WD_CRITERION_DETAIL_ID | NUMBER | 18 | Indicates the criterion details from the scenario reference based on which the snap shot request is required. | ||
| REFERENCE_ID | NUMBER | 18 | Indicates the work definition item record from which the work definition snapshot is inherited for this work definition item. | ||
| REFERENCE_SCENARIO_ID | NUMBER | 18 | Indicates the scenario reference based on which the work definition information is copied from for incremental rollup. | ||
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Indicates the item cost profile reference generated / derived for the item and plant combination. | ||
| ASSET_COST_PROFILE_ID | NUMBER | 18 | Indicates the asset cost profile reference generated / derived for the item and plant combination. | ||
| EXPENSE_COST_PROFILE_ID | NUMBER | 18 | Indicates the expense cost profile reference generated / derived for the item and plant combination. | ||
| ASSET_VAL_UNIT_ID | NUMBER | 18 | Indicates the asset valuation unit reference generated / derived for the item and plant combination. | ||
| EXPENSE_VAL_UNIT_ID | NUMBER | 18 | Indicates the expense valuation unit reference generated / derived for the item and plant combination. | ||
| WORK_ORDER_ID | NUMBER | 18 | Indicates the work order identifier for configure to order items used for build and rollup processes. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Indicates the CTO purchase order schedule identifier which is being interfaced for processing by cost rollup processor. | ||
| BILL_SEQUENCE_ID | NUMBER | 18 | Identifies the bill of material information for the standard item, when it is based on item structure instead of work definitions. | ||
| PHANTOM_OPERATION_INHERIT_FLAG | VARCHAR2 | 30 | Indicates whether the operation to which the phantom item is assigned, inherits only the input components / input components and resources. | ||
| WD_OPERATION_COUNT | NUMBER | 9 | Indicates the number of operations performed in the work definition for validation of work definition integrity. | ||
| WD_MATERIAL_COUNT | NUMBER | 9 | Indicates the number of materials consumed in the work definition for validation of work definition integrity. | ||
| WD_RESOURCE_COUNT | NUMBER | 9 | Indicates the number of resources utilized in the work definition for validation of work definition integrity. | ||
| PUBLISHED_FLAG | VARCHAR2 | 1 | Indicates the record has been published to the cost accounting domain. Possible values are Y, N, or X. | ||
| POSTED_FLAG | VARCHAR2 | 1 | Indicates if the record has been propagated to the Costing snapshot table CST_WORK_DEFINITIONS. Valid values are N, Y, null. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| OUTPUT_TYPE | VARCHAR2 | 30 | Indicates the output item type. Valid values are contained within the lookup ORA_CST_OUTPUT_TYPE. | ||
| WORK_METHOD_CODE | VARCHAR2 | 30 | Indicates the work method type. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Indicates the primary UOM of the item. | ||
| CST_MSC_SRC_RULE_ID | NUMBER | 18 | Indicates the costing identifier for the sourcing rule. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_WORK_DEFINITION_ITEMS | cst_scenarios | SCENARIO_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WORK_DEFN_ITEMS_N1 | Non Unique | FUSION_TS_TX_DATA | SCENARIO_ID, WORK_DEFINITION_VERSION_ID, WD_CRITERION_DETAIL_ID |
| CST_WORK_DEFN_ITEMS_N2 | Non Unique | FUSION_TS_TX_DATA | WORK_DEFINITION_VERSION_ID |
| CST_WORK_DEFN_ITEMS_N3 | Non Unique | Default | SCENARIO_ID, WORK_DEFINITION_ITEM_ID |
| CST_WORK_DEFN_ITEMS_N4 | Non Unique | FUSION_TS_TX_DATA | REFERENCE_ID |
| CST_WORK_DEFN_ITEMS_N5 | Non Unique | Default | POSTED_FLAG |
| CST_WORK_DEFN_ITEMS_PK | Unique | FUSION_TS_TX_DATA | WORK_DEFINITION_ITEM_ID |
| CST_WORK_DEFN_ITEMS_U1 | Unique | FUSION_TS_TX_DATA | SCENARIO_ID, INVENTORY_ITEM_ID, INVENTORY_ORG_ID |