View: POR_UNIT_OF_MEASURE_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of Values for Unit of Measure
Implementation/DBA Data:	APPS.POR_UNIT_OF_MEASURE_LOV_V

View Text

SELECT MUOM.UNIT_OF_MEASURE_TL
, MUOM.UOM_CLASS
, MUOM.UNIT_OF_MEASURE
FROM MTL_UNITS_OF_MEASURE_VL MUOM
, MTL_UOM_CONVERSIONS MUC
WHERE NVL(MUOM.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND MUC.UOM_CODE = MUOM.UOM_CODE
AND MUC.INVENTORY_ITEM_ID = 0

Columns