PSAPMSGINUSEVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
2 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
3 IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID