APPS.MRP_AUTO_REDUCE_PK dependencies on BOM_CALENDAR_DATES

Line 45: FROM bom_calendar_dates cal1,

41: rowid
42: FROM mrp_schedule_dates dates
43: WHERE exists
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

Line 46: bom_calendar_dates cal2,

42: FROM mrp_schedule_dates dates
43: WHERE exists
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 =

Line 193: FROM bom_calendar_dates cal1,

189: 'N');
190: DELETE mrp_schedule_dates dates
191: WHERE exists
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

Line 194: bom_calendar_dates cal2,

190: DELETE mrp_schedule_dates dates
191: WHERE exists
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 =

Line 269: FROM bom_calendar_dates cal1,

265: SET last_update_date = SYSDATE,
266: last_updated_by = arg_user_id,
267: dates.schedule_date =
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

Line 270: bom_calendar_dates cal2,

266: last_updated_by = arg_user_id,
267: dates.schedule_date =
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 =

Line 323: FROM bom_calendar_dates cal1,

319: AND sys.auto_reduce_mps is not null
320: AND sys.inventory_item_id = dates.inventory_item_id)
321: WHERE exists
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

Line 324: bom_calendar_dates cal2,

320: AND sys.inventory_item_id = dates.inventory_item_id)
321: WHERE exists
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 =