select 
* from openquery(JDEPROD,'select DISTINCT c.GMSUB as gbsub,c.GmMCU as gbmcu,  GMUM ,''U'' as  UOMType, ''1'' as UOMSeq, a.GBUPMJ,
''Production'' as CostTypeDescription,
(SUM(COALESCE(a.GBan01,0)+COALESCE(a.GBan02,0)+COALESCE(a.GBan03,0)+COALESCE(a.GBan04,0)+COALESCE(a.GBan05,0)+COALESCE(a.GBan06,0)+
COALESCE(a.GBan07,0)+COALESCE(a.GBan08,0)+COALESCE(a.GBan09,0)+COALESCE(a.GBan10,0)+COALESCE(a.GBan11,0)+COALESCE(a.GBan12,0)+COALESCE(a.GBan13,0)+COALESCE(a.GBan14,0)))*.01 as actual 
,(SUM(COALESCE(b.GBBORG ,0)+COALESCE(b.GBan01,0)+COALESCE(b.GBan02,0)+COALESCE(b.GBan03,0)+COALESCE(b.GBan04,0)+COALESCE(b.GBan05,0)+COALESCE(b.GBan06,0)+
COALESCE(b.GBan07,0)+COALESCE(b.GBan08,0)+COALESCE(b.GBan09,0)+COALESCE(b.GBan10,0)+COALESCE(b.GBan11,0)+COALESCE(b.GBan12,0)+COALESCE(b.GBan13,0)+COALESCE(b.GBan14,0)))*.01 as budget
from VGIPRDDTA.F0901 c
inner join VGIPRDDTA.F0006 on GMMCU=MCMCU and GMCO = MCCO  
left join VGIPRDDTA.F0902 a
on c.GMMCU=a.GbMCU and c.GMCO = a.GbCO and c.GMSUB=a.GbSUB and a.GBLT=''AU'' and a.gbobj like ''%     %'' 
left join  VGIPRDDTA.F0902 b 
on c.GMMCU=b.GbMCU and c.GMCO = b.GbCO and c.GMSUB=b.GbSUB and b.GBLT=''JU'' and b.gbobj like ''%     %'' 
where  c.GMOBJ like ''%     %'' and  c.GMSUB <> ''     '' and c.GMMCU <>''     ''  and
MCSTYL in (''51'', ''52'', ''53'', ''54'',''03'', ''04'', ''21'',''05'',''11'')  and mcpecc in ('''',''K'') 
GROUP BY c.gmSUB,c.gmMCU, GMUM,a.GBUPMJ')