[Home] [Help] [Dependency Information]
Object Name: | MST_SELECTION_CRITERIA |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
N
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MST_SELECTION_CRITERIA_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
QUERY_ID
FIELD_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Yes | FK to QUERY_ID of MST_PERSONAL_QUERIES | |
FIELD_NAME | VARCHAR2 | (30) | Yes | Name of the Field |
SEQUENCE | NUMBER | Sequence number in the Query | ||
FILTER_TYPE | NUMBER | Filter type for the Field. 1=>Equals, 2=>Not Equals, 3 => Among, 4=>Between, 5=>Like, 6=>Less than, 7=>Greater than, 8=>Atleast, 9=>Atmost. | ||
FIELD_VALUE_FROM | VARCHAR2 | (2000) | FROM values for the Specific Field. | |
DISPLAY_VALUE | VARCHAR2 | (2000) | Displayed FROM values for the Specific Field. | |
FIELD_VALUE_TO | VARCHAR2 | (2000) | TO values for the Specific Field. | |
MULTI_SELECT | NUMBER | Flag to Allow Multiselection. 1=>Yes, 2=>No. | ||
ACTIVE_FLAG | NUMBER | Flag to indicate Active Condition. 1=>Yes, 2=>No | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
DISPLAY_VALUE2 | VARCHAR2 | (2000) | Displayed TO values for the Specific Field. |
Cut, paste (and edit) the following text to query this object:
SELECT QUERY_ID
, FIELD_NAME
, SEQUENCE
, FILTER_TYPE
, FIELD_VALUE_FROM
, DISPLAY_VALUE
, FIELD_VALUE_TO
, MULTI_SELECT
, ACTIVE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DISPLAY_VALUE2
FROM MST.MST_SELECTION_CRITERIA;
MST.MST_SELECTION_CRITERIA does not reference any database object
MST.MST_SELECTION_CRITERIA is referenced by following:
|
|
|