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_SAVED_ADV_CRITERIA

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_SR_SAVED_ADV_CRITERIA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEARCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SEARCH_ID	NUMBER		Yes	The identifier of the saved search.
CREATION_DATE	DATE		Yes	Standard Who Column.
CREATED_BY	NUMBER		Yes	Standard Who Column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
FIELD_NAME	VARCHAR2	(60)		The name of the field on which the search was performed.
FIELD_NAME_ID	VARCHAR2	(30)		The identifier value of the field on which the search was performed.
FIELD_VALUE	VARCHAR2	(240)		The value in the field with which the search was performed.
FIELD_VALUE_ID	VARCHAR2	(90)		The identifier of the value in the field with which the search was performed.
OBJECT_VERSION_NUMBER	NUMBER		Yes	The object version number.
ROWNUM_IN_LAYOUT	NUMBER			Indicates the record number in the multi record block of the advanced query.
CONDITION	VARCHAR2	(30)		This column stores the logical condition that was used to construct the SQL.

Query Text

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


SELECT SEARCH_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      FIELD_NAME
,      FIELD_NAME_ID
,      FIELD_VALUE
,      FIELD_VALUE_ID
,      OBJECT_VERSION_NUMBER
,      ROWNUM_IN_LAYOUT
,      CONDITION
FROM CS.CS_SR_SAVED_ADV_CRITERIA;