[Home] [Help]
5192: p_rout_seq number, p_act_group number, p_alternate_num number) is
5193: select count(*)
5194: from (select distinct mors.resource_seq_num
5195: from msc_operation_resource_seqs mors,
5196: msc_operation_resources mor
5197: where mors.plan_id = p_plan
5198: and mors.sr_instance_id = p_inst
5199: and mors.operation_sequence_id = p_op_seq
5200: and mors.routing_sequence_id = p_rout_seq
5223: select distinct mrr.transaction_id,
5224: mor.principal_flag,
5225: mrr.resource_id
5226: from msc_resource_requirements mrr,
5227: msc_operation_resources mor
5228: where mrr.plan_id = p_plan
5229: and mrr.sr_instance_id = p_inst
5230: and mrr.routing_sequence_id = p_rout_seq
5231: and mrr.operation_sequence_id = p_op_seq
5270: mor.alternate_number,
5271: mor.principal_flag,
5272: mor.basis_type,
5273: mor.orig_resource_seq_num
5274: from msc_operation_resources mor
5275: where mor.plan_id = p_plan
5276: and mor.sr_instance_id = p_inst
5277: and mor.routing_sequence_id = p_rout_seq
5278: and mor.operation_sequence_id = p_op_seq
7146: mor.resource_id,
7147: mbp_null_value res_instance_id,
7148: mbp_null_value_char serial_number,
7149: mor.alternate_number
7150: from msc_operation_resources mor,
7151: msc_resource_requirements mrr
7152: where mrr.plan_id = p_plan
7153: and mrr.sr_instance_id = p_inst
7154: and mrr.transaction_id = p_trx
7190: mdri.resource_id,
7191: mdri.res_instance_id,
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
7245: mor.resource_id,
7246: mbp_null_value res_instance_id,
7247: mbp_null_value_char serial_number,
7248: mor.alternate_number
7249: from msc_operation_resources mor,
7250: msc_resource_requirements mrr
7251: where mrr.plan_id = p_plan
7252: and mrr.sr_instance_id = p_inst
7253: and mrr.transaction_id = p_trx
7289: mdri.resource_id,
7290: mdri.res_instance_id,
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
7450: select count(*)
7451: into l_avail_seqs
7452: from (select distinct mors.resource_seq_num
7453: from msc_operation_resource_seqs mors,
7454: msc_operation_resources mor
7455: where mors.plan_id = p_plan_id
7456: and mors.sr_instance_id = p_instance_id
7457: and mors.operation_sequence_id = l_op_seq
7458: and mors.routing_sequence_id = l_rout_seq
7614: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) resource_code,
7615: mor.resource_id resource_id,
7616: mbp_null_value res_instance_id,
7617: mbp_null_value_char serial_number
7618: from msc_operation_resources mor,
7619: msc_resource_requirements mrr
7620: where mrr.plan_id = p_plan_id
7621: and mrr.transaction_id = p_trx_id
7622: and mrr.sr_instance_id = p_inst_id
7634: mdri.resource_id, mdri.res_instance_id, mdri.serial_number) resource_code,
7635: mdri.resource_id,
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
7657: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) resource_code,
7658: mor.resource_id,
7659: mbp_null_value res_instance_id,
7660: mbp_null_value_char serial_number
7661: from msc_operation_resources mor,
7662: msc_resource_requirements mrr
7663: where mrr.plan_id = p_plan
7664: and mrr.sr_instance_id = p_inst
7665: and mrr.transaction_id = p_trx
7677: mdri.department_id, mdri.resource_id, mdri.res_instance_id, mdri.serial_number) resource_code,
7678: mdri.resource_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