View: MTL_PRIMARY_UOMS_VV

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_PRIMARY_UOMS_VV

View Text

SELECT DISTINCT UOMT.UNIT_OF_MEASURE
, UOMT.UNIT_OF_MEASURE_TL
, UOMT.DESCRIPTION
, UOMT.UOM_CODE
, UOMT.UOM_CLASS
FROM MTL_UOM_CONVERSIONS CONV
, MTL_UNITS_OF_MEASURE_TL UOMT
WHERE NVL(CONV.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND CONV.INVENTORY_ITEM_ID = 0
AND CONV.UOM_CODE = UOMT.UOM_CODE
AND UOMT.LANGUAGE = USERENV('LANG')
AND NVL(UOMT.DISABLE_DATE
, SYSDATE+1) > SYSDATE

Columns