[Home] [Help] [Dependency Information]
Object Name: | EGO_CRITERIA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_CRITERIA_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Yes | The Application ID of the Product Team using the Customization |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Yes | The Unique ID that identifies the Customization |
REGION_APPLICATION_ID | NUMBER | (15) | Yes | The Application ID of the Product Team using the Customization |
REGION_CODE | VARCHAR2 | (30) | Yes | The Common Region Code that is used for each kind of Customization |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Yes | The Application ID of the Attribute included as a Criterion in the Customization |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | The Unique Attribute code of the Attribute included as a Criterion in the Customization |
SEQUENCE_NUMBER | NUMBER | (15) | Yes | The Sequence in which the Attributes appear in the Customization |
OPERATION | VARCHAR2 | (30) | Yes | The Operation applied to the Attribute while searching |
VALUE_VARCHAR2 | VARCHAR2 | (240) | The Value of the Varchar attribute | |
SECOND_VALUE_VARCHAR2 | VARCHAR2 | (240) | The second string value for the criterion | |
VALUE_NUMBER | NUMBER | (15) | The Value of the Number attribute | |
SECOND_VALUE_NUMBER | NUMBER | (15) | The second number value for the criterion (useful for between) | |
VALUE_DATE | DATE | The Value of the Date attribute | ||
SECOND_VALUE_DATE | DATE | The second date value for the criterion | ||
START_DATE_ACTIVE | DATE | Yes | The Date since when the Attribute is Actively used while searching | |
END_DATE_ACTIVE | DATE | The Date since when the Attribute is Disabled used while searching | ||
USE_KEYWORD_SEARCH | VARCHAR2 | (30) | The Sequence in which the Attributes appear in the Customization | |
MATCH_CONDITION | VARCHAR2 | (30) | The Sequence in which the Attributes appear in the Customization | |
FUZZY | VARCHAR2 | (1) | Indicates whether to apply Fuzzy logic for values specified for attributes while searching for entities | |
STEMMING | VARCHAR2 | (1) | Indicates whether to apply Stemming logic for values specified for attributes while searching for entities | |
SYNONYMS | VARCHAR2 | (1) | Indicates whether to apply Synonyms logic for values specified for attributes while searching for entities |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE
, REGION_APPLICATION_ID
, REGION_CODE
, ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_CODE
, SEQUENCE_NUMBER
, OPERATION
, VALUE_VARCHAR2
, SECOND_VALUE_VARCHAR2
, VALUE_NUMBER
, SECOND_VALUE_NUMBER
, VALUE_DATE
, SECOND_VALUE_DATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, USE_KEYWORD_SEARCH
, MATCH_CONDITION
, FUZZY
, STEMMING
, SYNONYMS
FROM APPS.EGO_CRITERIA_V;
|
|
|