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 NameField TypeColumn TypeDescription
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
IB_PSOFTSERVICECharacter(1)VARCHAR2(1) NOT NULLRestricted Service
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
IB_MSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLMessage Version
QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19