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_HUB_CALENDAR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14


    select mcd.calendar_date into x_date
    from msc_calendar_dates mcd,msc_calendars mc
    where mc.calendar_code = p_calendar_code
    and mc.sr_instance_id = p_sr_instance_id
    and mc.calendar_code=mcd.calendar_code
    and mc.sr_instance_id=mcd.sr_instance_id
 --   and mc.exception_set_id = mcd.exception_set_id
    and mcd.calendar_date = p_bkt_start_date
    and mcd.seq_num is not null;

Line: 28


     select min(mcd.calendar_date) into x_date
     from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd
     where mc.calendar_code = p_calendar_code
     and mc.sr_instance_id = p_sr_instance_id
     and   mc.calendar_code =  mcd.calendar_code
     and   mc.sr_instance_id = mcd.sr_instance_id
     -- and   mc.exception_set_id = mcd.exception_set_id
     and   mcd.seq_num is not null
     and   mcd.calendar_code = mcwsd.calendar_code
     and   mcd.sr_instance_id = mcwsd.sr_instance_id
     and   mcd.exception_set_id =mcwsd.exception_set_id
     and   mcwsd.WEEK_START_DATE = p_bkt_start_date
     and   mcd.calendar_date >=mcwsd.WEEK_START_DATE
     and   mcd.calendar_date


Line: 46

     select min(mcd.calendar_date) into x_date
     from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd
     where mc.calendar_code = p_calendar_code
     and   mc.sr_instance_id = p_sr_instance_id
     and   mc.calendar_code =  mcd.calendar_code
     and   mc.sr_instance_id = mcd.sr_instance_id
     -- and   mc.exception_set_id = mcd.exception_set_id
     and   mcd.seq_num is not null
     and   mcd.calendar_code = mpsd.calendar_code
     and   mcd.sr_instance_id = mpsd.sr_instance_id
     and   mcd.exception_set_id =mpsd.exception_set_id
     and   mpsd.PERIOD_START_DATE = p_bkt_start_date
     and   mcd.calendar_date >=mpsd.PERIOD_START_DATE
     and   mcd.calendar_date

Line: 86

    select plan_type into l_plan_type
    from msc_plans where plan_id=p_plan_id;

Line: 101

      select mtp.calendar_code into l_calendar_code
      from msc_trading_partners mtp,       msc_plans mp
      where mtp.sr_tp_id = mp.organization_id
      and mtp.sr_instance_id = mp.sr_instance_id
      and mp.plan_id =p_plan_id and mtp.PARTNER_TYPE =3;

Line: 118

    select mcd.calendar_date into x_date
    from msc_calendar_dates mcd,msc_calendars mc
    where mc.calendar_code = l_calendar_code
    and mc.sr_instance_id = p_sr_instance_id
    and mc.calendar_code=mcd.calendar_code
    and mc.sr_instance_id=mcd.sr_instance_id

    and mcd.calendar_date = p_bkt_start_date
    and mcd.seq_num is not null;

Line: 132

     select max(mcd.calendar_date) into x_date
     from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd
     where mc.calendar_code = l_calendar_code
     and mc.sr_instance_id = p_sr_instance_id
     and   mc.calendar_code =  mcd.calendar_code
     and   mc.sr_instance_id = mcd.sr_instance_id

     and   mcd.seq_num is not null
     and   mcd.calendar_code = mcwsd.calendar_code
     and   mcd.sr_instance_id = mcwsd.sr_instance_id
     and   mcd.exception_set_id =mcwsd.exception_set_id
     and   mcwsd.WEEK_START_DATE >= p_bkt_start_date
     and   mcwsd.WEEK_START_DATE <= p_bkt_end_date
     and   mcd.calendar_date >=mcwsd.WEEK_START_DATE
     and   mcd.calendar_date

Line: 151

     select max(mcd.calendar_date) into x_date
     from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd
     where mc.calendar_code = l_calendar_code
     and   mc.sr_instance_id = p_sr_instance_id
     and   mc.calendar_code =  mcd.calendar_code
     and   mc.sr_instance_id = mcd.sr_instance_id

     and   mcd.seq_num is not null
     and   mcd.calendar_code = mpsd.calendar_code
     and   mcd.sr_instance_id = mpsd.sr_instance_id
     and   mcd.exception_set_id =mpsd.exception_set_id
     and   mpsd.PERIOD_START_DATE >= p_bkt_start_date
     and   mpsd.PERIOD_START_DATE <= p_bkt_end_date
     and   mcd.calendar_date >=mpsd.PERIOD_START_DATE
     and   mcd.calendar_date

Line: 190

    select mcd.calendar_date into x_date
    from msc_calendar_dates mcd,msc_calendars mc
    where mc.calendar_code = p_calendar_code
    and mc.sr_instance_id = p_sr_instance_id
    and mc.calendar_code=mcd.calendar_code
    and mc.sr_instance_id=mcd.sr_instance_id

    and mcd.calendar_date = p_bkt_start_date
    and mcd.seq_num is not null;

Line: 204

     select max(mcd.calendar_date) into x_date
     from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd
     where mc.calendar_code = p_calendar_code
     and mc.sr_instance_id = p_sr_instance_id
     and   mc.calendar_code =  mcd.calendar_code
     and   mc.sr_instance_id = mcd.sr_instance_id

     and   mcd.seq_num is not null
     and   mcd.calendar_code = mcwsd.calendar_code
     and   mcd.sr_instance_id = mcwsd.sr_instance_id
     and   mcd.exception_set_id =mcwsd.exception_set_id
     and   mcwsd.WEEK_START_DATE = p_bkt_start_date
     and   mcd.calendar_date >=mcwsd.WEEK_START_DATE
     and   mcd.calendar_date

Line: 222

     select max(mcd.calendar_date) into x_date
     from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd
     where mc.calendar_code = p_calendar_code
     and   mc.sr_instance_id = p_sr_instance_id
     and   mc.calendar_code =  mcd.calendar_code
     and   mc.sr_instance_id = mcd.sr_instance_id

     and   mcd.seq_num is not null
     and   mcd.calendar_code = mpsd.calendar_code
     and   mcd.sr_instance_id = mpsd.sr_instance_id
     and   mcd.exception_set_id =mpsd.exception_set_id
     and   mpsd.PERIOD_START_DATE = p_bkt_start_date
     and   mcd.calendar_date >=mpsd.PERIOD_START_DATE
     and   mcd.calendar_date

Line: 263

select bkt_start_date,bkt_end_date,bucket_type
into l_bkt_start_date,l_bkt_end_date,l_bkt_type
from msc_plan_buckets
where plan_id = p_plan_id
and p_date between bkt_start_date and bkt_end_date;

Line: 270

select sr_instance_id into l_sr_instance_id
from msc_plans where plan_id=p_plan_id;

Line: 280

   select curr_start_date into x_date
   from msc_plans where plan_id = p_plan_id;

Line: 292

     select max(period_start_date) into x_date
     from msc_safety_Stocks
     where period_start_date <=p_bkt_end_date
     and plan_id=p_plan_id;

Line: 329

      select mtp.calendar_code into l_calendar_code
      from msc_trading_partners mtp,       msc_plans mp
      where mtp.sr_tp_id = mp.organization_id
      and mtp.sr_instance_id = mp.sr_instance_id
      and mp.plan_id =p_plan_id and mtp.PARTNER_TYPE =3;

Line: 342

    select max(mcd.calendar_date)  into x_date
    from msc_calendar_dates mcd,msc_calendars mc
    where mc.calendar_code = l_calendar_code
    and mc.sr_instance_id = p_sr_instance_id
    and mc.calendar_code=mcd.calendar_code
    and mc.sr_instance_id=mcd.sr_instance_id

    and mcd.calendar_date <= p_bkt_start_date
    and mcd.calendar_date >= p_bkt_start_date -7
    and mcd.seq_num is not null;

Line: 373

        select organization_id
        into l_organization_id
        from
            (select organization_id,
                rank() over(order by decode(organization_id, p_def_organization_id, 1, 0) desc,
                    organization_id) n
            from msc_system_items
            where plan_id=p_plan_id
                and sr_instance_id=p_sr_instance_id
                and inventory_item_id=p_inventory_item_id
            )
        where n=1;