eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CLN.CLN_COLL_HIST_DTL

Object Details

Object Name:	CLN_COLL_HIST_DTL
Object Type:	TABLE
Owner:	CLN
FND Design Data:	CLN.CLN_COLL_HIST_DTL
Subobject Name:
Status:	VALID

Stores the detail information for any collaboration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CLN_COLL_HIST_DTL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COLLABORATION_DTL_ID
CLN_COLL_HIST_DTL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLABORATION_ID
CLN_COLL_HIST_DTL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XMLG_INTERNAL_CONTROL_NUMBER
CLN_COLL_HIST_DTL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XMLG_MSG_ID

Columns

Name	Datatype	Length	Comments
XML_EVENT_KEY	VARCHAR2	(240)	This parameter stores the event key.
COLLABORATION_DTL_ID	NUMBER		This is a unique running serial number generated by collaboration History Module. This uniquely identifies the collaboration details.
COLLABORATION_ID	NUMBER		This is a unique running serial number generated by collaboration History Module, this uniquely identifies collaboration.
COLLABORATION_DOCUMENT_TYPE	VARCHAR2	(100)	Type of the message that is sent or received. For examples typically in Oracle apps we have Process PO, Confirmation and ACK PO.
DOCUMENT_DIRECTION	VARCHAR2	(3)	Whether the direction of the collaboration is inbound (IN) or outbound (OUT).
COLLABORATION_POINT	VARCHAR2	(20)	The module/system, which is the source of the History transaction. APPS, XMLG, B2B Gateway etc.
ORIGINATOR_REFERENCE	VARCHAR2	(255)	Any reference number from the message generator so as to identify the message. This can be taken as a reference id passed on by different individual components like XML gateway, 9iAS server etc.
DOCUMENT_STATUS	VARCHAR2	(10)	Status of the document.
NOTIFICATION_ID	VARCHAR2	(100)	Notification ID of the collaboration.
MESSAGE_TEXT	VARCHAR2	(2000)	Any message associated with the document.
CREATION_DATE	DATE		Standard who column.
CREATED_BY	NUMBER		Standard who column.
LAST_UPDATE_DATE	DATE		Standard who column.
LAST_UPDATED_BY	NUMBER		Standard who column.
LAST_UPDATE_LOGIN	NUMBER		Standard who column.
BSR_VERB	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
BSR_NOUN	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
BSR_REVISION	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_LOGICAL_ID	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_COMPONENT	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_TASK	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_REFERENCEID	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_CONFIRMATION	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_LANGUAGE	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_CODEPAGE	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_AUTHID	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_DATETIME_QUALIFIER	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_DATETIME	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
SENDER_TIMEZONE	VARCHAR2	(240)	Represent the elements in the Control area of OAG XML.
ATTRIBUTE1	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE2	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE3	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE4	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE5	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE6	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE7	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE8	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE9	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE10	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE11	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE12	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE13	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE14	VARCHAR2	(240)	Additional attribute provided for later use.
ATTRIBUTE15	VARCHAR2	(240)	Additional attribute provided for later use.
RESEND_FLAG	VARCHAR2	(1)	If this message was resent or not e.g. Y for yes and N for no.
XMLG_DOCUMENT_ID	VARCHAR2	(256)	Unique ID for the document.
XMLG_INTERNAL_CONTROL_NUMBER	NUMBER		Interanl control number as generated by the XMLG.
XMLG_MSG_ID	VARCHAR2	(100)	Msg ID generated by the XMLG for each document.
XMLG_TRANSACTION_SUBTYPE	VARCHAR2	(100)	External transaction sub type for the document.
XMLG_TRANSACTION_TYPE	VARCHAR2	(100)	External transaction type for the document.
XMLG_INT_TRANSACTION_SUBTYPE	VARCHAR2	(100)	This represents the Internal Transaction SubType for the transaction in the XML Gateway setup.
XMLG_INT_TRANSACTION_TYPE	VARCHAR2	(100)	This represents the Internal Transaction Type for the transaction in the XML Gateway setup.

Query Text

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;

Dependencies

[top of page]

CLN.CLN_COLL_HIST_DTL does not reference any database object

CLN.CLN_COLL_HIST_DTL is referenced by following:

CLN: CLN_COLL_HIST_DTL#