DBA Data[Home] [Help]

APPS.MRP_UPDATE_PLAN_OPTIONS_PK dependencies on MRP_PLAN_SCHEDULES

Line 131: DELETE FROM mrp_plan_schedules

127: AND plan_level = LAST_SUBMITTED;
128:
129: COMMIT;
130:
131: DELETE FROM mrp_plan_schedules
132: WHERE organization_id = arg_org_id
133: AND compile_designator = arg_compile_desig
134: AND plan_level = LAST_SUBMITTED;
135:

Line 174: INTO mrp_plan_schedules

170:
171: COMMIT;
172:
173: INSERT
174: INTO mrp_plan_schedules
175: (organization_id,
176: compile_designator,
177: input_type,
178: input_name,

Line 197: FROM mrp_plan_schedules

193: SYSDATE,
194: arg_user_id,
195: SYSDATE,
196: -1
197: FROM mrp_plan_schedules
198: WHERE organization_id = arg_org_id
199: AND compile_designator = arg_compile_desig
200: AND plan_level = CURRENT_LEVEL;
201: