XinYu_RZMES/.svn/pristine/d2/d2a50c79d49cad17a6fab1ba9e2b89207cb89952.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">

	<query id="NIG050010_CHEM_RSLT.select.select" desc="" fetchSize="10">
		<![CDATA[
			SELECT  a.CHEM_CD
                   ,a.CHEM_VAL
                   ,b.DISPLAY_SEQ
              FROM TBB02_WORK_INGR a,
                   TBB01_SEQ_INGR  b 
             WHERE  a.CHARGE_NO = ?
               AND  a.PROC_CD  = ?
               AND  a.CHEM_CD = b.CHEM_CD
   ORDER BY b.DISPLAY_SEQ  
		]]>
	</query> 
	 <query id="NIG050010_CHEM_DEC.select" desc="" fetchSize="10">
		<![CDATA[
	     SELECT  CHEM_CD,PROC_CD,CHEM_VAL,CHEM_MIN,CHEM_MAX
        FROM 
        (
           SELECT  a.CHEM_CD,a.PROC_CD||a.CHEM_SEQ PROC_CD,a.CHEM_VAL,b.CHEM_MIN,b.CHEM_MAX
             FROM 
            (
              SELECT  a.CHEM_CD ,a.CHEM_VAL,b.DISPLAY_SEQ,a.PROC_CD,a.CHEM_SEQ
                  FROM   TBB02_WORK_INGR a,
                      TBB01_SEQ_INGR  b 
               WHERE  a.CHARGE_NO = ?
                 AND  a.PROC_CD  = 'JJ'
                 AND  a.CHEM_CD = b.CHEM_CD
                ORDER BY b.DISPLAY_SEQ  
            ) a,
            ( 
              SELECT  a.CHEM_CD,a.CHEM_MIN ,a.CHEM_MAX,b.DISPLAY_SEQ
                FROM TBB01_FAC_INGR a,
                     TBB01_SEQ_INGR  b 
               WHERE  a.FAC_STL_GRD = ?
                 AND  a.FAC_CODE  = 'HC'
                 AND  a.CHEM_CD = b.CHEM_CD
               ORDER BY b.DISPLAY_SEQ  
            ) b
            where a.CHEM_CD = b.CHEM_CD
      )  
     WHERE   CHEM_VAL <CHEM_MIN 
      or    CHEM_VAL > CHEM_MAX
		]]>
	</query> 
    <query id="NIG050010_CHEM_DEC.update" desc="init " fetchSize="10">
		<![CDATA[
			UPDATE TBG02_CHARGE_COMM set 
           	  LST_INGR_CD    = ?
			 ,LST_INGR_PROC_CLF          = ?
			 ,LST_INGR_REG_DTIME = to_char(sysdate,'YYYYMMDDHH24MISS')
			 
			where CHARGE_NO = ?  
		]]>
	</query>
</queryMap>