APPS.OKE_MDS_RELIEF_PKG dependencies on MRP_SCHEDULE_DATES

Line 36: , mrp_schedule_dates m

32: , d.unit_number
33: FROM mtl_system_items c
34: , mtl_material_transactions a
35: , oke_k_deliverables_b d
36: , mrp_schedule_dates m
37: WHERE a.source_code = 'OKE'
38: AND a.organization_id = c.organization_id
39: AND a.inventory_item_id = c.inventory_item_id
40: AND a.primary_quantity < 0

Line 109: FROM Mrp_Schedule_Dates

105: l_conc_program_id NUMBER := fnd_global.conc_program_id;
106:
107: CURSOR qty_c (p_transaction_id NUMBER) IS
108: SELECT schedule_quantity, original_schedule_quantity, schedule_date
109: FROM Mrp_Schedule_Dates
110: WHERE mps_transaction_id = p_transaction_id
111: AND Schedule_Level = 2
112: AND supply_demand_type = 1
113: AND Schedule_Quantity > 0

Line 126: , mrp_schedule_dates m

122: , m.schedule_quantity
123: , m.schedule_date
124: FROM okc_k_lines_b a
125: , oke_k_deliverables_b d
126: , mrp_schedule_dates m
127: , okc_statuses_b sts
128: WHERE d.k_line_id = a.id
129: And m.mps_transaction_id = d.mps_transaction_id
130: And m.schedule_level = 2

Line 207: UPDATE mrp_schedule_dates d

203: ;
204:
205: write_log( 'New MDS qty ........ ' || l_qty );
206:
207: UPDATE mrp_schedule_dates d
208: SET schedule_quantity = l_qty
209: , original_schedule_quantity = l_mds_tbl(i).order_quantity
210: , last_update_date = l_now
211: , last_updated_by = l_user_id

Line 296: UPDATE mrp_schedule_dates d

292: ;
293:
294: write_log( 'New MDS qty ........ ' || l_qty );
295:
296: UPDATE mrp_schedule_dates d
297: SET schedule_quantity = l_qty
298: , original_schedule_quantity = cancel_rec.quantity
299: , last_update_date = l_now
300: , last_updated_by = l_user_id