SELECT  a.WrtSbjCode, a.WrtID,  a.WrkBeginDate, 
 COALESCE(a.WrkEndDate, a.WrkBeginDate) as WrkEndDate,   
 a.WrkPlanVolume, a.WrkPlanSum,   a.WrkActualVolume, a.WrkActualSum,   
 a.WrkGIDSbjCodeObj, a.WrkGIDObj,   
 RTRIM(RTRIM(b.StrName) || ' ' || RTRIM(b.AdrHouseNum) || ' ' || RTRIM(coalesce(b.AdrKorpNumber, ''))) as HsName,
 c.HrgSbjCode, c.HrgID  
 FROM vFsvTreeWork a
   INNER JOIN vLivAddressText b ON 
    ((a.WrkGIDSbjCodeObj, a.WrkGIDObj) = (b.GIDSbjCode, b.GID))
   INNER JOIN vLivLstHsObjPoss c ON
    ((b.AdrSbjCode, b.AdrID) = (c.AdrSbjCode, c.AdrID))
 WHERE 
  ((not a.WrkGIDSbjCodeObj is null) and (not a.WrkGIDObj is null))  
  AND
  (a.PrjSbjCode, a.PrjID) = (?, ?)  
  AND
  ((a.WrkBeginDate >= ?) AND (COALESCE(a.WrkEndDate, a.WrkBeginDate) <= ?))
    AND
  ((a.WrkBeginDate >= c.HroBeginDate) AND (COALESCE(a.WrkEndDate, a.WrkBeginDate) <= COALESCE(c.HroEndDate, '2999-12-31')))