XinYu_RZMES/.svn/pristine/6a/6a1db0a7206acfbb67be6c78b1e0744f58745770.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH020031_01.select" desc=" " fetchSize="10">
		<![CDATA[
    select D.ROLL_SLAB_SEQ SEQ,
       b.mill_dtime MILL_DTIME,
       D.ROLL_MANA_NO,
       a.COIL_NO,
       a.SLAB_NO,
       d.SPEC_STL_GRD STL_GRD,
       d.ORD_NO ORD_NO,
       d.ORD_SEQ ORD_SEQ,
      (select CUST_NM FROM TBZ00_CUSTOMER WHERE CUST_CD = d.CUST_CD and REC_TP='01') CUST_NM, 
      (select CUST_NM ORD_NM FROM TBZ00_CUSTOMER WHERE CUST_CD = d.ORD_CUST_CD and REC_TP='02') ORD_NM,
       b.SPEC_ABBSYM,
       b.PRODNM_CD,
       CASE
         WHEN (D.STATUS_CD = 'A' AND B.COIL_STAT IS NULL) THEN
          '轧制作业待机'
         WHEN (D.STATUS_CD = 'A' AND B.COIL_STAT = '0') THEN
          '上料进行'
         WHEN (D.STATUS_CD = 'D') THEN
          '轧制吊销'
         WHEN (D.STATUS_CD = 'B') THEN
          '轧制进行'
         WHEN (D.STATUS_CD = 'C' AND B.MISSNO_CLF_CD IS NULL) THEN
          '轧制完成'
         WHEN (D.STATUS_CD = 'C' AND B.MISSNO_CLF_CD = 'C') THEN
          '轧废或中板'
         ELSE
          '轧制完成'
       END STATUS_CD,
       a.RM_EXT_AVG_THK,
       a.RM_EXT_AVG_WTH,
       a.RM_EXT_AVG_LEN,
       a.R2_EXT_TEMP,
       a.R1_EXT_TEMP,
       a.F1_ENT_TEMP_AVG,
       A.F1_ENT_TEMP_MAX,
       A.F1_ENT_TEMP_MIN,
       A.F1_ENT_TEMP,
       a.FM_EXT_STRIP_TEMP,
       a.FM_EXT_STRIP_TEMP_AVG,
       a.FM_EXT_STRIP_TEMP_MAX,
       a.FM_EXT_STRIP_TEMP_MIN,
       a.FM_EXT_STRIP_WTH,
       a.FM_EXT_STRIP_WTH_AVG,
       a.FM_EXT_STRIP_WTH_MAX,
       a.FM_EXT_STRIP_WTH_MIN,
       a.FM_EXT_STRIP_THK,
       a.FM_EXT_STRIP_THK_AVG,
       a.FM_EXT_STRIP_THK_MAX,
       a.FM_EXT_STRIP_THK_MIN,
       a.DC_TEMP,
       a.DC_TEMP_AVG,
       a.COIL_OUTDIA,
       C.CHRGING_BEF_TEMP,
       c.EQ_HT_TEMP,
       c.EQ_HT_INFUR_HOUR,
       c.INFUR_HOUR,
       c.EXTRACT_AVG_TEMP,
       b.old_sampl_no,
       DECODE(b.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','','待判定') EXTSHAPE_DEC_GRD,
       DECODE(b.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品','','待判定') TOT_DEC_GRD  
        from tbh02_mill_result a,tbh02_coil_comm b,TBH02_REHEATFUR c,tbf02_spec_mill d
        where b.coil_no = a.COIL_NO(+)
              AND b.COIL_NO = c.coil_no(+) 
              and b.COIL_NO = d.COIL_NO(+)
              and d.ROLL_MANA_NO like :1||'%'
              and NVL(B.MILL_DTIME,'20090515000000') between NVL(:2,'20090515000000') and NVL(:3,'20220515000000')
              AND B.OLD_SAMPL_NO LIKE :4||'%'
              AND ROWNUM < 5001
        order by d.ROLL_SLAB_SEQ
			
		]]>
	</query>
</queryMap>