CST_WORK_DEFINITIONS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

CST_WORK_DEFINITION_ID SCENARIO_ID WORK_DEFINITION_ITEM_ID WORK_DEFINITION_VERSION_ID WORK_DEFINITION_ID VERSION_NUMBER WD_EFFECTIVE_FROM_DATE WD_EFFECTIVE_TO_DATE COSTING_BATCH_OUTPUT_SIZE WORK_DEFINITION_TYPE WORK_DEFINITION_NAME_ID PRODUCTION_PRIORITY COSTING_PRIORITY ORGANIZATION_ID WORK_METHOD_ID WORK_METHOD_CODE WORK_METHOD_NAME OUTPUT_INVENTORY_ITEM_ID OUTPUT_INVENTORY_ORG_ID CST_OPERATION_ID WD_OPERATION_ID OPERATION_SEQ_NUMBER WORK_CENTER_ID WORK_CENTER_CODE WORK_AREA_ID WORK_AREA_CODE OP_EFFECTIVE_FROM_DATE OP_EFFECTIVE_TO_DATE WD_OPERATION_RESOURCE_ID RESOURCE_SEQ_NUMBER RESOURCE_ASSIGNED_UNITS RESOURCE_USAGE_RATE RESOURCE_UOM_CODE RESOURCE_PRIMARY_UOM_CODE RESOURCE_UOM_CONVERSION_FACTOR RESOURCE_BASIS_TYPE RESOURCE_ACTIVITY_CODE RESOURCE_ID RESOURCE_COSTED_FLAG RESOURCE_SCALED_USAGE_RATE WD_OPERATION_MATERIAL_ID MATERIAL_TYPE MATERIAL_QUANTITY MATERIAL_UOM_CODE MATERIAL_PRIMARY_UOM_CODE MATERIAL_UOM_CONVERSION_FACTOR MATERIAL_BASIS_TYPE MATERIAL_YIELD_FACTOR MATERIAL_INVENTORY_ITEM_ID MATERIAL_INVENTORY_ORG_ID CST_MSC_SRC_RULE_ID MATERIAL_SEQ_NUMBER OPERATION_OUTPUT_ITEM_ID OPERATION_OUTPUT_ORG_ID MATERIAL_SUPPLY_TYPE MATERIAL_SCALED_QUANTITY WD_CRITERION_DETAIL_ID SCENARIO_EVENT_ID STATUS_CODE SCENARIO_ROLLUP_HEADER_ID BATCH_QUANTITY BATCH_UOM_CODE BATCH_PRIMARY_UOM_CODE BATCH_UOM_CONVERSION_FACTOR ELEVATED_FROM_PHANTOM_FLAG ELEVATED_FROM_PHANTOM_CWD_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE COMPONENT_SEQUENCE_ID FIND_NUMBER WIS_MATERIAL_SEQ_NUMBER OP_YIELD_FACTOR OP_CUM_YIELD_FACTOR OP_REV_YIELD_FACTOR

Query

SQL_Statement

SELECT CWD.CST_WORK_DEFINITION_ID, CWDI.SCENARIO_ID, CWD.WORK_DEFINITION_ITEM_ID, CWD.WORK_DEFINITION_VERSION_ID, CWD.WORK_DEFINITION_ID, CWD.VERSION_NUMBER, CWD.WD_EFFECTIVE_FROM_DATE, CWD.WD_EFFECTIVE_TO_DATE, CWD.COSTING_BATCH_OUTPUT_SIZE, CWD.WORK_DEFINITION_TYPE, CWD.WORK_DEFINITION_NAME_ID, CWD.PRODUCTION_PRIORITY, CWD.COSTING_PRIORITY, CWD.ORGANIZATION_ID, CWD.WORK_METHOD_ID, WWMV.WORK_METHOD_CODE, WWMV.WORK_METHOD_NAME, CWD.OUTPUT_INVENTORY_ITEM_ID, CWD.OUTPUT_INVENTORY_ORG_ID, CWD.CST_OPERATION_ID, CWD.WD_OPERATION_ID, CWD.OPERATION_SEQ_NUMBER, CWD.WORK_CENTER_ID, CWD.WORK_CENTER_CODE, CWD.WORK_AREA_ID, CWD.WORK_AREA_CODE, CWD.OP_EFFECTIVE_FROM_DATE, CWD.OP_EFFECTIVE_TO_DATE, CWD.WD_OPERATION_RESOURCE_ID, CWD.RESOURCE_SEQ_NUMBER, CWD.RESOURCE_ASSIGNED_UNITS, CWD.RESOURCE_USAGE_RATE, CWD.RESOURCE_UOM_CODE, CWD.RESOURCE_PRIMARY_UOM_CODE, CWD.RESOURCE_UOM_CONVERSION_FACTOR, CWD.RESOURCE_BASIS_TYPE, CWD.RESOURCE_ACTIVITY_CODE, CWD.RESOURCE_ID, CWD.RESOURCE_COSTED_FLAG, CWD.RESOURCE_SCALED_USAGE_RATE, CWD.WD_OPERATION_MATERIAL_ID, CWD.MATERIAL_TYPE, CWD.MATERIAL_QUANTITY, CWD.MATERIAL_UOM_CODE, CWD.MATERIAL_PRIMARY_UOM_CODE, CWD.MATERIAL_UOM_CONVERSION_FACTOR, CWD.MATERIAL_BASIS_TYPE, CWD.MATERIAL_YIELD_FACTOR, CWD.MATERIAL_INVENTORY_ITEM_ID, CWD.MATERIAL_INVENTORY_ORG_ID, CWD.CST_MSC_SRC_RULE_ID, CWD.MATERIAL_SEQ_NUMBER, CWD.OPERATION_OUTPUT_ITEM_ID, CWD.OPERATION_OUTPUT_ORG_ID, CWD.MATERIAL_SUPPLY_TYPE, CWD.MATERIAL_SCALED_QUANTITY, CWD.WD_CRITERION_DETAIL_ID, CWDI.SCENARIO_EVENT_ID, CWD.STATUS_CODE, CWD.SCENARIO_ROLLUP_HEADER_ID, CWD.BATCH_QUANTITY, CWD.BATCH_UOM_CODE, CWD.BATCH_PRIMARY_UOM_CODE, CWD.BATCH_UOM_CONVERSION_FACTOR, CWD.ELEVATED_FROM_PHANTOM_FLAG, CWD.ELEVATED_FROM_PHANTOM_CWD_ID, CWDI.CREATED_BY, CWDI.CREATION_DATE, CWDI.LAST_UPDATED_BY, CWDI.LAST_UPDATE_DATE, CWDI.LAST_UPDATE_LOGIN, CWDI.REQUEST_ID, CWDI.JOB_DEFINITION_NAME, CWDI.JOB_DEFINITION_PACKAGE, CWD.COMPONENT_SEQUENCE_ID, CWD.FIND_NUMBER, CWD.WIS_MATERIAL_SEQ_NUMBER, CWD.OP_YIELD_FACTOR, CWD.OP_CUM_YIELD_FACTOR, CWD.OP_REV_YIELD_FACTOR FROM CST_WORK_DEFINITION_ITEMS CWDI, CST_WORK_DEFINITIONS CWD, WIS_WORK_METHODS_VL WWMV WHERE CWDI.WORK_DEFINITION_ITEM_ID = CWD.WORK_DEFINITION_ITEM_ID AND CWDI.REFERENCE_ID IS NULL AND CWD.WORK_METHOD_ID = WWMV.WORK_METHOD_ID(+) UNION ALL SELECT CWD.CST_WORK_DEFINITION_ID, CWDI.SCENARIO_ID, CWD.WORK_DEFINITION_ITEM_ID, CWD.WORK_DEFINITION_VERSION_ID, CWD.WORK_DEFINITION_ID, CWD.VERSION_NUMBER, CWD.WD_EFFECTIVE_FROM_DATE, CWD.WD_EFFECTIVE_TO_DATE, CWD.COSTING_BATCH_OUTPUT_SIZE, CWD.WORK_DEFINITION_TYPE, CWD.WORK_DEFINITION_NAME_ID, CWD.PRODUCTION_PRIORITY, CWD.COSTING_PRIORITY, CWD.ORGANIZATION_ID, CWD.WORK_METHOD_ID, WWMV.WORK_METHOD_CODE, WWMV.WORK_METHOD_NAME, CWD.OUTPUT_INVENTORY_ITEM_ID, CWD.OUTPUT_INVENTORY_ORG_ID, CWD.CST_OPERATION_ID, CWD.WD_OPERATION_ID, CWD.OPERATION_SEQ_NUMBER, CWD.WORK_CENTER_ID, CWD.WORK_CENTER_CODE, CWD.WORK_AREA_ID, CWD.WORK_AREA_CODE, CWD.OP_EFFECTIVE_FROM_DATE, CWD.OP_EFFECTIVE_TO_DATE, CWD.WD_OPERATION_RESOURCE_ID, CWD.RESOURCE_SEQ_NUMBER, CWD.RESOURCE_ASSIGNED_UNITS, CWD.RESOURCE_USAGE_RATE, CWD.RESOURCE_UOM_CODE, CWD.RESOURCE_PRIMARY_UOM_CODE, CWD.RESOURCE_UOM_CONVERSION_FACTOR, CWD.RESOURCE_BASIS_TYPE, CWD.RESOURCE_ACTIVITY_CODE, CWD.RESOURCE_ID, CWD.RESOURCE_COSTED_FLAG, CWD.RESOURCE_SCALED_USAGE_RATE, CWD.WD_OPERATION_MATERIAL_ID, CWD.MATERIAL_TYPE, CWD.MATERIAL_QUANTITY, CWD.MATERIAL_UOM_CODE, CWD.MATERIAL_PRIMARY_UOM_CODE, CWD.MATERIAL_UOM_CONVERSION_FACTOR, CWD.MATERIAL_BASIS_TYPE, CWD.MATERIAL_YIELD_FACTOR, CWD.MATERIAL_INVENTORY_ITEM_ID, CWD.MATERIAL_INVENTORY_ORG_ID, CWD.CST_MSC_SRC_RULE_ID, CWD.MATERIAL_SEQ_NUMBER, CWD.OPERATION_OUTPUT_ITEM_ID, CWD.OPERATION_OUTPUT_ORG_ID, CWD.MATERIAL_SUPPLY_TYPE, CWD.MATERIAL_SCALED_QUANTITY, CWD.WD_CRITERION_DETAIL_ID, CWDI.SCENARIO_EVENT_ID, CWD.STATUS_CODE, CWD.SCENARIO_ROLLUP_HEADER_ID, CWD.BATCH_QUANTITY, CWD.BATCH_UOM_CODE, CWD.BATCH_PRIMARY_UOM_CODE, CWD.BATCH_UOM_CONVERSION_FACTOR, CWD.ELEVATED_FROM_PHANTOM_FLAG, CWD.ELEVATED_FROM_PHANTOM_CWD_ID, CWDI.CREATED_BY, CWDI.CREATION_DATE, CWDI.LAST_UPDATED_BY, CWDI.LAST_UPDATE_DATE, CWDI.LAST_UPDATE_LOGIN, CWDI.REQUEST_ID, CWDI.JOB_DEFINITION_NAME, CWDI.JOB_DEFINITION_PACKAGE, CWD.COMPONENT_SEQUENCE_ID, CWD.FIND_NUMBER, CWD.WIS_MATERIAL_SEQ_NUMBER, CWD.OP_YIELD_FACTOR, CWD.OP_CUM_YIELD_FACTOR, CWD.OP_REV_YIELD_FACTOR FROM CST_WORK_DEFINITION_ITEMS CWDI, CST_WORK_DEFINITIONS CWD, WIS_WORK_METHODS_VL WWMV WHERE CWDI.REFERENCE_ID = CWD.WORK_DEFINITION_ITEM_ID AND CWD.WORK_METHOD_ID = WWMV.WORK_METHOD_ID(+)