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_RESULTS_FORMAT_V

Object Details

Object Name:	EGO_RESULTS_FORMAT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_RESULTS_FORMAT_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 results format
CUSTOMIZATION_CODE	VARCHAR2	(30)	Yes	One of the PK values for a results format
REGION_APPLICATION_ID	NUMBER	(15)	Yes	One of the PK values for a results format
REGION_CODE	VARCHAR2	(30)	Yes	One of the PK values for a results format
NAME	VARCHAR2	(2000)		The name of the results format
DESCRIPTION	VARCHAR2	(2000)		A description of the results format
NUM_ROWS_DISPLAYED	NUMBER			The number of rows displayed in the results format
DEFAULT_RESULT_FLAG	VARCHAR2	(2000)		Whether this is the default results format for the object with which the results format is associated
DEFAULT_RESULT_FLAG_MEANING	VARCHAR2	(80)	Yes	The meaning of the default result flag
CLASSIFICATION1	VARCHAR2	(50)		The first classification of the object with which the results format is associated
CLASSIFICATION2	VARCHAR2	(50)		The second classification of the object with which the results format is associated
CLASSIFICATION3	VARCHAR2	(50)		The third classification of the object with which the results format is associated
SITE_ID	NUMBER			The site id of the results format if it is a site level results format
WEB_USER_ID	NUMBER			The user id of the owner of the results format if it is a user level results format
CUSTOMIZATION_LEVEL_ID	NUMBER			Whether this is a site level or user level results format
IMPORT_FLAG	VARCHAR2	(2000)		Y if this is an import format, null or N if it is not
DATA_LEVEL	VARCHAR2	(2000)		If this is an import format, the data level at which it is associated

Query Text

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


SELECT CUSTOMIZATION_APPLICATION_ID
,      CUSTOMIZATION_CODE
,      REGION_APPLICATION_ID
,      REGION_CODE
,      NAME
,      DESCRIPTION
,      NUM_ROWS_DISPLAYED
,      DEFAULT_RESULT_FLAG
,      DEFAULT_RESULT_FLAG_MEANING
,      CLASSIFICATION1
,      CLASSIFICATION2
,      CLASSIFICATION3
,      SITE_ID
,      WEB_USER_ID
,      CUSTOMIZATION_LEVEL_ID
,      IMPORT_FLAG
,      DATA_LEVEL
FROM APPS.EGO_RESULTS_FORMAT_V;

Dependencies

[top of page]

APPS.EGO_RESULTS_FORMAT_V references the following:

APPS: AK_CUSTOM_REGIONS; AK_CUSTOM_REGIONS_TL; EGO_CUSTOMIZATION_EXT; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES

APPS.EGO_RESULTS_FORMAT_V is referenced by following:

APPS: EGO_ITEM_BULKLOAD_PKG - show dependent code; EGO_SEARCH_FWK_PUB - show dependent code