PSIBMSGSERV_VW

index back

Messages for a Service.

Shows IB Messages that are tied to IB Services.
SELECT DISTINCT S.IB_SERVICENAME , S.IB_PSOFTSERVICE , P.MSGNAME , P.IB_MSGVERSION , P.QUEUENAME FROM PSSERVICE S , PSSERVICEOPR B , PSOPERATION O , PSOPRVERDFNPARM P WHERE S.IB_SERVICENAME = B.IB_SERVICENAME AND B.IB_OPERATIONNAME = O.IB_OPERATIONNAME AND O.IB_OPERATIONNAME = P.IB_OPERATIONNAME

PeopleSoft Field Name Field Type Column Type Description
IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
IB_PSOFTSERVICE Character(1) VARCHAR2(1) NOT NULL Restricted Service
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
IB_MSGVERSION Character(30) VARCHAR2(30) NOT NULL Message Version
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19