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]

VIEW: APPS.MTL_LOT_UOM_CLASS_CONV_V

Object Details

Object Name:	MTL_LOT_UOM_CLASS_CONV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_LOT_UOM_CLASS_CONV_V
Subobject Name:
Status:	VALID

Quantity view for lot UOM conversion based on MTL_LOT_UOM_CLASS_CONVERSIONS and MTL_SYSTEM_ITEMS_B

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONVERSION_ID	NUMBER		Yes	surrogate id
LOT_NUMBER	VARCHAR2	(80)	Yes	Lot number
ORGANIZATION_ID	NUMBER		Yes	Organization Id
INVENTORY_ITEM_ID	NUMBER		Yes	Item Surrogate key
FROM_UNIT_OF_MEASURE	VARCHAR2	(25)	Yes	From Unit of Measure
FROM_UOM_CODE	VARCHAR2	(3)	Yes	From Uom Code
FROM_UOM_CLASS	VARCHAR2	(10)	Yes	From Uom Class
TO_UNIT_OF_MEASURE	VARCHAR2	(25)	Yes	To Unit of Measure
TO_UOM_CODE	VARCHAR2	(3)	Yes	To Uom Code
TO_UOM_CLASS	VARCHAR2	(10)	Yes	To Uom Class
CONVERSION_RATE	NUMBER		Yes	Conversion Rate
DISABLE_DATE	DATE			Disable Date
EVENT_SPEC_DISP_ID	NUMBER			Quality Spec ID
CREATED_BY	NUMBER		Yes	Created By
CREATION_DATE	DATE		Yes	Creation Date
LAST_UPDATED_BY	NUMBER		Yes	Last updated by
LAST_UPDATE_DATE	DATE		Yes	Last update date
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
ITEM	VARCHAR2	(0)		Item Name
ITEM_DESCRIPTION	VARCHAR2	(0)		Item Description
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary UOM Code
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary UOM Code
LOT_DIVISIBLE_FLAG	VARCHAR2	(1)		Lot Divisible Flag
DEVIATION_HIGH	NUMBER			Deviation High
DEVIATION_LOW	NUMBER			Deviation Low
SERIAL_NUMBER_CONTROL_CODE	NUMBER			Serial Number Control Code

Query Text

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


SELECT CONVERSION_ID
,      LOT_NUMBER
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      FROM_UNIT_OF_MEASURE
,      FROM_UOM_CODE
,      FROM_UOM_CLASS
,      TO_UNIT_OF_MEASURE
,      TO_UOM_CODE
,      TO_UOM_CLASS
,      CONVERSION_RATE
,      DISABLE_DATE
,      EVENT_SPEC_DISP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ITEM
,      ITEM_DESCRIPTION
,      PRIMARY_UOM_CODE
,      SECONDARY_UOM_CODE
,      LOT_DIVISIBLE_FLAG
,      DEVIATION_HIGH
,      DEVIATION_LOW
,      SERIAL_NUMBER_CONTROL_CODE
FROM APPS.MTL_LOT_UOM_CLASS_CONV_V;

Dependencies

[top of page]

APPS.MTL_LOT_UOM_CLASS_CONV_V references the following:

APPS: MTL_LOT_UOM_CLASS_CONVERSIONS; MTL_SYSTEM_ITEMS_B

APPS.MTL_LOT_UOM_CLASS_CONV_V is not referenced by any database object