486: select mmtt.organization_id, mmtt.inventory_item_id,
487: nvl(mmtt.transfer_subinventory, mmtt.subinventory_code),
488: nvl(mmtt.transfer_to_location, mmtt.locator_id),
489: mtlt.lot_number
490: from mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
491: where mmtt.transaction_temp_id = mtlt.transaction_temp_id
492: and mmtt.transaction_temp_id = p_transaction_id;
493:
494: begin