RELATIONSHIPIDMSGNODENAMERQSTMSGNAMEPSRELATNTRXVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.RELATIONSHIPID , B.MSGNODENAME , B.RQSTMSGNAME FROM PSRELATIONSHIP A , PSNODETRX B WHERE A.NODE1 = B.MSGNODENAME OR A.NODE2 = B.MSGNODENAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RELATIONSHIPID |
Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Relationship ID (see PSRELATIONSHIP). |
| 2 | MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 3 | RQSTMSGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |