VIEW: APPS.ECX_OUT_PROCESS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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