XinYu_RZMES/.svn/pristine/54/54e0efd92e9c062a0369abd3bf08753ea25dc001.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Status I/F TABLE Process">
              
   <query id="NIE012070_SLAB_RT_CHECK.select" desc="it's query from TBE02_ORDSTS Table" fetchSize="10">
        <![CDATA[
			SELECT  A.SLAB_RT                                 
			  FROM  TBF01_SPEC_SLAB   A
			       ,TBF01_SPEC_SLAB_D B     
			 WHERE  A.CHARGE_MANA_NO  =   :1                   
			   AND  A.SLAB_EDT_SEQ    =   B.SLAB_EDT_SEQ 
			   AND  A.ORD_FL          =   '1'
			   AND  B.ORD_FL          =   '1' 
			   AND  B.ORD_NO          IS  NOT NULL    
			GROUP BY A.SLAB_RT
        ]]>
   </query>
   <query id="NIE012070_SLAB_RT_CHECK02.select" desc="it's query from TBE02_ORDSTS Table" fetchSize="10">
        <![CDATA[
			SELECT A.SLAB_RT FROM TBG02_SLAB_COMM  A
                             ,TBG02_SLAB_COMM_D B
	      WHERE  A.SLAB_NO = :1  
	      AND    A.SUB_SLAB_NO = B.SLAB_NO
	      AND    A.ORD_FL = '1'
	      AND    B.ORD_FL = '1'
	      AND    B.ORD_NO IS NOT NULL
	      AND    B.ORD_SEQ  IS NOT NULL
	      GROUP BY A.SLAB_RT 
        ]]>
   </query> 
   <query id="NIE012070_ORDSTS.update" desc="it's query from TBE02_ORDSTS Table" fetchSize="10">
        <![CDATA[
			UPDATE  TBE02_ORDSTS 
			   SET  BEF_ORD_NO   = ?                                    
             	   ,BEF_ORD_SEQ  = ?                                    
				   ,ORD_NO       = ?                                    
				   ,ORD_SEQ      = ?                                    
				   ,BEF_PROG_CD  = ?                                    
				   ,PROG_CD      = ?                                    
				   ,MAT_TYPE     = ?                                    
				   ,MAT_NO       = ?                                    
			       ,WGT          = ?                                    
			       ,PGMID        = ?                                    
			       ,REG_DTIME    = TO_CHAR(SYSDATE,'yyyymmddhh24miss')  
			       ,REG_ID       = ?                                    
			       ,PRC_DTIME    = ''                                   
			       ,FL           = ''                                   
			       ,ERR_DESC     = ''                                   
             WHERE  OCC_SEQ      = ?
        ]]>
    </query>

    <query id="NIE012070_ORDSTS.insert" desc="it's query from TBE02_ORDSTS Table" fetchSize="10">
        <![CDATA[
          INSERT INTO TBE02_ORDSTS (
			          OCC_SEQ                                           
                     ,BEF_ORD_NO                                         
             	     ,BEF_ORD_SEQ                                       
				     ,ORD_NO                                            
				     ,ORD_SEQ                                           
				     ,BEF_PROG_CD                                       
				     ,PROG_CD                                           
				     ,MAT_TYPE                                          
				     ,MAT_NO                                            
			         ,WGT                                               
			         ,PGMID                                             
			         ,REG_DTIME                                         
			         ,REG_ID                                            
			         ,PRC_DTIME                                         
			         ,FL                                                
			         ,ERR_DESC  )                                       
              VALUES (
			          ?                                                 --OCC_SEQ
                     ,?                                                 --BEF_ORD_NO 
             	     ,?                                                 --BEF_ORD_SEQ
				     ,?                                                 --ORD_NO
				     ,?                                                 --ORD_SEQ
				     ,?                                                 --BEF_PROG_CD
				     ,?                                                 --PROG_CD
				     ,?                                                 --MAT_TYPE
				     ,?                                                 --MAT_NO
			         ,?                                                 --WGT
			         ,?                                                 --PGMID
			         ,TO_CHAR(SYSDATE,'yyyymmddhh24miss')               --REG_DTIME
			         ,?                                                 --REG_ID
			         ,''                                                --PRC_DTIME
			         ,''                                                --FL
			         ,''  )                                             --ERR_DESC
        ]]>
    </query>
	 	
</queryMap>