[Home] [Help] [Dependency Information]
Object Name: | CLN_COLL_HIST_HDR# |
---|---|
Object Type: | VIEW |
Owner: | CLN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XML_EVENT_KEY | VARCHAR2 | (240) | ||
COLLABORATION_ID | NUMBER | |||
APPLICATION_ID | VARCHAR2 | (10) | ||
APPLICATION_REFERENCE_ID | VARCHAR2 | (100) | ||
ORG_ID | NUMBER | |||
RELEASE_NO | VARCHAR2 | (10) | ||
DOCUMENT_NO | VARCHAR2 | (255) | ||
RESEND_FLAG | VARCHAR2 | (1) | ||
RESEND_COUNT | NUMBER | |||
DOC_REVISION_NO | VARCHAR2 | (10) | ||
PARTNER_DOCUMENT_NO | VARCHAR2 | (255) | ||
COLLABORATION_TYPE | VARCHAR2 | (30) | ||
TRADING_PARTNER | VARCHAR2 | (30) | ||
DOCUMENT_OWNER | VARCHAR2 | (30) | ||
INITIATION_DATE | DATE | |||
DOCUMENT_CREATION_DATE | DATE | |||
DOCUMENT_REVISION_DATE | DATE | |||
COLLABORATION_STATUS | VARCHAR2 | (10) | ||
DISPOSITION | VARCHAR2 | (10) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
XMLG_MSG_ID | VARCHAR2 | (100) | ||
UNIQUE_ID1 | VARCHAR2 | (30) | ||
UNIQUE_ID2 | VARCHAR2 | (30) | ||
UNIQUE_ID3 | VARCHAR2 | (30) | ||
UNIQUE_ID4 | VARCHAR2 | (30) | ||
UNIQUE_ID5 | VARCHAR2 | (30) | ||
XMLG_TRANSACTION_TYPE | VARCHAR2 | (100) | ||
XMLG_TRANSACTION_SUBTYPE | VARCHAR2 | (100) | ||
XMLG_DOCUMENT_ID | VARCHAR2 | (256) | ||
TRADING_PARTNER_TYPE | VARCHAR2 | (10) | ||
TRADING_PARTNER_SITE | VARCHAR2 | (30) | ||
DOCUMENT_DIRECTION | VARCHAR2 | (3) | ||
XMLG_INTERNAL_CONTROL_NUMBER | NUMBER | |||
XMLG_INT_TRANSACTION_SUBTYPE | VARCHAR2 | (100) | ||
XMLG_INT_TRANSACTION_TYPE | VARCHAR2 | (100) | ||
COLLABORATION_STANDARD | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
DATTRIBUTE1 | DATE | |||
DATTRIBUTE2 | DATE | |||
DATTRIBUTE3 | DATE | |||
DATTRIBUTE4 | DATE | |||
DATTRIBUTE5 | DATE | |||
OWNER_ROLE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT XML_EVENT_KEY
, COLLABORATION_ID
, APPLICATION_ID
, APPLICATION_REFERENCE_ID
, ORG_ID
, RELEASE_NO
, DOCUMENT_NO
, RESEND_FLAG
, RESEND_COUNT
, DOC_REVISION_NO
, PARTNER_DOCUMENT_NO
, COLLABORATION_TYPE
, TRADING_PARTNER
, DOCUMENT_OWNER
, INITIATION_DATE
, DOCUMENT_CREATION_DATE
, DOCUMENT_REVISION_DATE
, COLLABORATION_STATUS
, DISPOSITION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, XMLG_MSG_ID
, UNIQUE_ID1
, UNIQUE_ID2
, UNIQUE_ID3
, UNIQUE_ID4
, UNIQUE_ID5
, XMLG_TRANSACTION_TYPE
, XMLG_TRANSACTION_SUBTYPE
, XMLG_DOCUMENT_ID
, TRADING_PARTNER_TYPE
, TRADING_PARTNER_SITE
, DOCUMENT_DIRECTION
, XMLG_INTERNAL_CONTROL_NUMBER
, XMLG_INT_TRANSACTION_SUBTYPE
, XMLG_INT_TRANSACTION_TYPE
, COLLABORATION_STANDARD
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, DATTRIBUTE1
, DATTRIBUTE2
, DATTRIBUTE3
, DATTRIBUTE4
, DATTRIBUTE5
, OWNER_ROLE
FROM CLN.CLN_COLL_HIST_HDR#;
|
|
|