RY_W_RETRY_VW(SQL View) |
Index Back |
---|---|
Transaction retry SQL viewDialog Event Wire Transaction retry report SQL view |
SELECT RY_EXT_ID , RY_TRXN_ID , RY_RETRY_DTTM ,log.STATUS_CODE , DESCR254 ,RY_URL FROM PS_RY_WIRE_EXTSYS ext ,PS_RY_WIRE_RETRY retry ,PS_RY_W_RETRY_LOG log ,PS_RY_WIRE_TRXN trxn WHERE ext.RY_EXT_SYS_ID=retry.RY_EXT_SYS_ID AND retry.RY_RETRY_ID=log.RY_RETRY_ID AND log.RY_TRXN_SYS_ID=trxn.RY_TRXN_SYS_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(40) | VARCHAR2(40) NOT NULL | Field used by Online Marketing. | |
2 | RY_TRXN_ID | Character(40) | VARCHAR2(40) NOT NULL | Field used by Online Marketing. |
3 | RY_RETRY_DTTM | DateTime(26) | TIMESTAMP | Field used by Online Marketing. |
4 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL | Status Code |
5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
6 | RY_URL | Long Character(2000) | VARCHAR2(2000) | Template URL - Document Element |