MSGNODENAMEPSNODEWTRX_VW(SQL View) |
Index Back |
|---|---|
Unstructured Message ViewUnstructured 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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |