APPS.MSC_GANTT_UTILS dependencies on MSC_ROUTINGS

Line 6406: msc_routings mr

6402: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date,
6403: msc_gantt_utils.getMTQTime(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
6404: from msc_resource_requirements mrr1,
6405: msc_resource_requirements mrr2,
6406: msc_routings mr
6407: where mrr1.plan_id = p_plan_id
6408: and mrr1.transaction_id = p_transaction_id
6409: and mrr1.sr_instance_id = p_instance_id
6410: and mrr2.plan_id = mrr1.plan_id

Line 6456: msc_routings mr

6452: (nvl(mrr2.end_date, mrr2.start_date+mrr2.resource_hours/24) - mrr2.start_date),
6453: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date
6454: from msc_resource_requirements mrr1,
6455: msc_resource_requirements mrr2,
6456: msc_routings mr
6457: where mrr1.plan_id = p_plan_id
6458: and mrr1.transaction_id = p_transaction_id
6459: and mrr1.sr_instance_id = p_instance_id
6460: and mrr2.plan_id = mrr1.plan_id

Line 6539: msc_routings mr

6535: from msc_resource_requirements mrr1,
6536: msc_resource_instance_reqs mrir1,
6537: msc_resource_requirements mrr2,
6538: msc_resource_instance_reqs mrir2,
6539: msc_routings mr
6540: where mrir1.plan_id = p_plan_id
6541: and mrir1.res_inst_transaction_id = p_transaction_id
6542: and mrir1.sr_instance_id = p_instance_id
6543: and mrir1.plan_id = mrr1.plan_id

Line 6617: msc_routings mr

6613: from msc_resource_requirements mrr1,
6614: msc_resource_instance_reqs mrir1,
6615: msc_resource_requirements mrr2,
6616: msc_resource_instance_reqs mrir2,
6617: msc_routings mr
6618: where mrir1.plan_id = p_plan_id
6619: and mrir1.res_inst_transaction_id = p_transaction_id
6620: and mrir1.sr_instance_id = p_instance_id
6621: and mrir1.plan_id = mrr1.plan_id