XinYu_RZMES/.svn/pristine/64/64138ecaa157414f482d05d5c0a8de434ac3b362.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG010060_SLAB_CUT_INS.select" desc=" 包号查询 " fetchSize="10">
		<![CDATA[
			SELECT T.STL_GRD,T.SLAB_THK,T.SLAB_WTH,T.SLAB_LEN,T.SLAB_WGT/1000 SLAB_WGT_T,T.SLAB_WGT*COUNT(T.SLAB_THK)/1000 TOTAL_WGT_T,COUNT(T.SLAB_THK) SLAB_CNT 
			FROM (
					  SELECT STL_GRD,SLAB_THK,SLAB_WTH,SLAB_LEN,SLAB_WGT,MOD_DTIME,SLAB_RT 
					  FROM   TBF01_CHARGE_IDX A,
							 TBF01_SPEC_SLAB B
					  WHERE  SUBSTR(B.SLAB_MANA_NO,1,10) = A.CHARGE_MANA_NO
					  AND    A.L2_SEND = 'Y'
			
				 )T
				 
			WHERE   SUBSTR(T.MOD_DTIME,1,8)  like ?||'%'
			AND     T.SLAB_RT = 'H'
			GROUP BY T.STL_GRD, T.SLAB_LEN,T.SLAB_THK,T.SLAB_WTH,T.SLAB_WGT    
		]]>
	</query> 
</queryMap>