44: (SELECT NULL
45: FROM bom_calendar_dates cal1,
46: bom_calendar_dates cal2,
47: mtl_parameters param,
48: mtl_system_items sys
49: WHERE cal1.calendar_code = param.calendar_code
50: AND cal1.exception_set_id =
51: param.calendar_exception_set_id
52: AND cal1.calendar_date = TRUNC(SYSDATE)
192: (SELECT NULL
193: FROM bom_calendar_dates cal1,
194: bom_calendar_dates cal2,
195: mtl_parameters param,
196: mtl_system_items sys
197: WHERE cal1.calendar_code = param.calendar_code
198: AND cal1.exception_set_id =
199: param.calendar_exception_set_id
200: AND cal1.calendar_date = TRUNC(SYSDATE)
268: (SELECT cal2.calendar_date
269: FROM bom_calendar_dates cal1,
270: bom_calendar_dates cal2,
271: mtl_parameters param,
272: mtl_system_items sys
273: WHERE cal1.calendar_code = param.calendar_code
274: AND cal1.exception_set_id =
275: param.calendar_exception_set_id
276: AND cal1.calendar_date = TRUNC(SYSDATE)
322: (SELECT NULL
323: FROM bom_calendar_dates cal1,
324: bom_calendar_dates cal2,
325: mtl_parameters param,
326: mtl_system_items sys
327: WHERE cal1.calendar_code = param.calendar_code
328: AND cal1.exception_set_id =
329: param.calendar_exception_set_id
330: AND cal1.calendar_date = TRUNC(SYSDATE)