[Home] [Help] [Dependency Information]
Object Name: | EGO_ATTR_GROUPS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_ATTR_GROUPS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
View EGO_ATTR_GROUPS_V provides all the metadata information for attribute groups. Some of the pieces of information stored in this view include the attribute group id, name, description, type, view and edit privilegesed, and pre and post raise conditions for business events.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTR_GROUP_ID | NUMBER | (10) | Yes | Attribute group identifier |
APPLICATION_ID | NUMBER | (10) | Yes | Application identifier |
ATTR_GROUP_TYPE | VARCHAR2 | (40) | Yes | Attribute Group Type |
ATTR_GROUP_NAME | VARCHAR2 | (30) | Yes | Attribute group internal name |
ATTR_GROUP_DISP_NAME | VARCHAR2 | (80) | Yes | Attribute group display name |
DESCRIPTION | VARCHAR2 | (240) | Description for the attribute group | |
OWNING_PARTY_ID | NUMBER | (15) | Yes | Owner of this attribute group |
ENABLED_CODE | VARCHAR2 | (1) | Yes | Enabled Y or N |
ENABLED_MEANING | VARCHAR2 | (80) | Yes | Meaning for Enabled_Flag Yes or No |
MULTI_ROW_CODE | VARCHAR2 | (1) | Yes | Is this a multi row attribute group |
MULTI_ROW_MEANING | VARCHAR2 | (80) | Yes | Meaning of Multi Row Yes or No |
SECURITY_CODE | VARCHAR2 | (30) | Yes | Security level (Obsolete column) |
SECURITY_MEANING | VARCHAR2 | (80) | Yes | Meaning of security like public etc(Obsolete column) |
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) | Flag indicating whether or not a Business Event will be raised before changes to data for this Attribute Group | |
VARIANT | VARCHAR2 | (1) | Flag indicating the Attribute Group is Variant or not | |
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 | |
NUM_OF_ROWS | NUMBER | (15) | Holds the Number of Rows shown in the table for each page for a multi-Row Attribute Group |
Cut, paste (and edit) the following text to query this object:
SELECT ATTR_GROUP_ID
, APPLICATION_ID
, ATTR_GROUP_TYPE
, ATTR_GROUP_NAME
, ATTR_GROUP_DISP_NAME
, DESCRIPTION
, OWNING_PARTY_ID
, ENABLED_CODE
, ENABLED_MEANING
, MULTI_ROW_CODE
, MULTI_ROW_MEANING
, SECURITY_CODE
, SECURITY_MEANING
, VIEW_PRIVILEGE_ID
, EDIT_PRIVILEGE_ID
, AGV_NAME
, REGION_CODE
, BUSINESS_EVENT_FLAG
, PRE_BUSINESS_EVENT_FLAG
, VARIANT
, NUM_OF_COLS
, NUM_OF_ROWS
FROM APPS.EGO_ATTR_GROUPS_V;
|
|
|