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_B

Object Details

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

This table stores the 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.
ATTR_GROUP_ID	NUMBER		Yes	Identifies the attribute group corresponding to this record.
C_EXT_ATTR	VARCHAR2	(150)		Column to store value for character attributes.
N_EXT_ATTR	NUMBER	(15)		Column to store value for number attributes.
UOM_EXT_ATTR	VARCHAR2	(3)		Column to store UOM for number attributes.
D_EXT_ATTR	DATE			Column to store value for date 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
,      ATTR_GROUP_ID
,      C_EXT_ATTR
,      N_EXT_ATTR
,      UOM_EXT_ATTR
,      D_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_B;

Dependencies

[top of page]

EGO.EGO_ITEM_TRANS_ATTRS_B does not reference any database object

EGO.EGO_ITEM_TRANS_ATTRS_B is referenced by following:

EGO: EGO_ITEM_TRANS_ATTRS_B#