INSERT INTO uni_megdown (downsite, downaction, downtrt, downcode, downcexv, downlibl, downcvccode, downddeb, downbaseprice, downredprice, downminprice, downminval, downgtdnumber, downlibc, downcons, downweight, downgrat, downvat, downutil, downdcre)
SELECT downsite, downaction, downtrt, downcode, downcexv, downlibl, downcvccode, downddeb,
       downbaseprice, downredprice, downminprice,
       downminval, downgtdnumber, downlibc, downcons, downweight, downgrat, downvat, downutil,
       downdcre
FROM
(SELECT downsite, downaction, 0 AS downtrt, downcode, downcexv, downlibl, downcvccode, downddeb,
       downbaseprice, downredprice, downminprice, downminval,
       downgtdnumber, downlibc, downcons, downweight, downgrat, downvat, downutil,
       SYSDATE AS downdcre
  FROM
   (
     SELECT
       downsite, downaction, 0 AS downtrt, downcode, downcexv, downlibl, downcvccode, downddeb,
       downbaseprice, -- оптова¤
       downredprice,  -- рознична¤
       downminprice,  -- минимальна¤
       downminval,
       downgtdnumber, downlibc, downcons, downweight, downgrat,
       NVL((SELECT av.avictva FROM aveprix av WHERE 1=1 AND av.avicinv=arccinv AND TRUNC(SYSDATE) BETWEEN av.aviddeb AND av.avidfin AND ROWNUM=1), downvat) AS downvat, 'mazura_discount' AS downutil, downdcre,
       -- нужен последние измененные Ў  дл¤ кода товара
       ROW_NUMBER() over(PARTITION BY downsite, downcode ORDER BY downdcre DESC) AS numid
       --row_number() over(partition by downsite, artcexr || '_' || arvcexv order by downdcre desc, downaction) as numid
         FROM ukm48.uni_megdown@GOLD u, artcoca, artrac a1, artuv, strucrel a3, strucobj a4
       WHERE (1 = 1)
        AND a1.artcinr = a3.objcint
        AND(a3.objdfin >= TO_DATE(SYSDATE,  'DD/MM/RR'))
        AND(a3.objpere = a4.sobcint)
        AND SYSDATE BETWEEN arcddeb AND arcdfin
        AND downcode = arccode AND arccinr = artcinr AND artcinr = arvcinr AND arccinv=arvcinv
--        and artcexr || '_' || arvcexv in '1140061657_0') -- артикул с продаваемым вариантом
        --Ограничение по ТК
        -- and (a4.sobcext like '650403%' or a4.sobcext like '650402%')
      -- AND artcexr=''
      -- and artcexr || '_' || arvcexv in ('0000119834_0') -- артикул с продаваемым вариантом
      AND downsite IN (
          SELECT relid
          FROM resrel, resobj
          WHERE robid = relid AND robprof = -1
          --   and robid <> 5038
          CONNECT BY PRIOR relid = relpere
          START WITH relid IN (501) -- в скобках можно указывать не только список сайтов, но и узел коммерческой сети, вся сеть - это 501
        )
     AND a4.sobcext IN(SELECT classif FROM UNI_CLASSIFDISCOUNT)
      AND downdcre>=TRUNC(SYSDATE-140)
      -- and downaction = 'C' -- выбираем только операции по созданию/изменению цены
      -- классифа нет в списке запрета на купоны
      -- AND substr(decode(a4.sobcext, 1, 0, a4.sobcext), 0, 8) NOT IN(SELECT classif FROM UNI_DOWNMINPRICE_EXCLASSIF)
      -- на товар нет акции
      AND NOT EXISTS(SELECT 1 FROM uni_top500_list_art WHERE cexr=artcexr AND pv=arvcexv AND site_id=u.downsite AND TO_DATE(SYSDATE, 'DD/MM/RR') BETWEEN TO_DATE(date_beg, 'DD/MM/RR') AND  TO_DATE(date_end, 'DD/MM/RR') )
      -- не весовой
     -- AND decode(artustk, 1, 0, 3)<>3
   )
   WHERE numid = 1 AND downaction = 'C' -- из полученных последних операций нас интересует только создание/изменение цены
) m;