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 NameField TypeColumn TypeDescription
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
ISREQUESTNumber(1,0)SMALLINT NOT NULLIs Request
ALIASNAMECharacter(254)VARCHAR2(254) NOT NULLExternal Alias
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19