[Home] [Help]
VIEW: APPS.AS_INV_UOM_V
Source
View Text - Preformatted
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
View Text - HTML Formatted
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