[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
1484:
1485: cursor inst_name is
1486: select msc_get_name.item_name(mdri.equipment_item_id, null, null, null)
1487: ||decode(mdri.serial_number, null, null_space, COLON_SEPARATOR || mdri.serial_number)
1488: from msc_dept_res_instances mdri,
1489: msc_department_resources mdr,
1490: msc_trading_partners mtp
1491: where mdr.plan_id = p_plan_id
1492: and mdr.sr_instance_id = p_instance_id
6057: and res_inst_transaction_id = l_trx_id;
6058:
6059: cursor c_equipment is
6060: select equipment_item_id
6061: from msc_dept_res_instances
6062: where plan_id = p_plan_id
6063: and resource_id = p_alt_res_id
6064: and res_instance_id = p_alt_res_instance_id
6065: and nvl(serial_number,mbp_null_value_char) = nvl(p_serial_number,mbp_null_value_char);
7192: mdri.serial_number,
7193: mor.alternate_number
7194: from msc_operation_resources mor,
7195: msc_resource_requirements mrr,
7196: msc_dept_res_instances mdri
7197: where mrr.plan_id = p_plan
7198: and mrr.sr_instance_id = p_inst
7199: and mrr.transaction_id = p_trx
7200: and mrr.assigned_units = 1
7218: mdri.serial_number,
7219: mjor.alternate_num
7220: from msc_job_op_resources mjor,
7221: msc_resource_requirements mrr,
7222: msc_dept_res_instances mdri
7223: where mrr.plan_id = p_plan
7224: and mrr.sr_instance_id = p_inst
7225: and mrr.transaction_id = p_trx
7226: and mrr.routing_sequence_id is null
7291: mdri.serial_number,
7292: mor.alternate_number
7293: from msc_operation_resources mor,
7294: msc_resource_requirements mrr,
7295: msc_dept_res_instances mdri
7296: where mrr.plan_id = p_plan
7297: and mrr.sr_instance_id = p_inst
7298: and mrr.transaction_id = p_trx
7299: and mor.plan_id = mrr.plan_id
7314: mdri.res_instance_id,
7315: mdri.serial_number,
7316: mrr.alternate_num
7317: from msc_resource_requirements mrr,
7318: msc_dept_res_instances mdri
7319: where mrr.plan_id = p_plan
7320: and mrr.sr_instance_id = p_inst
7321: and mrr.transaction_id = p_trx
7322: and mrr.plan_id = mdri.plan_id
7335: mdri.serial_number,
7336: mjor.alternate_num
7337: from msc_job_op_resources mjor,
7338: msc_resource_requirements mrr,
7339: msc_dept_res_instances mdri
7340: where mrr.plan_id = p_plan
7341: and mrr.sr_instance_id = p_inst
7342: and mrr.transaction_id = p_trx
7343: and mrr.routing_sequence_id is null
7636: mdri.res_instance_id,
7637: mdri.serial_number
7638: from msc_operation_resources mor,
7639: msc_resource_requirements mrr,
7640: msc_dept_res_instances mdri
7641: where mrr.plan_id = p_plan
7642: and mrr.sr_instance_id = p_inst
7643: and mrr.transaction_id = p_trx
7644: and mor.plan_id = mrr.plan_id
7679: mdri.res_instance_id,
7680: mdri.serial_number
7681: from msc_operation_resources mor,
7682: msc_resource_requirements mrr,
7683: msc_dept_res_instances mdri
7684: where mrr.plan_id = p_plan
7685: and mrr.sr_instance_id = p_inst
7686: and mrr.transaction_id = p_trx
7687: and mor.plan_id = mrr.plan_id