select bir.ID [birID]
		,cast(bir.Quantity as decimal(24,12)) [birQty]
		,cast(lpn.Entity2Quantity / pn.TotalQuantity as decimal(24,12))
			[K_bir2pn]
		,lpn.Entity1ToEntity2Coef [Coef_bir2pn]
		,pn.ID [pnID]
		,pn.TotalQuantity [pnQty]
		,cast(rl.Entity2Quantity / req.Quantity as decimal(24,12))
			[K_pn2req]
		,rl.Entity1ToEntity2Coef  [Coef_pn2req]
		,req.ID [reqID]
		,req.Quantity [reqQty]
		,spl.Entity2Quantity --/ si.UnconvertedQuantity
			[K_req2si]
		,si.ID [siID]
		,si.UnconvertedQuantity [siQty]
		,notel.Entity2Quantity --/ ni.Quantity
			[K_req2ni]
		,spl.Entity1ToEntity2Coef [Coef_req2spi]
		,ni.ID [niID]
		,ni.Quantity [niQty]
		,dlink.Entity1Quantity --/ di.Quantity
			[K_req2di]
		,notel.Entity1ToEntity2Coef [Coef_req2note]
		,di.ID [diID]
		,di.Quantity [diQty]
		,dlink.Entity1ToEntity2Coef [Coef_req2deli]
		,isnull(rdl.rdid, -1) [reqDistrID]
		--,K_pn2reqdistrNormK = case when rdl.sumPnQty > pn.TotalQuantity then cast(cast(NormCoef * rdl.sumPnQty as decimal(24,12)) / pn.TotalQuantity as decimal(24,12)) else NormCoef end
		,new_K_pn2reqdistrNormK = case when rdl.sumPnQty > pn.TotalQuantity then cast(rdl.sumPnQty / pn.TotalQuantity as decimal(24,12)) else cast(1 as decimal(1,0)) end
		,K_pn2reqdistr = cast(rdl.pnQty / rdl.sumPnQty as decimal(24,12))
		,K_pn2reqdistrDI = cast(rdl.diQty / rdl.pnQty as decimal(24,12)) --isnull(cast(rdl.pnQty / rdl.sumPnQty as decimal(24,12)), cast(1 as decimal(1,0)))
		,K_pn2distr = cast(distri.Quantity / rdl.rdQty as decimal(24,12))
		,isnull(cast(rdl.pnQty / pn.TotalQuantity as decimal(24,12)), 1) [K_di2rdi_c]
		,rdl.coef [Coef_toFactPn]
		,rdl.new_Coef [Coef_Del_pn2deli]
		,pnIDd = rdl.projectNeedID
		,isnull(rdl.deliveryItemID, -1) as rdl_deliveryItemID
		,rdl_diCnt = cast(rdl.diCnt as decimal(3,0))
		,K_di2reqdistr = case
							when rdl.deliveryItemID = 0 
								then cast(1 as decimal(1,0)) 
							else isnull(cast(rdl.diQty / nullif(sumDiQty, 0.0) as decimal(24,12)), cast(1 as decimal(1,0)))
						 end
		,isnull(distri.ID, -1) [distri_ID]
		,distri.Quantity [distri_Quantity]
		,distri.sumQty [distri_sumQty]
		,K_rd2distri_c = isnull(cast(distri.Quantity / distri.sumQty as decimal(24,12)), cast(1 as decimal(1,0)))
		,K_rd2distri_r = isnull(cast(distri.Quantity / rdl.rdQty as decimal(24,12)), cast(1 as decimal(1,0)))
		,coalesce(pn.ProjectID, req.ProjectID, s.ProjectID, n.ProjectID, d.ProjectID, -1) as ProjectID
	from MTO_D_BudgetItemResources bir
	join #itemLink lpn
		on bir.ID = lpn.Entity1ID and lpn.EntityType = 1
	join MTO_D_ProjectNeeds pn
		on lpn.Entity2ID = pn.ID  and lpn.EntityType = 1
	join #itemLink rl
		on pn.ID = rl.Entity1ID and rl.EntityType = 9
	join MTO_D_Requests req
		on rl.Entity2ID = req.ID and rl.EntityType = 9
	join #itemLink spl
		on req.ID = spl.Entity1ID and spl.EntityType = 5
	join MTO_D_SpecificationItems si
		on si.ID = spl.Entity2ID and spl.EntityType = 5
	join #itemLink notel
		on req.ID = notel.Entity1ID and notel.EntityType = 12
	join MTO_D_NotificationItems ni
		on ni.SpecificationItemID = si.ID and notel.Entity2ID = ni.ID
	join #itemLink dlink
		on req.ID = dlink.Entity1ID and dlink.EntityType = 1012
	join MTO_D_DeliveryItems di
		on si.ID = di.SpecificationItemID and di.ID = dlink.Entity2ID
	join MTO_D_Notifications n
		on n.ID = ni.NotificationID
	join MTO_D_Deliveries d
		on d.ID = di.DeliveryID and n.ID = d.NotificationID
	left join MTO_D_Specifications s
		on si.SpecificationID = s.ID
	left join #requestDistributionLink rdl
		on pn.ID = rdl.projectNeedID
	left join (select ID, Quantity, sum(Quantity) over(partition by ID) sumQty, DistributionRequestItemID from MTO_D_DistributionItems) distri
		on distri.DistributionRequestItemID = rdl.rdid