APPS.MSC_GANTT_UTILS dependencies on MSC_ROUTINGS

Line 6411: msc_routings mr

6407: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date,
6408: msc_gantt_utils.getMTQTime(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
6409: from msc_resource_requirements mrr1,
6410: msc_resource_requirements mrr2,
6411: msc_routings mr
6412: where mrr1.plan_id = p_plan_id
6413: and mrr1.transaction_id = p_transaction_id
6414: and mrr1.sr_instance_id = p_instance_id
6415: and mrr2.plan_id = mrr1.plan_id

Line 6461: msc_routings mr

6457: (nvl(mrr2.end_date, mrr2.start_date+mrr2.resource_hours/24) - mrr2.start_date),
6458: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date
6459: from msc_resource_requirements mrr1,
6460: msc_resource_requirements mrr2,
6461: msc_routings mr
6462: where mrr1.plan_id = p_plan_id
6463: and mrr1.transaction_id = p_transaction_id
6464: and mrr1.sr_instance_id = p_instance_id
6465: and mrr2.plan_id = mrr1.plan_id

Line 6544: msc_routings mr

6540: from msc_resource_requirements mrr1,
6541: msc_resource_instance_reqs mrir1,
6542: msc_resource_requirements mrr2,
6543: msc_resource_instance_reqs mrir2,
6544: msc_routings mr
6545: where mrir1.plan_id = p_plan_id
6546: and mrir1.res_inst_transaction_id = p_transaction_id
6547: and mrir1.sr_instance_id = p_instance_id
6548: and mrir1.plan_id = mrr1.plan_id

Line 6622: msc_routings mr

6618: from msc_resource_requirements mrr1,
6619: msc_resource_instance_reqs mrir1,
6620: msc_resource_requirements mrr2,
6621: msc_resource_instance_reqs mrir2,
6622: msc_routings mr
6623: where mrir1.plan_id = p_plan_id
6624: and mrir1.res_inst_transaction_id = p_transaction_id
6625: and mrir1.sr_instance_id = p_instance_id
6626: and mrir1.plan_id = mrr1.plan_id