PTIA_SYSVIEWDEP

(SQL View)
 Index Back

Objects in a View

There is a version of the view text for each database platform because we need to look at database catalogs to get the information.

SELECT NAME ,referenced_name ,CASE referenced_type WHEN 'TABLE' THEN 'T' WHEN 'VIEW' THEN 'V' ELSE 'X' END referenced_type FROM ALL_DEPENDENCIES WHERE TYPE = 'VIEW'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIA_VWNAME Character(35) VARCHAR2(35) NOT NULL View Name
2 PTIA_VWDEPNAME Character(35) VARCHAR2(35) NOT NULL View Dependency Name
3 PTIA_VWDEPTYPE Character(1) VARCHAR2(1) NOT NULL View Dependency Type