DBA Data[Home] [Help]

APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_RESERVATIONS

Line 230: l_res_secondary_qty mtl_reservations.secondary_reservation_quantity%TYPE;

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

Line 231: l_sec_secondary_qty mtl_reservations.secondary_detailed_quantity%TYPE;

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

Line 252: FROM mtl_reservations

248:
249: CURSOR c_rsv_info IS
250: SELECT primary_reservation_quantity, detailed_quantity
251: ,secondary_reservation_quantity, secondary_detailed_quantity --INVCONV kkillams
252: FROM mtl_reservations
253: WHERE reservation_id = l_mmtt_info.reservation_id;
254:
255: BEGIN
256: x_return_status := fnd_api.g_ret_sts_success;