XinYu_RZMES/.svn/pristine/39/39499b3c3f0fc945713e5fd23ca5ae6453435ff2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="MILL WORK TIME SCHEDULE ">

   <query id="NIF023040_SlabChk.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
	   <![CDATA[
			SELECT  SLAB_EDT_SEQ
              FROM  TBF02_SPEC_MILL
             WHERE  ROLL_MANA_NO     =   ?
		       AND  ROLL_SLAB_SEQ    =   ?
       ]]>
   </query>	
	           
   <query id="NIF023040_LstMillPreTme.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
	   <![CDATA[
			SELECT  MAX(ROLL_MANA_NO)    ROLL_MANA_NO
		           ,MAX(MILL_PRE_TME)    MILL_PRE_TME
              FROM  TBF02_SPEC_MILL
             WHERE  ROLL_MANA_NO || LPAD(TO_CHAR(ROLL_SLAB_SEQ),4,'0')  <  ? || LPAD(TO_CHAR(?),4,'0')
       ]]>
   </query>	
   
   <query id="NIF023040_RollSlabSel.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
	   <![CDATA[
			SELECT  ROLL_MANA_NO
		           ,SLAB_EDT_SEQ
		           ,FUR_TME
		           ,MILL_TME
              FROM  TBF02_SPEC_MILL
             WHERE  ROLL_MANA_NO || LPAD(TO_CHAR(ROLL_SLAB_SEQ),4,'0')  >=  ? || LPAD(TO_CHAR(?),4,'0')
		     ORDER  BY  ROLL_MANA_NO
		               ,ROLL_SLAB_SEQ
       ]]>
   </query>	

   <query id="NIF023040_MillFurTme.update" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF02_SPEC_MILL
		       SET  FUR_IN_PRE_DTIME   =   ?
		           ,MILL_PRE_TME       =   ?
             WHERE  SLAB_EDT_SEQ       =   ?
       ]]>
   </query>	
		
</queryMap>