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 Name Field Type Column Type Description
ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
EFFDT Date(10) DATE Effective Date

Default: %date

PARAMETERNAME Character(15) VARCHAR2(15) NOT NULL Parameter Name
SENDERNODENAME Character(30) VARCHAR2(30) NOT NULL Sender Node Name
RECEIVERNODENAME Character(30) VARCHAR2(30) NOT NULL Receiver Node Name
ALIASNAME Character(254) VARCHAR2(254) NOT NULL External Alias
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19