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_KB_SETS_TL

Object Details

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

Knowledge Base Sets (Translation table). This table stores the translatable Solution Title.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: SYS_C00219658

SET_ID
LANGUAGE

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_KB_SETS_TL_U1	NORMAL	UNIQUE	APPS_TS_TX_DATA	SET_ID LANGUAGE
SYS_IL0000132875C00015$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000132875C00016$$	LOB	UNIQUE	APPS_TS_TX_DATA
CS_KB_SETS_ATTACH_TL_N3	DOMAIN	NONUNIQUE		COMPOSITE_ASSOC_ATTACH_INDEX
CS_KB_SETS_TL_N3	DOMAIN	NONUNIQUE		COMPOSITE_ASSOC_INDEX
CS_KB_SETS_TL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NAME LANGUAGE

Columns

Name	Datatype	Length	Mandatory	Comments
SET_ID	NUMBER	(15)	Yes	Set id.
LANGUAGE	VARCHAR2	(4)	Yes	Language.
SOURCE_LANG	VARCHAR2	(4)	Yes	Source language.
NAME	VARCHAR2	(500)	Yes	Name.
DESCRIPTION	VARCHAR2	(30)		Description.
COMPOSITE_ASSOC_INDEX	VARCHAR2	(30)		Dummy column, use to create the intermedia index for all statements.
POSITIVE_ASSOC_INDEX	VARCHAR2	(30)		Dummy column, use to create the intermedia index for all positive statements within solutions.- This Column is Obsolete
NEGATIVE_ASSOC_INDEX	VARCHAR2	(30)		Dummy column, use to create the intermedia index for all negative statements within solutions.- This Column is Obsolete
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CONTENT_CACHE	CLOB	(4000)		This is a cache column to store the synthesized solution content to be Text indexed. This does not include Security Information
ATTACHMENT_CONTENT_CACHE	CLOB	(4000)		Store Attachment Cache
COMPOSITE_ASSOC_ATTACH_INDEX	VARCHAR2	(30)		Index value for comosite attachment index

Query Text

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


SELECT SET_ID
,      LANGUAGE
,      SOURCE_LANG
,      NAME
,      DESCRIPTION
,      COMPOSITE_ASSOC_INDEX
,      POSITIVE_ASSOC_INDEX
,      NEGATIVE_ASSOC_INDEX
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      CONTENT_CACHE
,      ATTACHMENT_CONTENT_CACHE
,      COMPOSITE_ASSOC_ATTACH_INDEX
FROM CS.CS_KB_SETS_TL;

Dependencies

[top of page]

CS.CS_KB_SETS_TL does not reference any database object

CS.CS_KB_SETS_TL is referenced by following:

CS: CS_KB_SETS_TL#