[Home] [Help]
5187: p_rout_seq number, p_act_group number, p_alternate_num number) is
5188: select count(*)
5189: from (select distinct mors.resource_seq_num
5190: from msc_operation_resource_seqs mors,
5191: msc_operation_resources mor
5192: where mors.plan_id = p_plan
5193: and mors.sr_instance_id = p_inst
5194: and mors.operation_sequence_id = p_op_seq
5195: and mors.routing_sequence_id = p_rout_seq
5218: select distinct mrr.transaction_id,
5219: mor.principal_flag,
5220: mrr.resource_id
5221: from msc_resource_requirements mrr,
5222: msc_operation_resources mor
5223: where mrr.plan_id = p_plan
5224: and mrr.sr_instance_id = p_inst
5225: and mrr.routing_sequence_id = p_rout_seq
5226: and mrr.operation_sequence_id = p_op_seq
5265: mor.alternate_number,
5266: mor.principal_flag,
5267: mor.basis_type,
5268: mor.orig_resource_seq_num
5269: from msc_operation_resources mor
5270: where mor.plan_id = p_plan
5271: and mor.sr_instance_id = p_inst
5272: and mor.routing_sequence_id = p_rout_seq
5273: and mor.operation_sequence_id = p_op_seq
7141: mor.resource_id,
7142: mbp_null_value res_instance_id,
7143: mbp_null_value_char serial_number,
7144: mor.alternate_number
7145: from msc_operation_resources mor,
7146: msc_resource_requirements mrr
7147: where mrr.plan_id = p_plan
7148: and mrr.sr_instance_id = p_inst
7149: and mrr.transaction_id = p_trx
7185: mdri.resource_id,
7186: mdri.res_instance_id,
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
7240: mor.resource_id,
7241: mbp_null_value res_instance_id,
7242: mbp_null_value_char serial_number,
7243: mor.alternate_number
7244: from msc_operation_resources mor,
7245: msc_resource_requirements mrr
7246: where mrr.plan_id = p_plan
7247: and mrr.sr_instance_id = p_inst
7248: and mrr.transaction_id = p_trx
7284: mdri.resource_id,
7285: mdri.res_instance_id,
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
7445: select count(*)
7446: into l_avail_seqs
7447: from (select distinct mors.resource_seq_num
7448: from msc_operation_resource_seqs mors,
7449: msc_operation_resources mor
7450: where mors.plan_id = p_plan_id
7451: and mors.sr_instance_id = p_instance_id
7452: and mors.operation_sequence_id = l_op_seq
7453: and mors.routing_sequence_id = l_rout_seq
7609: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) resource_code,
7610: mor.resource_id resource_id,
7611: mbp_null_value res_instance_id,
7612: mbp_null_value_char serial_number
7613: from msc_operation_resources mor,
7614: msc_resource_requirements mrr
7615: where mrr.plan_id = p_plan_id
7616: and mrr.transaction_id = p_trx_id
7617: and mrr.sr_instance_id = p_inst_id
7629: mdri.resource_id, mdri.res_instance_id, mdri.serial_number) resource_code,
7630: mdri.resource_id,
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
7652: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) resource_code,
7653: mor.resource_id,
7654: mbp_null_value res_instance_id,
7655: mbp_null_value_char serial_number
7656: from msc_operation_resources mor,
7657: msc_resource_requirements mrr
7658: where mrr.plan_id = p_plan
7659: and mrr.sr_instance_id = p_inst
7660: and mrr.transaction_id = p_trx
7672: mdri.department_id, mdri.resource_id, mdri.res_instance_id, mdri.serial_number) resource_code,
7673: mdri.resource_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