AMM_ARCH_DETAIL

index back

App Msg Monitor Pub View

This view is used to list Publications in the Application Message Monitor.
SELECT DISTINCT C.OPRID , A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID FROM PSAPMSGARCHPH A , PSAUTHQUEUEMON B , PSOPRCLS C WHERE A.QUEUENAME = B.QUEUENAME AND B.CLASSID = C.OPRCLASS

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

Prompt Table: PSMSGNODEDEFN

QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19