CS_CT_PARNTNODE(SQL View) |
Index Back |
|---|---|
Parent NodeParent Node |
| SELECT A.MSGNODENAME FROM %Table(PSMSGNODEDEFN) A , %Table(PSNODETRX) B WHERE %Join(COMMON_KEYS, PSMSGNODEDEFN A, PSNODETRX B) AND A.ACTIVE_NODE = '1' AND A.LOCALNODE = 0 AND B.RQSTMSGNAME = 'CS_ACTIVITY_CNTRCT' AND B.TRXTYPE = 'OA' AND %EffdtCheck(PSNODETRX, B, %CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SUBNODE | Character(30) | VARCHAR2(30) NOT NULL | Subscribing Node |