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]

VIEW: APPS.EGO_CRITERIA_V

Object Details

Object Name:	EGO_CRITERIA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_CRITERIA_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

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

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
,      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;

Dependencies

[top of page]

APPS.EGO_CRITERIA_V references the following:

APPS: AK_CRITERIA; EGO_CRITERIA_EXT

APPS.EGO_CRITERIA_V is referenced by following:

APPS: BOM_COPY_BILL - show dependent code; BOM_VALIDATE_BOM_COMPONENT - show dependent code