PTIB_JMSTRX_VW

Return to Index

View: PS_PTIB_JMSTRX_VW

Returns routings using JMS

PlatformView Text
DefaultSELECT 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 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