APPS.MSC_GANTT_UTILS dependencies on MSC_OPERATION_RESOURCE_SEQS

Line 5150: msc_operation_resource_seqs mors,

5146: ms.new_order_quantity qty,
5147: mrr.assigned_units,
5148: mrr.firm_flag
5149: from msc_resource_requirements mrr,
5150: msc_operation_resource_seqs mors,
5151: msc_supplies ms
5152: where mrr.plan_id = p_plan
5153: and mrr.transaction_id = p_trx
5154: and mrr.sr_instance_id = p_inst

Line 5195: from msc_operation_resource_seqs mors,

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

Line 5213: from msc_operation_resource_seqs mors

5209: cursor all_res_seq(p_plan number, p_inst number, p_op_seq number,
5210: p_rout_seq number, p_act_group number) is
5211: select
5212: distinct mors.resource_seq_num
5213: from msc_operation_resource_seqs mors
5214: where mors.plan_id = p_plan
5215: and mors.sr_instance_id = p_inst
5216: and mors.routing_sequence_id = p_rout_seq
5217: and mors.operation_sequence_id = p_op_seq

Line 7366: from msc_operation_resource_seqs mors,

7362:
7363: cursor activity_c (p_plan number, p_inst number, p_trx number) is
7364: select mors.activity_group_id, mrr.routing_sequence_id,
7365: mrr.operation_sequence_id, mrr.resource_seq_num
7366: from msc_operation_resource_seqs mors,
7367: msc_resource_requirements mrr
7368: where mrr.plan_id = p_plan
7369: and mrr.transaction_id = p_trx
7370: and mrr.sr_instance_id = p_inst

Line 7443: from msc_operation_resource_seqs mors

7439: if l_act_group is not null then -- {
7440: select count(*)
7441: into l_total_seqs
7442: from (select distinct mors.resource_seq_num
7443: from msc_operation_resource_seqs mors
7444: where mors.plan_id = p_plan_id
7445: and mors.routing_sequence_id = l_rout_seq
7446: and mors.operation_sequence_id = l_op_seq
7447: and mors.sr_instance_id = p_instance_id

Line 7453: from msc_operation_resource_seqs mors,

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