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: INV.MTL_EAM_ATTR_VAL_INTERFACE

Object Details

Object Name:	MTL_EAM_ATTR_VAL_INTERFACE
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_EAM_ATTR_VAL_INTERFACE
Subobject Name:
Status:	VALID

This is an interface table for Asset Attributes. If asset attribute import is enabled, the Asset Number Import concurrent program processes rows in this table and imports asset attributes into Oracle Applications along with assets.
This table is used to populate data before executing EAM_AST_NUM_INTERFACE concurrent program.
Scope: public
Product: EAM
Lifecycle: active
Display Name: MTL_EAM_ATTR_VAL_INTERFACE
Category: OPEN_INTERFACE EAM_AST_NUM_INTERFACE 1
Category: BUSINESS_ENTITY EAM_ASSET_NUMBER

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_EAM_ATTR_VAL_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_LINE_ID
MTL_EAM_ATTR_VAL_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_HEADER_ID PROCESS_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_HEADER_ID	NUMBER		Yes	Interface header identifier
INTERFACE_LINE_ID	NUMBER		Yes	Interface line identifier
APPLICATION_ID	NUMBER	(10)		Application identifier
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(40)		Descriptive flexfield name
APPLICATION_COLUMN_NAME	VARCHAR2	(30)		Application column name
END_USER_COLUMN_NAME	VARCHAR2	(30)	Yes	Column title
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Yes	Descriptive flexfield structure defining column
LINE_TYPE	NUMBER		Yes	Line type
ASSOCIATION_ID	NUMBER			Attribute group association identifier
ATTRIBUTE_VARCHAR2_VALUE	VARCHAR2	(150)		Varchar segment value
ATTRIBUTE_NUMBER_VALUE	NUMBER			Number segment value
ATTRIBUTE_DATE_VALUE	DATE			Date segment value
PROCESS_STATUS	VARCHAR2	(1)	Yes	Process status of import row
ERROR_NUMBER	NUMBER			Error number
ERROR_MESSAGE	VARCHAR2	(2000)		Error message
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column
INTERFACE_GROUP_ID	NUMBER			Interface group identifier

Query Text

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


SELECT INTERFACE_HEADER_ID
,      INTERFACE_LINE_ID
,      APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      APPLICATION_COLUMN_NAME
,      END_USER_COLUMN_NAME
,      ATTRIBUTE_CATEGORY
,      LINE_TYPE
,      ASSOCIATION_ID
,      ATTRIBUTE_VARCHAR2_VALUE
,      ATTRIBUTE_NUMBER_VALUE
,      ATTRIBUTE_DATE_VALUE
,      PROCESS_STATUS
,      ERROR_NUMBER
,      ERROR_MESSAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INTERFACE_GROUP_ID
FROM INV.MTL_EAM_ATTR_VAL_INTERFACE;

Dependencies

[top of page]

INV.MTL_EAM_ATTR_VAL_INTERFACE does not reference any database object

INV.MTL_EAM_ATTR_VAL_INTERFACE is referenced by following:

APPS: MTL_EAM_ATTR_VAL_INTERFACE