index back

SELECT DISTINCT A.pnlgrpname , A.pnlname , B.recname FROM PS_PTPRCSPNLSUB_VW A , PSPNLFIELD B WHERE A.pnlname=B.pnlname AND B.recname <> ' ' AND B.recname IN ( SELECT DISTINCT recname FROM psrecdefn WHERE objectownerid = 'PPT' AND rectype='0')

PeopleSoft Field Name Field Type Column Type Description
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20