3691: , ''
3692: , ''
3693: FROM mtl_serial_numbers msn
3694: , rcv_serials_supply rss
3695: , rcv_supply rs
3696: WHERE msn.lpn_id = p_lpn_id
3697: AND msn.inventory_item_id = p_inventory_item_id
3698: AND msn.current_organization_id = p_organization_id
3699: AND NVL(msn.lot_number, '&*^') = NVL(p_lot_number, '&*^')