I had a unique issue trying to determine values in an table, not in another, but in a hard coded list.
Using the Oracle COLUMN_VALUE Pseudocolumn did the trick.
select column_value as SOME_NUMBER
from table(sys.odcinumberlist(135074433,350776765,35047670))
