[Home] [Help] [Dependency Information]
Object Name: | ECX_OUTBOUND_LOGS |
---|---|
Object Type: | TABLE |
Owner: | ECX |
FND Design Data: | ECX.ECX_OUTBOUND_LOGS |
Subobject Name: | |
Status: | VALID |
This table contains the outbound transaction logs
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ECX_OUTBOUND_LOGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRIGGER_ID |
ECX_OUTBOUND_LOGS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OUT_MSGID |
ECX_OUTBOUND_LOGS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TIME_STAMP |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_ID | NUMBER | (15) | Yes | Trigger Identifier |
TRANSACTION_TYPE | VARCHAR2 | (100) | External Transaction Type | |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | External Transaction Subtype | |
PARTY_ID | VARCHAR2 | (256) | Party Identifier | |
PARTY_SITE_ID | VARCHAR2 | (256) | Party Site Identifier | |
DOCUMENT_NUMBER | VARCHAR2 | (256) | Document Number | |
PROCESS_ID | RAW | (16) | No longer used | |
STATUS | VARCHAR2 | (256) | Processing Status | |
ERROR_ID | NUMBER | (15) | Error Message Identifier | |
OUT_MSGID | RAW | (16) | Message Identifier | |
LOGFILE | VARCHAR2 | (256) | Processing Logfile | |
TIME_STAMP | DATE | Last Update Time Stamp | ||
PARTY_TYPE | VARCHAR2 | (30) | The Party Type |
Cut, paste (and edit) the following text to query this object:
SELECT TRIGGER_ID
, TRANSACTION_TYPE
, TRANSACTION_SUBTYPE
, PARTY_ID
, PARTY_SITE_ID
, DOCUMENT_NUMBER
, PROCESS_ID
, STATUS
, ERROR_ID
, OUT_MSGID
, LOGFILE
, TIME_STAMP
, PARTY_TYPE
FROM ECX.ECX_OUTBOUND_LOGS;
ECX.ECX_OUTBOUND_LOGS does not reference any database object
ECX.ECX_OUTBOUND_LOGS is referenced by following:
|
|
|