[Home] [Help]
822: if arg_dept_id = -1 then -- from undo, arg_org_id will pass transaction_id
823: select distinct mdr.resource_code
824: into v_resource_code
825: from msc_department_resources mdr,
826: msc_resource_requirements mrr
827: where mdr.department_id = mrr.department_id
828: and mdr.resource_id = arg_resource_id
829: and mdr.plan_id = mrr.plan_id
830: and mdr.organization_id = mrr.organization_id
1043: end if;
1044:
1045: select assigned_units
1046: into v_assigned_units
1047: from msc_resource_requirements
1048: where department_id = arg_dept_id
1049: and resource_id = arg_resource_id
1050: and plan_id = arg_plan_id
1051: and organization_id = arg_org_id
4086: Mdr.Resource_Code,
4087: Mrr.Department_Id,
4088: Mdr.Department_Code
4089: From Msc_Department_Resources Mdr,
4090: Msc_Resource_Requirements Mrr
4091: Where Mrr.Transaction_Id = P_Res_Transaction_Id
4092: And Mrr.Plan_Id = P_Plan_Id
4093: And Mrr.Sr_Instance_Id = P_Sr_Instance_Id
4094: And Mdr.Plan_Id = Mrr.Plan_Id
4615:
4616: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number
4617: , p_curr_trans_id number ,p_operation_seq_num number ,p_resource_seq_num number) is
4618: select mrr.operation_sequence_id , ms.routing_sequence_id , ms.inventory_item_id
4619: from msc_supplies ms ,msc_resource_requirements mrr
4620: where ms.transaction_id = mrr.supply_id
4621: and ms.plan_id = mrr.plan_id
4622: and mrr.operation_seq_num = p_operation_seq_num
4623: and mrr.resource_seq_num = p_resource_seq_num
5347: res.from_setup_id
5348: ,res.setup_id
5349: ,res.resource_id
5350: from
5351: msc_resource_requirements res
5352: where res.plan_id = p_plan_id
5353: and res.sr_instance_id = p_sr_instance_id
5354: and res.department_id=p_department_id
5355: and res.organization_id = p_org_id