[Home] [Help]
View: MTL_UOM_CONVERSIONS_VAL_V
View Text
SELECT MUC.UNIT_OF_MEASURE
, MUOM.DESCRIPTION
, MUC.DISABLE_DATE
, MUC.UOM_CLASS
, MUC.INVENTORY_ITEM_ID ITEM_ID
, MUOM.UNIT_OF_MEASURE_TL
FROM MTL_UOM_CONVERSIONS MUC
, MTL_UNITS_OF_MEASURE MUOM
WHERE NVL(MUC.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND MUC.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE
AND NVL(MUOM.DISABLE_DATE
, SYSDATE+1) > SYSDATE
Columns
Name |
UNIT_OF_MEASURE |
DESCRIPTION |
DISABLE_DATE |
UOM_CLASS |
ITEM_ID |
UNIT_OF_MEASURE_TL |