WL_RECORD2_VW

index back

SELECT DISTINCT A.PNLGRPNAME , A.MARKET , B.RECNAME FROM PSPNLGROUP A , PSPNLFIELD B WHERE A.PNLNAME = B.PNLNAME AND B.RECNAME <> ' '

PeopleSoft Field Name Field Type Column Type Description
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19