[Home] [Help]
View: ECX_IN_PROCESS_V
Product: | ECX - XML Gateway |
Description: | Status for Inbound Messages |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT INT.TRIGGER_ID
, DOC.DOCUMENT_NUMBER
, DOC.TRANSACTION_TYPE
, DOC.TRANSACTION_SUBTYPE
, DOC.PARTYID
, DOC.PARTY_SITE_ID
, DOC.PARTY_TYPE
, DOC.INTERNAL_CONTROL_NUMBER
, INT.STATUS
, ERR.MESSAGE
, INT.TIME_STAMP
, INT.LOGFILE
, DOC.OUT_MSGID
, DOC.MSGID
FROM ECX_DOCLOGS DOC
, ECX_INBOUND_LOGS INT
, ECX_ERROR_MSGS ERR
WHERE INT.ERROR_ID = ERR.ERROR_ID(+)
AND DOC.MSGID = INT.MSGID(+)
Columns
Name |
TRIGGER_ID |
DOCUMENT_ID |
TRANSACTION_TYPE |
TRANSACTION_SUBTYPE |
PARTY_ID |
PARTY_SITE_ID |
PARTY_TYPE |
INTERNAL_CONTROL_NUMBER |
PROCESSING_STATUS |
PROCESSING_MESSAGE |
PROCESSING_TIMESTAMP |
PROCESSING_LOGFILE |
OUT_MSGID |
MSGID |