1-- Dependencies on a view, table, ...
2SELECT *
3 FROM ALL_DEPENDENCIES -- or DBA_DEPENDENCIES or USER_DEPENDENCIES
4 WHERE TYPE = 'VIEW' -- or 'PROCEDURE', 'SYNONYM'...
5 AND REFERENCED_OWNER = 'OBJECT_OWNER'
6 AND REFERENCED_NAME = 'OBJECT_NAME';