DBA Data[Home] [Help]

APPS.MSC_DEMAND_PKG dependencies on MSC_CALENDAR_DTL

Line 999: from msc_calendar_dtl mcd

995: last_update_login,
996: date1
997: )
998: select unique l_qid_last_date, l_sysdate, 1, l_sysdate, 1, 1, trunc(mcd.month_end_date)
999: from msc_calendar_dtl mcd
1000: where mcd.month_end_date between l_first_bkt_start_date and l_last_bkt_end_date
1001: union
1002: select unique l_qid_last_date, l_sysdate, 1, l_sysdate, 1, 1, trunc(mw.week_end_date)
1003: from msc_phub_mfg_cal_weeks_mv mw