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_DSC_FLX_CTX_EXT

Object Details

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

This table contains metadata information about Attribute Groups. This table is an extension on FND_DECR_FLEX_CONTEXTS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_FND_DSC_FLX_CTX_EXT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTR_GROUP_ID
EGO_FND_DSC_FLX_CTX_EXT_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ATTR_GROUP_ID	NUMBER	(10)	Yes	Identifier for the Attribute Group
APPLICATION_ID	NUMBER	(10)	Yes	Identifier for the application to which the Attribute Group belongs (part of the foreign key to FND_DESCR_FLEX_CONTEXTS)
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(40)	Yes	Attribute Group Type to which the Attribute Group belongs (part of the foreign key to FND_DESCR_FLEX_CONTEXTS)
DESCRIPTIVE_FLEX_CONTEXT_CODE	VARCHAR2	(30)	Yes	Internal name of the Attribute Group (part of the foreign key to FND_DESCR_FLEX_CONTEXTS)
MULTI_ROW	VARCHAR2	(1)	Yes	Defines if the Attribute Group is Multi-Row
SECURITY_TYPE	VARCHAR2	(30)	Yes	Security level (Obsolete column)
OWNING_PARTY_ID	NUMBER	(15)	Yes	Not currently used (would be a foreign key to HZ_PARTIES reflecting the Company that owns the Attribute Group, if the column were used)
CREATED_BY	NUMBER	(15)	Yes	One of the five standard "WHO" columns
CREATION_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns
VIEW_PRIVILEGE_ID	NUMBER	(15)		Name of the Data Security privilege necessary to view the attribute group value(foreign key to FND_FORM_FUNCTIONS)
EDIT_PRIVILEGE_ID	NUMBER	(15)		Name of the Data Security privilege necessary to edit the attribute group value(foreign key to FND_FORM_FUNCTIONS)
AGV_NAME	VARCHAR2	(30)		Attribute Group Database view Name
REGION_CODE	VARCHAR2	(30)		Used for displaying the attributes in sections, used only for seeded attributes
BUSINESS_EVENT_FLAG	VARCHAR2	(1)		Depicts if post Business event is raised on change of Attribute group data or not
PRE_BUSINESS_EVENT_FLAG	VARCHAR2	(1)		Depicts if pre Business event is raised on change of Attribute group data or not
VARIANT	VARCHAR2	(1)		Variant Flag identifying if the Attribute Group is variant
NUM_OF_ROWS	NUMBER	(15)		Holds the Number of Rows shown in the table for each page for a multi-Row Attribute Group
NUM_OF_COLS	NUMBER	(15)		Holds the Number of columns shown in pagelayout for single-Row AG or Number of columns in the table for multi-Row AG

Query Text

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


SELECT ATTR_GROUP_ID
,      APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      DESCRIPTIVE_FLEX_CONTEXT_CODE
,      MULTI_ROW
,      SECURITY_TYPE
,      OWNING_PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      VIEW_PRIVILEGE_ID
,      EDIT_PRIVILEGE_ID
,      AGV_NAME
,      REGION_CODE
,      BUSINESS_EVENT_FLAG
,      PRE_BUSINESS_EVENT_FLAG
,      VARIANT
,      NUM_OF_ROWS
,      NUM_OF_COLS
FROM EGO.EGO_FND_DSC_FLX_CTX_EXT;

Dependencies

[top of page]

EGO.EGO_FND_DSC_FLX_CTX_EXT does not reference any database object

EGO.EGO_FND_DSC_FLX_CTX_EXT is referenced by following:

APPS: EGO_FND_DSC_FLX_CTX_EXT