ALL_DEPENDENCIES

ALL_DEPENDENCIES describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the user, including dependencies on views created without any database links. This view does not display the SCHEMAID column.

Related Views

• DBA_DEPENDENCIES describes all dependencies between objects in the database. This view does not display the SCHEMAID column.
• USER_DEPENDENCIES describes dependencies between objects in the current user's schema. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
  NAME	VARCHAR2(30)	NOT NULL	Name of the object
  TYPE	VARCHAR2(12)		Type of object
  REFERENCED_OWNER	VARCHAR2(30)		Owner of the parent object
  REFERENCED_NAME	VARCHAR2(64)		Type of parent object
  REFERENCED_TYPE	VARCHAR2(12)		Type of referenced object
  REFERENCED_LINK_NAME	VARCHAR2(128)		Name of the link to the parent object (if remote)
  SCHEMAID	NUMBER		ID of the current schema
  DEPENDENCY_TYPE	VARCHAR2(4)		Whether the dependency is a REF dependency (REF) or not (HARD)