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_VALID_OBJ

Object Details

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

Stores link types and the objects (in JTF Objects) that can be linked with the type. Links are restricted in use to only a selected number of objects. For eg. a SR **cannot** be a 'Duplicate Of' a Defect, it can only be a 'Duplicate Of' another SR. This tables holds such setup data.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_SR_LINK_VALID_OBJ_U1	NORMAL	UNIQUE	APPS_TS_SEED	LINK_VALID_OBJ_ID ZD_EDITION_NAME
CS_SR_LINK_VALID_OBJ_U2	NORMAL	NONUNIQUE	APPS_TS_SEED	LINK_TYPE_ID SUBJECT_TYPE OBJECT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
LINK_VALID_OBJ_ID	NUMBER	(15)	Yes	Identifier of the Link between two Object types
SUBJECT_TYPE	VARCHAR2	(90)	Yes	JTF Object tye of the subject. FK to JTF_OBJECTS_B.OBJECT_CODE.
OBJECT_TYPE	VARCHAR2	(90)	Yes	JTF Object tye of the object. FK to JTF_OBJECTS_B.OBJECT_CODE.
LINK_TYPE_ID	NUMBER	(15)	Yes	Stores the ID of the link type that is allowed between a subject (type) and an object (type). FK to CS_INCIDENT_LINK_TYPES_B.LINK_TYPE_ID.
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.
CREATED_BY	NUMBER	(15)	Yes	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_DATE	DATE		Yes	Who column. Date the record was last updated.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who column. ID of the use who last updated the record.
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.
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.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT LINK_VALID_OBJ_ID
,      SUBJECT_TYPE
,      OBJECT_TYPE
,      LINK_TYPE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      APPLICATION_ID
,      SEEDED_FLAG
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM CS.CS_SR_LINK_VALID_OBJ;

Dependencies

[top of page]

CS.CS_SR_LINK_VALID_OBJ does not reference any database object

CS.CS_SR_LINK_VALID_OBJ is referenced by following:

CS: CS_SR_LINK_VALID_OBJ#