USER_DEPENDENCIES

Dependencies to and from a users objects

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

Related Commands:

Simon Sheppard
SS64.com