RY_W_RETRY_LVW(SQL View) |
Index Back |
---|---|
Transaction retry SQL viewDialog Event Wire Transaction retry report SQL Related Language record. |
SELECT ext.RY_EXT_ID , lng.LANGUAGE_CD , lng.DESCR254 FROM PS_RY_WIRE_EXTSYS ext ,PS_RY_WIRE_RETRY retry ,PS_RY_W_RETRY_LOG log ,PS_RY_WIRE_TRXN trxn ,PS_RY_WIR_EXSY_LNG lng 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 AND ext.RY_EXT_ID = lng.RY_EXT_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RY_EXT_ID | Character(40) | VARCHAR2(40) NOT NULL | Field used by Online Marketing. |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |