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 NameField TypeColumn TypeDescription
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19