XinYu_RZMES/.svn/pristine/17/17b72e41a48badd71603abe35770ae3fd2d11d08.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH090050_01.select" desc=" 成品库入库报表 " fetchSize="10">
		<![CDATA[
           select B.ROLL_SLAB_SEQ SEQ,
       b.roll_mana_no,
       c.ord_no,substr(a.coil_no,0,10) SPM_NO,
       c.old_sampl_no,
       c.SMP_DIR_PIC_YN,
       c.spec_stl_grd,
       c.coil_thk||'*'||c.coil_wth t_w,
       c.act_wgt,
       c.cur_load_loc,
       decode(c.tot_dec_grd,'1','合格','2','不合格','3','外观原因','4','废品') tot_dec_grd,
       sq_qd_common.COMMCD_CDTOCFNM('H02001',(case when c.crk_cd1 is not null then c.crk_cd1 
             when c.crk_cd2 is not null then c.crk_cd2
             when c.crk_cd3 is not null then c.crk_cd3
             when c.crk_cd4 is not null then c.crk_cd4
             when c.crk_cd5 is not null then c.crk_cd5
       end ))crk_cd,
       a.reg_id,
       a.reg_dtime,
       c.rem   
       from tbh05_coil_yard a,tbf02_spec_mill b,tbh02_coil_comm c
         where a.coil_no = c.old_sampl_no
         and   b.slab_no = c.slab_no
         and   c.coil_stat = '2'
         and   a.reg_dtime like ?||'%'
         order by B.ROLL_MANA_NO,B.ROLL_SLAB_SEQ,a.REG_DTIME
		]]>
	</query>
	<query id="UIH090050_02.select" desc=" 成品库入库钢卷个数和总量的统计 " fetchSize="10">
		<![CDATA[
               select count(*) COIL_CNT,
                    nvl(sum(c.act_wgt)/1000,0) COIL_WGT   
                    from tbh05_coil_yard a,tbh02_coil_comm c
                    where a.coil_no = c.old_sampl_no
                    and   c.coil_stat = '2'
                    and   a.reg_dtime like ?||'%'
		]]>
	</query>
</queryMap>