XinYu_RZMES/.svn/pristine/07/07e586a244c80c787bc325e50cfd3da38a870a44.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="SMS WORK TIME CHANGE IN CHARGE INFORMATION">
              
   <query id="NIF012180_LadleMvTme.select" desc="it's query from TBF01_LADLE_TIME Table" fetchSize="10">
	   <![CDATA[
			SELECT  STR_PROC_CD              
             	   ,END_PROC_CD              
				   ,LADLE_MOVE_TME           
		      FROM  TBF01_LADLE_TIME
		     ORDER  BY  STR_PROC_CD
		               ,END_PROC_CD 
       ]]>
   </query>

   <query id="NIF012180_LastChargeTme1.select" desc="it's query from TBF01_SPEC_CHARGE, TBG02_CHARGE_COMM, TBG02_CC_RESULT Table" fetchSize="10">
	   <![CDATA[
		    SELECT  B.CC_STA_DTIME   CCM_STR
		           ,B.CC_END_DTIME   CCM_END
		           ,C.STL_GRP_CD
		           ,C.CHARGE_MANA_NO
		           ,D.CHG_SEQ
		      FROM  TBG02_CHARGE_COMM A
		           ,TBG02_CC_RESULT   B
		           ,TBF01_SPEC_CHARGE C
		           ,TBF01_CHARGE_IDX  D
		     WHERE  D.CHARGE_EDT_SEQ    =   C.CHARGE_EDT_SEQ
		       AND  A.PLAN_CHARGE_NO    =   C.CHARGE_MANA_NO
		       AND  A.CHARGE_NO         =   B.CHARGE_NO(+)
		       AND  A.PLAN_CHARGE_NO    =   (SELECT  MAX(D.CHARGE_MANA_NO)
									  	       FROM  TBF01_CHARGE_IDX   D
										      WHERE  D.PRC_LINE    =   ?                                                    
                                                AND  D.L2_SEND     =   'Y'
                                                AND  D.STATUS_CD   =   'C') 
       ]]>
    
   </query>

   <query id="NIF012180_LastChargeTme2.select" desc="it's query from TBF01_SPEC_CHARGE, TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
		    SELECT  A.PRE_CCM_STR_DTIME   CCM_STR
		           ,A.PRE_CCM_END_DTIME   CCM_END
		           ,A.STL_GRP_CD
		           ,B.CHARGE_MANA_NO
		           ,B.CHG_SEQ
		      FROM  TBF01_SPEC_CHARGE A
		           ,TBF01_CHARGE_IDX  B
		     WHERE  A.CHARGE_EDT_SEQ     =      B.CHARGE_EDT_SEQ
		       AND  B.PRC_LINE           =      ?
		       AND  B.L2_SEND            =      'Y'
		       AND  B.CHG_SEQ            =      (SELECT  MAX(D.CHG_SEQ)
		                                           FROM  TBF01_CHARGE_IDX  D
		                                          WHERE  D.PRC_LINE   =   ?
                                                    AND  D.L2_SEND    =  'Y')
       ]]>
   </query>

   <query id="NIF012180_ChargeInf.select" desc="it's query from TBF01_SPEC_CHARGE, TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  A.CHARGE_EDT_SEQ
		           ,A.STL_GRP_CD
		           ,A.PATH_PROC_CD
		           ,B.ORG_SEQ
		      FROM  TBF01_SPEC_CHARGE A
		           ,TBF01_CHARGE_IDX  B
		     WHERE  A.CHARGE_EDT_SEQ     =      B.CHARGE_EDT_SEQ
		       AND  B.PRC_LINE           =      ?
		       AND  B.CHG_SEQ            >      ?
		     ORDER  BY  B.CHG_SEQ 
       ]]>
   </query>

   <query id="NIF012180_ProcNeedTME.select" desc="it's query from TBF01_SMS_TTT Table" fetchSize="10">
	   <![CDATA[
			SELECT  PROC_CD
		           ,NEED_STD_TME
		      FROM  TBF01_SMS_TTT 
		     WHERE  STL_GRP_CD    =   ?
		     ORDER  BY  PROC_CD 
       ]]>
   </query>

   <query id="NIF012180_CcmCutTme.select" desc="it's query from TBF01_SPEC_CHARGE, TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  COUNT(SLAB_EDT_SEQ)  SLAB_CNT
		           ,SUM(CCM_CUT_TME)     CCM_CUT_TME
		           ,MAX(CCM_CUT_TME)     MAX_CUT_TME
		      FROM  TBF01_SPEC_SLAB 
		     WHERE  CHARGE_EDT_SEQ     =   ?
       ]]>
   </query>

   <query id="NIF012180_ChgIdxBefUpd.update" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_CHARGE_IDX
		       SET  CHG_SEQ              =   ?
		           ,CHARGE_MANA_NO       =   ?
		           ,CHG_CHARGE_MANA_NO   =   ?
		     WHERE  ORG_SEQ              =   ?
       ]]>
   </query>	
	
   <query id="NIF012180_SpecSlabBefUpd.update" desc="it's query from TBF01_SPEC_SLAB Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_SLAB
		       SET  SLAB_MANA_NO     =   ? || SUBSTR(SLAB_MANA_NO,11,3)
		           ,CHARGE_MANA_NO   =   ?
		     WHERE  CHARGE_EDT_SEQ   =   ?
       ]]>
   </query>
	
   <query id="NIF012180_SMSWorkTmeCharge.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_CHARGE
		       SET  HM_STR_DTIME       =   ? 
		           ,BLOW_STR_DTIME     =   ?
                   ,PRE_BOF_STR_DTIME  =   ?
                   ,PRE_BOF_END_DTIME  =   ?
                   ,PRE_CAS_STR_DTIME  =   ?
                   ,PRE_CAS_END_DTIME  =   ?
 		           ,PRE_RH_STR_DTIME   =   ?
                   ,PRE_RH_END_DTIME   =   ?
                   ,PRE_LF_STR_DTIME   =   ?
                   ,PRE_LF_END_DTIME   =   ?
                   ,PRE_CCM_STR_DTIME  =   ?
                   ,PRE_CCM_END_DTIME  =   ?
		           ,CCM_TME            =   ?
		           ,CHARGE_MANA_NO     =   ?
		     WHERE  CHARGE_EDT_SEQ     =   ?
       ]]>
   </query>

   <query id="NIF012180_SlabInf.select" desc="it's query from TBF01_SPEC_SLAB Table" fetchSize="10">
	   <![CDATA[
		    SELECT  A.CHARGE_EDT_SEQ
		           ,A.CHARGE_SLAB_SEQ
		           ,A.SLAB_EDT_SEQ
		           ,A.CCM_CUT_TME
		           ,B.PRE_CCM_STR_DTIME
		      FROM  TBF01_SPEC_SLAB   A
		           ,TBF01_SPEC_CHARGE B
		     WHERE  A.CHARGE_EDT_SEQ     =      B.CHARGE_EDT_SEQ
		       AND  B.CHARGE_EDT_SEQ     =      ?
		     ORDER  BY  A.CHARGE_SLAB_SEQ 
       ]]>
   </query>
		   
   <query id="NIF012180_SMSWorkTmeSlab.update" desc="it's query from TBF01_SPEC_SLAB Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_SLAB
		       SET  CCM_CUT_PRE_TME  =   ?
		     WHERE  SLAB_EDT_SEQ     =   ?
       ]]>
   </query>
	 
</queryMap>