SELECT DISTINCT MIC.ORGANIZATION_ID , MIC.CATEGORY_ID , MCT.DESCRIPTION , MC.CONCATENATED_SEGMENTS FROM MTL_ITEM_CATEGORIES MIC , MTL_CATEGORIES_B_KFV MC , MTL_CATEGORIES_TL MCT WHERE MCT.CATEGORY_ID = MC.CATEGORY_ID AND MIC.CATEGORY_ID = MC.CATEGORY_ID AND MCT.LANGUAGE = USERENV('LANG')