FND_UOM_CONVERSIONS

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
UOM_CODE UOM_CLASS UOM_CLASS_CODE CONVERSION_RATE DISABLE_DATE

Name

UOM_CODE

UOM_CLASS

UOM_CLASS_CODE

CONVERSION_RATE

DISABLE_DATE

Query

SQL_Statement
SELECT U.UOM_CODE as UOM_CODE, U.UOM_CLASS as UOM_CLASS, C.UOM_CLASS_CODE as UOM_CLASS_CODE, U.CONVERSION_RATE as CONVERSION_RATE, U.DISABLE_DATE as DISABLE_DATE FROM INV_UOM_CONVERSIONS U, INV_UOM_CLASSES_B C WHERE U.INVENTORY_ITEM_ID = 0 AND U.UOM_CLASS = C.UOM_CLASS

SQL_Statement

SELECT U.UOM_CODE as UOM_CODE, U.UOM_CLASS as UOM_CLASS, C.UOM_CLASS_CODE as UOM_CLASS_CODE, U.CONVERSION_RATE as CONVERSION_RATE, U.DISABLE_DATE as DISABLE_DATE

FROM INV_UOM_CONVERSIONS U, INV_UOM_CLASSES_B C

WHERE U.INVENTORY_ITEM_ID = 0 AND U.UOM_CLASS = C.UOM_CLASS