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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19