XinYu_RZMES/.svn/pristine/25/25ce2b101425a9a4b4dae7fa6bc47c3a4b3f9064.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS    ">
              
   <query id="NIG020610_SLAB_COMM.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
          SELECT SLAB_NO,CUR_PROG_CD,CUR_PROG_CD_PGM,CUR_PROG_CD_DTIME
                ,SLAB_STAT,SLAB_INGR_DEC_GRD,ORD_NO,ORD_SEQ,ORD_FL,CUR_LOAD_LOC
                ,CUR_LOAD_LOC_DTIME,SLAB_WGT
           FROM TBG02_SLAB_COMM
          WHERE SLAB_NO = ? 
        ]]>
    </query>
    <query id="NIG020610_SLAB_SPEC.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
          SELECT SLAB_EDT_SEQ,CHARGE_SLAB_SEQ,SLAB_MANA_NO,PRODNM_CD,STL_GRD,
                 SLAB_RT,SLAB_THK,SLAB_WTH,SLAB_LEN,SLAB_WGT,HCR_CLF,ORD_FL,
                 ORD_NO,ORD_SEQ,ORD_THK,ORD_WTH,ORD_LEN,ORD_WGT,COIL_INDIA,
                 COIL_OUTDIA,ORD_USEAGE_CD,CUST_CD,ORDCUST_CD,SPEC_ABBSYM,MILL_FL,DSN_SLAB_NO
                 
          FROM TBF01_SPEC_SLAB      
          WHERE SLAB_MANA_NO LIKE ?||'%'
             
        ]]>
    </query>    
    <query id="NIG020610_SLAB_COMM.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         UPDATE TBG02_SLAB_COMM   SET  
              SLAB_STAT                   ='2'     
             ,CUR_PROG_CD                 =?       
             ,CUR_PROG_CD_PGM             = 'XinSaveSlabComm'       
             ,CUR_PROG_CD_DTIME           = TO_CHAR(sysdate,'YYYYMMDDHH24MISS')  
             ,BEF_PROG_CD                 = ''
             ,BEF_PROG_CD_PGM             = CUR_PROG_CD_PGM
             ,BEF_PROG_CD_DTIME           = CUR_PROG_CD_DTIME 
             ,ORD_NO                      =?       
             ,ORD_SEQ                     =?       
             ,ORD_FL                      =?       
             ,STL_GRD                     =?       
             ,PRODNM_CD                   =?       
             ,CUST_CD                     =?       
             ,ORD_USE_CD                  =?       
             ,SPEC_ABBSYM                 =?        
             ,INSTR_SLAB_THK              =?       
             ,INSTR_SLAB_WTH              =?       
             ,INSTR_SLAB_LEN              =?       
             ,INSTR_SLAB_WGT              =?       
             ,HCR_CLF                     =?       
             ,ORDCUST_CD                  =?       
             ,SLAB_THK                    =?       
             ,SLAB_WTH                    =?       
             ,SLAB_LEN                    =?       
             ,SLAB_WGT                    =?       
             ,SLAB_TEMP                   =?       
             ,SLAB_CUT_DTIME              =?       
             ,LAST_SLAB_YN                =?       
             ,SURPLMATL_YN                =?       
             ,INSTR_HCR_CLF               =?       
             ,STRAND_NO                   =?  
             ,SLAB_WAY                    =? 
             ,SLAB_RT                     =? 
             ,CAL_SLAB_WGT                = round(?,0)    
             ,EXTSHAPE_GRD                ='1'  
             ,CUR_LOAD_LOC                = ?  
             ,CUR_LOAD_LOC_DTIME          = ?  
             ,SIZE_UPDT_BEF_THK           = ?  
             ,SIZE_UPDT_BEF_WTH           = ?
             ,SIZE_UPDT_BEF_LEN           = ?
             ,SIZE_UPDT_BEF_WGT           = ?      
             ,CUT_WKSHIFT                 = ?
             ,CUT_WKGROUP                 = ?
             ,PROC_CD                     = ?
             ,ORG_ORD_NO                  = ?
             ,ORG_ORD_SEQ                 = ?   
             ,NONORD_CAUSE_CD             = ? 
             ,MILL_SCH_STAT               = ?   
			 ,SLAB_SIZE_DEC_GRD           = ?
			 ,DIFF_STL_GRD_STA_END_YN     = ?
			 ,INSTR_COIL_THK			  = ?
			 ,INSTR_COIL_WTH			  = ?
            WHERE SLAB_NO          =?  
        ]]>
    </query>
    
   
    <query id="NIG020610_SLAB_COMM.insert" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
          INSERT INTO TBG02_SLAB_COMM (
                 SLAB_NO                                              
                ,PLAN_SLAB_NO                                          
                ,SLAB_STAT                                           
                ,CUR_PROG_CD                                           
                ,CUR_PROG_CD_PGM                                   
                ,CUR_PROG_CD_DTIME                                 
                ,ORD_NO                                                
                ,ORD_SEQ                                               
                ,ORD_FL                                                
                ,STL_GRD                                               
                ,PRODNM_CD                                             
                ,CUST_CD                                               
                ,ORD_USE_CD                                            
                ,SPEC_ABBSYM                                           
                ,INSTR_SLAB_THK                                        
                ,INSTR_SLAB_WTH                                        
                ,INSTR_SLAB_LEN                                        
                ,INSTR_SLAB_WGT                                         
                ,HCR_CLF                                               
                ,ORDCUST_CD                                            
                ,SLAB_THK                                              
                ,SLAB_WTH                                              
                ,SLAB_LEN                                              
                ,SLAB_WGT                                              
                ,SLAB_TEMP                                             
                ,SLAB_CUT_DTIME                                        
                ,LAST_SLAB_YN                                          
                ,SURPLMATL_YN                                          
                ,INSTR_HCR_CLF                                         
                ,STRAND_NO                                             
                ,DIFF_STL_GRD_STA_END_YN                               
                ,SLAB_WAY
                ,SLAB_RT  
                ,CAL_SLAB_WGT
                ,EXTSHAPE_GRD   
                ,CUR_LOAD_LOC     
                ,CUR_LOAD_LOC_DTIME   
                ,SIZE_UPDT_BEF_THK           
                ,SIZE_UPDT_BEF_WTH           
                ,SIZE_UPDT_BEF_LEN            
                ,SIZE_UPDT_BEF_WGT  
                ,CUT_WKSHIFT                  
                ,CUT_WKGROUP 
                ,INSTR_ORD_FL 
                ,NONORD_CAUSE_CD   
                ,PROC_CD 
                ,ORG_ORD_NO
                ,ORG_ORD_SEQ  
                ,MILL_SCH_STAT     
			    ,SLAB_SIZE_DEC_GRD  
			    ,SLAB_INGR_DEC_GRD  
			    ,SLAB_INGR_DEC_KIND                                               
            )                                                             
            VALUES                                                        
            (                                                             
                 ?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?           
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?             
                ,?  
                ,? 
                ,round(?,0)    
                ,'1' 
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
                ,?
			    ,?
			    ,?
                ,? 
            )
          
        ]]>
    </query>
     <query id="NIG020610_DIFF_STL_GRD.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         SELECT  CHARGE_NO,   STL_GRD   
          FROM 
          (
           SELECT  CHARGE_NO,STL_GRD 
             FROM TBG02_CHARGE_COMM a, 
                ( SELECT  CASTING_STA_DTIME   
                   FROM TBG02_CHARGE_COMM WHERE CHARGE_NO = ?
                ) b  
           WHERE a.CASTING_STA_DTIME < b.CASTING_STA_DTIME 
            AND  a.CASTING_STA_DTIME IS NOT NULL
            AND  a.CC_DEVNO = ? 
            AND  a.CHARGE_NO != ?
            ORDER BY a.CASTING_STA_DTIME DESC
           )  
            WHERE ROWNUM = 1 
        ]]>
    </query> 
	<query id="NIG020610_DIF_STLGRD.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
          UPDATE TBG02_SLAB_COMM   SET   
             DIFF_STL_GRD_STA_END_YN     =?       
                                            
            WHERE SLAB_NO          =?       
        ]]>
    </query> 
    <query id="NIG020610_YARD.select" desc="    " fetchSize="10">
        <![CDATA[
       SELECT  YARD_ADDR
              ,DECODE(LENGTH(YARD_LAY),1,'0'||YARD_LAY,YARD_LAY) YARD_LAY
              ,SLAB_NO 
        FROM  
        (
          SELECT SUBSTR(YARD_ADDR,1,2) YARD_ADDR,  SUBSTR(YARD_ADDR,4,1)+1 YARD_LAY, STORELAY,SLAB_NO
             FROM   TBG04_SLAB_YARD      
             WHERE YARD_ADDR LIKE ?||'%'
              AND  SLAB_NO != ?  
          ORDER BY STORELAY 
        )  
           
        ]]>
    </query>
    <query id="NIG020610_YARD_SLAB_EXIST.select" desc="    " fetchSize="10">
        <![CDATA[
        SELECT   SLAB_NO  
          FROM   TBG04_SLAB_YARD      
          WHERE  SLAB_NO  = ?   
           AND (YARD_ADDR LIKE ?||'%' OR YARD_ADDR LIKE 'A0'||'%' OR  YARD_ADDR LIKE 'C0'||'%')
        ]]>
    </query>  
    <query id="NIG020610_YARD.update" desc="    " fetchSize="10">
        <![CDATA[
          UPDATE TBG04_SLAB_YARD   SET   
              SLAB_NO     =?                
            WHERE STORELAY = '01'
             AND  YARD_ADDR     = ?     
        ]]>
    </query> 
    <query id="NIG020610_SPEC_SLAB_D.select" desc="   slab spec detail info. select  " fetchSize="10">
        <![CDATA[
          SELECT  SLAB_CUT_SEQ,SLAB_THK,SLAB_WTH,SLAB_LEN,ORD_THK,ORD_WTH,ORD_LEN,
                  COIL_INDIA,COIL_OUTDIA
             FROM   TBF01_SPEC_SLAB_D      
             WHERE SLAB_EDT_SEQ = ? 
           
        ]]>
    </query> 
    <query id="NIG020610_SLAB_COMM_D.insert" desc="  insert  slab spec detail    " fetchSize="10">
        <![CDATA[
          INSERT INTO TBG02_SLAB_COMM_D (
                 SLAB_NO                                    
                ,SLAB_CUT_SEQ                               
                ,SLAB_THK                                 
                ,SLAB_WTH                                   
                ,SLAB_LEN                                   
                ,ORD_THK                                    
                ,ORD_WTH                                    
                ,ORD_LEN                                    
                ,ORD_WGT                                    
                ,COIL_INDIA                                 
                ,COIL_OUTDIA                                
                ,ORD_NO                                   
                ,ORD_SEQ                                  
                ,ORD_FL                                                 
            )                                                             
            VALUES                                                        
            (                                                             
                 ?                 
                ,?                 
                ,?                 
                ,?                 
                ,?                 
                ,?               
                ,?                 
                ,?                 
                ,?                 
                ,?                 
                ,?                 
                ,?                 
                ,?                 
                ,?                 
           )
          
        ]]>
    </query>
    <query id="NIG020610_SPEC_CHARGE.update" desc="   " fetchSize="10">
        <![CDATA[
         UPDATE TBF01_SPEC_CHARGE  SET  
		        STATUS_CD  = ?
		      , PROG_CD    = ?  
		      , MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		      , MOD_ID    = 'CCM L2'
		  WHERE CHARGE_MANA_NO = ? 	                      
        ]]>
    </query>
    
    <query id="NIG020610_SPEC_CHARGE_IDX.update" desc="   " fetchSize="10">
        <![CDATA[
         UPDATE TBF01_CHARGE_IDX  SET  
		        STATUS_CD  = ?  
		  WHERE CHARGE_MANA_NO = ? 	                      
        ]]>
    </query>
    <query id="NIG020610_SPEC_SLAB.update" desc="   " fetchSize="10">
        <![CDATA[
         UPDATE TBF01_SPEC_SLAB  SET  
		        STATUS_CD  = ?
		      , MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		      , MOD_ID    = 'CCM L2'
		  WHERE SLAB_MANA_NO like ? || '%' 	                      
        ]]>
    </query>
	<query id="NIG020610_SPEC_SLAB_COMM.update" desc="   " fetchSize="10">
        <![CDATA[
         UPDATE TBF01_SPEC_SLAB  SET  
		        STATUS_CD  = ?
		      , MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		      , MOD_ID    = ?
		  WHERE SLAB_MANA_NO like ? || '%' 	                      
        ]]>
    </query>
    <query id="NIG020610_SPEC_SLAB_D.update" desc="   " fetchSize="10">
        <![CDATA[
         UPDATE TBF01_SPEC_SLAB_D  SET  
		        STATUS_CD  = ? 
		  WHERE SLAB_EDT_SEQ = ? 	                      
        ]]>
    </query>
     <query id="NIG020610_CHARGE_COMM.update" desc="   " fetchSize="10">
        <![CDATA[
         UPDATE TBG02_CHARGE_COMM  SET  
		        CHARGE_STAT  =?  
		       ,CUR_PROG_CD  =? 
		       ,CUR_PROG_CD_REG_PGM  =? 
		       ,CUR_PROG_CD_REG_DTIME  = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		  WHERE CHARGE_NO = ? 	                      
        ]]>
    </query>
    <query id="NIG020610_CHARGE_COMM_D.update" desc="   " fetchSize="10">
        <![CDATA[
         UPDATE TBG02_CHARGE_COMM  SET  
		        CHARGE_STAT  =?  
		       ,CUR_PROG_CD  =? 
		       ,CUR_PROG_CD_REG_PGM  =? 
		       ,CUR_PROG_CD_REG_DTIME  = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		  WHERE CHARGE_NO = ? 	                      
        ]]>
    </query>
    <query id="NIG020610_STLMAKE_PROG.update" desc="   " fetchSize="10">
        <![CDATA[
         UPDATE TBG03_STLMAKE_PROG  SET  
		        CHARGE_STAT  =?  
		  WHERE CHARGE_NO = ? 	                      
        ]]>
    </query>
    <query id="NIG020610_SLAB_WAY.update" desc="     " fetchSize="10">
        <![CDATA[
          UPDATE TBG02_SLAB_COMM   SET   
             SLAB_WAY     =?                  
            WHERE SLAB_NO          =?       
        ]]>
    </query> 
	<query id="NIG020610_SLAB_END.update" desc="     " fetchSize="10">
        <![CDATA[
          UPDATE TBG02_SLAB_COMM   SET   
             MATRL_END_CAUSE_CD    =?    
			,MATRL_END_DTIME       = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		    ,SLAB_STAT             = ?
			,ORG_ORD_NO = ORD_NO
			,ORG_ORD_SEQ = ORD_SEQ
			,ORD_FL = ''
		    ,ord_no = ''
		    ,ord_seq = ''
		    ,DSN_SLAB_NO = ''
		    ,SUB_DSN_SLAB_NO = ''	              
            WHERE SLAB_NO          =?       
        ]]>
    </query> 
	<query id="NIG020610_SLAB_END_D.update" desc="     " fetchSize="10">
        <![CDATA[
          UPDATE TBG02_SLAB_COMM_D  t
			set         t.ORD_FL = '2'      
            WHERE t.SLAB_NO          =  (select sub_slab_no from tbg02_slab_comm where slab_no = ?)       
        ]]>
    </query> 
	<query id="NIG020610_TBD01_SLABDN.update" desc="     " fetchSize="10">
        <![CDATA[
			UPDATE TBD01_SLABDN_OBJ2 SET PROC_STAT = ?
 			WHERE DSN_SLAB_NO IN
       		  (SELECT DSN_SLAB_NO FROM TBF01_SPEC_SLAB
         	  WHERE SLAB_MANA_NO LIKE SUBSTR(?, 1, 10)||'%' AND DSN_SLAB_NO IS NOT NULL)
   			AND PROC_STAT = '04'
        ]]>
    </query> 
    <query id="NIG020610_TBD01_DSN_SLABNO.update" desc="     " fetchSize="10">
        <![CDATA[
            UPDATE TBG02_SLAB_COMM T
			SET T.DSN_SLAB_NO = ''
			    ,T.SUB_DSN_SLAB_NO = ''
			WHERE T.SLAB_NO = :1  
        ]]>
    </query> 
	 <query id="NIG020610_SPEC_LAST_SLAB.select" desc="     " fetchSize="10">
        <![CDATA[
          SELECT TO_CHAR(COUNT(A.CHARGE_SLAB_SEQ)) SLAB_EDIT_NO 
		  FROM   TBF01_SPEC_SLAB A,
				 TBF01_SPEC_CHARGE B
		  WHERE  '1' = '1'
          AND    A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ
          AND    B.CHARGE_MANA_NO =  ?
        ]]>
    </query> 
	 <query id="NIG020610_REM_SLAB.select" desc="     " fetchSize="10">
        <![CDATA[
          SELECT SLAB_NO,PLAN_SLAB_NO ,B.DSN_SLAB_NO 
            FROM  TBG02_SLAB_COMM a,
                  TBF01_SPEC_SLAB b
           WHERE SUBSTR(SUB_SLAB_NO,1,10) =   SUBSTR(?,1,10)
             AND  a.PLAN_SLAB_NO = b.SLAB_MANA_NO
             AND  a.PLAN_SLAB_NO > ?
           ORDER BY SUB_SLAB_NO 
        ]]>
    </query> 
	
	 <query id="NIG020610_SLAB_COMM_D.select" desc="     " fetchSize="10">
        <![CDATA[
         
           SELECT  SUM(PROD_WGT_MIN) PROD_WGT_MIN, SUM(PROD_WGT_MAX) PROD_WGT_MAX  
             FROM  TBA01_ORD_LINE a      
                  ,TBG02_SLAB_COMM_D b
             WHERE a.ORD_SEQ = b.ORD_SEQ
               AND a.ORD_NO  = b.ORD_NO 
               AND b.SLAB_NO = ?
           
        ]]>
    </query> 
	<query id="NIG020610_SLAB_COMM_D.update" desc="     " fetchSize="10">
        <![CDATA[
            UPDATE TBG02_SLAB_COMM_D SET 
              ORD_FL = ?
              ,ORD_NO = ?
              ,ORD_SEQ = ?
              ,ORD_THK = ?
              ,ORD_WTH = ?
            WHERE SLAB_NO = (SELECT SUB_SLAB_NO FROM TBG02_SLAB_COMM WHERE SLAB_NO = ?)    
        ]]>
    </query> 
    
</queryMap>