XinYu_RZMES/.svn/pristine/6e/6ebb112383abc97bf5a83f3c986d0e889d39b3e2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="SMS WORK INSTRUCTION CCM LINE CHANGING ">
              
   <query id="NIF012160_ChargeManaNoInf.select" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
			SELECT  A.CHARGE_EDT_SEQ
		           ,A.CCM_PRC_LINE
		           ,A.LINE_PROC_CD   
		      FROM  TBF01_SPEC_CHARGE A
		     WHERE  A.CHARGE_EDT_SEQ   =   ?
		       AND  A.STATUS_CD        IN  ('A','B')
       ]]>
   </query>
 
   <query id="NIF012160_TreatRtInf.select" desc="it's query from TBZ00_COMMCD Table" fetchSize="10">
	   <![CDATA[
			SELECT  SM_CD 
		      FROM  TBZ00_COMMCD 
		     WHERE  LG_CD     =  'F01004' 
		       AND  SM_CFNM   =  ?
       ]]>
   </query>

   <query id="NIF012160_ChargeCcmLineUpd.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_CHARGE
		       SET  LINE_PROC_CD       =   ?
		           ,TREAT_RT_CD        =   ?
		           ,CCM_PRC_LINE       =   ?
		     WHERE  CHARGE_EDT_SEQ     =   ?
       ]]>
   </query>

   <query id="NIF012160_ChargeIdxCcmLineUpd.update" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_CHARGE_IDX
		       SET  CCM_PRC_LINE       =   ?
		     WHERE  CHARGE_EDT_SEQ     =   ?
       ]]>
   </query>
			
</queryMap>