169: , subinventory_code
170: , locator_id
171: , SUM(primary_transaction_quantity)
172: , SUM(secondary_transaction_quantity) -- INVCONV
173: FROM mtl_onhand_quantities_detail
174: WHERE lpn_id = p_lpn_id
175: GROUP BY revision, lot_number, subinventory_code, locator_id;
176:
177: --bug#2402957. added the cursor c_lpn_qty.
177: --bug#2402957. added the cursor c_lpn_qty.
178: CURSOR c_lpn_qty IS
179: SELECT SUM(primary_transaction_quantity),
180: sum (secondary_transaction_quantity) -- 16773889
181: FROM mtl_onhand_quantities_detail
182: WHERE lpn_id = p_lpn_id;
183:
184: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
185: -- 16773889