IB_NODETRXVW

Platform	View Text
Default	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	Description
MSGNODENAME	Application Message Node Name. Name of the Application Message Node Definition.
MSGNAME	Application Message Name. Name of the Application Message Definition.

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010