VIEW: APPS.ECX_IN_PROCESS_VL

Source

View Text - Preformatted

SELECT int.trigger_id, doc.document_number, doc.transaction_type, doc.transaction_subtype, tpsetup.party_id, tpsetup.party_site_id, tpsetup.party_type, doc.internal_control_number, int.status, ecx_debug.getMessage(err.message, err.message_parameters), int.time_stamp, int.logfile, doc.out_msgid, doc.msgid from ecx_doclogs doc, ecx_inbound_logs int, ecx_error_msgs err, ( select eep.ext_type, eep.ext_subtype, etd.source_tp_location_code, es.standard_code, es.standard_type, eth.party_id, eth.party_site_id, eth.party_type from ecx_ext_processes eep, ecx_standards es, ecx_tp_details etd, ecx_tp_headers eth where eep.direction = 'IN' AND eep.standard_id = es.standard_id AND etd.ext_process_id = eep.ext_process_id AND etd.tp_header_id = eth.tp_header_id) tpsetup where int.error_id = err.error_id(+) AND doc.msgid = int.msgid(+) AND doc.direction = 'IN' AND doc.transaction_type = tpsetup.ext_type(+) AND doc.transaction_subtype = tpsetup.ext_subtype(+) AND doc.party_site_id = tpsetup.source_tp_location_code(+) AND doc.message_type = tpsetup.standard_type(+) AND doc.message_standard = tpsetup.standard_code(+)

View Text - HTML Formatted

SELECT INT.TRIGGER_ID
, DOC.DOCUMENT_NUMBER
, DOC.TRANSACTION_TYPE
, DOC.TRANSACTION_SUBTYPE
, TPSETUP.PARTY_ID
, TPSETUP.PARTY_SITE_ID
, TPSETUP.PARTY_TYPE
, DOC.INTERNAL_CONTROL_NUMBER
, INT.STATUS
, ECX_DEBUG.GETMESSAGE(ERR.MESSAGE
, ERR.MESSAGE_PARAMETERS)
, INT.TIME_STAMP
, INT.LOGFILE
, DOC.OUT_MSGID
, DOC.MSGID
FROM ECX_DOCLOGS DOC
, ECX_INBOUND_LOGS INT
, ECX_ERROR_MSGS ERR
, ( SELECT EEP.EXT_TYPE
, EEP.EXT_SUBTYPE
, ETD.SOURCE_TP_LOCATION_CODE
, ES.STANDARD_CODE
, ES.STANDARD_TYPE
, ETH.PARTY_ID
, ETH.PARTY_SITE_ID
, ETH.PARTY_TYPE
FROM ECX_EXT_PROCESSES EEP
, ECX_STANDARDS ES
, ECX_TP_DETAILS ETD
, ECX_TP_HEADERS ETH
WHERE EEP.DIRECTION = 'IN'
AND EEP.STANDARD_ID = ES.STANDARD_ID
AND ETD.EXT_PROCESS_ID = EEP.EXT_PROCESS_ID
AND ETD.TP_HEADER_ID = ETH.TP_HEADER_ID) TPSETUP
WHERE INT.ERROR_ID = ERR.ERROR_ID(+)
AND DOC.MSGID = INT.MSGID(+)
AND DOC.DIRECTION = 'IN'
AND DOC.TRANSACTION_TYPE = TPSETUP.EXT_TYPE(+)
AND DOC.TRANSACTION_SUBTYPE = TPSETUP.EXT_SUBTYPE(+)
AND DOC.PARTY_SITE_ID = TPSETUP.SOURCE_TP_LOCATION_CODE(+)
AND DOC.MESSAGE_TYPE = TPSETUP.STANDARD_TYPE(+)
AND DOC.MESSAGE_STANDARD = TPSETUP.STANDARD_CODE(+)