APPS.MRP_PLANNER_PK dependencies on MRP_SCHEDULE_DATES

Line 39: DELETE mrp_schedule_dates dates

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
40: WHERE EXISTS
41: (SELECT NULL
42: FROM bom_calendar_dates cal1,
43: bom_calendar_dates cal2,

Line 95: DELETE mrp_schedule_dates dates

91: | repetitive_daily_rate > 0 are deleted. This takes care of |
92: | The schedule consumption information. |
93: +-------------------------------------------------------------*/
94:
95: DELETE mrp_schedule_dates dates
96: WHERE EXISTS
97: (SELECT NULL
98: FROM mtl_system_items sys
99: WHERE

Line 130: UPDATE mrp_schedule_dates dates

126: AND schedule_designator = arg_compile_desig;
127:
128: COMMIT;
129:
130: UPDATE mrp_schedule_dates dates
131: SET rate_end_date =
132: (SELECT cal1.calendar_date
133: FROM bom_calendar_dates cal1,
134: bom_calendar_dates cal2,

Line 212: INSERT INTO mrp_schedule_dates

208:
209: MPS_AND_DRP_PLANNING CONSTANT INTEGER := 8;
210:
211: BEGIN
212: INSERT INTO mrp_schedule_dates
213: (inventory_item_id,
214: reference_schedule_id,
215: organization_id,
216: schedule_designator,

Line 257: mrp_schedule_dates_s.nextval,

253: SCHED_MPS_PLAN,
254: NULL,
255: changes.source_organization_id,
256: arg_sched_desig,
257: mrp_schedule_dates_s.nextval,
258: daily_rate,
259: last_unit_completion_date,
260: new_schedule_date,
261: changes.new_order_quantity,

Line 271: FROM mrp_schedule_dates dates

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
273: AND dates.organization_id = changes.organization_id
274: AND dates.inventory_item_id = changes.inventory_item_id
275: AND dates.schedule_designator = changes.compile_designator

Line 297: INSERT INTO mrp_schedule_dates

293: PROCEDURE create_orig_mps_entries(
294: arg_sched_desig IN VARCHAR2,
295: arg_org_id IN NUMBER) IS
296: BEGIN
297: INSERT INTO mrp_schedule_dates
298: (inventory_item_id,
299: reference_schedule_id,
300: organization_id,
301: schedule_designator,

Line 344: FROM mrp_schedule_dates dates

340: source_schedule_designator,
341: schedule_date,
342: original_schedule_quantity,
343: supply_demand_type
344: FROM mrp_schedule_dates dates
345: WHERE NOT EXISTS
346: (SELECT NULL
347: FROM mrp_schedule_dates
348: WHERE mps_transaction_id =

Line 347: FROM mrp_schedule_dates

343: supply_demand_type
344: FROM mrp_schedule_dates dates
345: WHERE NOT EXISTS
346: (SELECT NULL
347: FROM mrp_schedule_dates
348: WHERE mps_transaction_id =
349: dates.mps_transaction_id
350: AND schedule_level = ORIG_SCHEDULE)
351: AND schedule_level = UPDATED_SCHEDULE

Line 364: INSERT INTO mrp_schedule_dates

360: PROCEDURE create_mbp_orig_mps_entries(
361: arg_sched_desig IN VARCHAR2,
362: arg_org_id IN NUMBER) IS
363: BEGIN
364: INSERT INTO mrp_schedule_dates
365: (inventory_item_id,
366: reference_schedule_id,
367: organization_id,
368: schedule_designator,

Line 417: FROM mrp_schedule_dates dates

413: supply_demand_type,
414: project_id,
415: task_id,
416: line_id
417: FROM mrp_schedule_dates dates
418: WHERE NOT EXISTS
419: (SELECT NULL
420: FROM mrp_schedule_dates
421: WHERE mps_transaction_id =

Line 420: FROM mrp_schedule_dates

416: line_id
417: FROM mrp_schedule_dates dates
418: WHERE NOT EXISTS
419: (SELECT NULL
420: FROM mrp_schedule_dates
421: WHERE mps_transaction_id =
422: dates.mps_transaction_id
423: AND schedule_level = ORIG_SCHEDULE)
424: AND schedule_level = UPDATED_SCHEDULE