[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_FND_OBJECTS_EXT_U1 | NORMAL | UNIQUE | APPS_TS_SEED | OBJECT_NAME |
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 |
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
FROM EGO.EGO_FND_OBJECTS_EXT;
EGO.EGO_FND_OBJECTS_EXT does not reference any database object
EGO.EGO_FND_OBJECTS_EXT is referenced by following:
|
|
|