DBA Data[Home] [Help]

APPS.MSC_GET_GANTT_DATA dependencies on MSC_ROUTINGS

Line 2449: msc_routings mr

2445: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date,
2446: get_MTQ_time(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
2447: from msc_resource_requirements mrr1,
2448: msc_resource_requirements mrr2,
2449: msc_routings mr
2450: where mrr1.plan_id = p_plan_id
2451: and mrr1.transaction_id = p_transaction_id
2452: and mrr1.sr_instance_id = p_instance_id
2453: and mrr2.plan_id = mrr1.plan_id

Line 2501: msc_routings mr

2497: - mrr2.start_date),
2498: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date
2499: from msc_resource_requirements mrr1,
2500: msc_resource_requirements mrr2,
2501: msc_routings mr
2502: where mrr1.plan_id = p_plan_id
2503: and mrr1.transaction_id = p_transaction_id
2504: and mrr1.sr_instance_id = p_instance_id
2505: and mrr2.plan_id = mrr1.plan_id