PTIB_JMSTRX_VW

index back

Returns routings using JMS


SELECT A.ROUTINGDEFNNAME , A.EFFDT , A.PARAMETERNAME , A.SENDERNODENAME , A.RECEIVERNODENAME , A.ALIASNAME , B.IB_OPERATIONNAME FROM PSRTNGDFNPARM A , PSIBRTNGDEFN B , PS_IB_ROUTING_TMP C WHERE A.ROUTINGDEFNNAME = B.ROUTINGDEFNNAME AND A.EFFDT = B.EFFDT AND B.ROUTINGDEFNNAME = C.ROUTINGDEFNNAME AND B.EFFDT = C.EFFDT AND B.CONNID = 'JMSTARGET'

PeopleSoft Field NameField TypeColumn TypeDescription
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
EFFDTDate(10)DATEEffective Date

Default: %date

PARAMETERNAMECharacter(15)VARCHAR2(15) NOT NULLParameter Name
SENDERNODENAMECharacter(30)VARCHAR2(30) NOT NULLSender Node Name
RECEIVERNODENAMECharacter(30)VARCHAR2(30) NOT NULLReceiver Node Name
ALIASNAMECharacter(254)VARCHAR2(254) NOT NULLExternal Alias
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19