DBA Data[Home] [Help]

APPS.MRP_AUTO_REDUCE_PK dependencies on MTL_SYSTEM_ITEMS

Line 48: mtl_system_items sys

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)

Line 196: mtl_system_items sys

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)

Line 272: mtl_system_items sys

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)

Line 326: mtl_system_items sys

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)