|
sql.add('select dept_name, ');
sql.add(' sum(decode(laser_chk,''Y'',out_amt,0)) LASER, ');
sql.add(' sum(decode(laser_chk,''Y'',out_amt*cost,0)) LASET_COST, ');
sql.add(' sum(decode(laser_chk,''N'',decode(color_chk,''B'',out_amt,0),0)) BK_INK, ');
sql.add(' sum(decode(laser_chk,''N'',decode(color_chk,''B'',out_amt*cost,0),0)) BK_COST, ');
sql.add(' sum(decode(laser_chk,''N'',decode(color_chk,''C'',out_amt,0),0)) CO_INK, ');
sql.add(' sum(decode(laser_chk,''N'',decode(color_chk,''C'',out_amt*cost,0),0)) CO_COST, ');
sql.add(' sum(out_amt) TOTAL_AMT, sum(out_amt*cost) TOTAL_COST ');
sql.add('from somo_mst, somo_out, insa_tm_view ');
sql.add('where somo_mst.code=somo_out.code ');
sql.add(' and somo_mst.gubun=somo_out.gubun ');
sql.add(' and somo_out.out_dept_code=insa_tm_view.dept_code ');
sql.add(' and out_date like :input_date || ''%'' ');
sql.add(' and somo_mst.gubun=''65'' ');
sql.add(' and pum_gu=''1'' ');
sql.add('group by dept_name ');
sql.add('order by TOTAL_COST desc ');
|
