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: CS.CS_INCIDENT_LINKS

Object Details

Object Name:	CS_INCIDENT_LINKS
Object Type:	TABLE
Owner:	CS
FND Design Data:	CS.CS_INCIDENT_LINKS
Subobject Name:
Status:	VALID

Service Request can be linked to another Service Request or to any other object defined in JTF Objects. This link information is stored in this table.
In pre 1159, only SRs linked to other SRs were stored in this table,all other links to external objects were stored as external links in cs_incident_links_ext table. But from 1159, all links are stored in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_INCIDENT_LINKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINK_ID
CS_INCIDENT_LINKS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FROM_INCIDENT_ID
CS_INCIDENT_LINKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TO_INCIDENT_ID
CS_INCIDENT_LINKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID
CS_INCIDENT_LINKS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBJECT_ID SUBJECT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
LINK_ID	NUMBER	(15)	Yes	Link identifier
FROM_INCIDENT_ID	NUMBER	(15)		Obsolete
TO_INCIDENT_ID	NUMBER	(15)		Obsolete
LINK_TYPE	VARCHAR2	(10)
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column - with the user id from FND_USER
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column - with the user id from FND_USER
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
CONTEXT	VARCHAR2	(30)
OBJECT_VERSION_NUMBER	NUMBER			Sequential number used for database locking control when using HTML as a user interface
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
FROM_INCIDENT_NUMBER	VARCHAR2	(64)		Service request number from where the link is created.
TO_INCIDENT_NUMBER	VARCHAR2	(64)		Service request number to where the link is created.
SUBJECT_ID	NUMBER	(15)		Subject's primary key. Eg. if a link is created between and SR(subject) and a Bug(object), then this column stores the primary key of the SR. New for 1159.
SUBJECT_TYPE	VARCHAR2	(30)		Type of the Subject Eg. if a link is created between a SR(subject) and a Bug(object), then this column stores the type of the subject. ie. SR New for 1159.
OBJECT_ID	NUMBER	(15)		Object's primary key. Eg. if a link is created between and SR(subject) and a Bug(object), then this column stores the primary key of the Bug. New for 1159.
OBJECT_TYPE	VARCHAR2	(30)		Type of the Object. Eg. if a link is created between a SR(subject) and a Bug(object), then this column stores the type of the object as stored in column object_code of JTF Objects. ie. SR New for 1159.
OBJECT_NUMBER	VARCHAR2	(90)		Number equivalent of the PK of the object. For eg. if the object is a SR, this column stores the SR's incident number. (For display purposes in the Related Objects Tab) New for 1159. Previous releases used column TO_INCIDENT_NUMBER.
LINK_TYPE_ID	NUMBER	(15)	Yes	Stores the ID of the link type. FK to CS_SR_LINK_TYPES_B.LINK_TYPE_ID. New for 1159.
RECIPROCAL_LINK_ID	NUMBER	(15)		FK To the PK (link_id) in this table. New for 1159.
START_DATE_ACTIVE	DATE			The date from which the link is active. New in 11.5.9.
END_DATE_ACTIVE	DATE			The date on which the link expires. New in 11.5.9.
REQUEST_ID	NUMBER	(15)		If the link record is created by a concurrent program, this colunm store the concurrent program's request if. New for 1159.
PROGRAM_APPLICATION_ID	NUMBER	(15)		If the link record is created by a concurrent program, this column stores the id of the application who owns the concurrent program. (FK to fnd_concurrent_programs.application_id) New for 1159.
PROGRAM_ID	NUMBER	(15)		If the link record is created by a concurrent program, this column stores the id of the concurrent program. (FK to fnd_concurrent_programs.concurrent_program_id) New for 1159.
PROGRAM_UPDATE_DATE	DATE			If the link record is created by a concurrent program, this column stores the date the concurrent program last updated the record.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column. New for 1159.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column . New for 1159.
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment column . New for 1159.
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment column. New for 1159.
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment column. New for 1159.
ATTRIBUTE_CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column
PROGRAM_LOGIN_ID	NUMBER			Standard Who Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINK_ID
,      FROM_INCIDENT_ID
,      TO_INCIDENT_ID
,      LINK_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      FROM_INCIDENT_NUMBER
,      TO_INCIDENT_NUMBER
,      SUBJECT_ID
,      SUBJECT_TYPE
,      OBJECT_ID
,      OBJECT_TYPE
,      OBJECT_NUMBER
,      LINK_TYPE_ID
,      RECIPROCAL_LINK_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CONTEXT
,      PROGRAM_LOGIN_ID
FROM CS.CS_INCIDENT_LINKS;

Dependencies

[top of page]

CS.CS_INCIDENT_LINKS does not reference any database object

CS.CS_INCIDENT_LINKS is referenced by following:

APPS: CS_INCIDENT_LINKS