View: ECX_OUT_PROCESS_VL

Product:	ECX - XML Gateway
Description:	Status for Outbound Messages
Implementation/DBA Data:	APPS.ECX_OUT_PROCESS_VL

View Text

SELECT OUT.TRIGGER_ID
, OUT.DOCUMENT_NUMBER
, OUT.TRANSACTION_TYPE
, OUT.TRANSACTION_SUBTYPE
, OUT.PARTY_TYPE
, ETH.PARTY_ID
, OUT.PARTY_SITE_ID
, OUT.STATUS
, ECX_DEBUG.GETMESSAGE(ERR1.MESSAGE
, ERR1.MESSAGE_PARAMETERS)
, OUT.TIME_STAMP
, OUT.LOGFILE
, OUT.OUT_MSGID
, EXT.STATUS
, ECX_DEBUG.GETMESSAGE(ERR2.MESSAGE
, ERR2.MESSAGE_PARAMETERS)
, EXT.TIME_STAMP
, RETRY.STATUS
, ECX_DEBUG.GETMESSAGE(ERR3.MESSAGE
, ERR3.MESSAGE_PARAMETERS)
, RETRY.TIME_STAMP
, DOC.PROTOCOL_TYPE
, DOC.PROTOCOL_ADDRESS
, RETRY.RETRY_MSGID
FROM ECX_OUTBOUND_LOGS OUT
, ECX_EXTERNAL_LOGS EXT
, ECX_EXTERNAL_RETRY RETRY
, ECX_DOCLOGS DOC
, ECX_ERROR_MSGS ERR1
, ECX_ERROR_MSGS ERR2
, ECX_ERROR_MSGS ERR3
, ECX_TP_HEADERS ETH
WHERE OUT.OUT_MSGID = EXT.OUT_MSGID(+)
AND OUT.OUT_MSGID = RETRY.MSGID
AND OUT.ERROR_ID = ERR1.ERROR_ID(+)
AND EXT.ERROR_ID = ERR2.ERROR_ID(+)
AND RETRY.ERROR_ID = ERR3.ERROR_ID(+)
AND OUT.OUT_MSGID = DOC.MSGID(+)
AND OUT.PARTY_SITE_ID = ETH.PARTY_SITE_ID UNION SELECT OUT.TRIGGER_ID
, OUT.DOCUMENT_NUMBER
, OUT.TRANSACTION_TYPE
, OUT.TRANSACTION_SUBTYPE
, OUT.PARTY_TYPE
, ETH.PARTY_ID
, OUT.PARTY_SITE_ID
, OUT.STATUS
, ECX_DEBUG.GETMESSAGE(ERR1.MESSAGE
, ERR1.MESSAGE_PARAMETERS)
, OUT.TIME_STAMP
, OUT.LOGFILE
, OUT.OUT_MSGID
, EXT.STATUS
, ECX_DEBUG.GETMESSAGE(ERR2.MESSAGE
, ERR2.MESSAGE_PARAMETERS)
, EXT.TIME_STAMP
, NULL
, NULL
, TO_DATE(NULL)
, DOC.PROTOCOL_TYPE
, DOC.PROTOCOL_ADDRESS
, HEXTORAW(NULL)
FROM ECX_EXTERNAL_LOGS EXT
, ECX_OUTBOUND_LOGS OUT
, ECX_DOCLOGS DOC
, ECX_ERROR_MSGS ERR1
, ECX_ERROR_MSGS ERR2
, ECX_TP_HEADERS ETH
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 = DOC.MSGID(+)
AND OUT.PARTY_SITE_ID = ETH.PARTY_SITE_ID

Columns