APPS.MSC_GET_GANTT_DATA dependencies on MSC_PLANS

Line 535: from msc_plans

531: select nvl(MIN_CUTOFF_BUCKET,0)+nvl(HOUR_CUTOFF_BUCKET,0)+data_start_date,
532: nvl(MIN_CUTOFF_BUCKET,0)+data_start_date
533: into p_day_bkt_start_date,
534: p_hour_bkt_start_date
535: from msc_plans
536: where plan_id = p_plan_id;
537:
538: -- parse the resource_list
539: -- the format of res_list is

Line 825: msc_plans mp

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
829: and mpb.sr_instance_id = mp.sr_instance_id

Line 3522: from msc_plans

3518:
3519: Function get_plan_time (p_plan_id number) return varchar2 IS
3520: Cursor cutoff_date_cur IS
3521: select curr_cutoff_date +1, curr_cutoff_date +2
3522: from msc_plans
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)

Line 3528: msc_plans mp

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
3532: and mpb.sr_instance_id = mp.sr_instance_id

Line 3549: msc_plans mp

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
3553: and mpb.sr_instance_id = mp.sr_instance_id

Line 3577: msc_plans mp

3573: SELECT greatest(mpsd.period_start_date, mp.data_start_date)
3574: BULK COLLECT INTO v_date
3575: FROM msc_trading_partners tp,
3576: msc_period_start_dates mpsd,
3577: msc_plans mp
3578: WHERE mpsd.calendar_code = tp.calendar_code
3579: and mpsd.sr_instance_id = tp.sr_instance_id
3580: and mpsd.exception_set_id = tp.calendar_exception_set_id
3581: and tp.sr_instance_id = mp.sr_instance_id

Line 3603: from msc_plans

3599: select nvl(MIN_CUTOFF_BUCKET,0),
3600: nvl(HOUR_CUTOFF_BUCKET,0),
3601: DAILY_CUTOFF_BUCKET
3602: into v_min_day, v_hour_day, v_date_day
3603: from msc_plans
3604: where plan_id = p_plan_id;
3605:
3606: if v_min_day <> 0 then
3607: v_buckets :=

Line 5394: msc_plans mp

5390: cursor start_date_cur is
5391: select nvl(trunc(mis.SUPPLIER_LEAD_TIME_DATE +1),
5392: trunc(mp.plan_start_date+2))
5393: from msc_item_suppliers mis,
5394: msc_plans mp
5395: where mis.plan_id = mp.plan_id
5396: and mis.inventory_item_id = v_item_id
5397: and mis.sr_instance_id = v_instance_id
5398: and mis.supplier_id = v_supplier_id

Line 5413: msc_plans mp

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
5417: and mpb.sr_instance_id = mp.sr_instance_id

Line 5450: msc_plans mp,

5446: select
5447: mca.calendar_date, mca.calendar_date+1, msc.capacity
5448: bulk collect into v_start, v_end, v_qty
5449: from msc_calendar_dates mca,
5450: msc_plans mp,
5451: msc_trading_partners mtp,
5452: msc_supplier_capacities msc
5453: where msc.plan_id = p_plan_id
5454: and msc.inventory_item_id = v_item_id