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 WD_MATERIAL_COUNT PROCESS_BATCH_TYPE CONTRIBUTE_TO_YIELD_FLAG PERCENT_BATCH OPERATION_OUT_QUANTITY

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, cwdi.wd_material_count, cwd.process_batch_type, cwd.contribute_to_yield_flag, cwd.percent_batch, cwd.operation_out_quantity 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 cwdi.work_method_code = wwmv.work_method_code 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, cwdi.wd_material_count, cwd.process_batch_type, cwd.contribute_to_yield_flag, cwd.percent_batch, cwd.operation_out_quantity 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 cwdi.work_method_code = wwmv.work_method_code