PSAPMSGINUSEVW

index back

App Messages in use


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 NameField TypeColumn TypeDescription
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
IBPUBTRANSACTIDCharacter(36)VARCHAR2(36) NOT NULLOrig Transaction ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19