XinYu_RZMES/.svn/pristine/06/06a7571dd493543f87b1f16be787f7852b36feb3.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Mill Schedule Request">
 
 <query id="NIH020120_01.select" desc="init " fetchSize="10">
    <![CDATA[
      SELECT SEQ_NO ,TRANS_DTIME
       FROM
       (
          SELECT SEQ_NO ,TRANS_DTIME
           FROM TBH06_L2_MILL_INS
          WHERE SLAB_NO = ?
          ORDER BY   TRANS_DTIME DESC
       )  
       WHERE ROWNUM = 1
        ]]>
 </query>
    <query id="NIH020120_01.update" desc="init " fetchSize="10">
        <![CDATA[
       UPDATE TBH06_L2_MILL_INS  SET 
         MSG_FLAG  = 'N'              
        WHERE SEQ_NO = ? AND TRANS_DTIME = ? 
        ]]>
 </query>
     
</queryMap>