select '' partnerName, c.partnerType, c.partnerId, cc.requestId, s.sku, s.skuDesc, s.skuId, sum( pod.itemQty ) cases, sum( case when pod.status = 'CLAIM' then pod.totalRebate when pod.status = 'CONTRACT' then pod.qualifiedAmount else 0.0 end ) claimedAmount from tbl_TPM_ClaimContracts cc inner join tbl_TPM_Claims c on c.claimId = cc.claimId inner join tbl_TPM_ProofOfDelivery pod on pod.contractnbr = cc.contractnbr and pod.claimId = cc.claimId inner join tbl_PRD_Skus s on s.skuId = pod.skuId where cc.requestId in ( select requestId from tbl_TPM_RequestPartners where partnerId = and partnertype = 'OPR' ) and cc.ownerId= and cc.ownerType = and pod.status in ( 'CLAIM', 'CONTRACT' ) and cc.status like 'APPROVED%' and c.partnerType = 'CDR' and cc.requestId in ( ) group by c.partnerType, c.partnerId,cc.requestId,s.sku, s.skuDesc, s.skuId order by partnerType, partnerId, cc.requestId, s.sku select * from qmd_contractRealization order by requestId, partnerName, skuId select sum( costPerCase ) costPerCase, sum( costPerLb ) costPerLb from qmd_overlappingRequests

Distributor	SKU	Description	Cases	Claim Cost	True Cost	TC/Case
#htmleditformat( qmd_request.assignedContractNbr )# - #htmleditformat( qmd_request.description )#
#htmleditformat( partnerName )#	#htmleditformat( sku )#	#htmleditformat( skuDesc )#	#lsnumberformat( cases )#	#lscurrencyformat( claimedAmount )#	#lsCurrencyFormat( _trueCost )#	#lscurrencyformat( _trueCostPer )#-
Distributor Totals:			#lsnumberformat( _casesTotal )#	#lscurrencyformat( _claimedAmountTotal )#	#lsCurrencyFormat( _trueCostTotal )#	&##160;
Totals:			#lsnumberformat( _casesGrandTotal )#	#lscurrencyformat( _claimedAmountGrandTotal )#	#lsCurrencyFormat( _trueCostGrandTotal )#