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: EGO.EGO_CRITERIA_EXT

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

EGO.EGO_CRITERIA_EXT does not reference any database object

EGO.EGO_CRITERIA_EXT is referenced by following:

EGO: EGO_CRITERIA_EXT#