XinYu_RZMES/.svn/pristine/79/79b9a0e1f1ef02ebf885a647b22328e421fa8bc2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="报表">
	
	<query  id="UIG100001_01.SELECT" desc="报表">
	--发运量
		select '发运量' as NAME,(select sum(B.ACT_WGT) / 1000 
  from tbh02_coil_comm B
 where B.DLIV_TP in ('T', 'C')
   AND B.COIL_STAT = '3'
   AND B.CUR_PROG_CD = 'SFF'
   and B.TRNF_DTIME between ? and ?) SUM_DAY_WGT,
   (select sum(B.ACT_WGT) / 1000 
  from tbh02_coil_comm B
 where B.DLIV_TP in ('T', 'C')
   AND B.COIL_STAT = '3'
   AND B.CUR_PROG_CD = 'SFF'
   and B.TRNF_DTIME between ? and substr(?,1,6) || '31') SUM_MONTH_WGT
    from dual
    union
    --去冷轧
       select '去冷轧' as NAME,(select sum(T.ACT_WGT) / 1000 
  from tbh02_coil_comm T
 where T.DLIV_TP ='L'
   AND T.COIL_STAT = '3'
   and T.TRNF_DTIME between ? and ?) SUM_DAY_WGT,(select sum(T.ACT_WGT) / 1000 
  from tbh02_coil_comm T
 where T.DLIV_TP ='L'
   AND T.COIL_STAT = '3'
   and T.TRNF_DTIME between ? and substr(?,1,6) || '31') SUM_MONTH_WGT from dual
	</query>
<query  id="UIG100001_01.DETAILSELECT" desc="发运量明细">
	select OLD_SAMPL_NO, ACT_WGT,TRNF_DTIME
  from tbh02_coil_comm 
 where DLIV_TP in ('T', 'C')
   AND COIL_STAT = '3'
   AND CUR_PROG_CD = 'SFF' 
</query>
<query  id="UIG100001_02.DETAILSELECT" desc="去冷轧明细">
select OLD_SAMPL_NO, ACT_WGT,TRNF_DTIME
  from tbh02_coil_comm 
 where DLIV_TP = 'L'
   AND COIL_STAT = '3'
</query>	
</queryMap>