update dsbd_margin_trans t1
   set (t1.mdr, t1.id_saler) =
       (select MDR, id_saler
          from (SELECT t.dt,
                       t.grafnum,
                       t.id_pos,
                       t.id_saler,
                       sum(amount) as amount,
                       sum(CASE
                             WHEN t.id_type = 1 THEN
                              det.reward
                             ELSE
                              det.reward * -1
                           END) + sum(CASE
                                        WHEN t.id_type = 1 THEN
                                         det.discount
                                        ELSE
                                         det.discount * -1
                                      END) AS MDR
                  FROM (select *
                          from transit2.trans@sun
                         where id_cont in
                               ('8CAAEFEA6E0C4D1094B1139F182B6AF1',
                                'EF5D606A6E1A47E0AEC712CFF89B030F',
                                '64B1A95E8E244EBDE053044A14ACEA8A')) t
                  JOIN transit2.services@sun ser
                    ON ser.id_usl = t.id_usl
                  LEFT JOIN transit2.trans_detail@sun det
                    ON det.id_trans = t.id_trans
                   and det.id_type = 3
                 WHERE ser.uname = 'л'
                   AND t.grafnum > 0
                   AND t.id_type != 3
                 GROUP BY t.dt, t.grafnum, t.id_pos, t.id_saler) t2
         where t1.grafnum = t2.grafnum
           and t1.id_pos = t2.id_pos
           and t1.dt = t2.dt
           and t1.amount = t2.amount)
 where t1.main_id in
       (select id_cont
          from v_tmp_business_products
         where nvl(name_business, 0) = 'GPC RUS')
   and (t1.dt >= date '2019-04-01' and t1.dt < date '2019-04-05');