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_REPORTS

Object Details

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

This table is used to store Report information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_REPORTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPORT_ID
EGO_REPORTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPORT_APPLICATION_ID REPORT_CUSTOMIZATION_CODE REPORT_REGION_CODE REP_REGION_APPLICATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_ID	NUMBER		Yes	Unique numeric identifier for the report
REPORT_APPLICATION_ID	NUMBER		Yes	Identifier for the application of the report: part of composite foreign key to AK_CUSTOMIZATIONS
REPORT_CUSTOMIZATION_CODE	VARCHAR2	(30)	Yes	Report customization code for the the report: part of composite foreign key to AK_CUSTOMIZATIONS
REPORT_REGION_CODE	VARCHAR2	(30)	Yes	Report region code for the the report: part of composite foreign key to AK_CUSTOMIZATIONS
REP_REGION_APPLICATION_ID	NUMBER		Yes	Identifier for the application of the report region code: part of composite foreign key to AK_CUSTOMIZATIONS
EXPORT_TEMPLATE_ID	NUMBER			Identifier for the default Temlate of the report: foreign key to XDO_TEMPLATES_B
OUTPUT_FORMAT_CODE	VARCHAR2	(30)		Default Output Format Code for the reports
DATA_SOURCE_CODE	VARCHAR2	(80)		Internal code for an XML Data Definition: indicates which XML Publisher templates are available for this Report
ORGANIZATION_ID	NUMBER			The organization ID of the report
CREATED_BY	NUMBER		Yes	One of the five standard "WHO" columns
CREATION_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER		Yes	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER			One of the five standard "WHO" columns

Query Text

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


SELECT REPORT_ID
,      REPORT_APPLICATION_ID
,      REPORT_CUSTOMIZATION_CODE
,      REPORT_REGION_CODE
,      REP_REGION_APPLICATION_ID
,      EXPORT_TEMPLATE_ID
,      OUTPUT_FORMAT_CODE
,      DATA_SOURCE_CODE
,      ORGANIZATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EGO.EGO_REPORTS;

Dependencies

[top of page]

EGO.EGO_REPORTS does not reference any database object

EGO.EGO_REPORTS is referenced by following:

APPS: EGO_REPORTS