[Home] [Help]
1382: and operation_seq_num = p_old_op_seq_num
1383: and resource_seq_num = p_resource_seq_num;
1384:
1385: select bd.department_id into l_dept
1386: from bom_department_resources bdr,bom_departments bd
1387: where bd.department_id = bdr.department_id
1388: and resource_id = l_resource_id
1389: and bd.department_id in (select department_id
1390: from bom_departments
1452: and wor.operation_seq_num = p_old_op_seq_num
1453: and wor.resource_seq_num = p_resource_seq_num
1454: and wor.resource_id not in (
1455: select bdr.resource_id
1456: from bom_department_resources bdr
1457: where bdr.department_id = l_department_id
1458: );
1459: if( l_num_non_compatible_resources >0) then
1460: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_HANDOVER_DEPT_NOTOK'
1775:
1776: CURSOR c_res_cur IS --rhshriva
1777: select res.resource_code,
1778: res.unit_of_measure
1779: from cst_activities cst, mtl_uom_conversions muc, bom_resources res, bom_department_resources bdr
1780: where nvl(res.disable_date,sysdate+2) > sysdate
1781: and res.resource_id = bdr.resource_id
1782: and res.default_activity_id = cst.activity_id(+)
1783: and (cst.organization_id = res.organization_id or cst.organization_id is null)
3233: AND wor.operation_seq_num = p_operation_seq_num
3234: AND wor.resource_id not in
3235: (
3236: SELECT bdr.resource_id
3237: FROM BOM_DEPARTMENT_RESOURCES bdr
3238: WHERE bdr.department_id = bd.department_id
3239: )
3240: );
3241:
4383: -- get resources available in the assigned department
4384: IF(p_resource_code IS NOT NULL) THEN
4385: SELECT bdr.resource_id
4386: INTO l_resource_id
4387: FROM bom_department_resources bdr , bom_resources br
4388: WHERE bdr.department_id = l_department_id
4389: AND bdr.resource_id = br.resource_id
4390: AND br.resource_code like p_resource_code
4391: AND br.organization_id = p_organization_id;