[Home] [Help]
1137:
1138: CURSOR res_group IS
1139: SELECT distinct mrr.transaction_id,mor.principal_flag
1140: FROM msc_resource_requirements mrr,
1141: msc_operation_resources mor
1142: WHERE mrr.plan_id = p_plan_id
1143: AND mrr.sr_instance_id = p_instance_id
1144: and mrr.routing_sequence_id = l_rout_seq
1145: AND mrr.operation_sequence_id = l_op_seq
1160: mor.resource_units,
1161: mor.resource_id,
1162: mor.alternate_number,
1163: mor.principal_flag
1164: FROM msc_operation_resources mor
1165: WHERE mor.plan_id = p_plan_id
1166: AND mor.routing_sequence_id = l_rout_seq
1167: AND mor.sr_instance_id = p_instance_id
1168: AND mor.operation_sequence_id = l_op_seq
1240: into l_avail_res_seq
1241: from (
1242: select distinct mors.resource_seq_num
1243: from msc_operation_resource_seqs mors,
1244: msc_operation_resources mor
1245: where mors.plan_id = p_plan_id
1246: and mors.sr_instance_id = p_instance_id
1247: and mors.operation_sequence_id = l_op_seq
1248: and mors.routing_sequence_id = l_rout_seq
1617: mrr.organization_id, mrr.plan_id,
1618: mrr.sr_instance_id),
1619: mor.resource_id,
1620: mor.alternate_number
1621: FROM msc_operation_resources mor,
1622: msc_resource_requirements mrr
1623: WHERE mrr.plan_id = p_plan_id
1624: AND mrr.transaction_id = p_transaction_id
1625: AND mrr.sr_instance_id = p_instance_id
1696: into l_avail_seqs
1697: from (
1698: select distinct mors.resource_seq_num
1699: from msc_operation_resource_seqs mors,
1700: msc_operation_resources mor
1701: where mors.plan_id = p_plan_id
1702: and mors.sr_instance_id = p_instance_id
1703: and mors.operation_sequence_id = l_op_seq
1704: and mors.routing_sequence_id = l_rout_seq
1753: SELECT msc_get_name.resource_code(mor.resource_id, mrr.department_id,
1754: mrr.organization_id, mrr.plan_id,
1755: mrr.sr_instance_id),
1756: mor.resource_id
1757: FROM msc_operation_resources mor,
1758: msc_resource_requirements mrr
1759: WHERE mrr.plan_id = p_plan_id
1760: AND mrr.transaction_id = p_transaction_id
1761: AND mrr.sr_instance_id = p_instance_id