[Home] [Help]
140: cursor res_inst_cur (p_plan number, p_inst number, p_org number, p_dept number, p_res number)is
141: select mdr.owning_department_id department_id,
142: mdri.res_instance_id,
143: mdri.serial_number
144: from msc_dept_res_instances mdri,
145: msc_department_resources mdr
146: where mdr.plan_id = p_plan
147: and mdr.sr_instance_id = p_inst
148: and mdr.organization_id = p_org
156:
157: cursor inst_res_cur (p_plan number, p_inst number, p_org number, p_dept number, p_res number,
158: p_res_instance number, p_serial_number varchar2 )is
159: select distinct mdr.department_id department_id
160: from msc_dept_res_instances mdri,
161: msc_department_resources mdr
162: where mdr.plan_id = p_plan
163: and mdr.sr_instance_id = p_inst
164: and mdr.organization_id = p_org
1483:
1484: cursor inst_name is
1485: select msc_get_name.item_name(mdri.equipment_item_id, null, null, null)
1486: ||decode(mdri.serial_number, null, null_space, COLON_SEPARATOR || mdri.serial_number)
1487: from msc_dept_res_instances mdri,
1488: msc_department_resources mdr,
1489: msc_trading_partners mtp
1490: where mdr.plan_id = p_plan_id
1491: and mdr.sr_instance_id = p_instance_id
6052: and res_inst_transaction_id = l_trx_id;
6053:
6054: cursor c_equipment is
6055: select equipment_item_id
6056: from msc_dept_res_instances
6057: where plan_id = p_plan_id
6058: and resource_id = p_alt_res_id
6059: and res_instance_id = p_alt_res_instance_id
6060: and nvl(serial_number,mbp_null_value_char) = nvl(p_serial_number,mbp_null_value_char);
7187: mdri.serial_number,
7188: mor.alternate_number
7189: from msc_operation_resources mor,
7190: msc_resource_requirements mrr,
7191: msc_dept_res_instances mdri
7192: where mrr.plan_id = p_plan
7193: and mrr.sr_instance_id = p_inst
7194: and mrr.transaction_id = p_trx
7195: and mrr.assigned_units = 1
7213: mdri.serial_number,
7214: mjor.alternate_num
7215: from msc_job_op_resources mjor,
7216: msc_resource_requirements mrr,
7217: msc_dept_res_instances mdri
7218: where mrr.plan_id = p_plan
7219: and mrr.sr_instance_id = p_inst
7220: and mrr.transaction_id = p_trx
7221: and mrr.routing_sequence_id is null
7286: mdri.serial_number,
7287: mor.alternate_number
7288: from msc_operation_resources mor,
7289: msc_resource_requirements mrr,
7290: msc_dept_res_instances mdri
7291: where mrr.plan_id = p_plan
7292: and mrr.sr_instance_id = p_inst
7293: and mrr.transaction_id = p_trx
7294: and mor.plan_id = mrr.plan_id
7309: mdri.res_instance_id,
7310: mdri.serial_number,
7311: mrr.alternate_num
7312: from msc_resource_requirements mrr,
7313: msc_dept_res_instances mdri
7314: where mrr.plan_id = p_plan
7315: and mrr.sr_instance_id = p_inst
7316: and mrr.transaction_id = p_trx
7317: and mrr.plan_id = mdri.plan_id
7330: mdri.serial_number,
7331: mjor.alternate_num
7332: from msc_job_op_resources mjor,
7333: msc_resource_requirements mrr,
7334: msc_dept_res_instances mdri
7335: where mrr.plan_id = p_plan
7336: and mrr.sr_instance_id = p_inst
7337: and mrr.transaction_id = p_trx
7338: and mrr.routing_sequence_id is null
7631: mdri.res_instance_id,
7632: mdri.serial_number
7633: from msc_operation_resources mor,
7634: msc_resource_requirements mrr,
7635: msc_dept_res_instances mdri
7636: where mrr.plan_id = p_plan
7637: and mrr.sr_instance_id = p_inst
7638: and mrr.transaction_id = p_trx
7639: and mor.plan_id = mrr.plan_id
7674: mdri.res_instance_id,
7675: mdri.serial_number
7676: from msc_operation_resources mor,
7677: msc_resource_requirements mrr,
7678: msc_dept_res_instances mdri
7679: where mrr.plan_id = p_plan
7680: and mrr.sr_instance_id = p_inst
7681: and mrr.transaction_id = p_trx
7682: and mor.plan_id = mrr.plan_id