APPS.OKE_PA_MDS_RELIEF_PKG dependencies on MRP_SCHEDULE_DATES

Line 37: , mrp_schedule_dates m

33: From mtl_system_items c
34: , mtl_material_transactions a
35: , oke_deliverables_b b
36: , oke_deliverable_actions d
37: , mrp_schedule_dates m
38: where a.source_code = 'OKE'
39: And a.organization_id = c.organization_id
40: And a.inventory_item_id = c.inventory_item_id
41: And a.primary_quantity < 0

Line 117: From Mrp_Schedule_Dates

113: l_value Number;
114:
115: Cursor qty_c Is
116: Select schedule_quantity, schedule_date, old_transaction_id
117: From Mrp_Schedule_Dates
118: Where mps_transaction_id = l_transaction_id
119: And Schedule_Level = 2
120: And Schedule_Quantity > 0
121: For Update Of schedule_quantity;

Line 161: update mrp_schedule_dates

157: write_log( 'New MDS qty ........ ' || l_qty );
158:
159: if l_mds_tbl(i).mtl_transaction_id > nvl(l_old_transaction_id, 0) then
160:
161: update mrp_schedule_dates
162: set schedule_quantity = l_qty,
163: last_update_date = sysdate,
164: last_updated_by = fnd_global.user_id,
165: request_id = fnd_global.conc_request_id,