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