PSIBCONALIAS_VW

 index back

IB publication contracts.


SELECT DISTINCT R.ROUTINGDEFNNAME , D.IB_OPERATIONNAME , D.VERSIONNAME , C.ISREQUEST , P.ALIASNAME FROM PSOPRVERDFN D , PSIBRTNGDEFN R , PSRTNGDFNPARM P , PSAPMSGPUBCON C WHERE R.IB_OPERATIONNAME = R.IB_OPERATIONNAME AND R.VERSIONNAME = R.VERSIONNAME AND R.ROUTINGDEFNNAME = P.ROUTINGDEFNNAME AND R.EFFDT = P.EFFDT AND D.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND D.VERSIONNAME = C.VERSIONNAME AND ((C.ISREQUEST = 1 AND P.PARAMETERNAME = 'OUTREQUEST') OR (C.ISREQUEST = 0 AND P.PARAMETERNAME = 'OUTRESPONSE'))

PeopleSoft Field Name Field Type Column Type Description
ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
ISREQUEST Number(1,0) SMALLINT NOT NULL Is Request
ALIASNAME Character(254) VARCHAR2(254) NOT NULL External Alias
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20