eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.EGO_ALL_ATTR_LANG_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.EGO_ALL_ATTR_LANG_V references the following:

APPS: EGO_ATTRS_V; EGO_ATTR_GROUPS_V; EGO_MTL_SY_ITEMS_EXT_TL

APPS.EGO_ALL_ATTR_LANG_V is referenced by following:

APPS: EGO_PUBLICATION_PKG - show dependent code