PV_PNLG_RECNAME

(SQL View)
 Index Back

SELECT DISTINCT B.RECNAME FROM PSPNLFIELD B WHERE B.PNLNAME IN ( SELECT C.PNLNAME FROM PSPNLGRPDEFN A , PSPNLGROUP C WHERE A.PNLGRPNAME = C.PNLGRPNAME AND A.PNLGRPNAME = 'PV_REQ_APPR_COMM') AND RECNAME <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).