[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 |