XinYu_RZMES/.svn/pristine/6e/6e049cb2e0a67fd465f420a5d88a30aad15cf15a.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH090110_01.select" desc=" 中废板查询 " fetchSize="10">
		<![CDATA[
			SELECT (SELECT DECODE(A.MISSNO_CLF,1,'炉前取消',2,'炉后加回',3,'轧回') FROM TBH02_RHF_MISSNO A WHERE A.SLAB_NO = B.SLAB_NO AND A.COIL_NO = B.COIL_NO) MISSNO_CLF
       ,( SELECT A.SM_CFNM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'H02009' AND A.SM_CD = (SELECT A.MISSNO_CAUSE_CD FROM TBH02_RHF_MISSNO A WHERE A.SLAB_NO = B.SLAB_NO AND A.COIL_NO = B.COIL_NO)) MISSNO_CAUSE_CD
       ,(SELECT A.MISSNO_DTIME FROM TBH02_RHF_MISSNO A WHERE A.SLAB_NO = B.SLAB_NO AND A.COIL_NO = B.COIL_NO) MISSNO_DTIME
       ,(SELECT A.MISSNO_WK_EMP_NO FROM TBH02_RHF_MISSNO A WHERE A.SLAB_NO = B.SLAB_NO AND A.COIL_NO = B.COIL_NO) MISSNO_WK_EMP_NO
       ,B.MISSNO_BAR_THK
       ,B.MISSNO_BAR_WTH
       ,B.MISSNO_BAR_WGT
       ,DECODE(B.MISSNO_CAUSE_QY,'H06002','粗轧中废原因','H06003','精轧中废原因','H06004','卷取中废原因') MISSNO_CAUSE_QY
       ,(SELECT A.SM_CFNM FROM TBZ00_COMMCD A WHERE A.LG_CD = B.MISSNO_CAUSE_QY AND A.SM_CD = B.MISSNO_CAUSE_CD) MISSNO_CAUSE_CD
       ,B.WK_EMP_USE_NO
       ,B.SLAB_NO
       ,B.COIL_NO
       FROM TBH02_MILL_RESULT B,TBH02_REHEATFUR C
       WHERE C.SLAB_NO = B.SLAB_NO 
       AND C.COIL_NO = B.COIL_NO
       AND B.WKGROUP||'&' like :1||'%'
       AND substr(C.EXTRACT_DTIME,1,8) >= :2
       AND substr(C.EXTRACT_DTIME,1,8) <= :3
		]]>
	</query>
</queryMap>