IB_NODETRXVW

 index back

SELECT DISTINCT A.MSGNODENAME , A.RQSTMSGNAME FROM PSNODETRX A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSNODETRX B WHERE A.MSGNODENAME = B.MSGNODENAME AND A.TRXTYPE = B.TRXTYPE AND A.RQSTMSGNAME = B.RQSTMSGNAME AND A.RQSTMSGVER = B.RQSTMSGVER) AND A.MSGNODENAME IN ( SELECT C.MSGNODENAME FROM PSMSGNODEDEFN C )

PeopleSoft Field Name Field Type Column Type Description
MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20