DBA Data[Home] [Help]

APPS.INV_LPN_RESERVATIONS_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 173: FROM mtl_onhand_quantities_detail

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.

Line 180: FROM mtl_onhand_quantities_detail

176:
177: --bug#2402957. added the cursor c_lpn_qty.
178: CURSOR c_lpn_qty IS
179: SELECT SUM(primary_transaction_quantity)
180: FROM mtl_onhand_quantities_detail
181: WHERE lpn_id = p_lpn_id;
182:
183: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
184: BEGIN