[Home] [Help] [Dependency Information]
Object Name: | EGO_ALL_ATTR_BASE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_ALL_ATTR_BASE_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Each row in view EGO_ALL_ATTR_BASE_V provides all the information (values) associated with base and user-defined attributes for a given item.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION_ID | NUMBER | Yes | Unique identifier for the rows in Item and Item Revision Extension Table | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B | |
REVISION_ID | NUMBER | Item Revision Id.Foreign key to MTL_ITEM_REVISIONS_B | ||
DATA_LEVEL_ID | NUMBER | Yes | Refers to the data level associated with the attribute. | |
PK1_VALUE | NUMBER | This is the primary key value for primary key one (PK1) for attribute | ||
PK2_VALUE | NUMBER | This is the primary key value for primary key two (PK2) for attribute | ||
PK3_VALUE | NUMBER | This is the primary key value for primary key three (PK3) for attribute | ||
PK4_VALUE | NUMBER | This is the primary key value for primary key four (PK4) for attribute | ||
PK5_VALUE | NUMBER | This is the primary key value for primary key five (PK5) for attribute | ||
ATTRIBUTEGROUP_ID | NUMBER | (10) | Yes | Attribute group internal ID. |
APPLICATION_ID | NUMBER | (10) | Yes | Application Identifier |
ATTRIBUTE_GROUP_NAME | VARCHAR2 | (30) | Yes | Attribute group internal name |
ATTRIBUTE_ID | NUMBER | (15) | Yes | Attribute Identifier |
ATTRIBUTE_NAME | VARCHAR2 | (30) | Yes | Attribute internal name |
DATA_TYPE_CODE | VARCHAR2 | (30) | Yes | Data type of the attribute |
ATTRIBUTE_CHAR_VALUE | VARCHAR2 | (150) | This is the value of attribute for attributes of type CHAR | |
ATTRIBUTE_NUMBER_VALUE | NUMBER | This is the value of attribute for attributes of type NUMBER | ||
ATTRIBUTE_UOM_VALUE | VARCHAR2 | (3) | This is the unit of measure value for the attribute | |
ATTRIBUTE_DATE_VALUE | VARCHAR2 | (10) | This is the value of attribute for attributes of type DATE | |
ATTRIBUTE_DATETIME_VALUE | VARCHAR2 | (19) | This is the value of attribute for attributes of type DATETIME |
Cut, paste (and edit) the following text to query this object:
SELECT EXTENSION_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, REVISION_ID
, DATA_LEVEL_ID
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, ATTRIBUTEGROUP_ID
, APPLICATION_ID
, ATTRIBUTE_GROUP_NAME
, ATTRIBUTE_ID
, ATTRIBUTE_NAME
, DATA_TYPE_CODE
, ATTRIBUTE_CHAR_VALUE
, ATTRIBUTE_NUMBER_VALUE
, ATTRIBUTE_UOM_VALUE
, ATTRIBUTE_DATE_VALUE
, ATTRIBUTE_DATETIME_VALUE
FROM APPS.EGO_ALL_ATTR_BASE_V;
|
|
|