CST_DELETE_WORK_DEFINITIONS_GT
This table stores the work definition parameter information passed to the utilities API in costing to check whether they are being used in published scenarios.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | Identifies the work definition version identifier passed to costing for work definition deletion validation. | |
| WORK_DEFINITION_ID | NUMBER | 18 | Identifies the work definition identifier passed to costing for work definition deletion validation. | |
| VERSION_NUMBER | VARCHAR2 | 10 | Identifies the work definition version passed to costing for work definition deletion validation. | |
| WORK_DEFINITION_NAME_ID | NUMBER | 18 | Identifies the work definition name identifier passed to costing for work definition deletion validation. | |
| WORK_DEFINITION_CODE | VARCHAR2 | 30 | Identifies the work definition code passed to costing for work definition deletion validation. | |
| WD_MNT_NAME_ID | NUMBER | 18 | Identifies the maintenance work definition identifier passed to costing for work definition deletion validation. | |
| MAINTENANCE_WD_CODE | VARCHAR2 | 30 | Identifies the maintenance work definition code passed to costing for work definition deletion validation. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the item identifier passed to costing for work definition deletion validation. | |
| ITEM_NUMBER | VARCHAR2 | 300 | Identifies the item number passed to costing for work definition deletion validation. | |
| ORGANIZATION_ID | NUMBER | 18 | Identifies the organization identifier passed to costing for work definition deletion validation. | |
| ORGANIZATION_CODE | VARCHAR2 | 18 | Identifies the organization code passed to costing for work definition deletion validation. | |
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status code returned after the validation. | |
| ERROR_MESSAGE | VARCHAR2 | 4000 | Indicates the error message returned after the validation. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_DEL_WD_GT_PK | Unique | WORK_DEFINITION_VERSION_ID, WORK_DEFINITION_ID, VERSION_NUMBER, WORK_DEFINITION_NAME_ID, WORK_DEFINITION_CODE, WD_MNT_NAME_ID, MAINTENANCE_WD_CODE, INVENTORY_ITEM_ID, ITEM_NUMBER, ORGANIZATION_ID, ORGANIZATION_CODE |