1. Tables and Views for SCM
  2. MSC_AP_UOM_CLASS_CONVERSIONS_V

MSC_AP_UOM_CLASS_CONVERSIONS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

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

Query

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