PSRTGANYPARMVW

index back

IB Routing Parameter View


SELECT DISTINCT A.ROUTINGDEFNNAME , A.PARAMETERNAME , A.ALIASNAME , B.IB_OPERATIONNAME , B.VERSIONNAME FROM PSRTNGDFNPARM A , PSIBRTNGDEFN B WHERE A.ROUTINGDEFNNAME = B.ROUTINGDEFNNAME AND (A.SENDERNODENAME = '~~ANY~~' OR A.RECEIVERNODENAME = '~~ANY~~') AND A.ROUTINGDEFNNAME NOT LIKE '~IMPORTED%'

PeopleSoft Field NameField TypeColumn TypeDescription
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
PARAMETERNAMECharacter(15)VARCHAR2(15) NOT NULLParameter Name
ALIASNAMECharacter(254)VARCHAR2(254) NOT NULLExternal Alias
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19