APPS.MRP_ADJUST_DATES_PK dependencies on MRP_PLANS
Line 307: UPDATE mrp_plans
303: AND dates.organization_id = org_id;
304: END IF;
305: -- Set the snapshot and plan completion date to NULL
306: IF demand_exists or forecast_exists then 307: UPDATE mrp_plans 308: SET data_completion_date = NULL,
309: plan_completion_date = NULL
310: WHERE (compile_designator , organization_id) in
311: (SELECT compile_designator , organization_id