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_FND_OBJECTS_EXT

Object Details

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

Table EGO_FND_OBJECTS_EXT stores the object information for which the user-defined framework is implemented for the EGO application. The information stored includes the objects name, select statement for object description, classification column name and type.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_FND_OBJECTS_EXT_U1	NORMAL	UNIQUE	APPS_TS_SEED	OBJECT_NAME ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_NAME	VARCHAR2	(430)	Yes	Object Name from FND_OBJECTS
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)
EXT_ATTR_OCV_NAME	VARCHAR2	(30)		View name that provides the classification code and meaning
EXT_ATTR_ICV_NAME	VARCHAR2	(30)		View name that provides the instance PK values and the instance name
CLASSIFICATION_COL_NAME	VARCHAR2	(30)		The name of the classification column for the object
CLASSIFICATION_COL_TYPE	VARCHAR2	(30)		The type of the classification column for the object
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT OBJECT_NAME
,      VIEW_PRIVILEGE
,      NAME_DESC_SELECT_SQL
,      PARENT_OBJECT_ID
,      EXT_ATTR_OCV_NAME
,      EXT_ATTR_ICV_NAME
,      CLASSIFICATION_COL_NAME
,      CLASSIFICATION_COL_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM EGO.EGO_FND_OBJECTS_EXT;

Dependencies

[top of page]

EGO.EGO_FND_OBJECTS_EXT does not reference any database object

EGO.EGO_FND_OBJECTS_EXT is referenced by following:

EGO: EGO_FND_OBJECTS_EXT#