VIEW: CLN.CLN_COLL_HIST_DTL#

Source

View Text - Preformatted

select XML_EVENT_KEY XML_EVENT_KEY, COLLABORATION_DTL_ID COLLABORATION_DTL_ID, COLLABORATION_ID COLLABORATION_ID, COLLABORATION_DOCUMENT_TYPE COLLABORATION_DOCUMENT_TYPE, DOCUMENT_DIRECTION DOCUMENT_DIRECTION, COLLABORATION_POINT COLLABORATION_POINT, ORIGINATOR_REFERENCE ORIGINATOR_REFERENCE, DOCUMENT_STATUS DOCUMENT_STATUS, NOTIFICATION_ID NOTIFICATION_ID, MESSAGE_TEXT MESSAGE_TEXT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BSR_VERB BSR_VERB, BSR_NOUN BSR_NOUN, BSR_REVISION BSR_REVISION, SENDER_LOGICAL_ID SENDER_LOGICAL_ID, SENDER_COMPONENT SENDER_COMPONENT, SENDER_TASK SENDER_TASK, SENDER_REFERENCEID SENDER_REFERENCEID, SENDER_CONFIRMATION SENDER_CONFIRMATION, SENDER_LANGUAGE SENDER_LANGUAGE, SENDER_CODEPAGE SENDER_CODEPAGE, SENDER_AUTHID SENDER_AUTHID, SENDER_DATETIME_QUALIFIER SENDER_DATETIME_QUALIFIER, SENDER_DATETIME SENDER_DATETIME, SENDER_TIMEZONE SENDER_TIMEZONE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, RESEND_FLAG RESEND_FLAG, XMLG_DOCUMENT_ID XMLG_DOCUMENT_ID, XMLG_INTERNAL_CONTROL_NUMBER XMLG_INTERNAL_CONTROL_NUMBER, XMLG_MSG_ID XMLG_MSG_ID, XMLG_TRANSACTION_SUBTYPE XMLG_TRANSACTION_SUBTYPE, XMLG_TRANSACTION_TYPE XMLG_TRANSACTION_TYPE, XMLG_INT_TRANSACTION_SUBTYPE XMLG_INT_TRANSACTION_SUBTYPE, XMLG_INT_TRANSACTION_TYPE XMLG_INT_TRANSACTION_TYPE from "CLN"."CLN_COLL_HIST_DTL"

View Text - HTML Formatted

SELECT XML_EVENT_KEY XML_EVENT_KEY
, COLLABORATION_DTL_ID COLLABORATION_DTL_ID
, COLLABORATION_ID COLLABORATION_ID
, COLLABORATION_DOCUMENT_TYPE COLLABORATION_DOCUMENT_TYPE
, DOCUMENT_DIRECTION DOCUMENT_DIRECTION
, COLLABORATION_POINT COLLABORATION_POINT
, ORIGINATOR_REFERENCE ORIGINATOR_REFERENCE
, DOCUMENT_STATUS DOCUMENT_STATUS
, NOTIFICATION_ID NOTIFICATION_ID
, MESSAGE_TEXT MESSAGE_TEXT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BSR_VERB BSR_VERB
, BSR_NOUN BSR_NOUN
, BSR_REVISION BSR_REVISION
, SENDER_LOGICAL_ID SENDER_LOGICAL_ID
, SENDER_COMPONENT SENDER_COMPONENT
, SENDER_TASK SENDER_TASK
, SENDER_REFERENCEID SENDER_REFERENCEID
, SENDER_CONFIRMATION SENDER_CONFIRMATION
, SENDER_LANGUAGE SENDER_LANGUAGE
, SENDER_CODEPAGE SENDER_CODEPAGE
, SENDER_AUTHID SENDER_AUTHID
, SENDER_DATETIME_QUALIFIER SENDER_DATETIME_QUALIFIER
, SENDER_DATETIME SENDER_DATETIME
, SENDER_TIMEZONE SENDER_TIMEZONE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, RESEND_FLAG RESEND_FLAG
, XMLG_DOCUMENT_ID XMLG_DOCUMENT_ID
, XMLG_INTERNAL_CONTROL_NUMBER XMLG_INTERNAL_CONTROL_NUMBER
, XMLG_MSG_ID XMLG_MSG_ID
, XMLG_TRANSACTION_SUBTYPE XMLG_TRANSACTION_SUBTYPE
, XMLG_TRANSACTION_TYPE XMLG_TRANSACTION_TYPE
, XMLG_INT_TRANSACTION_SUBTYPE XMLG_INT_TRANSACTION_SUBTYPE
, XMLG_INT_TRANSACTION_TYPE XMLG_INT_TRANSACTION_TYPE
FROM "CLN"."CLN_COLL_HIST_DTL"