[Home] [Help]
| Product: | ECX - XML Gateway |
|---|---|
| Description: | Status for Outbound Messages |
| Implementation/DBA Data: | Not implemented in this database |
SELECT OUT.TRIGGER_ID
, OUT.DOCUMENT_NUMBER
, OUT.TRANSACTION_TYPE
, OUT.TRANSACTION_SUBTYPE
, OUT.PARTY_ID
, OUT.PARTY_SITE_ID
, OUT.STATUS
, ERR1.MESSAGE
, OUT.TIME_STAMP
, OUT.LOGFILE
, OUT.OUT_MSGID
, EXT.STATUS
, ERR2.MESSAGE
, EXT.TIME_STAMP
, RETRY.STATUS
, ERR3.MESSAGE
, RETRY.TIME_STAMP
FROM ECX_OUTBOUND_LOGS OUT
, ECX_EXTERNAL_LOGS EXT
, ECX_EXTERNAL_RETRY RETRY
, ECX_ERROR_MSGS ERR1
, ECX_ERROR_MSGS ERR2
, ECX_ERROR_MSGS ERR3
WHERE OUT.ERROR_ID = ERR1.ERROR_ID(+)
AND OUT. OUT_MSGID = EXT.OUT_MSGID(+)
AND EXT.ERROR_ID = ERR2.ERROR_ID(+)
AND OUT.OUT_MSGID = RETRY.MSGID(+)
AND RETRY.ERROR_ID = ERR3.ERROR_ID(+)