Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_UOM_CLASS_CONVERSIONS |
SELECT '_KF:INV:MSTK:SY'
, UO.FROM_UNIT_OF_MEASURE
, UO.FROM_UOM_CODE
, UO.FROM_UOM_CLASS
, UO.TO_UNIT_OF_MEASURE
, UO.TO_UOM_CODE
, UO.TO_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_UOM_CLASS_CONVERSIONS UO
, MTL_SYSTEM_ITEMS SY
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