XinYu_RZMES/.svn/pristine/4f/4f1fcc7d3cae37c174521adfe68869fddba546bd.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Mill Transaction action ">
    <query id="NIH060100_RECV_01.select" desc=" " fetchSize="10">
   <![CDATA[
      SELECT   TO_CHAR(SEQ_NO,'FM000000')  SEQ_NO,b.TC_ID ,TC_MSG ,TRANS_DTIME
    
      FROM  
      ( 
        SELECT   SEQ_NO,TRIM(SUBSTR(TC_MSG,5,6)) TC_ID , SUBSTR(TC_MSG,41) TC_MSG
	           , TRANS_DTIME 
          FROM TBH06_L2_RECV_DATA 
         WHERE MSG_FLAG = 'N' 
      ) a ,
      ( 
        select TC_ID,L2_RECV_TC_ID
         from TBZ01_TCID_LEN 
        WHERE PROC_CD = 'H'
          AND TC_SEND_RECV = 'R'
      ) b
      where  a.TC_ID =b.L2_RECV_TC_ID  
       AND ROWNUM = 1   
		]]>
	</query>
  
   <query id="NIH060100_RECV_DATA.update" desc=" " fetchSize="10">
    <![CDATA[
     UPDATE TBH06_L2_RECV_DATA SET
       MSG_FLAG = 'C'
    
     WHERE   SEQ_NO = ?    
        ]]>
    </query>
	
   <query id="NIH060100_L2_DATA_EDIT.select" desc=" " fetchSize="10">
    <![CDATA[
      SELECT MSG_ID,MSG_DATA,TRAN_DTIME
        
      FROM  
      ( 
         SELECT  b.TC_ID MSG_ID ,TC_MSG MSG_DATA ,TRANS_DTIME TRAN_DTIME
    
         FROM  
         ( 
           SELECT   SEQ_NO,TRIM(SUBSTR(TC_MSG,5,6)) TC_ID , SUBSTR(TC_MSG,41) TC_MSG
		           ,TRANS_DTIME
             FROM TBH06_L2_RECV_DATA 
            WHERE MSG_FLAG = 'N' 
         ) a ,
         ( 
           select TC_ID,L2_RECV_TC_ID
           from TBZ01_TCID_LEN 
         ) b
         where  a.TC_ID =b.L2_RECV_TC_ID     
      ) 
      WHERE MSG_ID = ?
    ]]>
  </query>	
	 		
</queryMap>