substr(''SMS-оповещение на номер телефона ''||na1.attrasvarchar||na2.attrasvarchar||na3.attrasvarchar, 1, 255)

    SELECT d.dirvalue as id,  d.dirname as name 
    FROM brsdirectories d 
    WHERE d.dircode = 'SMSPACKET'

SELECT n.notifyid as ID, substr(''SMS-оповещение на номер телефона ''||na1.attrasvarchar||na2.attrasvarchar||na3.attrasvarchar||'' пакет ''||nap.attrasfloat, 1, 255) as NAME 
 FROM brsnotifies n 
INNER JOIN brsnotifyattrs na1 ON (na1.objectid = n.notifyid 
                             AND na1.attrcode = ''PHONE_STATE''  
                                 AND na1.startdate <= (select fbrs_getopenoday from dual) 
                                   AND na1.enddate > (select fbrs_getopenoday from dual))
 INNER JOIN brsnotifyattrs na2 ON (na2.objectid = n.notifyid
                                   AND na2.attrcode = ''PHONE_ZONE'' 
                                   AND na2.startdate <= (select fbrs_getopenoday from dual) 
                                  AND na2.enddate > (select fbrs_getopenoday from dual))
INNER JOIN brsnotifyattrs na3 ON (na3.objectid = n.notifyid 
                                  AND na3.attrcode = ''PHONE_NUMBER'' 
                                   AND na3.startdate <= (select fbrs_getopenoday from dual)
                                   AND na3.enddate > (select fbrs_getopenoday from dual)) 
INNER JOIN brsnotifyattrs nap ON (nap.objectid = n.notifyid 
                                   AND nap.attrcode = ''NOTIFY_PACKETID'' 
                                 AND nap.startdate <= (select fbrs_getopenoday from dual) 
                                   AND nap.enddate > (select fbrs_getopenoday from dual))
 WHERE (n.entityID = %s) 
   AND (n.stateid = api_states.getStateBySign(''NOTIFY'',''ACTIVE'')) 
   AND (n.notifyproductid = %s)