XinYu_RZMES/.svn/pristine/32/323b90d50e312433e490b96d168788de8036c162.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="SMS WORK INSTRUCTION INFORMATION DELETE">

   <query id="NIF012120_CastManaNo.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  A.CAST_MANA_NO CAST_MANA_NO_ST, A.CHG_SEQ CHG_SEQ_ST,
		            B.CAST_MANA_NO CAST_MANA_NO_EN, B.CHG_SEQ CHG_SEQ_EN,
		            C.CAST_MANA_NO CAST_MANA_NO_TG, C.CHG_SEQ CHG_SEQ_TG
		      FROM  (SELECT  A.CAST_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.CHARGE_MANA_NO   =  ?) A,
		            (SELECT  A.CAST_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.CHARGE_MANA_NO   =  ?) B,
		            (SELECT  A.CAST_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.CHARGE_MANA_NO   =  ?) C
       ]]>
   </query>

   <query id="NIF012120_ChargeCastManaNoUpd.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_CHARGE
		       SET  CAST_MANA_NO     =  ?
		     WHERE  CHARGE_EDT_SEQ   IN  (SELECT  CHARGE_EDT_SEQ
		                                    FROM  TBF01_CHARGE_IDX
		                                   WHERE  PRC_LINE  =        ?
		                                     AND  CHG_SEQ   BETWEEN  ?  AND  ?)
       ]]>
   </query>

   <query id="NIF012120_SlabCastManaNoUpd.update" desc="it's query from TBF01_SPEC_SLAB Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_SLAB
		       SET  CAST_MANA_NO     =  ?
		     WHERE  CHARGE_EDT_SEQ   IN  (SELECT  CHARGE_EDT_SEQ
		                                    FROM  TBF01_CHARGE_IDX
		                                   WHERE  PRC_LINE  =        ?
		                                     AND  CHG_SEQ   BETWEEN  ?  AND  ?)
       ]]>
    
   </query>
		              
   <query id="NIF012120_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,'A',0,1))  STATUS_CNT
		      FROM  TBF01_CHARGE_IDX
		     WHERE  PRC_LINE    =        ?
		       AND  CHG_SEQ     BETWEEN  LEAST (?, ?)  AND  GREATEST (?, ?) 
       ]]>
   </query>
	
   <query id="NIF012120_TGChgCntChk.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,'A',0,1))  STATUS_CNT
		      FROM  TBF01_CHARGE_IDX
		     WHERE  PRC_LINE    =        ?
		       AND  CHG_SEQ     >        ?
       ]]>
   </query>	

   <query id="NIF012120_ChgIdx.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  ORG_SEQ
		           ,CHG_SEQ
		      FROM  TBF01_CHARGE_IDX
		     WHERE  L2_SEND    =  'N'
		       AND  PRC_LINE   =  ?
		       AND  STATUS_CD  =  'A'
		     ORDER  BY  CHG_SEQ  
       ]]>
   </query>
	
   <query id="NIF012120_ChgSeqNoUpd.update" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">

	   <![CDATA[
			UPDATE  TBF01_CHARGE_IDX
		       SET  CHG_SEQ   =   ?
		     WHERE  ORG_SEQ   =   ?
       ]]>
    
   </query>
	
   <query id="NIF012120_ChgManaLast.select" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
		    SELECT  A.CAST_MANA_NO
		           ,A.CAST_CHARGE_SEQ
		           ,A.CHARGE_MANA_NO
		      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          =  (SELECT  MAX(CHG_SEQ)
		                                     FROM  TBF01_CHARGE_IDX
		                                    WHERE  PRC_LINE   =   ?
		                                      AND  L2_SEND    =   'Y')
       ]]>
   </query>	
		
   <query id="NIF012120_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     >=  ?
		       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="NIF012120_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>