DBA Data[Home] [Help] [Dependency Information]

TABLE: ECX.ECX_OUTBOUND_LOGS

Object Details
Object Name: ECX_OUTBOUND_LOGS
Object Type: TABLE
Owner: ECX
FND Design Data: TableECX.ECX_OUTBOUND_LOGS
Subobject Name:
Status: VALID


This table contains the outbound transaction logs


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECX_OUTBOUND_LOGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRIGGER_ID
ECX_OUTBOUND_LOGS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOUT_MSGID
ECX_OUTBOUND_LOGS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIME_STAMP
Columns
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
Query Text

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;

Dependencies

[top of page]

ECX.ECX_OUTBOUND_LOGS does not reference any database object

ECX.ECX_OUTBOUND_LOGS is referenced by following:

SchemaECX
ViewECX_OUTBOUND_LOGS#