MSC_AP_UOM_CLASS_CONVERSIONS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ITEM_NAME FROM_UNIT_OF_MEASURE FROM_UOM_CODE FROM_UOM_CLASS TO_UNIT_OF_MEASURE TO_UOM_CODE TO_UOM_CLASS CONVERSION_RATE DISABLE_DATE ROW_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT ( SELECT item.ITEM_NUMBER FROM EGP_SYSTEM_ITEMS_VL item WHERE item.INVENTORY_ITEM_ID = X.INVENTORY_ITEM_ID AND rownum =1) AS ITEM_NAME, VL1.UNIT_OF_MEASURE FROM_UNIT_OF_MEASURE, x.FROM_UOM_CODE, VL1.UOM_CLASS FROM_UOM_CLASS, VL2.UNIT_OF_MEASURE TO_UNIT_OF_MEASURE, x.TO_UOM_CODE, VL2.UOM_CLASS TO_UOM_CLASS, x.CONVERSION_RATE, x.DISABLE_DATE, x.rowid ROW_ID FROM INV_UOM_CLASS_CONVERSIONS x, MSC_AP_UNITS_OF_MEASURE_V VL1, MSC_AP_UNITS_OF_MEASURE_V VL2 where x.FROM_UOM_CODE = VL1.UOM_CODE AND x.TO_UOM_CODE = VL2.UOM_CODE |