PUBNODEQUEUENAMEIBPUBTRANSACTIDPSAPMSGINUSEVW |
| Platform | View Text |
|---|---|
| Default | SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID FROM PSAPMSGPUBHDR A WHERE A.PUBSTATUS IN (2, 3) OR EXISTS ( SELECT 'X' FROM PSAPMSGPUBCON B WHERE A.IBTRANSACTIONID = B.IBPUBTRANSACTID AND B.PUBCONSTATUS IN (2, 3)) OR EXISTS ( SELECT 'X' FROM PSAPMSGSUBCON C WHERE A.IBTRANSACTIONID = C.IBPUBTRANSACTID AND C.SUBCONSTATUS IN (2, 3)) |
| PeopleSoft Field Name | Description |
|---|---|
| PUBNODE | Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from. |
| QUEUENAME | Channel Name |
| IBPUBTRANSACTID | Orig Transaction ID |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |