PTIB_JMSNODE_VW

index back

Returns routings that use JMS


SELECT A.ROUTINGDEFNNAME , A.EFFDT , A.PARAMETERNAME , A.SENDERNODENAME , A.RECEIVERNODENAME , A.ALIASNAME , B.IB_OPERATIONNAME FROM PSRTNGDFNPARM A , PSIBRTNGDEFN B , PSMSGNODEDEFN C , PSMSGNODEDEFN D , PS_IB_ROUTING_TMP E WHERE A.ROUTINGDEFNNAME = B.ROUTINGDEFNNAME AND B.ROUTINGDEFNNAME = E.ROUTINGDEFNNAME AND B.EFFDT = E.EFFDT AND A.EFFDT = B.EFFDT AND B.CONNID = '' AND B.SENDERNODENAME = C.MSGNODENAME AND B.RECEIVERNODENAME = D.MSGNODENAME AND B.CONNOVERRIDE = 'N' AND (C.CONNID = 'JMSTARGET' OR D.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