PSRELTGTTYPVW

index back

SELECT DISTINCT A.RELATIONSHIPID , B.MSGNODENAME , B.TRXTYPE FROM PSRELATIONSHIP A , PSNODETRX B WHERE A.NODE1 = B.MSGNODENAME OR A.NODE2 = B.MSGNODENAME

PeopleSoft Field Name Field Type Column Type Description
RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID (see PSRELATIONSHIP).
TGTNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID
TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19