MSC_AP_WD_OP_RESOURCE_CONFIG_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

WORK_DEFINITION_ID ORGANIZATION_CODE ASSEMBLY_NAME CONFIG_ITEM_ID ORGANIZATION_ID WORK_DEFINITION_CODE OPERATION_SEQ_NUMBER EFFECTIVITY_DATE SR_WD_OPERATION_ID WD_OPERATION_RESOURCE_ID WD_OP_ALT_RESOURCE_ID RESOURCE_TYPE ALTERNATE_NUMBER UOM_CODE WORK_CENTER_CODE RESOURCE_CODE PRIMARY_RESOURCE_CODE RESOURCE_SEQ_NUMBER SCHEDULE_FLAG PRINCIPAL_FLAG SUBSTITUTE_GROUP_NUM BASIS_TYPE ASSIGNED_UNITS USAGE_RATE

Query

SQL_Statement

SELECT wop.work_definition_id, wop.organization_code, wop. ASSEMBLY_NAME, wd_res.config_item_id, wd_res.organization_id, wop.work_definition_code, wd_res. operation_seq_number, wop.effective_from_date effectivity_date, wop.wd_operation_id SR_WD_OPERATION_ID, wd_res.wd_operation_resource_id, wd_res.wd_op_alt_resource_id, 0 resource_type, nvl(priority_ranking,0) alternate_number, wd_res .uom_code, wop.work_center_code, res.RESOURCE_CODE, p_res.RESOURCE_CODE primary_resource_code, wd_res.resource_seq_number, decode(wd_res.schedule_type, 'YES',1,'NO',2,'PRIOR",,3,"NEXT',4,1) schedule_flag, decode(wd_res.principal_flag,'Y',1,'N',2) principal_flag, 0 substitute_group_num, wd_res.basis_type, wd_res.assigned_units, wd_res.usage_rate From MSC_AP_WD_OPERATIONS_CONFIG_V wop, MSC_API_WD_OP_RESOURCES wd_res, WIS_RESOURCES_B res, WIS_RESOURCES_B p_res where wop.wd_operation_id =wd_res.wd_operation_id AND wop.config_item_id=wd_res.config_item_id AND wop.organization_id=wd_res.organization_id AND wop.work_method_code = 'DISCRETE_MANUFACTURING' AND wd_res.resource_id = res.resource_id and wd_res.PRIMARY_RESOURCE_ID = p_res.resource_id(+)