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_HDR

Object Details

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

Stores the header 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_HDR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COLLABORATION_ID
CLN_COLL_HIST_HDR_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_REFERENCE_ID
CLN_COLL_HIST_HDR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID DOCUMENT_NO
CLN_COLL_HIST_HDR_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XMLG_TRANSACTION_TYPE XMLG_TRANSACTION_SUBTYPE XMLG_DOCUMENT_ID
CLN_COLL_HIST_HDR_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XMLG_MSG_ID
CLN_COLL_HIST_HDR_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XMLG_INTERNAL_CONTROL_NUMBER

Columns

Name	Datatype	Length	Comments
XML_EVENT_KEY	VARCHAR2	(240)	This parameter stores the event key.
COLLABORATION_ID	NUMBER		This is a unique running serial number generated by collaboration History Module, this uniquely identifies collaboration.
APPLICATION_ID	VARCHAR2	(10)	The ID of the application that is using this document.
APPLICATION_REFERENCE_ID	VARCHAR2	(100)	Any reference number that uniquely identifies this collaboration from integrating application point of view.
ORG_ID	NUMBER		Organization ID from application.
RELEASE_NO	VARCHAR2	(10)	Release Number from Application.
DOCUMENT_NO	VARCHAR2	(255)	The number that identifies this transaction in the application.
RESEND_FLAG	VARCHAR2	(1)	If this message was resent or not e.g. Y for yes and N for no.
RESEND_COUNT	NUMBER		Number of times the original message was resent.
DOC_REVISION_NO	VARCHAR2	(10)	Revision Number of the document.
PARTNER_DOCUMENT_NO	VARCHAR2	(255)	The document number from the Trading partner if the collaboration was intiated from his end.
COLLABORATION_TYPE	VARCHAR2	(30)	Type of the collaboration. For example Order, Change Order.
TRADING_PARTNER	VARCHAR2	(30)	ID that uniquely identifies the trading partner.
DOCUMENT_OWNER	VARCHAR2	(30)	One who create the Doc.
INITIATION_DATE	DATE		Initial date of creation of the collaboration.
DOCUMENT_CREATION_DATE	DATE		Document Creation date.
DOCUMENT_REVISION_DATE	DATE		Document Revision date.
COLLABORATION_STATUS	VARCHAR2	(10)	Status of the collaboration.
DISPOSITION	VARCHAR2	(10)	Status of the transaction.
LAST_UPDATE_DATE	DATE		Standard who column.
LAST_UPDATED_BY	NUMBER		Standard who column.
CREATION_DATE	DATE		Standard who column.
CREATED_BY	NUMBER		Standard who column.
LAST_UPDATE_LOGIN	NUMBER		Standard who column.
XMLG_MSG_ID	VARCHAR2	(100)	Unique ID generated by XML Gateway for each XML document.
UNIQUE_ID1	VARCHAR2	(30)	Unique ID for identifying Collaboration.
UNIQUE_ID2	VARCHAR2	(30)	Unique ID for identifying Collaboration.
UNIQUE_ID3	VARCHAR2	(30)	Unique ID for identifying Collaboration.
UNIQUE_ID4	VARCHAR2	(30)	Unique ID for identifying Collaboration.
UNIQUE_ID5	VARCHAR2	(30)	Unique ID for identifying Collaboration.
XMLG_TRANSACTION_TYPE	VARCHAR2	(100)	Transaction Type defined in the XMLG setting.
XMLG_TRANSACTION_SUBTYPE	VARCHAR2	(100)	Transaction sub type defined in the XMLG setting.
XMLG_DOCUMENT_ID	VARCHAR2	(256)	XML Gateway document ID.
TRADING_PARTNER_TYPE	VARCHAR2	(10)	Trading Partner Type S for Supplier, C Customer, B Bank etc...
TRADING_PARTNER_SITE	VARCHAR2	(30)	Trading Partner Site.
DOCUMENT_DIRECTION	VARCHAR2	(3)	Direction of the document.
XMLG_INTERNAL_CONTROL_NUMBER	NUMBER		Internal Control NUmber as generated by the XMLG.
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.
COLLABORATION_STANDARD	VARCHAR2	(30)	Collaboration Standard
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)

Query Text

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;

Dependencies

[top of page]

CLN.CLN_COLL_HIST_HDR does not reference any database object

CLN.CLN_COLL_HIST_HDR is referenced by following:

APPS: CLN_COLL_HIST_HDR