MSC_AP_WD_OPERATIONS_CONFIG_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
WD_OPERATION_ID ORGANIZATION_CODE CONFIG_ITEM_ID ORGANIZATION_ID ASSEMBLY_NAME WORK_DEFINITION_CODE OPERATION_SEQ_NUMBER EFFECTIVE_FROM_DATE WORK_DEFINITION_ID OPERATION_DESCRIPTION EFFECTIVE_TO_DATE OPTION_DEPENDENT_FLAG WORK_CENTER_CODE YIELD OPERATION_TYPE PLANNING_PERCENT OSP_ITEM_ID OSP_OPERATION_TYPE SUPPLIER_ID SUPPLIER_SITE_ID LEAD_TIME_UOM FIXED_LEAD_TIME VARIABLE_LEAD_TIME

Query

SQL_Statement

SELECT wob.wd_operation_id, assy_esi.organization_code, wob.config_item_id, wob.organization_id, assy_esi.item_number assembly_name, wd.work_definition_code, wob.operation_seq_number, wob.effective_from_date, wob.work_definition_id, wob.operation_description, wob.effective_to_date, 2 option_dependent_flag, wob.work_center_code, 1 yield, wob.operation_type, wob.planning_percent, wob.osp_item_id, wob.osp_operation_type, wob.supplier_id, wob.supplier_site_id, wob.lead_time_uom, wob.fixed_lead_time, wob.variable_lead_time FROM msc_api_work_def_header wd, msc_api_wd_operation wob, msc_planned_egp_system_items assy_esi WHERE wd.organization_id = assy_esi.organization_id AND wd.work_definition_id = wob.work_definition_id AND wd.config_item_id = assy_esi.inventory_item_id AND wd.config_item_id = wob.config_item_id AND wd.organization_id = wob.organization_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 )