1. Tables and Views for SCM
  2. MSC_AP_UOM_CONVERSIONS_V

MSC_AP_UOM_CONVERSIONS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

UNIT_OF_MEASURE

UOM_CODE

UOM_CLASS

ITEM_NAME

CONVERSION_RATE

DEFAULT_CONVERSION_FLAG

DISABLE_DATE

ROW_ID

Query

SQL_Statement

SELECT

VL.UNIT_OF_MEASURE,

X.UOM_CODE,

VL.UOM_CLASS,

( 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,

X.CONVERSION_RATE,

X.DEFAULT_CONVERSION_FLAG,

X.DISABLE_DATE,

X.ROWID ROW_ID

FROM INV_UOM_CONVERSIONS X,

MSC_AP_UNITS_OF_MEASURE_V VL

where X.UOM_CODE = VL.UOM_CODE