UPDATE m2oPointComptage pds
SET m2oDateRaccorde =
  ( SELECT DISTINCT first_value(e.m2oDateDerRx) over (partition BY pds.sysId order by e.sysUpdTime)
  FROM m2oCompteur cpt,
    m2oEquipement eq,
    m2oHrNbRecepCr e
  WHERE e.m2oTraite        = 'N'
  AND e.m2oIdEquipement    = eq.m2oAdresseRadio
  AND e.m2oTypeDeTrame     = '3'
  AND eq.sysClass          = 'm2oModule'
  AND eq.m2oTechno         = 'HR'
  AND cpt.sysId            = eq.m2ocompteur_id
  AND pds.sysId            = cpt.m2opointcomptage_id
  AND e.m2oDateDerRx      IS NOT NULL
  AND pds.m2oDateRaccorde IS NULL
  )
WHERE pds.m2oDateRaccorde IS NULL
AND EXISTS
  (SELECT 1
  FROM m2oCompteur cpt,
    m2oEquipement eq,
    m2oHrNbRecepCr e
  WHERE e.m2oTraite     = 'N'
  AND e.m2oIdEquipement = eq.m2oAdresseRadio
  AND e.m2oTypeDeTrame  = '3'
  AND eq.sysClass       = 'm2oModule'
  AND eq.m2oTechno      = 'HR'
  AND cpt.sysId         = eq.m2ocompteur_id
  AND pds.sysId         = cpt.m2opointcomptage_id
  AND e.m2oDateDerRx   IS NOT NULL
  )