31: var_bkwd_compat VARCHAR2(2) := FND_PROFILE.VALUE('MRP_NEW_PLANNER_BACK_COMPATIBILITY');
32:
33: BEGIN
34: /*-------------------------------------------------------------+
35: | We need to go to mtl_system_items because mrp_system_items |
36: | may not have been populated at that point |
37: +-------------------------------------------------------------*/
38: --1851794 For phantoms if backward compatibility is yes treat them like standard items
39: DELETE mrp_schedule_dates dates
264: changes.task_id,
265: changes.line_id,
266: changes.end_item_unit_number
267: FROM mrp_recommendations changes,
268: mrp_system_items data
269: WHERE NOT EXISTS
270: (SELECT NULL
271: FROM mrp_schedule_dates dates
272: WHERE dates.schedule_level = UPDATED_SCHEDULE