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: MSC.MSC_SELECTION_CRITERIA

Object Details

Object Name:	MSC_SELECTION_CRITERIA
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_SELECTION_CRITERIA
Subobject Name:
Status:	VALID

MSC Selection Criteria Stores the UI Search selection criteria from Find Window.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_SELECTION_CRITERIA_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FOLDER_OBJECT FIELD_NAME FOLDER_ID
MSC_SELECTION_CRITERIA_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	SEARCH_QUERY_ID FOLDER_OBJECT TREE_NODE

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE	NUMBER		Yes	Criteria sequence
FOLDER_ID	NUMBER		Yes	Folder identifier
FIELD_NAME	VARCHAR2	(30)	Yes	Field name
FIELD_TYPE	VARCHAR2	(10)	Yes	Field type
HIDDEN_FROM_FIELD	VARCHAR2	(250)		From field value
CONDITION	NUMBER			Condition
FROM_FIELD	VARCHAR2	(250)		From field value
TO_FIELD	VARCHAR2	(250)		To field value
FOLDER_OBJECT	VARCHAR2	(30)	Yes	Folder object identifier
TREE_NODE	NUMBER			Tree node
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			Standard Who column
AND_OR	NUMBER			And Or
COUNT_BY	NUMBER			Store checkbox 'display message count' for find exceptions block
SEARCH_QUERY_ID	NUMBER	(38)		Search query identifier
SEARCH_QUERY_NAME	VARCHAR2	(30)		Search query name
DEFAULT_FLAG	NUMBER	(38)		Default flag
PUBLIC_FLAG	NUMBER	(38)		Public flag
FROM_FIELD_VALUE	VARCHAR2	(250)		From field value
TO_FIELD_VALUE	VARCHAR2	(250)		To field value
OBJECT_TYPE	NUMBER			Exception Type
SOURCE_TYPE	NUMBER			Source Type, CP or EXCP
ACTIVE_FLAG	NUMBER			Flag to indicate whether the criteria is active or not
OBJECT_SEQUENCE_ID	NUMBER			Sequence Id for the same object type

Query Text

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


SELECT SEQUENCE
,      FOLDER_ID
,      FIELD_NAME
,      FIELD_TYPE
,      HIDDEN_FROM_FIELD
,      CONDITION
,      FROM_FIELD
,      TO_FIELD
,      FOLDER_OBJECT
,      TREE_NODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AND_OR
,      COUNT_BY
,      SEARCH_QUERY_ID
,      SEARCH_QUERY_NAME
,      DEFAULT_FLAG
,      PUBLIC_FLAG
,      FROM_FIELD_VALUE
,      TO_FIELD_VALUE
,      OBJECT_TYPE
,      SOURCE_TYPE
,      ACTIVE_FLAG
,      OBJECT_SEQUENCE_ID
FROM MSC.MSC_SELECTION_CRITERIA;

Dependencies

[top of page]

MSC.MSC_SELECTION_CRITERIA does not reference any database object

MSC.MSC_SELECTION_CRITERIA is referenced by following:

MSC: MSC_SELECTION_CRITERIA#