APPS.OKE_MDS_RELIEF_PKG dependencies on MRP_SCHEDULE_CONSUMPTIONS

Line 156: INSERT INTO mrp_schedule_consumptions(

152: write_log( 'Deliverable qty ... ' || l_mds_tbl(i).order_quantity );
153: write_log( 'Old MDS qty ... ' || qty_rec.schedule_quantity );
154: write_log( 'Shipment qty ....... ' || -l_mds_tbl(i).primary_quantity );
155:
156: INSERT INTO mrp_schedule_consumptions(
157: transaction_id,
158: relief_type,
159: disposition_type,
160: disposition_id,

Line 200: FROM mrp_schedule_consumptions mc

196: write_log( 'Relief record created' );
197:
198: SELECT Greatest(Nvl(l_mds_tbl(i).order_quantity,0)-Nvl(SUM(RELIEF_QUANTITY),0),0)
199: INTO l_qty
200: FROM mrp_schedule_consumptions mc
201: where mc.transaction_id = l_mds_tbl(i).mps_transaction_id
202: AND mc.relief_type=1 AND mc.disposition_type=3
203: ;
204:

Line 246: INSERT INTO mrp_schedule_consumptions(

242: write_log( 'cancel_rec.quantity ......... ' || cancel_rec.quantity );
243: write_log( 'cancel_rec.schedule_date ......... ' || cancel_rec.schedule_date );
244: write_log( 'cancel_rec.schedule_quantity ......... ' || cancel_rec.schedule_quantity );
245:
246: INSERT INTO mrp_schedule_consumptions(
247: transaction_id,
248: relief_type,
249: disposition_type,
250: disposition_id,

Line 289: FROM mrp_schedule_consumptions mc

285: write_log( 'Relief record created' );
286:
287: SELECT Greatest(Nvl(cancel_rec.quantity,0)-Nvl(SUM(RELIEF_QUANTITY),0),0)
288: INTO l_qty
289: FROM mrp_schedule_consumptions mc
290: where mc.transaction_id = cancel_rec.mps_transaction_id
291: AND mc.relief_type=1 AND mc.disposition_type=3
292: ;
293: