PTPRCSPNLSUB_VW

 index back

Run Control Pages and Sub-page


SELECT DISTINCT PNLGRPNAME, PNLNAME FROM PS_PTPRCSRUNPGS_VW UNION SELECT DISTINCT B.PNLGRPNAME, A.SUBPNLNAME FROM PSPNLFIELD A, PS_PTPRCSRUNPGS_VW B WHERE A.PNLNAME = B.PNLNAME AND A.SUBPNLNAME NOT IN ('PRCSRQSTDLG','PRCSRUNCNTL_LC_SBP','PRCSRUNCNTL_RL_SBP','PRCSRUNCNTL_SBP','PRCSRUNCNTL_SBP2','PT_PRCSRUNCNTL_SBP',' ')

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).
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20