View: AS_INV_UOM_V

Product:	AS - Sales Foundation
Description:	View to provide Inventory Item identifier and it's corresponding unit of measure(s).
Implementation/DBA Data:	APPS.AS_INV_UOM_V

View Text

SELECT ITEMS.ORGANIZATION_ID
, ITEMS.INVENTORY_ITEM_ID
, UOM.UOM_CODE
, UOM.DESCRIPTION UOM_DESCRIPTION
FROM MTL_UNITS_OF_MEASURE_VL UOM
, MTL_SYSTEM_ITEMS_B ITEMS
WHERE ITEMS.PRIMARY_UOM_CODE = UOM.UOM_CODE

Columns