DBA Data[Home] [Help]

VIEW: APPS.JTM_MTL_UOM_CONVERSIONS_V

Source

View Text - Preformatted

SELECT B.INVENTORY_ITEM_ID , B.UNIT_OF_MEASURE , B.UOM_CODE , B.UOM_CLASS , B.CONVERSION_RATE , B.CREATION_DATE , B.LAST_UPDATE_DATE FROM MTL_UOM_CONVERSIONS B WHERE B.INVENTORY_ITEM_ID = 0 AND NVL(B.DISABLE_DATE, SYSDATE) >= SYSDATE
View Text - HTML Formatted

SELECT B.INVENTORY_ITEM_ID
, B.UNIT_OF_MEASURE
, B.UOM_CODE
, B.UOM_CLASS
, B.CONVERSION_RATE
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
FROM MTL_UOM_CONVERSIONS B
WHERE B.INVENTORY_ITEM_ID = 0
AND NVL(B.DISABLE_DATE
, SYSDATE) >= SYSDATE