SELECT
   r_object_id,description,code,proposition_date,registry_number_repl,registry_date_repl,document_type,document_kind from
     (SELECT doc.r_object_id,doc.description,doc.code,doc.proposition_date,doc.registry_number_repl,doc.registry_date_repl,dockind.description as document_type,dockind_name.description as document_kind from croc_document_akt_rk doc, crc_dockind_group dockind, crc_dict_dockind_name dockind_name where doc.croc_document_type_id = dockind.r_object_id and doc.croc_document_kind = dockind_name.r_object_id and (1=1) union SELECT doc.r_object_id,doc.description,doc.code,doc.proposition_date,doc.registry_number_repl,doc.registry_date_repl,dockind.description as document_type,dockind_name.description as document_kind from croc_document_od_pnr doc, crc_dockind_group dockind, crc_dict_dockind_name dockind_name where doc.croc_document_type_id = dockind.r_object_id and doc.croc_document_kind = dockind_name.r_object_id and (1=1) ) order by document_type, document_kind, proposition_date