APPS.GMIVLDX dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 229: FROM mtl_transaction_lots_temp lot, mtl_material_transactions_temp mtl

225: END IF;
226:
227: SELECT COUNT(1)
228: INTO l_count
229: FROM mtl_transaction_lots_temp lot, mtl_material_transactions_temp mtl
230: WHERE mtl.inventory_item_id <> p_odm_item_id
231: AND lot.lot_number = p_odm_lot_number
232: AND mtl.transaction_temp_id = lot.transaction_temp_id
233: AND ROWNUM = 1;