[Home] [Help] [Dependency Information]
Object Name: | ECX_EXTERNAL_LOGS |
---|---|
Object Type: | TABLE |
Owner: | ECX |
FND Design Data: | ECX.ECX_EXTERNAL_LOGS |
Subobject Name: | |
Status: | VALID |
This table contains the outbound message logs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ECX_EXTERNAL_LOGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXTERNAL_PROCESS_ID |
ECX_EXTERNAL_LOGS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ERROR_ID |
ECX_EXTERNAL_LOGS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OUT_MSGID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTERNAL_PROCESS_ID | NUMBER | (15) | Yes | External Process Identifier |
OUT_MSGID | RAW | (16) | Yes | Message Identifier |
STATUS | VARCHAR2 | (240) | Document Status | |
ERROR_ID | NUMBER | (15) | Error Message Identifier | |
TIME_STAMP | DATE | Last Update Time Stamp |
Cut, paste (and edit) the following text to query this object:
SELECT EXTERNAL_PROCESS_ID
, OUT_MSGID
, STATUS
, ERROR_ID
, TIME_STAMP
FROM ECX.ECX_EXTERNAL_LOGS;
ECX.ECX_EXTERNAL_LOGS does not reference any database object
ECX.ECX_EXTERNAL_LOGS is referenced by following:
|
|
|