SELECT MC.CATEGORY_ID PROD_ID , MC.CONCATENATED_SEGMENTS PROD_VALUE , MC.DESCRIPTION DESCRIPTION FROM MTL_CATEGORY_SETS_VL MSV , MTL_CATEGORIES_KFV MC WHERE MSV.CATEGORY_SET_ID = ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID AND MC.STRUCTURE_ID = MSV.STRUCTURE_ID AND MC.ENABLED_FLAG = 'Y' ORDER BY PROD_VALUE