SYS.ALL_DEPENDENCIES

The ALL_DEPENDENCIES describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user. This view does not display the SCHEMAID column.

Related views

SYS.DBA_DEPENDENCIES describes all dependencies between objects in the database. This view does not display the SCHEMAID column.
SYS.USER_DEPENDENCIES describes dependencies between objects that are owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2 (30) NOT NULL	Object owner.
NAME	VARCHAR2 (30) NOT NULL	Object name.
TYPE	VARCHAR2 (12) NOT NULL	Object type.
REFERENCED_OWNER	VARCHAR2 (30) NOT NULL	Owner of the referenced object.
REFERENCED_NAME	VARCHAR2 (30) NOT NULL	Name of the referenced object.
REFERENCED_TYPE	VARCHAR2 (12) NOT NULL	Type of the referenced object.
REFERENCED_LINK_NAME	VARCHAR2 (128)	Ignored.
SCHEMAID	TT_INTEGER NOT NULL	ID of the current database.
DEPENDENCY_TYPE	VARCHAR2 (4) NOT NULL	Indicates whether the dependency is a REF dependency (REF) or not (HARD).