XinYu_RZMES/.svn/pristine/87/87e6a99c136ca34e744f8cfc8639cdb2020d6fa2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
  <query id="UIG02COMM_SPEC_CHARGE.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 通过电文中接收的炉次号查询炉次参数表 TBF01_SPEC_CHARGE 取得的数据项 ，修改炼钢公共表 TBF02_CHARGE_COMM */
           SELECT      A.CAST_CHARGE_SEQ
		               , A.CAST_EDT_CHARGE_CNT
		               , A.PRODNM_CD
		               , A.STL_GRD  
		               , A.LINE_PROC_CD
		               , A.HCR_CLF
		               , A.SPEC_ABBSYM
		               , A.CAST_MANA_NO
		               , A.CHARGE_MANA_NO
		               , A.CAST_EDT_CHARGE_CNT
		               , A.PREV_CHARGE_WGT
		               , B.SLAB_RT
					   , A.STATUS_CD 
          FROM TBF01_SPEC_CHARGE A,
                TBF01_SPEC_SLAB B 
          WHERE  A.CHARGE_MANA_NO =  B.CHARGE_MANA_NO
            AND A.CHARGE_MANA_NO =  ?
            AND ROWNUM = 1  
        ]]>
   </query>	
   <query id="UIG02COMM_PLAN_SLABNO.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			SELECT PLAN_SLAB_NO FROM TBG02_SLAB_COMM WHERE SLAB_NO = ?
        ]]>
   </query>
   <query id="UIG02COMM_CACUL_SLAB_WGT.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			SELECT T.SM_CD*?*?*? FROM TBZ00_COMMCD T WHERE T.LG_CD LIKE 'D01006'
        ]]>
   </query>
</queryMap>