APPS.MSC_GANTT_UTILS dependencies on MSC_OPERATION_RESOURCE_SEQS

Line 5145: msc_operation_resource_seqs mors,

5141: ms.new_order_quantity qty,
5142: mrr.assigned_units,
5143: mrr.firm_flag
5144: from msc_resource_requirements mrr,
5145: msc_operation_resource_seqs mors,
5146: msc_supplies ms
5147: where mrr.plan_id = p_plan
5148: and mrr.transaction_id = p_trx
5149: and mrr.sr_instance_id = p_inst

Line 5190: from msc_operation_resource_seqs mors,

5186: cursor c_avail_res_seq_count(p_plan number, p_inst number, p_op_seq number,
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

Line 5208: from msc_operation_resource_seqs mors

5204: cursor all_res_seq(p_plan number, p_inst number, p_op_seq number,
5205: p_rout_seq number, p_act_group number) is
5206: select
5207: distinct mors.resource_seq_num
5208: from msc_operation_resource_seqs mors
5209: where mors.plan_id = p_plan
5210: and mors.sr_instance_id = p_inst
5211: and mors.routing_sequence_id = p_rout_seq
5212: and mors.operation_sequence_id = p_op_seq

Line 7361: from msc_operation_resource_seqs mors,

7357:
7358: cursor activity_c (p_plan number, p_inst number, p_trx number) is
7359: select mors.activity_group_id, mrr.routing_sequence_id,
7360: mrr.operation_sequence_id, mrr.resource_seq_num
7361: from msc_operation_resource_seqs mors,
7362: msc_resource_requirements mrr
7363: where mrr.plan_id = p_plan
7364: and mrr.transaction_id = p_trx
7365: and mrr.sr_instance_id = p_inst

Line 7438: from msc_operation_resource_seqs mors

7434: if l_act_group is not null then -- {
7435: select count(*)
7436: into l_total_seqs
7437: from (select distinct mors.resource_seq_num
7438: from msc_operation_resource_seqs mors
7439: where mors.plan_id = p_plan_id
7440: and mors.routing_sequence_id = l_rout_seq
7441: and mors.operation_sequence_id = l_op_seq
7442: and mors.sr_instance_id = p_instance_id

Line 7448: from msc_operation_resource_seqs mors,

7444:
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