[Home] [Help] [Dependency Information]
Object Name: | EGO_ALL_ATTR_LANG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_ALL_ATTR_LANG_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
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 |
LANGUAGE | VARCHAR2 | (4) | Yes | Language utilized for the ATTRIBUTE_TRANSLATABLE_VALUE column |
ATTRIBUTE_TRANSLATABLE_VALUE | VARCHAR2 | (1000) | This is the translatable text for a given attribute |
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
, LANGUAGE
, ATTRIBUTE_TRANSLATABLE_VALUE
FROM APPS.EGO_ALL_ATTR_LANG_V;
|
|
|