APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_RESERVATIONS

Line 229: l_res_secondary_qty mtl_reservations.secondary_reservation_quantity%TYPE;

225: l_rsv_detailed_qty NUMBER;
226: l_ato_item NUMBER := 0;
227: l_mmtt_primary_qty_sum NUMBER := 0; /*Bug.4539851*/
228: --INVCONV KKILLAMS
229: l_res_secondary_qty mtl_reservations.secondary_reservation_quantity%TYPE;
230: l_sec_secondary_qty mtl_reservations.secondary_detailed_quantity%TYPE;
231: --END INVCONV KKILLAMS
232:
233: CURSOR c_mmtt_info IS

Line 230: l_sec_secondary_qty mtl_reservations.secondary_detailed_quantity%TYPE;

226: l_ato_item NUMBER := 0;
227: l_mmtt_primary_qty_sum NUMBER := 0; /*Bug.4539851*/
228: --INVCONV KKILLAMS
229: l_res_secondary_qty mtl_reservations.secondary_reservation_quantity%TYPE;
230: l_sec_secondary_qty mtl_reservations.secondary_detailed_quantity%TYPE;
231: --END INVCONV KKILLAMS
232:
233: CURSOR c_mmtt_info IS
234: SELECT mmtt.inventory_item_id

Line 255: FROM mtl_reservations

251:
252: CURSOR c_rsv_info IS
253: SELECT primary_reservation_quantity, detailed_quantity
254: ,secondary_reservation_quantity, secondary_detailed_quantity --INVCONV kkillams
255: FROM mtl_reservations
256: WHERE reservation_id = l_mmtt_info.reservation_id;
257:
258: /* Fix for Bug#9896283. Added cursor c_sai_info and made various changes to calculate secondary
259: quantities