select  (select decode(ck.contracttype, 5, '№'||lt.tocontractid, 0, '№'||lt.tocontractid, '') 
          from BRSActions a1, longterminstructions lt, Contracttypesref ct, BrsContractKindsRef ck, BRSContracts c1                  
         where a1.actioncodeid = '925'
           and c1.contractid = k.contractid
           and lt.contractid = c1.contractid                                                                              
           and a1.contractid = c1.ContractID
           and ck.contractkind = c1.contractkind
           and ct.contracttype = ck.contracttype
           and rownum = 1 ) as contractnum, a.actioncodeid from brscontracts k, brsactions a
           where k.contractid = '2308737' 
           and k.contractid = a.contractid