MSGNODENAMEMSGNAMEPSMSGDEFN_VW3 |
index back |
|---|---|
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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |