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]

TABLE: EGO.EGO_ITEM_TRANS_ATTRS_TL

Object Details

Object Name:	EGO_ITEM_TRANS_ATTRS_TL
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_ITEM_TRANS_ATTRS_TL
Subobject Name:
Status:	VALID

This table stores the translatable transaction attribute values for an item.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
EXTENSION_ID	NUMBER		Yes	Unique identifier for a row in this table.
INVENTORY_ITEM_ID	NUMBER		Yes	Identifies the item for which this Transaction Attribute value corresponds to. Foreign Key to MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID.
ORGANIZATION_ID	NUMBER		Yes	Identifies the organization for which this Transaction Attribute value corresponds to. Foreign Key to MTL_PARAMETERS.ORGANIZATION_ID.
REVISION_ID	NUMBER		Yes	Identifies the item revision for which this Transaction Attribute value corresponds to. Foreign Key to MTL_ITEM_REVISIONS_B.REVISION_ID.
SOURCE_LANG	VARCHAR2	(4)	Yes	Language in which transaction attribute was initially created
LANGUAGE	VARCHAR2	(4)	Yes	Language in which the transaction attribute is currently stored
ATTR_GROUP_ID	NUMBER		Yes	Identifies the attribute group corresponding to this record.
TL_EXT_ATTR	VARCHAR2	(150)		Column to store value for translatable attributes.
CREATED_BY	NUMBER	(15)	Yes	standard "WHO" column.
CREATION_DATE	DATE		Yes	standard "WHO" column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	standard "WHO" column.
LAST_UPDATE_DATE	DATE		Yes	standard "WHO" column.
LAST_UPDATE_LOGIN	NUMBER	(15)		standard "WHO" column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		concurrent request "WHO" column.
PROGRAM_ID	NUMBER	(15)		concurrent request "WHO" column.
PROGRAM_UPDATE_DATE	DATE			concurrent request "WHO" column.
REQUEST_ID	NUMBER	(15)		Refers to the concurrent request id of this import process.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXTENSION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      REVISION_ID
,      SOURCE_LANG
,      LANGUAGE
,      ATTR_GROUP_ID
,      TL_EXT_ATTR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM EGO.EGO_ITEM_TRANS_ATTRS_TL;

Dependencies

[top of page]

EGO.EGO_ITEM_TRANS_ATTRS_TL does not reference any database object

EGO.EGO_ITEM_TRANS_ATTRS_TL is referenced by following:

EGO: EGO_ITEM_TRANS_ATTRS_TL#