Product: | ECX - XML Gateway |
---|---|
Description: | Status for Inbound Messages |
Implementation/DBA Data: | APPS.ECX_IN_PROCESS_VL |
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(+)