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 Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

Prompt Table: PSMSGNODEDEFN

QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19