[Home] [Help]
692: if arg_dept_id = -1 then -- from undo, arg_org_id will pass transaction_id
693: select mdr.resource_code
694: into v_resource_code
695: from msc_department_resources mdr,
696: msc_resource_requirements mrr
697: where mdr.department_id = mrr.department_id
698: and mdr.resource_id = arg_resource_id
699: and mdr.plan_id = mrr.plan_id
700: and mdr.organization_id = mrr.organization_id
913: end if;
914:
915: select assigned_units
916: into v_assigned_units
917: from msc_resource_requirements
918: where department_id = arg_dept_id
919: and resource_id = arg_resource_id
920: and plan_id = arg_plan_id
921: and organization_id = arg_org_id
3629: Mdr.Resource_Code,
3630: Mrr.Department_Id,
3631: Mdr.Department_Code
3632: From Msc_Department_Resources Mdr,
3633: Msc_Resource_Requirements Mrr
3634: Where Mrr.Transaction_Id = P_Res_Transaction_Id
3635: And Mrr.Plan_Id = P_Plan_Id
3636: And Mrr.Sr_Instance_Id = P_Sr_Instance_Id
3637: And Mdr.Plan_Id = Mrr.Plan_Id
4158:
4159: cursor curr_supply(p_curr_plan_id number , p_curr_inst_id number
4160: , p_curr_trans_id number ,p_operation_seq_num number ,p_resource_seq_num number) is
4161: select mrr.operation_sequence_id , ms.routing_sequence_id , ms.inventory_item_id
4162: from msc_supplies ms ,msc_resource_requirements mrr
4163: where ms.transaction_id = mrr.supply_id
4164: and ms.plan_id = mrr.plan_id
4165: and mrr.operation_seq_num = p_operation_seq_num
4166: and mrr.resource_seq_num = p_resource_seq_num
4834: res.from_setup_id
4835: ,res.setup_id
4836: ,res.resource_id
4837: from
4838: msc_resource_requirements res
4839: where res.plan_id = p_plan_id
4840: and res.sr_instance_id = p_sr_instance_id
4841: and res.department_id=p_department_id
4842: and res.organization_id = p_org_id