SELECT DISTINCT IT.INVENTORY_ITEM_ID , IT.ORGANIZATION_ID , IT.CONCATENATED_SEGMENTS , IC.CATEGORY_ID , CT.CONCATENATED_SEGMENTS , IT.DESCRIPTION FROM MTL_SYSTEM_ITEMS_KFV IT , MTL_ITEM_CATEGORIES IC , POA_CM_COMMODITY_LOV_V CT WHERE IT.INVENTORY_ITEM_ID = IC.INVENTORY_ITEM_ID AND IT.ORGANIZATION_ID = IC.ORGANIZATION_ID AND IC.CATEGORY_ID = CT.CATEGORY_ID WITH READ ONLY