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 Name Field Type Column Type Description
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20