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_COLUMNS_V

Object Details

Object Name:	EGO_RESULTS_FORMAT_COLUMNS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_RESULTS_FORMAT_COLUMNS_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 PKs of the results format with which the column is associated
CUSTOMIZATION_CODE	VARCHAR2	(30)	Yes	One of the PKs of the results format with which the column is associated
REGION_APPLICATION_ID	NUMBER	(15)	Yes	One of the PKs of the results format with which the column is associated
REGION_CODE	VARCHAR2	(30)	Yes	One of the PKs of the results format with which the column is associated
ATTRIBUTE_APPLICATION_ID	NUMBER	(15)	Yes	Attribute Application Id
ATTRIBUTE_CODE	VARCHAR2	(30)	Yes	Holds the attribute code int he format [attrGroupId$$AttrId] for user defined attrs and db column name for seeded attrs
ORDER_SEQUENCE	NUMBER			The sort precedence of the column within the results format with which it is associated
DISPLAY_SEQUENCE	NUMBER			The order that the column is displayed within the results format with which it is associated
ORDER_DIRECTION	VARCHAR2	(4000)		What order the results will be ordered based on sorting by this column (ascending, descending, etc.)
COLUMN_NAME	VARCHAR2	(4000)		The user defined custom name of the column
SHOW_TOTAL	VARCHAR2	(4000)		Y: The column should show a total. N: The column should not show a total

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
,      ORDER_SEQUENCE
,      DISPLAY_SEQUENCE
,      ORDER_DIRECTION
,      COLUMN_NAME
,      SHOW_TOTAL
FROM APPS.EGO_RESULTS_FORMAT_COLUMNS_V;

Dependencies

[top of page]

APPS.EGO_RESULTS_FORMAT_COLUMNS_V references the following:

APPS: AK_CUSTOM_REGION_ITEMS

APPS.EGO_RESULTS_FORMAT_COLUMNS_V is referenced by following:

APPS: EGO_ITEM_BULKLOAD_PKG - show dependent code