DBA Data[Home] [Help]

APPS.MRP_PLANNER_PK dependencies on MRP_SYSTEM_ITEMS

Line 35: | We need to go to mtl_system_items because mrp_system_items |

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

Line 268: mrp_system_items data

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