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_SR_LINK_TYPES_B

Object Details

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

This table is used to store all the valid relationship Types between service request and service request and between service request and other business objects. The relationship description is stored in the translation table CS_SR_LINK_TYPES_TL. This table was introduced in 1159.
Users cannot create new link type in 1159. All link types are seeded.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_SR_LINK_TYPES_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	LINK_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINK_TYPE_ID	NUMBER	(15)	Yes	Identifier of the Link Type
RECIPROCAL_LINK_TYPE_ID	NUMBER	(15)		Column stores the id of the reciprocal link type for this link. This is an FK to the Primay Key of this table.
START_DATE_ACTIVE	DATE			Date from which the link was / will be active.
END_DATE_ACTIVE	DATE			Date from which the link was / will be inactive.
LAST_UPDATE_DATE	DATE		Yes	Who column. Date the record was last updated.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who column. ID of the user who last updated the record.
CREATED_BY	NUMBER	(15)		Who column. User id of the user who created the record.
CREATION_DATE	DATE		Yes	Who column. Date on which the record was created.
LAST_UPDATE_LOGIN	NUMBER	(15)		Who column. Login ID of the OS user who last updated the record.
APPLICATION_ID	NUMBER	(15)		ID of the application that owns the seeded record. FK to fnd_application.application_id
SEEDED_FLAG	VARCHAR2	(3)		Flag to denote if the record is seeded or not. Valued provided by lookup codes for lookup type CS_YES_NO.
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
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)		Flex field context.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Specifies how many updates the link record has gone through. This value is used in obtainint a lock before updates are performed.
SECURITY_GROUP_ID	NUMBER	(15)		Data striping attribute used by the Hosting product.

Query Text

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


SELECT LINK_TYPE_ID
,      RECIPROCAL_LINK_TYPE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      APPLICATION_ID
,      SEEDED_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CONTEXT
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
FROM CS.CS_SR_LINK_TYPES_B;

Dependencies

[top of page]

CS.CS_SR_LINK_TYPES_B does not reference any database object

CS.CS_SR_LINK_TYPES_B is referenced by following:

APPS: CS_SR_LINK_TYPES_B