IBPUBTRANSACTIDIBTRANSACTIONIDPSAPMSGSCON_VW |
| Platform | View Text |
|---|---|
| Default | SELECT DISTINCT S.IBPUBTRANSACTID , S.IBTRANSACTIONID , S.PUBNODE , S.QUEUENAME , S.IB_OPERATIONNAME , S.ACTIONNAME , S.SUBCONSTATUS , S.STATUSSTRING FROM PSAPMSGSUBCON S WHERE S.IB_SEGMENTINDEX = ( SELECT MIN(T.IB_SEGMENTINDEX) FROM PSAPMSGSUBCON T WHERE T.IBTRANSACTIONID = S.IBTRANSACTIONID AND T.SUBCONSTATUS IN (0, 6)) |
| PeopleSoft Field Name | Description |
|---|---|
| IBPUBTRANSACTID | Orig Transaction ID |
| IBTRANSACTIONID | Transaction ID |
| PUBNODE | Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from. |
| QUEUENAME | Channel Name |
| IB_OPERATIONNAME | Service Operation |
| ACTIONNAME | Action Name |
| SUBCONSTATUS | Subscription Contract Status for Application Messaging |
| STATUSSTRING | Status String |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |