eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GET_GANTT_DATA dependencies on MSC_PLAN_BUCKETS

Line 824: from msc_plan_buckets mpb,

820: order by shift_date, from_time, to_time;
821:
822: select mpb.bkt_start_date,mpb.bkt_end_date
823: BULK COLLECT INTO v_bkt_start, v_bkt_end
824: from msc_plan_buckets mpb,
825: msc_plans mp
826: where mp.plan_id =p_plan_id
827: and mpb.plan_id = mp.plan_id
828: and mpb.organization_id = mp.organization_id

Line 3527: from msc_plan_buckets mpb,

3523: where plan_id = p_plan_id;
3524:
3525: CURSOR daylevel_date_cur IS
3526: select min(mpb.bkt_start_date), max(mpb.bkt_end_date)
3527: from msc_plan_buckets mpb,
3528: msc_plans mp
3529: where mp.plan_id =p_plan_id
3530: and mpb.plan_id = mp.plan_id
3531: and mpb.organization_id = mp.organization_id

Line 3548: from msc_plan_buckets mpb,

3544: p_gantt_end_date date;
3545:
3546: cursor bkt_cur is
3547: select max(mpb.bkt_end_date)
3548: from msc_plan_buckets mpb,
3549: msc_plans mp
3550: where mp.plan_id =p_plan_id
3551: and mpb.plan_id = mp.plan_id
3552: and mpb.organization_id = mp.organization_id

Line 5412: from msc_plan_buckets mpb,

5408: p_end_date := to_date(p_end,format_mask);
5409:
5410: select mpb.bkt_start_date,mpb.bkt_end_date
5411: BULK COLLECT INTO v_bkt_start, v_bkt_end
5412: from msc_plan_buckets mpb,
5413: msc_plans mp
5414: where mp.plan_id =p_plan_id
5415: and mpb.plan_id = mp.plan_id
5416: and mpb.organization_id = mp.organization_id