PTIB_JMSNODE_VW

Return to Index

View: PS_PTIB_JMSNODE_VW

Returns routings that use JMS

PlatformView Text
DefaultSELECT 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 NameDescription
ROUTINGDEFNNAMERouting Name
EFFDTEffective Date

Default: %date

PARAMETERNAMEParameter Name
SENDERNODENAMESender Node Name
RECEIVERNODENAMEReceiver Node Name
ALIASNAMEExternal Alias
IB_OPERATIONNAMEService Operation

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010