DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on MSC_CALENDAR_DTL

Line 327: from msc_calendar_dtl mcd

323: last_update_login,
324: date1
325: )
326: select unique l_qid_last_date1, l_sysdate, 1, l_sysdate, 1, 1, trunc(mcd.month_end_date)
327: from msc_calendar_dtl mcd
328: where mcd.month_end_date between l_first_bkt_start_date and l_last_bkt_end_date
329: union
330: select unique l_qid_last_date1, l_sysdate, 1, l_sysdate, 1, 1, trunc(mw.week_end_date)
331: from msc_phub_mfg_cal_weeks_mv mw