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 Name Field Type Column Type Description
ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
PARAMETERNAME Character(15) VARCHAR2(15) NOT NULL Parameter Name
ALIASNAME Character(254) VARCHAR2(254) NOT NULL External Alias
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19