XinYu_RZMES/.svn/pristine/46/46f9a97a926f836b058068e66ef466be0be6512d.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="SMS WORK INSTRUCTION PRC LINE CHANGING">

   <query id="NIF012150_ChgSeqSel.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  A.CHG_SEQ CHG_SEQ_ST, 
		            B.CHG_SEQ CHG_SEQ_EN
		      FROM  (SELECT  CHG_SEQ  
		               FROM  TBF01_CHARGE_IDX
 					  WHERE  PRC_LINE         =   ?
						AND  CHARGE_MANA_NO   =   ?) A,
		            (SELECT  CHG_SEQ  
		               FROM  TBF01_CHARGE_IDX
 					  WHERE  PRC_LINE         =   ?
						AND  CHARGE_MANA_NO   =   ?) B
       ]]>
   </query>
	
   <query id="NIF012150_ChgCntChk.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  SUM(DECODE(L2_SEND,'Y',1,0))    L2_CNT              
             	   ,SUM(DECODE(STATUS_CD,'B',1,0))  STATUS_CNT
		      FROM  TBF01_CHARGE_IDX
		     WHERE  PRC_LINE    =        ?
		       AND  CHG_SEQ     BETWEEN  ?  AND  ?
       ]]>
   </query>

   <query id="NIF012150_ChgManaSel.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  A.CAST_MANA_NO CAST_MANA_NO_ST, 
		            B.CAST_MANA_NO CAST_MANA_NO_EN
		      FROM  (SELECT  CAST_MANA_NO  
		               FROM  TBF01_SPEC_CHARGE
 					  WHERE  CHARGE_MANA_NO   =   ?) A,
		            (SELECT  CAST_MANA_NO
		               FROM  TBF01_SPEC_CHARGE
 					  WHERE  CHARGE_MANA_NO   =   ?) B
       ]]>
   </query>

   <query id="NIF012150_ChgNoLast.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  CHG_SEQ
		           ,CHARGE_MANA_NO
		      FROM  TBF01_CHARGE_IDX
		     WHERE  PRC_LINE  =   ?
		       AND  CHG_SEQ   =   (SELECT  MAX(CHG_SEQ)
		                             FROM  TBF01_CHARGE_IDX
		                            WHERE  PRC_LINE   =  ?)
       ]]>
   </query>
	
   <query id="NIF012150_ChgIdx.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  B.ORG_SEQ
		           ,B.CHARGE_EDT_SEQ
		           ,A.LINE_PROC_CD
		      FROM  TBF01_SPEC_CHARGE A
		           ,TBF01_CHARGE_IDX  B
		     WHERE  A.CHARGE_EDT_SEQ   =         B.CHARGE_EDT_SEQ
		       AND  B.STATUS_CD        =         'A'
		       AND  B.PRC_LINE         =         ?
		       AND  B.CHG_SEQ          BETWEEN   ?    AND   ?
		     ORDER  BY  B.CHG_SEQ  
       ]]>
   </query>
	
   <query id="NIF012150_ChgIdxUpd.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   =   ?
		           ,PRC_LINE             =   ?
		     WHERE  ORG_SEQ              =   ?
       ]]>
   </query>
	
   <query id="NIF012150_SpecChgUpd.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_CHARGE
		       SET  CHARGE_MANA_NO   =   ?
		           ,TREAT_RT_CD      =   (SELECT SM_CD FROM TBZ00_COMMCD WHERE LG_CD = 'F01004' AND SM_CFNM = ?)
		           ,LINE_PROC_CD     =   ?
		           ,PRC_LINE         =   ?
		     WHERE  CHARGE_EDT_SEQ   =   ?
       ]]>
   </query>
	
   <query id="NIF012150_SpecSlabUpd.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="NIF012150_ChgManaLast.select" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
		    SELECT  MAX(B.CAST_CHARGE_SEQ) CAST_CHARGE_SEQ
		      FROM  TBF01_CHARGE_IDX  A
		           ,TBF01_SPEC_CHARGE B
		     WHERE  A.L2_SEND          =   'Y'
		       AND  B.CHARGE_EDT_SEQ   =   A.CHARGE_EDT_SEQ
		       AND  B.CAST_MANA_NO     =   ?
       ]]>
   </query>
	
   <query id="NIF012150_CastManaNoSeq.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  A.CAST_MANA_NO
		           ,A.CHARGE_EDT_SEQ
              FROM  TBF01_SPEC_CHARGE A
		           ,TBF01_CHARGE_IDX  B
             WHERE  A.CAST_MANA_NO     BETWEEN   ?   AND   ?
		       AND  A.CHARGE_EDT_SEQ   =   B.CHARGE_EDT_SEQ
		       AND  B.L2_SEND          =   'N'
		     ORDER  BY  A.CAST_MANA_NO 
		               ,A.HM_STR_DTIME
       ]]>
   </query>	
	
   <query id="NIF012150_ChargeSeqNo.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_CHARGE
		       SET  CAST_CHARGE_SEQ    =   ?
             WHERE  CHARGE_EDT_SEQ     =   ?
       ]]>
   </query>			
		
</queryMap>