XinYu_RZMES/.svn/pristine/cf/cfb3cfb54a9ee78ce640ed5b435aaba3c962131e.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="SMS Transaction action ">
    <query id="NIG060100_RECV_01.select" desc=" " fetchSize="10">
		<![CDATA[
		SELECT SEQ_NO,a.TC_LEN,b.TC_ID,TC_MSG 
            FROM 
           ( 
             SELECT SEQ_NO,SUBSTR(TC_MSG,1,4) TC_LEN,
              SUBSTR(TC_MSG,5,9) TC_ID,
              SUBSTR(TC_MSG,14) TC_MSG
             FROM TBG06_L2_RECV_DATA 
            WHERE MSG_FLAG = 'N' 
            ORDER BY TRANS_DTIME 
           )  a,
           (
             SELECT TC_ID ,  L2_RECV_TC_ID    
               FROM TBZ01_TCID_LEN
              WHERE TC_SEND_RECV = 'R'
                AND PROC_CD = 'S'
           ) b
           WHERE a.TC_ID = L2_RECV_TC_ID  
		]]>
	</query>
	<query id="NIG060100_RECV_DATA.update" desc=" " fetchSize="10">
		<![CDATA[
		   UPDATE TBG06_L2_RECV_DATA SET
		     MSG_FLAG = 'C'
		    WHERE SEQ_NO = ? 
			
		]]>
	</query>  
	<query id="NIG060100_RECV_DATA.insert" desc=" " fetchSize="10">
		<![CDATA[
		   INSERT INTO TBG06_L2_RECV_DATA 
				  (SEQ_NO, MSG_FLAG, TRANS_DTIME, TC_MSG ) 
		   VALUES (
				   TBG06_L2_RECV_DATA_SEQ.NEXTVAL
				   ,'N'
				   ,?
				   ,?
			       )
		]]>
	</query>  
	<query id="KR_RECEV_L2_DATA.select" desc=" " fetchSize="10">
		<![CDATA[
			select TRAN_DTIME,MSG_LEN,MSG_ID,MSG_DATA,SEQ_NO from kr_result
			where  MSG_FLAG = 'N'
			ORDER BY TRANS_DTIME 
		]]>
	</query> 
	<query id="KR_RECEV_L2_DATA.update" desc=" " fetchSize="10">
		<![CDATA[
			UPDATE kr_result SET
		     MSG_FLAG = 'C'
		    WHERE SEQ_NO = ? 
		]]>
	</query> 
	
	<query id="BOF_RECEV_L2_DATA.select" desc=" " fetchSize="10">
		<![CDATA[
			select TRAN_DTIME,MSG_LEN,MSG_ID,MSG_DATA,SEQ_NO from BOF_result
			where  MSG_FLAG = 'N'
			ORDER BY TRANS_DTIME 
		]]>
	</query> 
	<query id="BOF_RECEV_L2_DATA.update" desc=" " fetchSize="10">
		<![CDATA[
			UPDATE BOF_result SET
		     MSG_FLAG = 'C'
		    WHERE SEQ_NO = ? 
		]]>
	</query> 
	
	<query id="CAS_RECEV_L2_DATA.select" desc=" " fetchSize="10">
		<![CDATA[
			select TRAN_DTIME,MSG_LEN,MSG_ID,MSG_DATA,SEQ_NO from CAS_result
			where  MSG_FLAG = 'N'
			ORDER BY TRANS_DTIME 
		]]>
	</query> 
	<query id="CAS_RECEV_L2_DATA.update" desc=" " fetchSize="10">
		<![CDATA[
			UPDATE CAS_result SET
		     MSG_FLAG = 'C'
		    WHERE SEQ_NO = ? 
		]]>
	</query> 
	
	<query id="RH_RECEV_L2_DATA.select" desc=" " fetchSize="10">
		<![CDATA[
			select TRAN_DTIME,MSG_LEN,MSG_ID,MSG_DATA,SEQ_NO from RH_result
			where  MSG_FLAG = 'N'
			ORDER BY TRANS_DTIME 
		]]>
	</query> 
	<query id="RH_RECEV_L2_DATA.update" desc=" " fetchSize="10">
		<![CDATA[
			UPDATE RH_result SET
		     MSG_FLAG = 'C'
		    WHERE SEQ_NO = ? 
		]]>
	</query> 
	
	<query id="LF_RECEV_L2_DATA.select" desc=" " fetchSize="10">
		<![CDATA[
			select TRAN_DTIME,MSG_LEN,MSG_ID,MSG_DATA,SEQ_NO from LF_result
			where  MSG_FLAG = 'N'
			ORDER BY TRANS_DTIME 
		]]>
	</query> 
	<query id="LF_RECEV_L2_DATA.update" desc=" " fetchSize="10">
		<![CDATA[
			UPDATE LF_result SET
		     MSG_FLAG = 'C'
		    WHERE SEQ_NO = ? 
		]]>
	</query> 
	
	<query id="CCM_RECEV_L2_DATA.select" desc=" " fetchSize="10">
		<![CDATA[
			select TRAN_DTIME,MSG_LEN,MSG_ID,MSG_DATA,SEQ_NO from CCM_result
			where  MSG_FLAG = 'N'
			ORDER BY TRANS_DTIME 
		]]>
	</query> 
	<query id="CCM_RECEV_L2_DATA.select" desc=" " fetchSize="10">
		<![CDATA[
			UPDATE CCM_result SET
		     MSG_FLAG = 'C'
		    WHERE SEQ_NO = ? 
		]]>
	</query>
	<query id="NIG060100_L2_CHEM_RST.select" desc=" " fetchSize="10">
		<![CDATA[   
			SELECT SEQ_NO, PLAN_CHARGE_NO, RT_CD, TRAN_DTIME, EXAMINE_SEQ                  
				,ELE_CD_1, TO_CHAR(nvl(ELE_1, 0))  ELE_1             
				,ELE_CD_2, TO_CHAR(nvl(ELE_2, 0))  ELE_2             
				,ELE_CD_3, TO_CHAR(nvl(ELE_3, 0))  ELE_3             
				,ELE_CD_4, TO_CHAR(nvl(ELE_4, 0))  ELE_4             
				,ELE_CD_5, TO_CHAR(nvl(ELE_5, 0))  ELE_5             
				,ELE_CD_6, TO_CHAR(nvl(ELE_6, 0))  ELE_6             
				,ELE_CD_7, TO_CHAR(nvl(ELE_7, 0))  ELE_7             
				,ELE_CD_8, TO_CHAR(nvl(ELE_8, 0))  ELE_8             
				,ELE_CD_9, TO_CHAR(nvl(ELE_9, 0))  ELE_9             
				,ELE_CD_10, TO_CHAR(nvl(ELE_10,0)) ELE_10            
				,ELE_CD_11, TO_CHAR(nvl(ELE_11,0)) ELE_11            
				,ELE_CD_12, TO_CHAR(nvl(ELE_12,0)) ELE_12            
				,ELE_CD_13, TO_CHAR(nvl(ELE_13,0)) ELE_13            
				,ELE_CD_14, TO_CHAR(nvl(ELE_14,0)) ELE_14            
				,ELE_CD_15, TO_CHAR(nvl(ELE_15,0)) ELE_15            
				,ELE_CD_16, TO_CHAR(nvl(ELE_16,0)) ELE_16            
				,ELE_CD_17, TO_CHAR(nvl(ELE_17,0)) ELE_17            
				,ELE_CD_18, TO_CHAR(nvl(ELE_18,0)) ELE_18            
				,ELE_CD_19, TO_CHAR(nvl(ELE_19,0)) ELE_19            
				,ELE_CD_20, TO_CHAR(nvl(ELE_20,0)) ELE_20            
				,ELE_CD_21, TO_CHAR(nvl(ELE_21,0)) ELE_21            
				,ELE_CD_22, TO_CHAR(nvl(ELE_22,0)) ELE_22            
				,ELE_CD_23, TO_CHAR(nvl(ELE_23,0)) ELE_23            
				,ELE_CD_24, TO_CHAR(nvl(ELE_24,0)) ELE_24            
				,ELE_CD_25, TO_CHAR(nvl(ELE_25,0)) ELE_25            
				,ELE_CD_26, TO_CHAR(nvl(ELE_26,0)) ELE_26            
				,ELE_CD_27, TO_CHAR(nvl(ELE_27,0)) ELE_27            
				,ELE_CD_28, TO_CHAR(nvl(ELE_28,0)) ELE_28            
				,ELE_CD_29, TO_CHAR(nvl(ELE_29,0)) ELE_29            
				,ELE_CD_30, TO_CHAR(nvl(ELE_30,0)) ELE_30            
				,ELE_CD_31, TO_CHAR(nvl(ELE_31,0)) ELE_31            
				,ELE_CD_32, TO_CHAR(nvl(ELE_32,0)) ELE_32            
				,ELE_CD_33, TO_CHAR(nvl(ELE_33,0)) ELE_33            
				,ELE_CD_34, TO_CHAR(nvl(ELE_34,0)) ELE_34            
				,ELE_CD_35, TO_CHAR(nvl(ELE_35,0)) ELE_35            
			FROM TBG06_L2_CHEM_RESULT                                
			WHERE MSG_FLAG = 'N'                                   
			ORDER BY TRAN_DTIME
		]]>
	</query>  
     
</queryMap>