MSC_AP_WORK_DEF_CONFIG_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
WORK_DEFINITION_ID ORGANIZATION_CODE ORGANIZATION_ID ASSEMBLY_NAME WORK_DEFINITION_TYPE WORK_DEF_NAME_DESCRIPTION PRODUCTION_PRIORITY COMPLETION_LOCATOR_ID COMPLETION_SUB_INVENTORY_NAME EFFECTIVE_FROM_DATE EFFECTIVE_TO_DATE PRIMARY_FLAG WORK_DEFINITION_CODE WORK_DEFINITION_NAME SR_BILL_SEQUENCE_ID PRODUCTION_LINE_ID WORK_METHOD_CODE

Query

SQL_Statement

SELECT wd.work_definition_id, assy_esi.organization_code, wd.organization_id, assy_esi.item_number assembly_name, DECODE(wd.work_definition_type, 'STANDARD', 1, 2) work_definition_type, wd.work_def_name_description, wd.Production_priority, wd.completion_locator_id, wd.completion_sub_inventory_name, wd.effective_from_date, wd.effective_to_date, DECODE(wd.production_priority, 1, 1 ,2) primary_flag, wd.work_definition_code, wd.work_definition_name, wd.sr_bill_sequence_id, wd.production_line_id, DECODE(wm.work_method_code,'FLOW_MANUFACTURING',4,1) WORK_METHOD_CODE FROM msc_api_work_def_header wd , wis_work_methods_vl wm , msc_planned_egp_system_items assy_esi WHERE wd.organization_id = assy_esi.organization_id AND wd.config_item_id = assy_esi.inventory_item_id AND EXISTS ( SELECT 1 FROM msc_ap_work_definitions_v wis WHERE wd.work_definition_id = wis.sr_wd_id AND wd.organization_id = wis.organization_id ) AND wd.work_method_id = wm.work_method_id AND wm.work_method_code in ('DISCRETE_MANUFACTURING','FLOW_MANUFACTURING')