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_RESULTS_FMT_USAGES

Object Details

Object Name:	EGO_RESULTS_FMT_USAGES
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_RESULTS_FMT_USAGES
Subobject Name:
Status:	VALID

Table containing Result format usages. This is internal use only.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_RESULTS_FMT_USAGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESULTFMT_USAGE_ID CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_CODE REGION_APPLICATION_ID REGION_CODE ATTRIBUTE_CODE DATA_LEVEL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESULTFMT_USAGE_ID	NUMBER	(15)	Yes	Unique usage identifier for the Result Format
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_CODE	VARCHAR2	(30)	Yes	One of the PKs of the results column
ATTR_DISPLAY_NAME	VARCHAR2	(150)	Yes	Display name for the Attribute
DISPLAY_SEQUENCE	NUMBER	(15)		The order that the column is displayed within the results format with which it is associated
SEGMENT_NUMBER	NUMBER	(15)	Yes	Segment the attribute value should go in. Segment number is 1 through 250 if Character value, 251 through 350 if Number value, 351 through 360 if Date value.
INTF_COLUMN_NAME	VARCHAR2	(80)	Yes	The EGO_BULKLOAD_INTF column name. The attribute value will go in this column.
CREATED_BY	NUMBER	(15)	Yes	One of the five standard "WHO" columns
CREATION_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns
CLASSIFICATION_CODE	VARCHAR2	(50)		Classification Code for the Result Format Usage
DATA_LEVEL_ID	NUMBER			Data Level Identifier, Uniquely identifies the Data Level Information.

Query Text

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


SELECT RESULTFMT_USAGE_ID
,      CUSTOMIZATION_APPLICATION_ID
,      CUSTOMIZATION_CODE
,      REGION_APPLICATION_ID
,      REGION_CODE
,      ATTRIBUTE_CODE
,      ATTR_DISPLAY_NAME
,      DISPLAY_SEQUENCE
,      SEGMENT_NUMBER
,      INTF_COLUMN_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CLASSIFICATION_CODE
,      DATA_LEVEL_ID
FROM EGO.EGO_RESULTS_FMT_USAGES;

Dependencies

[top of page]

EGO.EGO_RESULTS_FMT_USAGES does not reference any database object

EGO.EGO_RESULTS_FMT_USAGES is referenced by following:

EGO: EGO_RESULTS_FMT_USAGES#