[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECX_DOCLOGS# |
|---|---|
| Object Type: | VIEW |
| Owner: | ECX |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MSGID | RAW | (16) | Yes | |
| MESSAGE_TYPE | VARCHAR2 | (100) | ||
| MESSAGE_STANDARD | VARCHAR2 | (100) | ||
| TRANSACTION_TYPE | VARCHAR2 | (100) | ||
| TRANSACTION_SUBTYPE | VARCHAR2 | (100) | ||
| DOCUMENT_NUMBER | VARCHAR2 | (256) | ||
| PARTYID | VARCHAR2 | (256) | ||
| PARTY_SITE_ID | VARCHAR2 | (256) | ||
| PARTY_TYPE | VARCHAR2 | (30) | ||
| PROTOCOL_TYPE | VARCHAR2 | (500) | ||
| PROTOCOL_ADDRESS | VARCHAR2 | (2000) | ||
| USERNAME | VARCHAR2 | (500) | ||
| PASSWORD | VARCHAR2 | (500) | ||
| ATTRIBUTE1 | VARCHAR2 | (500) | ||
| ATTRIBUTE2 | VARCHAR2 | (500) | ||
| ATTRIBUTE3 | VARCHAR2 | (500) | ||
| ATTRIBUTE4 | VARCHAR2 | (500) | ||
| ATTRIBUTE5 | VARCHAR2 | (500) | ||
| PAYLOAD | CLOB | (4000) | ||
| FIELD1 | VARCHAR2 | (2000) | ||
| FIELD2 | VARCHAR2 | (2000) | ||
| FIELD3 | VARCHAR2 | (2000) | ||
| FIELD4 | VARCHAR2 | (2000) | ||
| FIELD5 | VARCHAR2 | (2000) | ||
| FIELD6 | VARCHAR2 | (2000) | ||
| FIELD7 | VARCHAR2 | (2000) | ||
| FIELD8 | VARCHAR2 | (2000) | ||
| FIELD9 | VARCHAR2 | (2000) | ||
| FIELD10 | VARCHAR2 | (2000) | ||
| FIELD11 | VARCHAR2 | (2000) | ||
| FIELD12 | VARCHAR2 | (2000) | ||
| FIELD13 | VARCHAR2 | (2000) | ||
| FIELD14 | VARCHAR2 | (2000) | ||
| FIELD15 | VARCHAR2 | (2000) | ||
| FIELD16 | VARCHAR2 | (2000) | ||
| FIELD17 | VARCHAR2 | (2000) | ||
| FIELD18 | VARCHAR2 | (2000) | ||
| FIELD19 | VARCHAR2 | (2000) | ||
| FIELD20 | VARCHAR2 | (2000) | ||
| FIELD21 | VARCHAR2 | (2000) | ||
| FIELD22 | VARCHAR2 | (2000) | ||
| FIELD23 | VARCHAR2 | (2000) | ||
| FIELD24 | VARCHAR2 | (2000) | ||
| FIELD25 | VARCHAR2 | (2000) | ||
| FIELD26 | VARCHAR2 | (2000) | ||
| FIELD27 | VARCHAR2 | (2000) | ||
| FIELD28 | VARCHAR2 | (2000) | ||
| FIELD29 | VARCHAR2 | (2000) | ||
| FIELD30 | VARCHAR2 | (2000) | ||
| LOGFILE | VARCHAR2 | (80) | ||
| INTERNAL_CONTROL_NUMBER | NUMBER | |||
| STATUS | VARCHAR2 | (256) | ||
| DIRECTION | VARCHAR2 | (240) | ||
| TIME_STAMP | DATE | |||
| OUT_MSGID | RAW | (16) | ||
| ITEM_TYPE | VARCHAR2 | (8) | ||
| ITEM_KEY | VARCHAR2 | (240) | ||
| ACTIVITY_ID | NUMBER | |||
| EVENT_NAME | VARCHAR2 | (240) | ||
| EVENT_KEY | VARCHAR2 | (240) | ||
| ORIG_REFERENCE_ID | VARCHAR2 | (240) | ||
| CB_EVENT_NAME | VARCHAR2 | (240) | ||
| CB_EVENT_KEY | VARCHAR2 | (240) | ||
| BLOCK_MODE | VARCHAR2 | (1) |
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
APPS
ECX_DOCLOGS
|
|
|
|