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_ATTR_APPL_DEPENDENCIES

Object Details

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

This table contains dependencies between item attributes and the
various products. These dependencies are used by the Master
Items window and the Organization Items window to display only
those attributes required by the products installed.
.
For instance, if Oracle Purchasing is not installed, those attributes
that are only associated with Oracle Purchasing will not appear in the
Master Items window.
.
The data in this table is seeded on install or upgrade.
.
The following values for APPLICATION_ID correspond to these Oracle
products:
.
APPLICATION_ID Product
170 Oracle Service
201 Oracle Purchasing
222 Oracle Receivables
660 Oracle Order Management
665 Oracle Shipping Execution
401 Oracle Inventory
702 Oracle Bills of Material
703 Oracle Engineering
704 Oracle Master Scheduling/MRP and Oracle Supply
Chain Planning
706 Oracle Work in Process
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_ATTR_APPL_DEPENDENCIES_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID ATTRIBUTE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER		Yes	Application identifier
ATTRIBUTE_NAME	VARCHAR2	(50)	Yes	Item attribute name
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			Standard Who column

Query Text

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


SELECT APPLICATION_ID
,      ATTRIBUTE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM INV.MTL_ATTR_APPL_DEPENDENCIES;

Dependencies

[top of page]

INV.MTL_ATTR_APPL_DEPENDENCIES does not reference any database object

INV.MTL_ATTR_APPL_DEPENDENCIES is referenced by following:

APPS: MTL_ATTR_APPL_DEPENDENCIES