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_UOM_CONVERSIONS

Object Details

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

MTL_UOM_CONVERSIONS stores conversion rates between non-base units of
measure and their base unit. The non-base units of measure are
stored in the table.
.
The default_conversion_flag indicates that the conversion being
defined is 1) associated with a specific item and 2) the conversion
between units of measure has already been defined as a standard
conversion with the same conversion rate.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_UOM_CONVERSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID UNIT_OF_MEASURE
MTL_UOM_CONVERSIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID UOM_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_OF_MEASURE	VARCHAR2	(25)	Yes	Unit of measure long name
UOM_CODE	VARCHAR2	(3)	Yes	Unit of measure short name
UOM_CLASS	VARCHAR2	(10)	Yes	Class of the conversion unit of measure (derived from MTL_UNITS_OF_MEASURE)
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
CONVERSION_RATE	NUMBER			Conversion rate from conversion unit to base unit of class
DEFAULT_CONVERSION_FLAG	VARCHAR2	(1)	Yes	'Y' if conversion is the same as the default conversion
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
DISABLE_DATE	DATE			Date when the conversion is no longer valid to be used in the system (transactions, etc)
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
LENGTH	NUMBER			Length of Item-UOM
WIDTH	NUMBER			Width of item-UOM
HEIGHT	NUMBER			Height of item-UOM
DIMENSION_UOM	VARCHAR2	(3)		UOM for item-UOM dimensions

Query Text

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


SELECT UNIT_OF_MEASURE
,      UOM_CODE
,      UOM_CLASS
,      INVENTORY_ITEM_ID
,      CONVERSION_RATE
,      DEFAULT_CONVERSION_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISABLE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LENGTH
,      WIDTH
,      HEIGHT
,      DIMENSION_UOM
FROM INV.MTL_UOM_CONVERSIONS;

Dependencies

[top of page]

INV.MTL_UOM_CONVERSIONS does not reference any database object

INV.MTL_UOM_CONVERSIONS is referenced by following:

INV: MTL_UOM_CONVERSIONS#