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 Field Type Column Type Description
PTIA_VWNAME Character(35) VARCHAR2(35) NOT NULL View Name
PTIA_VWDEPNAME Character(35) VARCHAR2(35) NOT NULL View Dependency Name
PTIA_VWDEPTYPE Character(1) VARCHAR2(1) NOT NULL View Dependency Type
index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20