SYS_VIEW_ROUTINE_USAGE

Information on the User Defined Functions (UDFs) that are used in views.

Column name	Data type	Contents
TABLE_SCHEMA	CHAR(31)	Name of the schema to which the view belongs
TABLE_NAME	CHAR(31)	Name of the view
SPECIFIC_SCHEMA	CHAR(31)	Name of the schema to which the routine belongs
SPECIFIC_NAME	CHAR(31)	Specific name of the routine

Table 141: SYS_VIEW_ROUTINE_USAGE view of the SYS_INFO_SCHEMA