XinYu_RZMES/.svn/pristine/f4/f44f0c9018567755fba419d567752376d4ccddf0.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Status MAIN Process">
              
   <query id="NIE012080_ORDSTS.update" desc="it's query from TBE02_ORDSTS Table" fetchSize="10">
        <![CDATA[
			UPDATE  TBE02_ORDSTS 
			   SET  PRC_DTIME    = TO_CHAR(SYSDATE,'yyyymmddhh24miss')  
			       ,FL           = '*'                                  
			       ,ERR_DESC     = ''                                   
             WHERE  OCC_SEQ      = ?
        ]]>
    </query>

   <query id="NIE012080_ORDSTS.select" desc="it's query from TBE02_ORDSTS Table" fetchSize="10">
        <![CDATA[
			SELECT  OCC_SEQ             
			       ,BEF_ORD_NO          
			       ,BEF_ORD_SEQ         
			       ,ORD_NO              
			       ,ORD_SEQ             
			       ,BEF_PROG_CD         
			       ,PROG_CD             
			       ,MAT_TYPE            
			       ,MAT_NO              
			       ,PGMID               
			       ,REG_ID              
			  FROM  TBE02_ORDSTS        
			 WHERE  FL  IS NULL         
			 ORDER  BY  REG_DTIME   ASC 
			           ,OCC_SEQ     ASC 
		]]>
    </query>

   <query id="NIE012080_ORDPRCDET.delete" desc="it's query from TBE02_ORD_PRC_DET Table" fetchSize="10">
        <![CDATA[
			DELETE  TBE02_ORD_PRC_DET 
             WHERE  TOT_WGT   =  0
        ]]>
    </query>

		
</queryMap>