[Home] [Help] [Dependency Information]
Object Name: | CLN_COLL_HIST_DTL# |
---|---|
Object Type: | VIEW |
Owner: | CLN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XML_EVENT_KEY | VARCHAR2 | (240) | ||
COLLABORATION_DTL_ID | NUMBER | |||
COLLABORATION_ID | NUMBER | |||
COLLABORATION_DOCUMENT_TYPE | VARCHAR2 | (100) | ||
DOCUMENT_DIRECTION | VARCHAR2 | (3) | ||
COLLABORATION_POINT | VARCHAR2 | (20) | ||
ORIGINATOR_REFERENCE | VARCHAR2 | (255) | ||
DOCUMENT_STATUS | VARCHAR2 | (10) | ||
NOTIFICATION_ID | VARCHAR2 | (100) | ||
MESSAGE_TEXT | VARCHAR2 | (2000) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
BSR_VERB | VARCHAR2 | (240) | ||
BSR_NOUN | VARCHAR2 | (240) | ||
BSR_REVISION | VARCHAR2 | (240) | ||
SENDER_LOGICAL_ID | VARCHAR2 | (240) | ||
SENDER_COMPONENT | VARCHAR2 | (240) | ||
SENDER_TASK | VARCHAR2 | (240) | ||
SENDER_REFERENCEID | VARCHAR2 | (240) | ||
SENDER_CONFIRMATION | VARCHAR2 | (240) | ||
SENDER_LANGUAGE | VARCHAR2 | (240) | ||
SENDER_CODEPAGE | VARCHAR2 | (240) | ||
SENDER_AUTHID | VARCHAR2 | (240) | ||
SENDER_DATETIME_QUALIFIER | VARCHAR2 | (240) | ||
SENDER_DATETIME | VARCHAR2 | (240) | ||
SENDER_TIMEZONE | VARCHAR2 | (240) | ||
ATTRIBUTE1 | VARCHAR2 | (240) | ||
ATTRIBUTE2 | VARCHAR2 | (240) | ||
ATTRIBUTE3 | VARCHAR2 | (240) | ||
ATTRIBUTE4 | VARCHAR2 | (240) | ||
ATTRIBUTE5 | VARCHAR2 | (240) | ||
ATTRIBUTE6 | VARCHAR2 | (240) | ||
ATTRIBUTE7 | VARCHAR2 | (240) | ||
ATTRIBUTE8 | VARCHAR2 | (240) | ||
ATTRIBUTE9 | VARCHAR2 | (240) | ||
ATTRIBUTE10 | VARCHAR2 | (240) | ||
ATTRIBUTE11 | VARCHAR2 | (240) | ||
ATTRIBUTE12 | VARCHAR2 | (240) | ||
ATTRIBUTE13 | VARCHAR2 | (240) | ||
ATTRIBUTE14 | VARCHAR2 | (240) | ||
ATTRIBUTE15 | VARCHAR2 | (240) | ||
RESEND_FLAG | VARCHAR2 | (1) | ||
XMLG_DOCUMENT_ID | VARCHAR2 | (256) | ||
XMLG_INTERNAL_CONTROL_NUMBER | NUMBER | |||
XMLG_MSG_ID | VARCHAR2 | (100) | ||
XMLG_TRANSACTION_SUBTYPE | VARCHAR2 | (100) | ||
XMLG_TRANSACTION_TYPE | VARCHAR2 | (100) | ||
XMLG_INT_TRANSACTION_SUBTYPE | VARCHAR2 | (100) | ||
XMLG_INT_TRANSACTION_TYPE | VARCHAR2 | (100) |
Cut, paste (and edit) the following text to query this object:
SELECT XML_EVENT_KEY
, COLLABORATION_DTL_ID
, COLLABORATION_ID
, COLLABORATION_DOCUMENT_TYPE
, DOCUMENT_DIRECTION
, COLLABORATION_POINT
, ORIGINATOR_REFERENCE
, DOCUMENT_STATUS
, NOTIFICATION_ID
, MESSAGE_TEXT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, BSR_VERB
, BSR_NOUN
, BSR_REVISION
, SENDER_LOGICAL_ID
, SENDER_COMPONENT
, SENDER_TASK
, SENDER_REFERENCEID
, SENDER_CONFIRMATION
, SENDER_LANGUAGE
, SENDER_CODEPAGE
, SENDER_AUTHID
, SENDER_DATETIME_QUALIFIER
, SENDER_DATETIME
, SENDER_TIMEZONE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RESEND_FLAG
, XMLG_DOCUMENT_ID
, XMLG_INTERNAL_CONTROL_NUMBER
, XMLG_MSG_ID
, XMLG_TRANSACTION_SUBTYPE
, XMLG_TRANSACTION_TYPE
, XMLG_INT_TRANSACTION_SUBTYPE
, XMLG_INT_TRANSACTION_TYPE
FROM CLN.CLN_COLL_HIST_DTL#;
|
|
|