DBA_DEPENDENCIES

Dependencies to and from objects

Columns
   ___________________________
 
   OWNER
      Owner of the object
   NAME
      Name of the object
   TYPE
      Type of the object
   REFERENCED_OWNER
      Owner of referenced object (remote owner if remote object)
   REFERENCED_NAME
      Name of referenced object
   REFERENCED_TYPE
      Type of referenced object
   REFERENCED_LINK_NAME
      Name of dblink if this is a remote object
   DEPENDENCY_TYPE
      --

Related:

Script to show all dependencies for an object - Jared Still & Jacques Kilchoer