[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECX_DOCLOGS |
|---|---|
| Object Type: | TABLE |
| Owner: | ECX |
| FND Design Data: |  ECX.ECX_DOCLOGS
|
| Subobject Name: | |
| Status: | VALID |
This table contains the document logs for Inbound, outbound and passthrough messages
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ECX_DOCLOGS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 MSGID
|
| SYS_IL0000165327C00019$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| ECX_DOCLOGS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INTERNAL_CONTROL_NUMBER
|
| ECX_DOCLOGS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_TYPE
ITEM_KEY
|
| ECX_DOCLOGS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TIME_STAMP
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MSGID | RAW | (16) | Yes | Message Iedntifier in a Queue |
| MESSAGE_TYPE | VARCHAR2 | (100) | Payload Type | |
| MESSAGE_STANDARD | VARCHAR2 | (100) | Payload Standard | |
| TRANSACTION_TYPE | VARCHAR2 | (100) | External Transaction Type Code | |
| TRANSACTION_SUBTYPE | VARCHAR2 | (100) | External Transaction Subtype Code | |
| DOCUMENT_NUMBER | VARCHAR2 | (256) | Document Identifier | |
| PARTYID | VARCHAR2 | (256) | No longer used | |
| PARTY_SITE_ID | VARCHAR2 | (256) | Source Trading Partner Party Site Identifier | |
| PARTY_TYPE | VARCHAR2 | (30) | No longer used | |
| PROTOCOL_TYPE | VARCHAR2 | (500) | Protocol Type | |
| PROTOCOL_ADDRESS | VARCHAR2 | (2000) | Protocol Address | |
| USERNAME | VARCHAR2 | (500) | Receiving UserName | |
| PASSWORD | VARCHAR2 | (500) | Receiving Password | |
| ATTRIBUTE1 | VARCHAR2 | (500) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (500) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (500) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (500) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (500) | Descriptive flexfield segment | |
| PAYLOAD | CLOB | (4000) | Message Payload | |
| FIELD1 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD2 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD3 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD4 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD5 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD6 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD7 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD8 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD9 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD10 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD11 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD12 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD13 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD14 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD15 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD16 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD17 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD18 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD19 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD20 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD21 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD22 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD23 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD24 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD25 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD26 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD27 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD28 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD29 | VARCHAR2 | (2000) | Reserved for Inbound | |
| FIELD30 | VARCHAR2 | (2000) | Reserved for Inbound | |
| LOGFILE | VARCHAR2 | (80) | Transaction Logfile | |
| INTERNAL_CONTROL_NUMBER | NUMBER | Internal Message Control Number | ||
| STATUS | VARCHAR2 | (256) | Message Processing Status | |
| DIRECTION | VARCHAR2 | (240) | Message Direction | |
| TIME_STAMP | DATE | Time Log was Last Updated | ||
| OUT_MSGID | RAW | (16) | Outbound Message Identifier | |
| ITEM_TYPE | VARCHAR2 | (8) | Workflow Item Type | |
| ITEM_KEY | VARCHAR2 | (240) | Workflow Item Key | |
| ACTIVITY_ID | NUMBER | Workflow activity id | ||
| EVENT_NAME | VARCHAR2 | (240) | Workflow event name | |
| EVENT_KEY | VARCHAR2 | (240) | Workflow event key | |
| ORIG_REFERENCE_ID | VARCHAR2 | (240) | Original Reference Id | |
| CB_EVENT_NAME | VARCHAR2 | (240) | Message Callback event name | |
| CB_EVENT_KEY | VARCHAR2 | (240) | Message Callback event key | |
| BLOCK_MODE | VARCHAR2 | (1) | Message Callback Mode |
Cut, paste (and edit) the following text to query this object:
SELECT MSGID
, MESSAGE_TYPE
, MESSAGE_STANDARD
, TRANSACTION_TYPE
, TRANSACTION_SUBTYPE
, DOCUMENT_NUMBER
, PARTYID
, PARTY_SITE_ID
, PARTY_TYPE
, PROTOCOL_TYPE
, PROTOCOL_ADDRESS
, USERNAME
, PASSWORD
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, PAYLOAD
, FIELD1
, FIELD2
, FIELD3
, FIELD4
, FIELD5
, FIELD6
, FIELD7
, FIELD8
, FIELD9
, FIELD10
, FIELD11
, FIELD12
, FIELD13
, FIELD14
, FIELD15
, FIELD16
, FIELD17
, FIELD18
, FIELD19
, FIELD20
, FIELD21
, FIELD22
, FIELD23
, FIELD24
, FIELD25
, FIELD26
, FIELD27
, FIELD28
, FIELD29
, FIELD30
, LOGFILE
, INTERNAL_CONTROL_NUMBER
, STATUS
, DIRECTION
, TIME_STAMP
, OUT_MSGID
, ITEM_TYPE
, ITEM_KEY
, ACTIVITY_ID
, EVENT_NAME
, EVENT_KEY
, ORIG_REFERENCE_ID
, CB_EVENT_NAME
, CB_EVENT_KEY
, BLOCK_MODE
FROM ECX.ECX_DOCLOGS;
ECX.ECX_DOCLOGS does not reference any database object
ECX.ECX_DOCLOGS is referenced by following:
APPS
ECX_DOCLOGS
|
|
|
|