DBA Data[Home] [Help]

APPS.MRP_SCHEDULE_DESIG_PKG dependencies on MRP_PLANS

Line 35: UPDATE mrp_plans

31: X_schedule_designator VARCHAR2) IS
32:
33: BEGIN
34:
35: UPDATE mrp_plans
36: SET explosion_start_date = NULL,
37: explosion_completion_date = NULL,
38: data_start_date = NULL,
39: data_completion_date = NULL,

Line 110: FROM mrp_plans

106: BEGIN
107:
108: SELECT 1
109: INTO dummy
110: FROM mrp_plans
111: WHERE explosion_completion_date >= explosion_start_date
112: AND data_start_date >= explosion_completion_date
113: AND data_completion_date >= data_start_date
114: AND plan_start_date >= data_completion_date