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_BASE_V

Object Details

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

View Type

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.

[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
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

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
,      ATTRIBUTE_CHAR_VALUE
,      ATTRIBUTE_NUMBER_VALUE
,      ATTRIBUTE_UOM_VALUE
,      ATTRIBUTE_DATE_VALUE
,      ATTRIBUTE_DATETIME_VALUE
FROM APPS.EGO_ALL_ATTR_BASE_V;

Dependencies

[top of page]

APPS.EGO_ALL_ATTR_BASE_V references the following:

APPS: EGO_ATTRS_V; EGO_ATTR_GROUPS_V; EGO_MTL_SY_ITEMS_EXT_B

APPS.EGO_ALL_ATTR_BASE_V is referenced by following:

APPS: EGO_PUBLICATION_PKG - show dependent code