RELATIONSHIPIDMSGNODENAMEPSRELATNODEVW(SQL View) |
Index Back |
|---|
| SELECT A.RELATIONSHIPID , B.MSGNODENAME FROM PSRELATIONSHIP A , PSMSGNODEDEFN 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). |