PTIB_JMSNODE_VW

Platform

View Text

Default

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	Description
ROUTINGDEFNNAME	Routing Name
EFFDT	Effective Date Default: %date
PARAMETERNAME	Parameter Name
SENDERNODENAME	Sender Node Name
RECEIVERNODENAME	Receiver Node Name
ALIASNAME	External Alias
IB_OPERATIONNAME	Service Operation

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010