VIEW: CLN.CLN_COLL_HIST_HDR#

Source

View Text - Preformatted

select XML_EVENT_KEY XML_EVENT_KEY, COLLABORATION_ID COLLABORATION_ID, APPLICATION_ID APPLICATION_ID, APPLICATION_REFERENCE_ID APPLICATION_REFERENCE_ID, ORG_ID ORG_ID, RELEASE_NO RELEASE_NO, DOCUMENT_NO DOCUMENT_NO, RESEND_FLAG RESEND_FLAG, RESEND_COUNT RESEND_COUNT, DOC_REVISION_NO DOC_REVISION_NO, PARTNER_DOCUMENT_NO PARTNER_DOCUMENT_NO, COLLABORATION_TYPE COLLABORATION_TYPE, TRADING_PARTNER TRADING_PARTNER, DOCUMENT_OWNER DOCUMENT_OWNER, INITIATION_DATE INITIATION_DATE, DOCUMENT_CREATION_DATE DOCUMENT_CREATION_DATE, DOCUMENT_REVISION_DATE DOCUMENT_REVISION_DATE, COLLABORATION_STATUS COLLABORATION_STATUS, DISPOSITION DISPOSITION, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, XMLG_MSG_ID XMLG_MSG_ID, UNIQUE_ID1 UNIQUE_ID1, UNIQUE_ID2 UNIQUE_ID2, UNIQUE_ID3 UNIQUE_ID3, UNIQUE_ID4 UNIQUE_ID4, UNIQUE_ID5 UNIQUE_ID5, XMLG_TRANSACTION_TYPE XMLG_TRANSACTION_TYPE, XMLG_TRANSACTION_SUBTYPE XMLG_TRANSACTION_SUBTYPE, XMLG_DOCUMENT_ID XMLG_DOCUMENT_ID, TRADING_PARTNER_TYPE TRADING_PARTNER_TYPE, TRADING_PARTNER_SITE TRADING_PARTNER_SITE, DOCUMENT_DIRECTION DOCUMENT_DIRECTION, XMLG_INTERNAL_CONTROL_NUMBER XMLG_INTERNAL_CONTROL_NUMBER, XMLG_INT_TRANSACTION_SUBTYPE XMLG_INT_TRANSACTION_SUBTYPE, XMLG_INT_TRANSACTION_TYPE XMLG_INT_TRANSACTION_TYPE, COLLABORATION_STANDARD COLLABORATION_STANDARD, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, DATTRIBUTE1 DATTRIBUTE1, DATTRIBUTE2 DATTRIBUTE2, DATTRIBUTE3 DATTRIBUTE3, DATTRIBUTE4 DATTRIBUTE4, DATTRIBUTE5 DATTRIBUTE5, OWNER_ROLE OWNER_ROLE from "CLN"."CLN_COLL_HIST_HDR"

View Text - HTML Formatted

SELECT XML_EVENT_KEY XML_EVENT_KEY
, COLLABORATION_ID COLLABORATION_ID
, APPLICATION_ID APPLICATION_ID
, APPLICATION_REFERENCE_ID APPLICATION_REFERENCE_ID
, ORG_ID ORG_ID
, RELEASE_NO RELEASE_NO
, DOCUMENT_NO DOCUMENT_NO
, RESEND_FLAG RESEND_FLAG
, RESEND_COUNT RESEND_COUNT
, DOC_REVISION_NO DOC_REVISION_NO
, PARTNER_DOCUMENT_NO PARTNER_DOCUMENT_NO
, COLLABORATION_TYPE COLLABORATION_TYPE
, TRADING_PARTNER TRADING_PARTNER
, DOCUMENT_OWNER DOCUMENT_OWNER
, INITIATION_DATE INITIATION_DATE
, DOCUMENT_CREATION_DATE DOCUMENT_CREATION_DATE
, DOCUMENT_REVISION_DATE DOCUMENT_REVISION_DATE
, COLLABORATION_STATUS COLLABORATION_STATUS
, DISPOSITION DISPOSITION
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XMLG_MSG_ID XMLG_MSG_ID
, UNIQUE_ID1 UNIQUE_ID1
, UNIQUE_ID2 UNIQUE_ID2
, UNIQUE_ID3 UNIQUE_ID3
, UNIQUE_ID4 UNIQUE_ID4
, UNIQUE_ID5 UNIQUE_ID5
, XMLG_TRANSACTION_TYPE XMLG_TRANSACTION_TYPE
, XMLG_TRANSACTION_SUBTYPE XMLG_TRANSACTION_SUBTYPE
, XMLG_DOCUMENT_ID XMLG_DOCUMENT_ID
, TRADING_PARTNER_TYPE TRADING_PARTNER_TYPE
, TRADING_PARTNER_SITE TRADING_PARTNER_SITE
, DOCUMENT_DIRECTION DOCUMENT_DIRECTION
, XMLG_INTERNAL_CONTROL_NUMBER XMLG_INTERNAL_CONTROL_NUMBER
, XMLG_INT_TRANSACTION_SUBTYPE XMLG_INT_TRANSACTION_SUBTYPE
, XMLG_INT_TRANSACTION_TYPE XMLG_INT_TRANSACTION_TYPE
, COLLABORATION_STANDARD COLLABORATION_STANDARD
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, DATTRIBUTE1 DATTRIBUTE1
, DATTRIBUTE2 DATTRIBUTE2
, DATTRIBUTE3 DATTRIBUTE3
, DATTRIBUTE4 DATTRIBUTE4
, DATTRIBUTE5 DATTRIBUTE5
, OWNER_ROLE OWNER_ROLE
FROM "CLN"."CLN_COLL_HIST_HDR"