[Home] [Help] [Dependency Information]
Object Name: | EGO_CRITERIA_EXT |
---|---|
Object Type: | TABLE |
Owner: | EGO |
FND Design Data: | EGO.EGO_CRITERIA_EXT |
Subobject Name: | |
Status: | VALID |
This table is used to store the extra Matching attributes for every Criteria
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_CRITERIA_EXT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CUSTOMIZATION_APPLICATION_ID
CUSTOMIZATION_CODE REGION_APPLICATION_ID REGION_CODE ATTRIBUTE_APPLICATION_ID ATTRIBUTE_CODE SEQUENCE_NUMBER ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | The Application ID of the Product Team using the Customization. Foreign Key from the AK_CRITERIA Table | |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | The Unique ID that identifies the Customization. Foreign Key from the AK_CRITERIA Table | |
REGION_APPLICATION_ID | NUMBER | (15) | The Application ID of the Product Team using the Customization. Foreign Key from the AK_CRITERIA Table | |
REGION_CODE | VARCHAR2 | (30) | The Common Region Code that is used for each kind of Customization. Foreign Key from the AK_CRITERIA Table | |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | The Application ID of the Attribute included as a Criterion in the Customization. Foreign Key from the AK_CRITERIA Table | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | The Unique Attribute code of the Attribute included as a Criterion in the Customization. Foreign Key from the AK_CRITERIA Table |
SEQUENCE_NUMBER | NUMBER | (15) | The Sequence in which the Attributes appear in the Customization. Foreign Key from the AK_CRITERIA Table | |
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 | |
CREATED_BY | NUMBER | (15) | One of the five standard "WHO" columns | |
CREATION_DATE | DATE | One of the five standard "WHO" columns | ||
LAST_UPDATED_BY | NUMBER | (15) | One of the five standard "WHO" columns | |
LAST_UPDATED_DATE | DATE | One of the five standard "WHO" columns | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | One of the five standard "WHO" columns | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
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
, USE_KEYWORD_SEARCH
, MATCH_CONDITION
, FUZZY
, STEMMING
, SYNONYMS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM EGO.EGO_CRITERIA_EXT;
EGO.EGO_CRITERIA_EXT does not reference any database object
EGO.EGO_CRITERIA_EXT is referenced by following:
|
|
|