[Home] [Help]
View: INVFV_UOM_CONVERSIONS
View Text
SELECT '_KF:INV:MSTK:SY'
, UO.UNIT_OF_MEASURE
, UO.UOM_CODE
, UO.UOM_CLASS
, UO.CONVERSION_RATE
, UO.DISABLE_DATE
, UO.INVENTORY_ITEM_ID
, UO.LAST_UPDATE_DATE
, UO.LAST_UPDATED_BY
, UO.CREATION_DATE
, UO.CREATED_BY
FROM MTL_SYSTEM_ITEMS SY
, MTL_UOM_CONVERSIONS UO
WHERE UO.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND SY.ORGANIZATION_ID IN (SELECT ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS SY2
WHERE SY2.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND ROWNUM = 1) WITH READ ONLY
Columns
Name |
"_KF:ITEM_NAME" |
UNIT_OF_MEASURE |
UOM_CODE |
UOM_CLASS |
CONVERSION_RATE |
END_EFFECTIVE_DATE |
INVENTORY_ITEM_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |