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_TEMPLATES_V

Object Details

Object Name:	EGO_CRITERIA_TEMPLATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_CRITERIA_TEMPLATES_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	One of the PK values for a criteria template
CUSTOMIZATION_CODE	VARCHAR2	(30)	Yes	One of the PK values for a criteria template
REGION_APPLICATION_ID	NUMBER	(15)	Yes	One of the PK values for a criteria template
REGION_CODE	VARCHAR2	(30)	Yes	One of the PK values for a criteria template
DEFAULT_CUSTOMIZATION_FLAG	VARCHAR2	(1)		Whether this is the default template for the object with which it is associated (Y or N)
DEFAULT_CUST_FLAG_MEANING	VARCHAR2	(80)	Yes	The meaning of the default customization flag
START_DATE_ACTIVE	DATE		Yes	The first date that the criteria template is active
END_DATE_ACTIVE	DATE			The last date that the criteria template is active
NAME	VARCHAR2	(80)	Yes	The name of the criteria template
DESCRIPTION	VARCHAR2	(2000)		The description of the criteria template
CLASSIFICATION1	VARCHAR2	(50)		The first classification of the object for which the template is associated
CLASSIFICATION2	VARCHAR2	(50)		The second classification of the object for which the template is associated
CLASSIFICATION3	VARCHAR2	(50)		The third classification of the object for which the template is associated
RF_CUSTOMIZATION_APPL_ID	NUMBER	(15)		The customization application id of the associated results format
RF_CUSTOMIZATION_CODE	VARCHAR2	(30)		The customization code of the associated results format
RF_REGION_APPLICATION_ID	NUMBER	(15)		The region application code of the associated results format
RF_REGION_CODE	VARCHAR2	(30)		The region code of the associated results format
CUSTOMIZATION_LEVEL_ID	NUMBER	(15)	Yes	Whether this is site level or user level
SITE_ID	NUMBER	(15)		If it is site level, the id of the site
WEB_USER_ID	NUMBER	(15)		If it is user level, the id of the user

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMIZATION_APPLICATION_ID
,      CUSTOMIZATION_CODE
,      REGION_APPLICATION_ID
,      REGION_CODE
,      DEFAULT_CUSTOMIZATION_FLAG
,      DEFAULT_CUST_FLAG_MEANING
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      NAME
,      DESCRIPTION
,      CLASSIFICATION1
,      CLASSIFICATION2
,      CLASSIFICATION3
,      RF_CUSTOMIZATION_APPL_ID
,      RF_CUSTOMIZATION_CODE
,      RF_REGION_APPLICATION_ID
,      RF_REGION_CODE
,      CUSTOMIZATION_LEVEL_ID
,      SITE_ID
,      WEB_USER_ID
FROM APPS.EGO_CRITERIA_TEMPLATES_V;

Dependencies

[top of page]

APPS.EGO_CRITERIA_TEMPLATES_V references the following:

APPS: AK_CUSTOMIZATIONS; AK_CUSTOMIZATIONS_TL; EGO_CUSTOMIZATION_EXT; FND_LOOKUP_VALUES

APPS.EGO_CRITERIA_TEMPLATES_V is referenced by following:

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