问CTE中的Getdate导致数据过度倍增

EN

tl.shipdate (in select field)
tl.shipdate (in group by field)
where DATEDIFF(day, tl.shipdate, GETDATE() ) > 45

 With ItemMetrics As
( 
 select ilm.item_id, 
 ilm.REORDER_POINT ReorderPnt,  
 ilm.PREF_STOCK_LEVEL PrefStockLvl,
 ilm.on_hand_count OnHandCnt,
 ilm.on_order_count OnOrderCnt,
 ilm.available_count AvailableCnt
   from ns.ITEM_LOCATION_MAP ilm
     where ilm.location_id = 3
), 

ItemPurchased As 
(
 select sum(tl.unit_qty) TotalItemsBought, sum(tl.unit_qty)/6 
 SixWkAverage, i.item_id,tl.shipdate
   from ns.tinvoice ti
     join ns.transaction_lines tl on ti.transaction_id = 
        tl.transaction_id
     join ns.items i on i.item_id = tl.item_id
 where DATEDIFF(day, tl.shipdate, GETDATE() ) > 45
 group by i.item_id,tl.shipdate
)

select tp.tranid, i.item_id, i.full_name, 
   i.displayname,sum(tl.item_count) -1 AmtOrdered, tl.location_id,  
   it_class.LIST_ITEM_NAME, tp.date_requested Due, v.printoncheckas 
   Vendor, tp.shipment_received ShipmntRecvd, IM.ReorderPnt, 
   IM.PrefStockLvl, IM.OnHandCnt, IM.OnOrderCnt, 
   IM.AvailableCnt,ipp.TotalItemsBought, ipp.SixWkAverage
     from ns.tPurchaseOrder tp
       inner join ns.Transaction_lines tl on tp.transaction_id = 
         tl.transaction_id 
       join ns.items i on i.item_id = tl.item_id
       left join ns.ITEM_CLASSIFICATION it_class on it_class.list_id 
         = i.ITEM_CLASSIFICATION_ID
       left join ns.vendors v on i.vendor_id = v.vendor_id
       left join ns.dw_item_inventory_totals iit on i.item_id = 
           iit.item_id
       left join ItemMetrics IM on im.item_id = i.item_id
       left join ItemPurchased IPP on ipp.item_id = i.item_id
          where tp.date_requested is not null and tp.location_id = 3 
          and tranid = '14980PO'
       group by i.item_id, tp.date_requested, i.displayname, 
         tl.location_id, i.full_name, it_class.LIST_ITEM_NAME, 
         tp.item_id, v.printoncheckas, tp.tranid, 
         tp.shipment_received, IM.ReorderPnt, IM.PrefStockLvl, 
         IM.OnHandCnt, IM.OnOrderCnt, IM.AvailableCnt, 
         ipp.TotalItemsBought, ipp.SixWkAverage