XinYu_RZMES/.svn/pristine/d5/d56e89ba6b455c5eb5b5b5dd3a686ee0aa35f992.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH051700_01.select" desc="  ">
        <![CDATA[
select substr(A.OLD_SAMPL_NO,1,10) SPM_NO ,
       A.OLD_SAMPL_NO,
       A.ORD_NO,
       A.ORD_SEQ,
       substr(a.SLAB_NO,1,10) CHARGE_NO,
       A.SPEC_STL_GRD,
       (SELECT C.SLAB_THK||'*'||C.SLAB_WTH FROM TBG02_SLAB_COMM C WHERE C.SLAB_NO = A.SLAB_NO) ST_SW,
       A.MILL_DTIME,
       DECODE(B.WKSHIFT,'1','早','2','中','3','晚',null) WKSHIFT,
       DECODE(B.WKGROUP,'A','甲','B','乙','C','丙','D','丁',null) WKGROUP,
       DECODE(A.CUR_PROG_CD,'SRC','充当待机','SED','综合判定待机','SFA','发货待机','SFB','运送待机','SFF','发货完成',null) COIL_STAT,
       B.WK_EMP_USE_NO,
       B.WK_EMP_USE_DTIME,
       A.YARD_ENTRY_REG,
       A.YARD_ENTRY_USE_TIME,
       A.COIL_THK||'*'||A.COIL_WTH CT_CW,
       A.INSTR_COIL_THK||'*'||A.INSTR_COIL_WTH IT_IW,
       TO_CHAR(A.ACT_WGT/1000) ACT_WGT,
       A.CUR_LOAD_LOC
        
       
       from tbh02_coil_comm a,tbh02_mill_result b
where a.COIL_NO = b.COIL_NO(+) 
AND   SUBSTR(A.MILL_DTIME,1,12) >= :1
AND   SUBSTR(A.MILL_DTIME,1,12) <= :2
AND   B.MISSNO_CLF_CD IS NULL 
order by A.MILL_DTIME 
		]]>
    </query>
	<query id="UIH051700_02.select" desc=" 统计总数 ">
        <![CDATA[
  select COUNT(A.OLD_SAMPL_NO) COIL_CNT,
        TO_CHAR(SUM(A.ACT_WGT)/1000) COIL_WGT  
        from tbh02_coil_comm a,tbh02_mill_result b
where a.COIL_NO = b.COIL_NO(+) 
AND   SUBSTR(A.MILL_DTIME,1,12) >= :1
AND   SUBSTR(A.MILL_DTIME,1,12) <= :2
AND   B.MISSNO_CLF_CD IS NULL 
order by A.MILL_DTIME        
		]]>
    </query>
</queryMap>