PSNODEWTRX_VW

index back

Unstructured Message View

Unstructured Message View
SELECT DISTINCT A.MSGNODENAME FROM PSNODETRX A , PSMSGDEFN B WHERE A.RQSTMSGNAME = B.MSGNAME AND A.RQSTMSGVER = B.DEFAULTVER AND A.EFFDT=( SELECT MAX(B.EFFDT) FROM PSNODETRX B WHERE B.MSGNODENAME=A.MSGNODENAME AND B.TRXTYPE=A.TRXTYPE AND B.RQSTMSGNAME=A.RQSTMSGNAME AND B.RQSTMSGVER=A.RQSTMSGVER AND B.EFF_STATUS='A' AND B.EFFDT<=%CurrentDateIn)

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).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19