[Home] [Help] [Dependency Information]
Object Name: | EGO_ATTRS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_ATTRS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
View EGO_ATTRS_V provides all the information for operational and user-defined attributes. Each row contains the definition information for an attribute such as its name, description, value set associated, and the attribute group owning the attribute.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTR_ID | NUMBER | (15) | Attribute 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_NAME | VARCHAR2 | (30) | Yes | Attribute internal name |
ATTR_DISPLAY_NAME | VARCHAR2 | (80) | Yes | Attribute display name |
DESCRIPTION | VARCHAR2 | (240) | Description for the attribute | |
DATABASE_COLUMN | VARCHAR2 | (30) | Yes | Database column in which this attribute value is stored |
DATA_TYPE_CODE | VARCHAR2 | (30) | Data type of the attribute | |
SEQUENCE | NUMBER | (3) | Yes | Sequence in which attributes are displayed in an attribute group in UI |
UNIQUE_KEY_FLAG | VARCHAR2 | (1) | Determines if this attribute is part of Unique key | |
DEFAULT_VALUE | VARCHAR2 | (2000) | Default value of the attribute | |
INFO_1 | VARCHAR2 | (2048) | URL incase of attribute type Dynamic URL | |
UOM_CLASS | VARCHAR2 | (10) | UOM class that is attached to this attribute | |
CONTROL_LEVEL | NUMBER | (15) | Used to determine whether the attribute is updateble or not | |
VALUE_SET_ID | NUMBER | (10) | Value set Identifier that is attached to this attribute | |
VALUE_SET_NAME | VARCHAR2 | (60) | Value set name | |
FORMAT_CODE | VARCHAR2 | (1) | Format in which the attribute is displayed | |
MAXIMUM_SIZE | NUMBER | (3) | Maximum size of the attribute | |
VALIDATION_CODE | VARCHAR2 | (1) | Validation code for the attribute | |
LONGLIST_FLAG | VARCHAR2 | (1) | Determines if the value is displayed as a poplist or LOV | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Enabled Y or N |
ENABLED_MEANING | VARCHAR2 | (80) | Yes | Meaning for Enabled_Flag Yes or No |
REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Required Y or N |
REQUIRED_MEANING | VARCHAR2 | (80) | Yes | Meaning for Required Yes Or No |
SEARCH_FLAG | VARCHAR2 | (1) | Searchable or Not | |
SEARCH_MEANING | VARCHAR2 | (80) | Search Flag Meaning | |
DISPLAY_CODE | VARCHAR2 | (1) | Yes | Display style of attribute |
DISPLAY_MEANING | VARCHAR2 | (80) | Yes | Display style meaning Text, Check box, etc.. |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Used for grouping the attributes in sections while displaying, used only for seeded attributes. | |
VIEW_IN_HIERARCHY_CODE | VARCHAR2 | (30) | Determines the level at which the attribute is visibile in a hierarchy | |
EDIT_IN_HIERARCHY_CODE | VARCHAR2 | (30) | Determines the level at which the attribute is editable in a hierarchy | |
CUSTOMIZATION_LEVEL | VARCHAR2 | (1) | Determines the level of customization allowed for seeded attributes | |
MINIMUM_VALUE | VARCHAR2 | (150) | Minimum value from FND_FLEX_VALUE_SETS | |
MAXIMUM_VALUE | VARCHAR2 | (150) | Maximum value from FND_FLEX_VALUE_SETS | |
VALIDATION_CODE_VS | VARCHAR2 | (1) | Calculated VALIDATION TYPE from FND_FLEX_VALUE_SETS |
Cut, paste (and edit) the following text to query this object:
SELECT ATTR_ID
, APPLICATION_ID
, ATTR_GROUP_TYPE
, ATTR_GROUP_NAME
, ATTR_NAME
, ATTR_DISPLAY_NAME
, DESCRIPTION
, DATABASE_COLUMN
, DATA_TYPE_CODE
, SEQUENCE
, UNIQUE_KEY_FLAG
, DEFAULT_VALUE
, INFO_1
, UOM_CLASS
, CONTROL_LEVEL
, VALUE_SET_ID
, VALUE_SET_NAME
, FORMAT_CODE
, MAXIMUM_SIZE
, VALIDATION_CODE
, LONGLIST_FLAG
, ENABLED_FLAG
, ENABLED_MEANING
, REQUIRED_FLAG
, REQUIRED_MEANING
, SEARCH_FLAG
, SEARCH_MEANING
, DISPLAY_CODE
, DISPLAY_MEANING
, ATTRIBUTE_CODE
, VIEW_IN_HIERARCHY_CODE
, EDIT_IN_HIERARCHY_CODE
, CUSTOMIZATION_LEVEL
, MINIMUM_VALUE
, MAXIMUM_VALUE
, VALIDATION_CODE_VS
FROM APPS.EGO_ATTRS_V;
|
|
|