PSOPRVERMSGS_VW

index back

IB Service Parameters


SELECT A.IB_OPERATIONNAME , A.VERSIONNAME , A.MSGNAME , A.IB_MSGVERSION , B.MSGNAME , B.IB_MSGVERSION , C.MSGNAME , C.IB_MSGVERSION FROM PSOPRVERDFNPARM A , PSOPRVERDFNPARM B , PSOPRFLTMSGS_VW C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME (+) AND A.VERSIONNAME = B.VERSIONNAME (+) AND A.PARAMETERNAME = 'REQUEST' AND B.PARAMETERNAME (+) = 'RESPONSE' AND A.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND A.VERSIONNAME = C.VERSIONNAME

PeopleSoft Field NameField TypeColumn TypeDescription
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
IB_REQMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
INMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLIn Message Version
IB_RESPMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
OUTMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLOut Message Version
IB_FLTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
FLTMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLFault Message Version
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19