select unique extractvalue(item,'/ITEM/@id') FilterID, extractvalue(item,'/ITEM/@type') Type,
       extractvalue(item,'//CAPTION') Caption,
       extractvalue(item,'//FIELDNAME') FieldName,
       extractvalue(item,'//PROPERTIESCLASSNAME') PropertiesClassName,
       extractvalue(item,'//REPOSITORYITEM/@ref') RepositoryItem
from
  (select value(x) item
   from (select p_XML text from dual) t,
     table(xmlsequence(XMLType(t.text).extract('CRITERIA/ITEMS/ITEM'))) x) t
order by Caption