FND_UOM_CONVERSIONS

詳細

スキーマ: FUSION
オブジェクト所有者: FND
オブジェクト・タイプ: VIEW

列

名前
UOM_CODE UOM_CLASS UOM_CLASS_CODE CONVERSION_RATE DISABLE_DATE

名前

UOM_CODE

UOM_CLASS

UOM_CLASS_CODE

CONVERSION_RATE

DISABLE_DATE

問合せ

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