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: TableEGO.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EGO_FND_DSC_FLX_CTX_EXT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTR_GROUP_ID
ColumnZD_EDITION_NAME
EGO_FND_DSC_FLX_CTX_EXT_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnDESCRIPTIVE_FLEXFIELD_NAME
ColumnDESCRIPTIVE_FLEX_CONTEXT_CODE
ColumnZD_EDITION_NAME
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
ZD_EDITION_NAME VARCHAR2 (30) Yes
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
,      ZD_EDITION_NAME
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:

SchemaEGO
ViewEGO_FND_DSC_FLX_CTX_EXT#