XinYu_RZMES/.svn/pristine/e7/e7e018f4bc6319ee56b4894037231a86654aa0fe.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">	
    <query id="UIG020060_CHARGE_INFO.select" desc="炉次信息查询">
        <![CDATA[
		   	SELECT 
		         A.PLAN_CHARGE_NO
		         ,A.STL_GRD
		         ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
		         ,A.CC_DEVNO
		         ,A.LD_NO
		         ,A.LT_ARRV_DTIME
		         ,A.RCPT_TAP_QTY
		         ,'' CUT_WKSHIFT
		         ,'' CUT_WKGROUP
		         ,'' CUT_EMP_ID
		      FROM TBG02_CHARGE_COMM A
		      WHERE CHARGE_NO = :1
        ]]>
    </query>
	<query id="UIG020060_01.select" desc="板坯切割实绩查询">
        <![CDATA[
		   
			
    		SELECT 
			 '' CHK  
			   ,A.PLAN_CHARGE_NO
			   ,A.STL_GRD
			   ,A.CAST_SEQ
			   ,A.CC_DEVNO
			   ,A.LD_NO
			   ,A.LT_ARRV_DTIME
			   ,A.RCPT_TAP_QTY
			   ,B.CUT_WKSHIFT
			   ,B.PLAN_SLAB_NO
			   ,B.CUT_WKGROUP
			   ,B.SLAB_NO_SEQ SLAB_NO 
			   ,B.SLAB_THK
			   ,B.SLAB_WTH
			   ,B.SLAB_LEN
			   ,B.SLAB_WGT
			   ,B.SLAB_TEMP
			   ,B.HCR_CLF
			   ,B.SLAB_RT
			   ,B.SLAB_CUT_DTIME
			   ,B.ORD_FL
			   ,B.LAST_SLAB_YN
			   ,B.DIFF_STL_GRD_STA_END_YN
			   ,SLAB_STAT          
			   ,CUT_EMP_ID   
			   ,SURPLMATL_YN
			 ,STRAND_NO
			 ,SLAB_INGR_DEC_GRD
			 ,SLAB_SIZE_DEC_GRD
		  --   ,DIFF_STL_GRD_STA_END_YN
			FROM 
			(
			 SELECT
				CHARGE_NO
			   ,PLAN_CHARGE_NO
			   ,STL_GRD
			   ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
			   ,CC_DEVNO
			   ,LD_NO
			   ,LT_ARRV_DTIME
			   ,RCPT_TAP_QTY 
				
			 FROM TBG02_CHARGE_COMM
			 WHERE CHARGE_NO = ?
			) A ,
			(
			 SELECT
				  CUT_WKSHIFT 
				 ,SLAB_NO
				 ,PLAN_SLAB_NO
				 ,CUT_WKGROUP
				 ,SUBSTR(SLAB_NO,11,12) SLAB_NO_SEQ 
				 ,DECODE(SLAB_THK,NULL,INSTR_SLAB_THK,SLAB_THK) SLAB_THK
				 ,DECODE(SLAB_WTH,NULL,INSTR_SLAB_WTH,SLAB_WTH) SLAB_WTH
				 ,DECODE(SLAB_LEN,NULL,INSTR_SLAB_LEN,SLAB_LEN) SLAB_LEN 
				 ,DECODE(SLAB_WGT,NULL,INSTR_SLAB_WGT,SLAB_WGT) SLAB_WGT
				 ,SLAB_TEMP
				 ,HCR_CLF
				 ,SLAB_RT
				 ,SLAB_CUT_DTIME
				 ,ORD_FL
				 ,LAST_SLAB_YN
			   --  ,DIFF_STL_GRD_STA_END_YN
				 ,SLAB_STAT         
				 ,CUT_EMP_ID  
				 ,SURPLMATL_YN
			   ,STRAND_NO  
			 ,DECODE(DIFF_STL_GRD_STA_END_YN,'2','Y','N') DIFF_STL_GRD_STA_END_YN
			 ,SLAB_INGR_DEC_GRD
			 ,SLAB_SIZE_DEC_GRD
			 FROM TBG02_SLAB_COMM
			 WHERE  SLAB_NO LIKE ?||'%' 
			) B
			WHERE B.SLAB_NO(+)  LIKE A.CHARGE_NO||'%'
			ORDER BY PLAN_SLAB_NO ASC
        ]]>
    </query>
    
    <query id="UIG020060_SLAB1.select" desc="板坯切割实绩查询">
        <![CDATA[
		   SELECT B.SLAB_NO,
			       b.CUT_WKSHIFT,
			       b.PLAN_SLAB_NO,
			       b.CUT_WKGROUP,
			       b.SLAB_NO_SEQ SLAB_NO,
			       b.SLAB_THK,
			       b.SLAB_WTH,
			       b.SLAB_LEN,
			       b.SLAB_WGT,
			       b.SLAB_TEMP,
			       b.HCR_CLF,
			       b.SLAB_RT,
			       b.SLAB_CUT_DTIME,
			       b.ORD_FL,
			       b.LAST_SLAB_YN,
			       b.DIFF_STL_GRD_STA_END_YN,
			       SLAB_STAT,
			       CUT_EMP_ID,
			       SURPLMATL_YN,
			       STRAND_NO
			       --  ,DIFF_STL_GRD_STA_END_YN
			      ,TW_SLAB_YN
			  FROM (SELECT CUT_WKSHIFT,
			               SLAB_NO,
			               PLAN_SLAB_NO,
			               SUB_SLAB_NO,
			               CUT_WKGROUP,
			               SUBSTR(SLAB_NO, 11, 12) SLAB_NO_SEQ,
			               DECODE(SLAB_THK, NULL, INSTR_SLAB_THK, SLAB_THK) SLAB_THK,
			               DECODE(SLAB_WTH, NULL, INSTR_SLAB_WTH, SLAB_WTH) SLAB_WTH,
			               DECODE(SLAB_LEN, NULL, INSTR_SLAB_LEN, SLAB_LEN) SLAB_LEN,
			               DECODE(SLAB_WGT, NULL, INSTR_SLAB_WGT, SLAB_WGT) SLAB_WGT,
			               SLAB_TEMP,
			               HCR_CLF,
			               SLAB_RT,
			               SLAB_CUT_DTIME,
			               ORD_FL,
			               LAST_SLAB_YN,
			               DIFF_STL_GRD_STA_END_YN,
			               SLAB_STAT,
			               CUT_EMP_ID,
			               SURPLMATL_YN,
			               STRAND_NO
			               --  ,DIFF_STL_GRD_STA_END_YN
			              ,
			               TW_SLAB_YN
			          FROM tbg02_slab_comm
			         WHERE STRAND_NO = '1'
			           AND SUB_SLAB_NO like :1|| '%'
			           AND slab_stat <> '1') b
			 ORDER BY B.SLAB_NO
		   
        ]]>
    </query>
    
    <query id="UIG020060_SLAB1.select_BAK" desc="板坯切割实绩查询">
        <![CDATA[
		   
       SELECT 
        a.PLAN_CHARGE_NO
       ,B.SLAB_NO
       ,a.STL_GRD
       ,a.CAST_SEQ
       ,a.CC_DEVNO
       ,a.LD_NO
       ,a.LT_ARRV_DTIME
       ,a.RCPT_TAP_QTY
       ,b.CUT_WKSHIFT
       ,b.PLAN_SLAB_NO
       ,b.CUT_WKGROUP
       ,b.SLAB_NO_SEQ SLAB_NO 
       ,b.SLAB_THK
       ,b.SLAB_WTH
       ,b.SLAB_LEN
       ,b.SLAB_WGT
       ,b.SLAB_TEMP
       ,b.HCR_CLF
       ,b.SLAB_RT
       ,b.SLAB_CUT_DTIME
       ,b.ORD_FL
       ,b.LAST_SLAB_YN
       ,b.DIFF_STL_GRD_STA_END_YN
       ,SLAB_STAT          
       ,CUT_EMP_ID   
       ,SURPLMATL_YN
	   ,STRAND_NO
	 --  ,DIFF_STL_GRD_STA_END_YN
	   ,TW_SLAB_YN		
    FROM 
    (
     SELECT
        CHARGE_NO
       ,PLAN_CHARGE_NO
       ,STL_GRD
       ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
       ,CC_DEVNO
       ,LD_NO
       ,LT_ARRV_DTIME
       ,RCPT_TAP_QTY 
        
     FROM TBG02_CHARGE_COMM
     where CHARGE_NO = ?
    ) a ,
    (
     SELECT
          CUT_WKSHIFT 
         ,SLAB_NO
         ,PLAN_SLAB_NO
         ,SUB_SLAB_NO
         ,CUT_WKGROUP
         ,SUBSTR(SLAB_NO,11,12) SLAB_NO_SEQ 
         ,DECODE(SLAB_THK,NULL,INSTR_SLAB_THK,SLAB_THK) SLAB_THK
         ,DECODE(SLAB_WTH,NULL,INSTR_SLAB_WTH,SLAB_WTH) SLAB_WTH
         ,DECODE(SLAB_LEN,NULL,INSTR_SLAB_LEN,SLAB_LEN) SLAB_LEN 
         ,DECODE(SLAB_WGT,NULL,INSTR_SLAB_WGT,SLAB_WGT) SLAB_WGT
         ,SLAB_TEMP
         ,HCR_CLF
         ,SLAB_RT
         ,SLAB_CUT_DTIME
         ,ORD_FL
         ,LAST_SLAB_YN
         ,DIFF_STL_GRD_STA_END_YN
         ,SLAB_STAT         
         ,CUT_EMP_ID  
         ,SURPLMATL_YN
	     ,STRAND_NO  
	--	 ,DIFF_STL_GRD_STA_END_YN
		 ,TW_SLAB_YN	
     FROM tbg02_slab_comm
     WHERE  STRAND_NO = '1'
       AND  SUB_SLAB_NO like ?||'%' 
	   AND  slab_stat <> '1'
    ) b
    WHERE b.SUB_SLAB_NO(+)  like a.CHARGE_NO||'%'
    ORDER BY B.SLAB_NO
    
        ]]>
    </query>
    
    <query id="UIG020060_SLAB2.select" desc="板坯切割实绩查询">
        <![CDATA[
		   SELECT B.SLAB_NO,
			       b.CUT_WKSHIFT,
			       b.PLAN_SLAB_NO,
			       b.CUT_WKGROUP,
			       b.SLAB_NO_SEQ SLAB_NO,
			       b.SLAB_THK,
			       b.SLAB_WTH,
			       b.SLAB_LEN,
			       b.SLAB_WGT,
			       b.SLAB_TEMP,
			       b.HCR_CLF,
			       b.SLAB_RT,
			       b.SLAB_CUT_DTIME,
			       b.ORD_FL,
			       b.LAST_SLAB_YN,
			       b.DIFF_STL_GRD_STA_END_YN,
			       SLAB_STAT,
			       CUT_EMP_ID,
			       SURPLMATL_YN,
			       STRAND_NO
			       --   ,DIFF_STL_GRD_STA_END_YN
			      ,TW_SLAB_YN
			  FROM (SELECT CUT_WKSHIFT,
			               SLAB_NO,
			               PLAN_SLAB_NO,
			               SUB_SLAB_NO,
			               CUT_WKGROUP,
			               SUBSTR(SLAB_NO, 11, 12) SLAB_NO_SEQ,
			               DECODE(SLAB_THK, NULL, INSTR_SLAB_THK, SLAB_THK) SLAB_THK,
			               DECODE(SLAB_WTH, NULL, INSTR_SLAB_WTH, SLAB_WTH) SLAB_WTH,
			               DECODE(SLAB_LEN, NULL, INSTR_SLAB_LEN, SLAB_LEN) SLAB_LEN,
			               DECODE(SLAB_WGT, NULL, INSTR_SLAB_WGT, SLAB_WGT) SLAB_WGT,
			               SLAB_TEMP,
			               HCR_CLF,
			               SLAB_RT,
			               SLAB_CUT_DTIME,
			               ORD_FL,
			               LAST_SLAB_YN
			               --  ,DIFF_STL_GRD_STA_END_YN
			              ,SLAB_STAT,
			               CUT_EMP_ID,
			               SURPLMATL_YN,
			               STRAND_NO,
			               DIFF_STL_GRD_STA_END_YN,
			               TW_SLAB_YN
			          FROM tbg02_slab_comm
			         WHERE STRAND_NO = '2'
			           AND SUB_SLAB_NO like :1|| '%'
			           AND slab_stat <> '1') b
			 ORDER BY B.SLAB_NO
					   
        ]]>
    </query>
    
    <query id="UIG020060_SLAB2.select_BAK" desc="板坯切割实绩查询">
        <![CDATA[
		   
       SELECT 
        a.PLAN_CHARGE_NO
       ,B.SLAB_NO
       ,a.STL_GRD
       ,a.CAST_SEQ
       ,a.CC_DEVNO
       ,a.LD_NO
       ,a.LT_ARRV_DTIME
       ,a.RCPT_TAP_QTY
       ,b.CUT_WKSHIFT
       ,b.PLAN_SLAB_NO
       ,b.CUT_WKGROUP
       ,b.SLAB_NO_SEQ SLAB_NO 
       ,b.SLAB_THK
       ,b.SLAB_WTH
       ,b.SLAB_LEN
       ,b.SLAB_WGT
       ,b.SLAB_TEMP
       ,b.HCR_CLF
       ,b.SLAB_RT
       ,b.SLAB_CUT_DTIME
       ,b.ORD_FL
       ,b.LAST_SLAB_YN
       ,b.DIFF_STL_GRD_STA_END_YN
       ,SLAB_STAT          
       ,CUT_EMP_ID   
       ,SURPLMATL_YN
	   ,STRAND_NO
	--   ,DIFF_STL_GRD_STA_END_YN
	   ,TW_SLAB_YN	
    FROM 
    (
     SELECT
        CHARGE_NO
       ,PLAN_CHARGE_NO
       ,STL_GRD
       ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
       ,CC_DEVNO
       ,LD_NO
       ,LT_ARRV_DTIME
       ,RCPT_TAP_QTY 
        
     FROM TBG02_CHARGE_COMM
     where CHARGE_NO = ?
    ) a ,
    (
     SELECT
          CUT_WKSHIFT 
         ,SLAB_NO
         ,PLAN_SLAB_NO
         ,SUB_SLAB_NO
         ,CUT_WKGROUP
         ,SUBSTR(SLAB_NO,11,12) SLAB_NO_SEQ 
         ,DECODE(SLAB_THK,NULL,INSTR_SLAB_THK,SLAB_THK) SLAB_THK
         ,DECODE(SLAB_WTH,NULL,INSTR_SLAB_WTH,SLAB_WTH) SLAB_WTH
         ,DECODE(SLAB_LEN,NULL,INSTR_SLAB_LEN,SLAB_LEN) SLAB_LEN 
         ,DECODE(SLAB_WGT,NULL,INSTR_SLAB_WGT,SLAB_WGT) SLAB_WGT
         ,SLAB_TEMP
         ,HCR_CLF
         ,SLAB_RT
         ,SLAB_CUT_DTIME
         ,ORD_FL
         ,LAST_SLAB_YN
       --  ,DIFF_STL_GRD_STA_END_YN
         ,SLAB_STAT         
         ,CUT_EMP_ID  
         ,SURPLMATL_YN  
		 ,STRAND_NO
		 ,DIFF_STL_GRD_STA_END_YN
		 ,TW_SLAB_YN	
     FROM tbg02_slab_comm
     WHERE  STRAND_NO = '2'
       AND  SUB_SLAB_NO like ?||'%' 
	   AND  slab_stat <> '1'
    ) b
    WHERE b.SUB_SLAB_NO(+)  like a.CHARGE_NO||'%'
    ORDER BY B.SLAB_NO
    
        ]]>
    </query>
    
	<query id="UIG020060_SLAB0.select" desc="板坯切割实绩查询">
        <![CDATA[
		SELECT '' CHK
       
			      ,
			       B.CUT_WKSHIFT,
			       B.PLAN_SLAB_NO,
			       B.CUT_WKGROUP,
			       B.SLAB_NO_SEQ SLAB_NO,
			       B.SLAB_NO_SEQ2 SUB_SLAB_NO,
			       B.SLAB_THK,
			       B.SLAB_WTH,
			       B.SLAB_LEN,
			       B.SLAB_WGT,
			       B.SLAB_TEMP,
			       B.HCR_CLF,
			       B.SLAB_RT,
			       B.SLAB_CUT_DTIME,
			       B.ORD_FL,
			       B.LAST_SLAB_YN,
			       B.DIFF_STL_GRD_STA_END_YN,
			       SLAB_STAT,
			       CUT_EMP_ID,
			       SURPLMATL_YN,
			       decode(STRAND_NO, 1, 'Y', 'N') STRAND_NO1,
			       decode(STRAND_NO, 2, 'Y', 'N') STRAND_NO2,
			       TW_SLAB_YN
			       --   ,DIFF_STL_GRD_STA_END_YN
			      ,
			       SLAB_INGR_DEC_GRD,
			       SLAB_SIZE_DEC_GRD,
			       C.MILL_FL,
			       C.ORD_NO || '-' || C.ORD_SEQ INS_ORD_NO,
			       C.SLAB_THK || '*' || C.SLAB_WTH || '*' || C.SLAB_LEN INS_SLAB_SIZE
			  FROM (SELECT CUT_WKSHIFT,
			               SLAB_NO,
			               SUB_SLAB_NO,
			               PLAN_SLAB_NO,
			               CUT_WKGROUP,
			               SUBSTR(SLAB_NO, 11, 12) SLAB_NO_SEQ,
			               SUBSTR(SUB_SLAB_NO, 11, 12) SLAB_NO_SEQ2,
			               DECODE(SLAB_THK, NULL, INSTR_SLAB_THK, SLAB_THK) SLAB_THK,
			               DECODE(SLAB_WTH, NULL, INSTR_SLAB_WTH, SLAB_WTH) SLAB_WTH,
			               DECODE(SLAB_LEN, NULL, INSTR_SLAB_LEN, SLAB_LEN) SLAB_LEN,
			               DECODE(SLAB_WGT, NULL, INSTR_SLAB_WGT, SLAB_WGT) SLAB_WGT,
			               SLAB_TEMP,
			               HCR_CLF,
			               SLAB_RT,
			               SLAB_CUT_DTIME,
			               ORD_FL,
			               LAST_SLAB_YN,
			               TW_SLAB_YN
			               --  ,DIFF_STL_GRD_STA_END_YN
			              ,
			               SLAB_STAT,
			               CUT_EMP_ID,
			               SURPLMATL_YN,
			               STRAND_NO,
			               DECODE(DIFF_STL_GRD_STA_END_YN, '2', 'Y', 'N') DIFF_STL_GRD_STA_END_YN,
			               SLAB_INGR_DEC_GRD,
			               SLAB_SIZE_DEC_GRD
			          FROM TBG02_SLAB_COMM
			         WHERE SUB_SLAB_NO LIKE :1|| '%') B,
			       TBF01_SPEC_SLAB C
			 WHERE '1' = '1'
			   AND B.PLAN_SLAB_NO = C.SLAB_MANA_NO
			 ORDER BY SUB_SLAB_NO

        ]]>
    </query>
    <query id="UIG020060_SLAB0.select_BAK" desc="板坯切割实绩查询">
        <![CDATA[
		SELECT 
	     '' CHK  
	       ,A.PLAN_CHARGE_NO
	       ,A.STL_GRD
	       ,A.CAST_SEQ
	       ,A.CC_DEVNO
	       ,A.LD_NO
	       ,A.LT_ARRV_DTIME
	       ,A.RCPT_TAP_QTY
	       ,B.CUT_WKSHIFT
	       ,B.PLAN_SLAB_NO
	       ,B.CUT_WKGROUP
	       ,B.SLAB_NO_SEQ SLAB_NO
	       ,B.SLAB_NO_SEQ2 SUB_SLAB_NO
	       ,B.SLAB_THK
	       ,B.SLAB_WTH
	       ,B.SLAB_LEN
	       ,B.SLAB_WGT
	       ,B.SLAB_TEMP
	       ,B.HCR_CLF
	       ,B.SLAB_RT
	       ,B.SLAB_CUT_DTIME
	       ,B.ORD_FL
	       ,B.LAST_SLAB_YN
	       ,B.DIFF_STL_GRD_STA_END_YN
	       ,SLAB_STAT          
	       ,CUT_EMP_ID   
	       ,SURPLMATL_YN
	     ,decode(STRAND_NO,1,'Y','N') STRAND_NO1
         ,decode(STRAND_NO,2,'Y','N') STRAND_NO2
	     ,TW_SLAB_YN    
	  --   ,DIFF_STL_GRD_STA_END_YN
	     ,SLAB_INGR_DEC_GRD
	     ,SLAB_SIZE_DEC_GRD
	     ,C.MILL_FL   
	     ,C.ORD_NO||'-'||C.ORD_SEQ INS_ORD_NO
	     ,C.SLAB_THK||'*'||C.SLAB_WTH||'*'||C.SLAB_LEN INS_SLAB_SIZE   
	    FROM 
	    (
	     SELECT
	        CHARGE_NO
	       ,PLAN_CHARGE_NO
	       ,STL_GRD
	       ,CAST_EDT_CHARGE_CNT || '-' ||CAST_CHARGE_SEQ CAST_SEQ
	       ,CC_DEVNO
	       ,LD_NO
	       ,LT_ARRV_DTIME
	       ,RCPT_TAP_QTY 
	        
	     FROM TBG02_CHARGE_COMM
	     WHERE CHARGE_NO = ?
	    ) A ,
	    (
	     SELECT
	          CUT_WKSHIFT 
	         ,SLAB_NO
	         ,SUB_SLAB_NO
	         ,PLAN_SLAB_NO
	         ,CUT_WKGROUP
	         ,SUBSTR(SLAB_NO,11,12) SLAB_NO_SEQ 
	         ,SUBSTR(SUB_SLAB_NO,11,12) SLAB_NO_SEQ2
	         ,DECODE(SLAB_THK,NULL,INSTR_SLAB_THK,SLAB_THK) SLAB_THK
	         ,DECODE(SLAB_WTH,NULL,INSTR_SLAB_WTH,SLAB_WTH) SLAB_WTH
	         ,DECODE(SLAB_LEN,NULL,INSTR_SLAB_LEN,SLAB_LEN) SLAB_LEN 
	         ,DECODE(SLAB_WGT,NULL,INSTR_SLAB_WGT,SLAB_WGT) SLAB_WGT
	         ,SLAB_TEMP
	         ,HCR_CLF
	         ,SLAB_RT
	         ,SLAB_CUT_DTIME
	         ,ORD_FL
	         ,LAST_SLAB_YN
	     ,TW_SLAB_YN  
	       --  ,DIFF_STL_GRD_STA_END_YN
	         ,SLAB_STAT         
	         ,CUT_EMP_ID  
	         ,SURPLMATL_YN
	       ,STRAND_NO  
	     ,DECODE(DIFF_STL_GRD_STA_END_YN,'2','Y','N') DIFF_STL_GRD_STA_END_YN
	     ,SLAB_INGR_DEC_GRD
	     ,SLAB_SIZE_DEC_GRD  
	     FROM TBG02_SLAB_COMM
	     WHERE  SUB_SLAB_NO LIKE ?||'%' 
	    ) B,
	  TBF01_SPEC_SLAB C    
	    WHERE B.SUB_SLAB_NO(+)  LIKE A.CHARGE_NO||'%'
	    AND   B.PLAN_SLAB_NO = C.SLAB_MANA_NO
	  ORDER BY   SUB_SLAB_NO
        ]]>
    </query>
	
    <query id="UIG020060_02.select" desc="板坯切割实绩查询">
        <![CDATA[
		   
     SELECT PLAN_CHARGE_NO,STL_GRD
     FROM   TBG02_CHARGE_COMM 
     WHERE CHARGE_NO = ? 
    
        ]]>
    </query>
    <query id="UIG020060_01.update" desc="This step query is update query   to TBG03_STLMAKE_PROG     ">
        <![CDATA[
		   update TBG02_SLAB_COMM set(
              	 SLAB_STAT
	             ,STL_GRD
	             ,CUR_PROG_CD
	             ,CUR_PROG_CD_PGM
	             ,CUR_PROG_CD_DTIME
	             ,BEF_PROG_CD
	             ,BEF_PROG_CD_PGM
	             ,BEF_PROG_CD_DTIME
	             ,ORD_NO
	             ,ORD_SEQ
	             ,ORD_FL
	             ,PRODNM_CD
	             ,INSTR_SLAB_THK
	             ,INSTR_SLAB_WTH
	             ,INSTR_SLAB_LEN
	             ,INSTR_SLAB_WGT
	             ,INSTR_COIL_THK
	             ,INSTR_COIL_WTH
	             ,SLAB_THK
	             ,SLAB_WTH
	             ,SLAB_LEN
	             ,SLAB_WGT
	             ,HCR_CLF
	             ,SLAB_WAY
	             ,SLAB_RT
	             ,LAST_SLAB_YN
	             ,SLAB_CUT_DTIME
	             ,CUT_WKSHIFT
	             ,CUT_WKGROUP
	             ,CUT_EMP_ID
	             ,CUST_CD
	             ,ORD_USE_CD
	             ,SPEC_ABBSYM
	             ,ORDCUST_CD
	             ,SIZE_UPDT_BEF_THK
	             ,SIZE_UPDT_BEF_WTH
	             ,SIZE_UPDT_BEF_LEN
	             ,SIZE_UPDT_BEF_WGT
	             ,SURPLMATL_YN
	             ,ORG_ORD_NO
	             ,ORG_ORD_SEQ
	             ,CUR_LOAD_LOC
	             ,MILL_SCH_STAT
	             ,SLAB_SIZE_DEC_GRD
	             ,DIFF_STL_GRD_STA_END_YN
	             ,CAST_NO
	             ,CUR_LOAD_LOC_DTIME
	             ,PROC_CD
	             ,STRAND_NO
	             ,EXTSHAPE_GRD
	             ,NONORD_CAUSE_CD
	             ,NONORD_OCR_DTIME
	             ,MATRL_END_DTIME
	             ,MATRL_END_CAUSE_CD
	             ,TW_SLAB_YN
	             ,DSN_SLAB_NO
	             )=(SELECT '2' SLAB_STAT
	                       ,a.STL_GRD
	                       ,? CUR_PROG_CD
	                       ,? CUR_PROG_CD_PGM
	                       ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD') CUR_PROG_CD_DTIME
	                       ,A.CUR_PROG_CD BEF_PROG_CD
	                       ,DECODE(A.CUR_PROG_CD_PGM,'',?,A.CUR_PROG_CD_PGM)BEF_PROG_CD_PGM
	                       ,A.CUR_PROG_CD_DTIME BEF_PROG_CD_DTIME
	                       ,? ORD_NO      
	                       ,? ORD_SEQ
	                       
	                       ,? ORD_FL
	                       ,a.PRODNM_CD
	                       ,B.SLAB_THK INSTR_SLAB_THK
	                       ,B.SLAB_WTH INSTR_SLAB_WTH
	                       ,B.SLAB_LEN INSTR_SLAB_LEN
	                       ,B.SLAB_WGT INSTR_SLAB_WGT
	                       ,B.ORD_THK  INSTR_COIL_THK
	                       ,B.ORD_WTH  INSTR_COIL_WTH
	                       ,? SLAB_THK
	                       ,? SLAB_WTH
	                       ,? SLAB_LEN
	                       ,? SLAB_WGT
	                       
	                       ,? HCR_CLF
	                       ,? SLAB_WAY
	                       ,? SLAB_RT
	                       ,? LAST_SLAB_YN
	                       ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD') SLAB_CUT_DTIME
	                       ,? CUT_WKSHIFT
	                       
	                       ,? CUT_WKGROUP
	                       ,? CUT_EMP_ID
	                       ,B.CUST_CD CUST_CD                       --
	                       ,B.ORD_USEAGE_CD ORD_USE_CD              --
	                       ,B.SPEC_ABBSYM SPEC_ABBSYM               --
	                       ,B.ORDCUST_CD ORDCUST_CD                  --
	                       ,A.SLAB_THK SIZE_UPDT_BEF_THK
	                       ,A.SLAB_WTH SIZE_UPDT_BEF_WTH
	                       ,A.SLAB_LEN SIZE_UPDT_BEF_LEN
	                       ,A.SLAB_WGT SIZE_UPDT_BEF_WGT
	                       ,? SURPLMATL_YN
	                       ,A.ORD_NO ORG_ORD_NO
	                       ,A.ORD_SEQ ORG_ORD_SEQ
	                       ,? CUR_LOAD_LOC
	                       ,'' MILL_SCH_STAT
	                       ,? SLAB_SIZE_DEC_GRD
	                       
	                       ,? DIFF_STL_GRD_STA_END_YN
	                       ,B.CAST_MANA_NO CAST_NO                    --
	                       ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') CUR_LOAD_LOC_DTIME
	                       ,? PROC_CD
	                       ,? STRAND_NO
	                       ,'1' EXTSHAPE_GRD
	                       ,? NONORD_CAUSE_CD
	                       ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') NONORD_OCR_DTIME
	                       ,'' MATRL_END_DTIME
	                       ,'' MATRL_END_CAUSE_CD
	                       ,? TW_SLAB_YN
	                       ,'' DSN_SLAB_NO
	                FROM TBG02_SLAB_COMM A
	                     ,TBF01_SPEC_SLAB B
	                WHERE '1' = '1'
	                AND   A.PLAN_SLAB_NO = B.SLAB_MANA_NO
	                AND   A.SLAB_NO = ?)
	      WHERE SLAB_NO = ?
        ]]>
  </query> 
  
  <query id="UIG020060_01.insert" desc="This step query is update query   to TBG03_STLMAKE_PROG     ">
        <![CDATA[
   insert into  TBG02_SLAB_COMM
  (  SLAB_NO                           
    ,PLAN_SLAB_NO                      
    ,SLAB_STAT                         
    ,STL_GRD                           
    ,CUR_PROG_CD                       
    ,CUR_PROG_CD_PGM               
    ,CUR_PROG_CD_DTIME             
    ,BEF_PROG_CD                       
    ,BEF_PROG_CD_PGM               
    ,BEF_PROG_CD_DTIME             
    ,ORD_NO                            
    ,ORD_SEQ                           
    ,ORD_FL                                  
    ,PRODNM_CD                         
    ,INSTR_SLAB_THK                    
    ,INSTR_SLAB_WTH                    
    ,INSTR_SLAB_LEN                    
    ,INSTR_SLAB_WGT                    
    ,SLAB_THK                          
    ,SLAB_WTH                          
    ,SLAB_LEN                          
    ,SLAB_WGT                           
    ,HCR_CLF                           
    ,SLAB_WAY                          
    ,SLAB_RT                           
    ,LAST_SLAB_YN                    
    ,SLAB_CUT_DTIME                                                        
    ,DIFF_STL_GRD_STA_END_YN        
    ,CUT_WKSHIFT           
    ,CUT_WKGROUP           
    ,CUT_EMP_ID      
    ,CUST_CD               
    ,ORD_USE_CD             
    ,SPEC_ABBSYM            
    ,ORDCUST_CD  
    ,SIZE_UPDT_BEF_THK       
    ,SIZE_UPDT_BEF_WTH      
    ,SIZE_UPDT_BEF_LEN     
    ,SIZE_UPDT_BEF_WGT 
    ,SURPLMATL_YN 
    ,CUR_LOAD_LOC
    ,CUR_LOAD_LOC_DTIME     
    ,MILL_SCH_STAT 
    ,SLAB_SIZE_DEC_GRD  
    ,CAST_NO
    ,EXTSHAPE_GRD   
    ,PROC_CD
    ,STRAND_NO  
    ,NONORD_CAUSE_CD   
	,NONORD_OCR_DTIME		
	,ORG_ORD_NO     
	,ORG_ORD_SEQ    
	,SLAB_INGR_DEC_GRD 
	,SLAB_INGR_DEC_KIND 
	,TW_SLAB_YN		
  )    
  values
  (
    
      ?                                            
     ,?                                            
     ,'2'                                          
     ,?                                            
     ,?                                            
     ,?                                                                                 
     ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')          
     ,''                                        
     ,?                                            
     ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')          
     ,?                                            
     ,?                                            
     ,?                                            
     ,?                                                                                 
     ,?                                            
     ,?                                             
     ,?                                                                                 
     ,?                                            
     ,?                                            
     ,?                                            
     ,?                                            
     ,?                                            
     ,?                                            
     ,?                                            
     ,?                                            
     ,?                                            
     ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')          
     ,? 
     ,?
     ,?
     ,? 
     ,? 
     ,?
     ,?
     ,? 
     ,? 
     ,?
     ,?
     ,?  
     ,? 
     ,?
     ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')       
     ,?
     ,?
     ,? 
     ,'1'
     ,? 
     ,? 
     ,?  
	 ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')		
	 ,? 
     ,? 
	 ,? 
     ,?
     ,?        
    )                                                 
        ]]>
  </query> 
  <query id="UIG020060_03.select" desc="it's selected query  from TBF01_SPEC_SLAB table   " fetchSize="10">
        <![CDATA[
      select 
        SLAB_EDT_SEQ
	   ,STATUS_CD	 
       ,STL_GRD
       ,ORD_NO    
       ,ORD_SEQ     
       ,PRODNM_CD
       ,CUST_CD
       ,ORD_USEAGE_CD
       ,SPEC_ABBSYM
       ,ORDCUST_CD
       ,SLAB_THK 
       ,SLAB_WTH  
       ,SLAB_LEN 
	   ,SLAB_WGT
	   ,HCR_CLF
	   ,SLAB_RT 
	   ,ORD_FL
	   ,SCARPING_PROC_YN    
	   ,CAST_MANA_NO
	   ,MILL_FL 
	   ,DSN_SLAB_NO
	   ,ORD_THK
	   ,ORD_WTH
      from  TBF01_SPEC_SLAB 
      where  SLAB_MANA_NO=?
        ]]>
    </query> 
	<query id="UIG020060_EMP.select" desc="查询板坯切割作业人信息，这里PROC_CD为JJS " fetchSize="10">
		<![CDATA[
		SELECT  EMP_NM  label  
                ,EMP_NM  value  
         FROM   TBZ01_FAC_EMP_GROUP   
         WHERE  GROUP_CD = ? 
          AND   PROC_CD  = 'JS' 
          AND   FAC_CD = 'J'
		]]>
	</query> 
	<query id="UIG020060_CH_COM.update" desc="  " fetchSize="10">
		<![CDATA[
		   UPDATE TBG02_CHARGE_COMM SET
		     CC_DEVNO = ?
		    ,CCM_PRC_LINE = ? 
		    WHERE CHARGE_NO = ?  
		]]>
	</query> 
	<query id="UIG020060_slab_comm_d.update" desc="  " fetchSize="10">
		<![CDATA[
			UPDATE TBG02_SLAB_COMM_D 
			SET     SLAB_THK = ?
					,SLAB_WTH = ?
					,SLAB_LEN = ?
					,ORD_LEN  = ?
					,ORD_WGT = decode('Y','Y',ord_wgt,?)
					,COIL_OUTDIA = ?
			WHERE   SLAB_NO = ?
			]]>
	</query> 
	<query id="UIG020060_SLAB_COMM_D_02.update" desc="     " fetchSize="10">
        <![CDATA[
            UPDATE TBG02_SLAB_COMM_D SET 
              ORD_FL = ?
              ,ORD_NO = ?
              ,ORD_SEQ = ?
            WHERE SLAB_NO = (SELECT SUB_SLAB_NO FROM TBG02_SLAB_COMM WHERE SLAB_NO =  ?)  
        ]]>
    </query>
    <query id="UIG020060_SLAB_RECUT.update" desc="     " fetchSize="10">
        <![CDATA[
            UPDATE TBG02_SLAB_COMM A
			SET A.STRAND_NO = ''
			    ,A.SLAB_STAT = '1'
			    ,A.CUR_PROG_CD = 'JJB'
			    ,A.CUR_LOAD_LOC = ''
			WHERE A.SLAB_NO LIKE ?||'%' 
        ]]>
    </query>
    <query id="UIG020060_SLAB_RECUT.delete" desc="     " fetchSize="10">
        <![CDATA[
           delete from tbg02_slab_comm where substr(sub_slab_no,1,9) = substr(?,1,9)
        ]]>
    </query>
    <query id="UIG020060_SLAB_RECUT_02.delete" desc="     " fetchSize="10">
        <![CDATA[
           delete from tbg02_slab_comm_d where substr(slab_no,1,9) = substr(?,1,9)
        ]]>
    </query>
    <query id="UIG020060_SLAB_RECUT_03.delete" desc="     " fetchSize="10">
        <![CDATA[
           delete from tbg02_charge_comm where charge_no = ?
        ]]>
    </query>
    <query id="UIG020060_SLAB_RECUT_04.delete" desc="     " fetchSize="10">
        <![CDATA[
           delete from tbg02_charge_comm_d where sub_charge_no = ?
        ]]>
    </query>
    <query id="UIG020060_SLAB_RECUT.select" desc="     " fetchSize="10">
        <![CDATA[
            SELECT A.SLAB_MANA_NO FROM TBF01_SPEC_SLAB A
		                 ,TBG02_CHARGE_COMM B
		      WHERE SUBSTR(A.SLAB_MANA_NO,1,10) = B.PLAN_CHARGE_NO
		      AND   B.CHARGE_NO = ?
        ]]>
    </query>
    <query id="UIG020060_SLAB_RECUT_02.update" desc="     " fetchSize="10">
        <![CDATA[
            UPDATE TBG04_SLAB_YARD A
      SET A.SLAB_NO = ''
          ,A.BEF_STORE_LOC = ''
          ,A.CR_NO = ''
          ,A.REG_ID = ''
          ,A.REG_DTIME = ''
          ,A.ORD_FLAG = ''
			WHERE A.SLAB_NO LIKE ?||'%' 
        ]]>
    </query>
    <query id="UIG020060_SUBSLABN0_CREATE" desc="     " fetchSize="10">
        <![CDATA[
            UPDATE TBG02_SLAB_COMM T 
			SET T.SLAB_NO = DECODE(?,'2',(
				SELECT DECODE(MAX(T.SLAB_NO),'',?||'51'||'0',?||lpad((SUBSTR(MAX(T.SLAB_NO),11,2)+1),2,'0')||'0')
				FROM TBG02_SLAB_COMM T 
				WHERE T.STRAND_NO  = '2' 
				AND T.SUB_SLAB_NO LIKE ?||'%' 
				AND T.SLAB_NO <> T.SUB_SLAB_NO
				AND SUBSTR(T.SLAB_NO,11,2) > '50'
			),'1',(
				SELECT DECODE(MAX(T.SLAB_NO),'',?||'01'||'0',?||lpad((SUBSTR(MAX(T.SLAB_NO),11,2)+1),2,'0')||'0')
				FROM TBG02_SLAB_COMM T 
				WHERE T.STRAND_NO  = '1' 
				AND T.SUB_SLAB_NO LIKE ?||'%' 
				--AND T.SUB_SLAB_NO <> T.SLAB_NO
				AND SUBSTR(T.SLAB_NO,11,2) < '50'
			))
			WHERE T.PLAN_SLAB_NO = ?    
			AND   T.SLAB_STAT = '1'
        ]]>
    </query>
	<query id="UIG020060_proc_rate.select" desc="  " fetchSize="10">
		<![CDATA[
			 SELECT PROC_RATE FROM  TBE01_PROC_RATE  WHERE PROC_CD = 'R'
			]]>
	</query> 
	<query id="UIG020060_SLAB_COMMD_ORD.select" desc="  " fetchSize="10">
		<![CDATA[
			 SELECT ORD_THK ,ORD_WTH,COIL_INDIA,SLAB_THK,SLAB_WTH FROM TBG02_SLAB_COMM_D WHERE SLAB_NO = ?
			]]>
	</query>
	<query id="UIG020060_compulsory_end_charge_01.update" desc="  " fetchSize="10">
		<![CDATA[
			 update tbf01_spec_charge t set t.STATUS_CD = 'C' where t.CHARGE_MANA_NO like ?
			]]>
	</query>
	<query id="UIG020060_compulsory_end_charge_02.update" desc="  " fetchSize="10">
		<![CDATA[
			 update tbf01_charge_idx t set t.STATUS_CD = 'C' where t.CHARGE_MANA_NO like ?
			]]>
	</query>
	<query id="UIG020060_compulsory_end_charge_03.update" desc="  " fetchSize="10">
		<![CDATA[
			 update tbf01_spec_slab t set t.STATUS_CD = 'C' where t.SLAB_MANA_NO like ?
			]]>
	</query>
	<query id="UIG020060_compulsory_end_charge_04.update" desc="  " fetchSize="10">
		<![CDATA[
			 update tbf01_spec_slab_d t set t.STATUS_CD = 'C' where t.SLAB_EDT_SEQ in 
			 (select slab_edt_seq from tbf01_spec_slab where slab_mana_no like ?)
			]]>
	</query>
	<query id="UIG020060_compulsory_end_charge_05.update" desc="  " fetchSize="10">
		<![CDATA[
			 update tbg02_charge_comm t set t.CHARGE_STAT = '3' where  t.CHARGE_NO like ?
			]]>
	</query>
	
	<query id="UIG020060_charge_ccdevno_06.update" desc="">
	<![CDATA[
		UPDATE    TBG06_L2_CHARGE_DEVNO     T 
		SET       T.MSG_FLAG                =     'C' 
		WHERE     T.MSG_FLAG                =     'N' 
		AND       T.CHARGE_NO               =      ?
			]]>
	</query>
</queryMap>