Check Oracle synonyms


select * from ALL_SYNONYMS where synonym_name = 'my_name';
select * from ALL_VIEWS where view_name = 'my_name';


See http://docs.oracle.com/cd/B19306_01/server.102/b14231/views.htm