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_FND_OBJECTS_V

Object Details

Object Name:	EGO_FND_OBJECTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_FND_OBJECTS_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

View EGO_FND_OBJECTS_V provides the object information for which the user-defined framework is implemented for the EGO application. The object information stored per row includes the name, description, database tables, primary key columns, and view and edit privileges.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER	(15)	Yes	Object ID (From FND_OBJECTS)
OBJECT_NAME	VARCHAR2	(430)	Yes	Object Name (From FND_OBJECTS)
APPLICATION_ID	NUMBER	(15)	Yes	Application Identifier
DATABASE_OBJECT_NAME	VARCHAR2	(30)	Yes	Name of database table
PK1_COLUMN_NAME	VARCHAR2	(30)	Yes	Name of column 1 in object PK.
PK2_COLUMN_NAME	VARCHAR2	(30)		Name of column 2 in object PK.
PK3_COLUMN_NAME	VARCHAR2	(30)		Name of column 3 in object PK.
PK4_COLUMN_NAME	VARCHAR2	(30)		Name of column 4 in object PK.
PK5_COLUMN_NAME	VARCHAR2	(30)		Name of column 5 in object PK.
DISPLAY_NAME	VARCHAR2	(240)	Yes	object display name
DESCRIPTION	VARCHAR2	(2000)	Yes	object description
VIEW_PRIVILEGE	VARCHAR2	(480)		Name of the Data Security privilege necessary to view instances of the Object (foreign key to FND_FORM_FUNCTIONS)
NAME_DESC_SELECT_SQL	VARCHAR2	(1000)		SQL that will select a relevant description of the Object
PARENT_OBJECT_ID	NUMBER	(15)		Optional identifier for the parent object to this object, if there is one (foreign key to FND_OBJECTS)

Query Text

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


SELECT OBJECT_ID
,      OBJECT_NAME
,      APPLICATION_ID
,      DATABASE_OBJECT_NAME
,      PK1_COLUMN_NAME
,      PK2_COLUMN_NAME
,      PK3_COLUMN_NAME
,      PK4_COLUMN_NAME
,      PK5_COLUMN_NAME
,      DISPLAY_NAME
,      DESCRIPTION
,      VIEW_PRIVILEGE
,      NAME_DESC_SELECT_SQL
,      PARENT_OBJECT_ID
FROM APPS.EGO_FND_OBJECTS_V;

Dependencies

[top of page]

APPS.EGO_FND_OBJECTS_V references the following:

APPS: EGO_FND_OBJECTS_EXT; FND_OBJECTS; FND_OBJECTS_TL

APPS.EGO_FND_OBJECTS_V is not referenced by any database object