SELECT	  			dbo.Batch.ReportDate AS job_date, dbo.Job.CompanyJobId AS job_number, dbo.Item.CompanyItemId AS cost_code, 
		     			 
					 SUM(CASE dbo.SourceType.CompanySourceTypeId WHEN 'MA' then dbo.ProductionEvent.AlternateQuantity ELSE 0 END) AS qty_received,
        	    			 	  SUM(CASE dbo.SourceType.CompanySourceTypeId WHEN 'PR' THEN dbo.ProductionEvent.Quantity ELSE 0 END) AS qty_used,
					 SUM(CASE dbo.SourceType.CompanySourceTypeId WHEN 'MA' then dbo.ProductionEvent.AlternateQuantity ELSE 0 END)
	  					 - SUM(CASE dbo.SourceType.CompanySourceTypeId WHEN 'PR' THEN dbo.ProductionEvent.Quantity ELSE 0 END) AS qty_wasted,
					 SUBSTRING(dbo.Job.CompanyJobId, 1 ,3) AS plant_id
		
		FROM    	 dbo.Batch INNER JOIN
                     		 dbo.Event ON dbo.Batch.BatchGuid = dbo.Event.BatchGuid INNER JOIN
                     		 dbo.Job ON dbo.Event.JobGuid = dbo.Job.JobGuid INNER JOIN
                     		 dbo.ProductionEvent ON dbo.Event.EventGuid = dbo.ProductionEvent.EventGuid INNER JOIN
                    		 dbo.Item ON dbo.Event.ItemGuid = dbo.Item.ItemGuid INNER JOIN
                     		 dbo.Source ON dbo.ProductionEvent.SourceGuid = dbo.Source.SourceGuid INNER JOIN
                   		 dbo.SourceType ON dbo.Source.SourceTypeGuid = dbo.SourceType.SourceTypeGuid left outer JOIN
                   		 dbo.Product ON dbo.ProductionEvent.ProductGuid = dbo.Product.ProductGuid
		
		WHERE 		 dbo.Item.UnitOfMeasure = 'TN' and dbo.Batch.ReportDate >= @DateFrom and dbo.Batch.ReportDate <= @DateTo
		
		GROUP BY 	 dbo.Batch.ReportDate, dbo.Job.CompanyJobId,dbo.Item.CompanyItemId

SUM(CASE dbo.SourceType.CompanySourceTypeId WHEN 'MA' then dbo.ProductionEvent.AlternateQuantity ELSE 0 END) AS qty_received

and dbo.Product.CompanyProductId LIKE 'ASPH%' 

SUM(CASE dbo.SourceType.CompanySourceTypeId WHEN 'MA' and dbo.Product.CompanyProductId when LIKE 'ASPH%'then dbo.ProductionEvent.AlternateQuantity ELSE 0 END) AS qty_received,