DBA Data[Home] [Help]

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