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_DESC_FLEXS_EXT

Object Details

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

This is an extension table on FND_DESCR_FLEX_CONTEXTS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_FND_DESC_FLEXS_EXT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(10)	Yes	The application ID for the Attribute Group Type
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(40)	Yes	The Flex name
APPLICATION_TL_TABLE_NAME	VARCHAR2	(30)	Yes	The name of the TL table that stores the runtime translated data
APPLICATION_VL_NAME	VARCHAR2	(30)	Yes	The name of the view that joins the APPLICATION_TABLE_NAME (the base table) and the APPLICATION_TL_TABLE_NAME
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
BUSINESS_EVENT_NAME	VARCHAR2	(240)		The name of the Business Event that is raised by changes to data for those Attribute Groups in this Attribute Group Type that are flagged to raise Business Events
HIERARCHY_NODE_QUERY	VARCHAR2	(4000)		Query that determines if an object instance is a Root or a Leaf
HIERARCHY_PROPAGATION_API	VARCHAR2	(240)		Column that stores the API that needs to be called to propagate values in a tree
PRE_BUSINESS_EVENT_NAME	VARCHAR2	(240)		Stores the business event name which is raised before changes

Query Text

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


SELECT APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      APPLICATION_TL_TABLE_NAME
,      APPLICATION_VL_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      BUSINESS_EVENT_NAME
,      HIERARCHY_NODE_QUERY
,      HIERARCHY_PROPAGATION_API
,      PRE_BUSINESS_EVENT_NAME
FROM EGO.EGO_FND_DESC_FLEXS_EXT;

Dependencies

[top of page]

EGO.EGO_FND_DESC_FLEXS_EXT does not reference any database object

EGO.EGO_FND_DESC_FLEXS_EXT is referenced by following:

APPS: EGO_FND_DESC_FLEXS_EXT