PTPRCSPNLSUB_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
2 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).