PSMSGDEFN_VW3

index back

Unstructured Message View

Unstructured Message View
SELECT DISTINCT A.MSGNODENAME , B.MSGNAME , B.DESCR , B.CHNLNAME 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).
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19