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_CF_SOURCE_CXT_TYPES

Object Details

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

CS_CF_SOURCE_CXT_TYPES is used to store all the possible contexts for a given source and is used in conjunction with other tables to store configurations for features in iSupport. This table is initially only a SEED table and will not be modified during normal operation.
A source type may refer to a page, a page flow typ, or other entities, as specified in the SOURCE_TYPE column.
The different context types allowed are defined in FND_LOOKUPS with a lookup type of IBU_CF_CONTEXT_TYPE. Each possible source is defined in FND_LOOKUPS with lookup types of IBU_CF_PAGE, or IBU_CF_FLOW_TYPE and can be extended to include other types as well.
Each source-context mapping is associated with a PRIORITY. This priority is used to determine the
precedence of the context types for each source type - the lower the priority, the higher the precedence.
SOURCE_CONTEXT_TYPE_ID is the unique identifier of each row.
For example:
The page IBU_SR_CR_IDENTIFY_PROBLEM may have different configurations stored at
the context levels GLOBAL and RESPONSIBILITY, with the configuration at the RESPONSIBILITY level taking precedence. Possible entries in this table may be
20 IBU_SR_CR_IDENTIFY_PROBLEM GLOBAL 50 IBU_CF_PAGE
30 IBU_SR_CR_IDENTIFY_PROBLEM RESP 40 IBU_CF_PAGE

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_CF_SOURCE_CXT_TYPES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_CONTEXT_TYPE_ID
CS_CF_SOURCE_CXT_TYPES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PURPOSE
CS_CF_SOURCE_CXT_TYPES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_CODE
CS_CF_SOURCE_CXT_TYPES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_CONTEXT_TYPE_ID	NUMBER	(15)	Yes	This is the primary key column.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Sequential number used for database locking control
SOURCE_CODE	VARCHAR2	(30)	Yes	Indicates the page, flow type or other defined source.
CONTEXT_TYPE	VARCHAR2	(30)	Yes	Context type available for this source code.
PRIORITY	NUMBER	(15)	Yes	Indicates the priority of the context type for the particular source code.
SOURCE_TYPE	VARCHAR2	(30)	Yes	Indicates the source type referenced for this mapping.
PURPOSE	VARCHAR2	(30)	Yes	Stores the context in which this row of information is used.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT SOURCE_CONTEXT_TYPE_ID
,      OBJECT_VERSION_NUMBER
,      SOURCE_CODE
,      CONTEXT_TYPE
,      PRIORITY
,      SOURCE_TYPE
,      PURPOSE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CS.CS_CF_SOURCE_CXT_TYPES;

Dependencies

[top of page]

CS.CS_CF_SOURCE_CXT_TYPES does not reference any database object

CS.CS_CF_SOURCE_CXT_TYPES is referenced by following:

APPS: CS_CF_SOURCE_CXT_TYPES