DBA_DEPENDENCIES

Dependencies to and from objects

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

Related Commands:

Simon Sheppard
SS64.com