XinYu_RZMES/.svn/pristine/6b/6b17dde7c92f7f6340fae46c3376c0a7953977cd.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">		
	<query id="UIG020070_01.update" desc=" UIG020070 update">
        <![CDATA[
            select distinct substr(sm_cd,1,1) label,substr(sm_cd,1,1) value
            from TBZ00_COMMCD    
            where BIZ_CLF = 'G03'
        ]]>
    </query> 
	<query id="UIG020070.CC_RSLT.select" desc="UIG030070 INIT_PARAM 01 select 炉次号 from TBG02_CC_RESULT">
        <![CDATA[
          SELECT CHARGE_NO   
            FROM TBG02_CC_RESULT
           WHERE CHARGE_NO = ?  
        ]]>
    </query> 
	<query id="UIG020070_01.select" desc=" 连铸实绩查询 " fetchSize="10">
        <![CDATA[
       select 
        a.PLAN_CHARGE_NO
       ,a.STL_GRD
       ,a.CAST_EDT_CHARGE_CNT ||'-'||a.CAST_CHARGE_SEQ  CAST_SEQ  
       ,b.CAST_NO
       ,b.CAST_END_YN
       ,b.XIN_DATE
       ,b.WKSHIFT
       ,b.WKGROUP
       ,b.CC_DEVNO
       ,b.REG_ID
       ,a.LD_NO
       ,b.LD_OPEN_YN
       ,a.TD_NO
       ,b.STLMELT_WGT
       ,b.CC_END_STLMELT_USE_WGT
       ,b.REM_WGT_IN_TD 
       ,b.REM_WGT_IN_LD
       ,b.CC_YIELD
       ,b.STLMELT_TEMP
       ,to_char(b.CC_SPEED_AVG1) CC_SPEED_AVG1
       ,to_char(b.CC_SPEED_MIN1) CC_SPEED_MIN1
       ,to_char(b.CC_SPEED_MAX1) CC_SPEED_MAX1
       ,to_char(b.CC_SPEED_AVG2) CC_SPEED_AVG2
       ,to_char(b.CC_SPEED_MIN2) CC_SPEED_MIN2
       ,to_char(b.CC_SPEED_MAX2) CC_SPEED_MAX2
       ,b.TD_TEMP_AVG
       ,b.TD_TEMP_MIN
     ,b.TD_TEMP_MAX
     ,b.MD_LVL1
     ,b.MD_UPPER_WTH1
     ,b.MD_LOWER_WTH1
     ,b.MD_VIBRATE_CNT1
     ,b.MD_VIBRATE_WTH1
     ,b.MD_LVL2
     ,b.MD_UPPER_WTH2
     ,b.MD_LOWER_WTH2
     ,b.MD_VIBRATE_CNT2
     ,b.MD_VIBRATE_WTH2
     ,b.COOLWAT_WGT
     ,LD_ARRV_DTIME
     ,CC_STA_DTIME
      ,LD_OPEN_DTIME
      ,LD_CLOSE_DTIME
      ,CC_END_DTIME
      ,CC_HOUR
      ,'7.8' STEEL_DENSITY
      from  TBG02_CHARGE_COMM a,
            TBG02_CC_RESULT  b 
      where  a.CHARGE_NO = b.CHARGE_NO(+)
        and  a.CHARGE_NO = ?
        ]]>
    </query> 
	
	<query id="UIG020070_02.update" desc=" ">
        <![CDATA[
          UPDATE TBG02_CC_RESULT SET
             CAST_END_YN = ?
            ,XIN_DATE    = ? 
            ,CC_DEVNO    = ?
            ,WKSHIFT     = ?
            ,WKGROUP     = ?
            ,REG_ID      = ?
            ,STLMELT_WGT = ?
            ,CC_END_STLMELT_USE_WGT = ?
            ,REM_WGT_IN_TD  = ?
            ,CC_YIELD  = ?
            ,STLMELT_TEMP  = ?
            --,PRE_CHARGE_NO = ?
            --,STEEL_DENSITY = ?
            --,CC_SPEED_AVG1 = ?
            --,CC_SPEED_AVG2 = ?
           WHERE CHARGE_NO = ? 
        ]]>
    </query>
	<query id="UIG020070_CH_COM.update" desc="   " fetchSize="10">
		<![CDATA[
		   UPDATE TBG02_CHARGE_COMM SET
		     CUR_PROG_CD           = ?
		    ,CUR_PROG_CD_REG_PGM   = ?
		    ,CUR_PROG_CD_REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		    ,BEF_PROG_CD           = CUR_PROG_CD 
		    ,BEF_PROG_CD_REG_PGM   = CUR_PROG_CD_REG_PGM
		    ,BEF_PROG_CD_REG_DTIME = CUR_PROG_CD_REG_DTIME 
		    ,BOF_TAPPING_WGT = ? 
		    ,CHARGE_WGT  = ?
			,ACT_CCM_RT = ?
		   WHERE CHARGE_NO = ?    
		]]>
	</query>
	<query id="UIG020070_02.insert" desc=" ">
        <![CDATA[
          insert into TBG02_CC_RESULT 
            (   CAST_END_YN 
            	,XIN_DATE    
				,CC_DEVNO    
				,WKSHIFT     
				,WKGROUP     
				,REG_ID      
				,STLMELT_WGT 
				,CC_END_STLMELT_USE_WGT
				,REM_WGT_IN_TD 
				,CC_YIELD 
				,STLMELT_TEMP 
			    ,CHARGE_NO
			    --,PRE_CHARGE_NO
			    --,STEEL_DENSITY
			    --,CC_SPEED_AVG1
			    --,CC_SPEED_AVG2
			    ,PLAN_CHARGE_NO 
			 )values
			 (?,?,?,?,?,?,?,?,?,?,?,?,?)   
        ]]>
    </query>
    <query id="UIG020070_01.insert" desc=" ">
        <![CDATA[
       INSERT INTO TBG02_CC_RESULT (   
			      CHARGE_NO                           
           ,CAST_END_YN                                                            
           ,XIN_DATE                                                               
           ,CC_DEVNO                                                               
           ,WKSHIFT                                                                
           ,WKGROUP                                                                
           ,REG_ID                                                            
           ,STLMELT_WGT                                                         
           ,CC_END_STLMELT_USE_WGT                                           
           ,REM_WGT_IN_TD                                                    
           ,CC_YIELD                                                       
           ,STLMELT_TEMP  	
       ) 
       VALUES
       (
           ?
          ,?
          ,?
          ,?
          ,?
          ,?
          ,?
          ,?
          ,?
          ,?
          ,?
          ,?
		  ,?	
       )                     
        ]]>
    </query>
	
	<query id="UIG020COMM_04.select" 
		desc="查询实绩成分，查询数据来源： TBB02_WORK_INGR,TBZ00_COMMCD,TBF01_SPEC_CHARGE表   "
		 fetchSize="10">
        <![CDATA[
      select
      SEQ,'MIN' CHEM_SEQ,C  , SI , MN , P  , S  , NI , CR , CU , ASE, TI , 
      V  , MO , B  , W  , AL , ALS, ALT, ZN , PB , SN ,
      CA , LA , SB , SE , MG , NB , CD , O  , N  , H  ,
      FE , CS , ZR , PSR 
 
      from 
       ( 
        select '1' SEQ,
           max(decode(a.CHEM_CD,'C'   ,CHEM_MIN,NULL))  C  ,max(decode(a.CHEM_CD,'SI'  ,CHEM_MIN,NULL)) SI ,
           max(decode(a.CHEM_CD,'MN'  ,CHEM_MIN,NULL))  MN ,max(decode(a.CHEM_CD,'P'   ,CHEM_MIN,NULL)) P  ,
           max(decode(a.CHEM_CD,'S'   ,CHEM_MIN,NULL))  S  ,max(decode(a.CHEM_CD,'NI'  ,CHEM_MIN,NULL)) NI ,
           max(decode(a.CHEM_CD,'CR'  ,CHEM_MIN,NULL))  CR ,max(decode(a.CHEM_CD,'CU'  ,CHEM_MIN,NULL)) CU ,
           max(decode(a.CHEM_CD,'ASE' ,CHEM_MIN,NULL))  ASE,max(decode(a.CHEM_CD,'TI'  ,CHEM_MIN,NULL)) TI , 
           max(decode(a.CHEM_CD,'V'   ,CHEM_MIN,NULL))  V  ,max(decode(a.CHEM_CD,'MO'  ,CHEM_MIN,NULL)) MO , 
           max(decode(a.CHEM_CD,'B'   ,CHEM_MIN,NULL))  B  ,max(decode(a.CHEM_CD,'W'   ,CHEM_MIN,NULL)) W  ,
           max(decode(a.CHEM_CD,'AL'  ,CHEM_MIN,NULL))  AL ,max(decode(a.CHEM_CD,'ALS' ,CHEM_MIN,NULL)) ALS,
           max(decode(a.CHEM_CD,'ALT' ,CHEM_MIN,NULL))  ALT,max(decode(a.CHEM_CD,'ZN'  ,CHEM_MIN,NULL)) ZN ,
           max(decode(a.CHEM_CD,'PB'  ,CHEM_MIN,NULL))  PB ,max(decode(a.CHEM_CD,'SN'  ,CHEM_MIN,NULL)) SN ,
           max(decode(a.CHEM_CD,'CA'  ,CHEM_MIN,NULL))  CA ,max(decode(a.CHEM_CD,'LA'  ,CHEM_MIN,NULL)) LA ,
           max(decode(a.CHEM_CD,'SB'  ,CHEM_MIN,NULL))  SB ,max(decode(a.CHEM_CD,'SE'  ,CHEM_MIN,NULL)) SE ,
           max(decode(a.CHEM_CD,'MG'  ,CHEM_MIN,NULL))  MG ,max(decode(a.CHEM_CD,'NB'  ,CHEM_MIN,NULL)) NB ,
           max(decode(a.CHEM_CD,'CD'  ,CHEM_MIN,NULL))  CD ,max(decode(a.CHEM_CD,'O'   ,CHEM_MIN,NULL)) O  ,
           max(decode(a.CHEM_CD,'N'   ,CHEM_MIN,NULL))  N  ,max(decode(a.CHEM_CD,'H'   ,CHEM_MIN,NULL)) H  ,
           max(decode(a.CHEM_CD,'FE'  ,CHEM_MIN,NULL))  FE ,max(decode(a.CHEM_CD,'CS'  ,CHEM_MIN,NULL)) CS ,
           max(decode(a.CHEM_CD,'ZR'  ,CHEM_MIN,NULL))  ZR ,max(decode(a.CHEM_CD,'PSR' ,CHEM_MIN,NULL)) PSR 
         from  
       ( 
          SELECT   CHEM_CD,CHEM_MIN   
           from TBB01_FAC_INGR  b01,
                TBG02_CHARGE_COMM  g02 
             where FAC_STL_GRD = STL_GRD 
              and  CHARGE_NO = ?
       ) a,
       (
          SELECT CHEM_CD,DISPLAY_SEQ FROM  TBB01_SEQ_INGR 
           WHERE COMP_YN = 'N'
              ORDER BY DISPLAY_SEQ  
    
       ) b
       where a.CHEM_CD = b.CHEM_CD  
          ORDER BY b.DISPLAY_SEQ
     )   
     UNION  
       select
      SEQ,'MIN' CHEM_SEQ,C  , SI , MN , P  , S  , NI , CR , CU , ASE, TI , 
      V  , MO , B  , W  , AL , ALS, ALT, ZN , PB , SN ,
      CA , LA , SB , SE , MG , NB , CD , O  , N  , H  ,
      FE , CS , ZR , PSR 
 
      from 
       ( 
        select '1' SEQ,
           max(decode(a.CHEM_CD,'C'   ,CHEM_MIN,NULL))  C  ,max(decode(a.CHEM_CD,'SI'  ,CHEM_MIN,NULL)) SI ,
           max(decode(a.CHEM_CD,'MN'  ,CHEM_MIN,NULL))  MN ,max(decode(a.CHEM_CD,'P'   ,CHEM_MIN,NULL)) P  ,
           max(decode(a.CHEM_CD,'S'   ,CHEM_MIN,NULL))  S  ,max(decode(a.CHEM_CD,'NI'  ,CHEM_MIN,NULL)) NI ,
           max(decode(a.CHEM_CD,'CR'  ,CHEM_MIN,NULL))  CR ,max(decode(a.CHEM_CD,'CU'  ,CHEM_MIN,NULL)) CU ,
           max(decode(a.CHEM_CD,'ASE' ,CHEM_MIN,NULL))  ASE,max(decode(a.CHEM_CD,'TI'  ,CHEM_MIN,NULL)) TI , 
           max(decode(a.CHEM_CD,'V'   ,CHEM_MIN,NULL))  V  ,max(decode(a.CHEM_CD,'MO'  ,CHEM_MIN,NULL)) MO , 
           max(decode(a.CHEM_CD,'B'   ,CHEM_MIN,NULL))  B  ,max(decode(a.CHEM_CD,'W'   ,CHEM_MIN,NULL)) W  ,
           max(decode(a.CHEM_CD,'AL'  ,CHEM_MIN,NULL))  AL ,max(decode(a.CHEM_CD,'ALS' ,CHEM_MIN,NULL)) ALS,
           max(decode(a.CHEM_CD,'ALT' ,CHEM_MIN,NULL))  ALT,max(decode(a.CHEM_CD,'ZN'  ,CHEM_MIN,NULL)) ZN ,
           max(decode(a.CHEM_CD,'PB'  ,CHEM_MIN,NULL))  PB ,max(decode(a.CHEM_CD,'SN'  ,CHEM_MIN,NULL)) SN ,
           max(decode(a.CHEM_CD,'CA'  ,CHEM_MIN,NULL))  CA ,max(decode(a.CHEM_CD,'LA'  ,CHEM_MIN,NULL)) LA ,
           max(decode(a.CHEM_CD,'SB'  ,CHEM_MIN,NULL))  SB ,max(decode(a.CHEM_CD,'SE'  ,CHEM_MIN,NULL)) SE ,
           max(decode(a.CHEM_CD,'MG'  ,CHEM_MIN,NULL))  MG ,max(decode(a.CHEM_CD,'NB'  ,CHEM_MIN,NULL)) NB ,
           max(decode(a.CHEM_CD,'CD'  ,CHEM_MIN,NULL))  CD ,max(decode(a.CHEM_CD,'O'   ,CHEM_MIN,NULL)) O  ,
           max(decode(a.CHEM_CD,'N'   ,CHEM_MIN,NULL))  N  ,max(decode(a.CHEM_CD,'H'   ,CHEM_MIN,NULL)) H  ,
           max(decode(a.CHEM_CD,'FE'  ,CHEM_MIN,NULL))  FE ,max(decode(a.CHEM_CD,'CS'  ,CHEM_MIN,NULL)) CS ,
           max(decode(a.CHEM_CD,'ZR'  ,CHEM_MIN,NULL))  ZR ,max(decode(a.CHEM_CD,'PSR' ,CHEM_MIN,NULL)) PSR 
         from  
       ( 
          SELECT   CHEM_CD,CHEM_MIN   
           from TBB01_FAC_INGR  b01,
                TBG02_CHARGE_COMM  g02 
             where FAC_STL_GRD = STL_GRD 
              and  CHARGE_NO = ?
       ) a,
       (
          SELECT CHEM_CD,DISPLAY_SEQ FROM  TBB01_SEQ_INGR 
           WHERE COMP_YN = 'N'
              ORDER BY DISPLAY_SEQ  
    
       ) b
       where a.CHEM_CD = b.CHEM_CD  
          ORDER BY b.DISPLAY_SEQ
     )   
     UNION  
     select
        SEQ,'MAX' DISPLAY_SEQ ,C  , SI , MN , P  , S  , NI , CR , CU , ASE, TI , 
        V  , MO , B  , W  , AL , ALS, ALT, ZN , PB , SN ,
        CA , LA , SB , SE , MG , NB , CD , O  , N  , H  ,
        FE , CS , ZR , PSR 
 
      from     
       (
     select '2' SEQ ,                                                                                         
       max(decode(c.CHEM_CD,'C'   ,CHEM_MAX,NULL))  C  ,max(decode(c.CHEM_CD,'SI'  ,CHEM_MAX,NULL)) SI , 
           max(decode(c.CHEM_CD,'MN'  ,CHEM_MAX,NULL))  MN ,max(decode(c.CHEM_CD,'P'   ,CHEM_MAX,NULL)) P  , 
           max(decode(c.CHEM_CD,'S'   ,CHEM_MAX,NULL))  S  ,max(decode(c.CHEM_CD,'NI'  ,CHEM_MAX,NULL)) NI , 
           max(decode(c.CHEM_CD,'CR'  ,CHEM_MAX,NULL))  CR ,max(decode(c.CHEM_CD,'CU'  ,CHEM_MAX,NULL)) CU , 
           max(decode(c.CHEM_CD,'ASE' ,CHEM_MAX,NULL))  ASE,max(decode(c.CHEM_CD,'TI'  ,CHEM_MAX,NULL)) TI , 
           max(decode(c.CHEM_CD,'V'   ,CHEM_MAX,NULL))  V  ,max(decode(c.CHEM_CD,'MO'  ,CHEM_MAX,NULL)) MO , 
           max(decode(c.CHEM_CD,'B'   ,CHEM_MAX,NULL))  B  ,max(decode(c.CHEM_CD,'W'   ,CHEM_MAX,NULL)) W  , 
           max(decode(c.CHEM_CD,'AL'  ,CHEM_MAX,NULL))  AL ,max(decode(c.CHEM_CD,'ALS' ,CHEM_MAX,NULL)) ALS, 
           max(decode(c.CHEM_CD,'ALT' ,CHEM_MAX,NULL))  ALT,max(decode(c.CHEM_CD,'ZN'  ,CHEM_MAX,NULL)) ZN , 
           max(decode(c.CHEM_CD,'PB'  ,CHEM_MAX,NULL))  PB ,max(decode(c.CHEM_CD,'SN'  ,CHEM_MAX,NULL)) SN , 
           max(decode(c.CHEM_CD,'CA'  ,CHEM_MAX,NULL))  CA ,max(decode(c.CHEM_CD,'LA'  ,CHEM_MAX,NULL)) LA , 
           max(decode(c.CHEM_CD,'SB'  ,CHEM_MAX,NULL))  SB ,max(decode(c.CHEM_CD,'SE'  ,CHEM_MAX,NULL)) SE , 
           max(decode(c.CHEM_CD,'MG'  ,CHEM_MAX,NULL))  MG ,max(decode(c.CHEM_CD,'NB'  ,CHEM_MAX,NULL)) NB , 
           max(decode(c.CHEM_CD,'CD'  ,CHEM_MAX,NULL))  CD ,max(decode(c.CHEM_CD,'O'   ,CHEM_MAX,NULL)) O  , 
           max(decode(c.CHEM_CD,'N'   ,CHEM_MAX,NULL))  N  ,max(decode(c.CHEM_CD,'H'   ,CHEM_MAX,NULL)) H  , 
           max(decode(c.CHEM_CD,'FE'  ,CHEM_MAX,NULL))  FE ,max(decode(c.CHEM_CD,'CS'  ,CHEM_MAX,NULL)) CS , 
           max(decode(c.CHEM_CD,'ZR'  ,CHEM_MAX,NULL))  ZR ,max(decode(c.CHEM_CD,'PSR' ,CHEM_MAX,NULL)) PSR    from  
        ( 
          select   CHEM_CD,CHEM_MAX   
           from TBB01_FAC_INGR  b01,
                TBG02_CHARGE_COMM  g02 
             where FAC_STL_GRD = STL_GRD
              and  CHARGE_NO = ?
       ) c,
       (
          SELECT CHEM_CD,DISPLAY_SEQ FROM  TBB01_SEQ_INGR 
           WHERE COMP_YN = 'N'
              ORDER BY DISPLAY_SEQ  
    
       ) d
       where c.CHEM_CD = d.CHEM_CD  
            ORDER BY d.DISPLAY_SEQ 
      )        
      UNION
     select
        SEQ,CHEM_SEQ,C  , SI , MN , P  , S  , NI , CR , CU , ASE, TI , 
        V  , MO , B  , W  , AL , ALS, ALT, ZN , PB , SN ,
        CA , LA , SB , SE , MG , NB , CD , O  , N  , H  ,
        FE , CS , ZR , PSR 
 
      from      
      (
        SELECT   '3' SEQ,
           CHEM_SEQ,
           max(decode(CHEM_CD,'C'   ,CHEM_VAL,NULL))  C  ,max(decode(CHEM_CD,'SI'  ,CHEM_VAL,NULL)) SI ,
           max(decode(CHEM_CD,'MN'  ,CHEM_VAL,NULL))  MN ,max(decode(CHEM_CD,'P'   ,CHEM_VAL,NULL)) P  ,
           max(decode(CHEM_CD,'S'   ,CHEM_VAL,NULL))  S  ,max(decode(CHEM_CD,'NI'  ,CHEM_VAL,NULL)) NI ,
           max(decode(CHEM_CD,'CR'  ,CHEM_VAL,NULL))  CR ,max(decode(CHEM_CD,'CU'  ,CHEM_VAL,NULL)) CU ,
           max(decode(CHEM_CD,'ASE' ,CHEM_VAL,NULL))  ASE,max(decode(CHEM_CD,'TI'  ,CHEM_VAL,NULL)) TI , 
           max(decode(CHEM_CD,'V'   ,CHEM_VAL,NULL))  V  ,max(decode(CHEM_CD,'MO'  ,CHEM_VAL,NULL)) MO , 
           max(decode(CHEM_CD,'B'   ,CHEM_VAL,NULL))  B  ,max(decode(CHEM_CD,'W'   ,CHEM_VAL,NULL)) W  ,
           max(decode(CHEM_CD,'AL'  ,CHEM_VAL,NULL))  AL ,max(decode(CHEM_CD,'ALS' ,CHEM_VAL,NULL)) ALS,
           max(decode(CHEM_CD,'ALT' ,CHEM_VAL,NULL))  ALT,max(decode(CHEM_CD,'ZN'  ,CHEM_VAL,NULL)) ZN ,
           max(decode(CHEM_CD,'PB'  ,CHEM_VAL,NULL))  PB ,max(decode(CHEM_CD,'SN'  ,CHEM_VAL,NULL)) SN ,
           max(decode(CHEM_CD,'CA'  ,CHEM_VAL,NULL))  CA ,max(decode(CHEM_CD,'LA'  ,CHEM_VAL,NULL)) LA ,
           max(decode(CHEM_CD,'SB'  ,CHEM_VAL,NULL))  SB ,max(decode(CHEM_CD,'SE'  ,CHEM_VAL,NULL)) SE ,
           max(decode(CHEM_CD,'MG'  ,CHEM_VAL,NULL))  MG ,max(decode(CHEM_CD,'NB'  ,CHEM_VAL,NULL)) NB ,
           max(decode(CHEM_CD,'CD'  ,CHEM_VAL,NULL))  CD ,max(decode(CHEM_CD,'O'   ,CHEM_VAL,NULL)) O  ,
           max(decode(CHEM_CD,'N'   ,CHEM_VAL,NULL))  N  ,max(decode(CHEM_CD,'H'   ,CHEM_VAL,NULL)) H  ,
           max(decode(CHEM_CD,'FE'  ,CHEM_VAL,NULL))  FE ,max(decode(CHEM_CD,'CS'  ,CHEM_VAL,NULL)) CS ,
           max(decode(CHEM_CD,'ZR'  ,CHEM_VAL,NULL))  ZR ,max(decode(CHEM_CD,'PSR' ,CHEM_VAL,NULL)) PSR 
       FROM   
        ( 
          SELECT 
             CHEM_SEQ  
            ,a.CHEM_CD
            ,a.CHEM_VAL
            ,DISPLAY_SEQ CD_SEQ
           FROM TBB02_WORK_INGR  a,
                TBB01_SEQ_INGR    b 
           WHERE CHARGE_NO = ?
            AND  PROC_CD   = ?
            AND  a.CHEM_CD = b.CHEM_CD
            ORDER BY DISPLAY_SEQ
           
            
         )  
           GROUP BY CHEM_SEQ
       )       
      UNION
     select
        SEQ,CHEM_SEQ,C  , SI , MN , P  , S  , NI , CR , CU , ASE, TI , 
        V  , MO , B  , W  , AL , ALS, ALT, ZN , PB , SN ,
        CA , LA , SB , SE , MG , NB , CD , O  , N  , H  ,
        FE , CS , ZR , PSR 
 
      from      
      (
        SELECT   '3' SEQ,
           CHEM_SEQ,
           max(decode(CHEM_CD,'C'   ,CHEM_VAL,NULL))  C  ,max(decode(CHEM_CD,'SI'  ,CHEM_VAL,NULL)) SI ,
           max(decode(CHEM_CD,'MN'  ,CHEM_VAL,NULL))  MN ,max(decode(CHEM_CD,'P'   ,CHEM_VAL,NULL)) P  ,
           max(decode(CHEM_CD,'S'   ,CHEM_VAL,NULL))  S  ,max(decode(CHEM_CD,'NI'  ,CHEM_VAL,NULL)) NI ,
           max(decode(CHEM_CD,'CR'  ,CHEM_VAL,NULL))  CR ,max(decode(CHEM_CD,'CU'  ,CHEM_VAL,NULL)) CU ,
           max(decode(CHEM_CD,'ASE' ,CHEM_VAL,NULL))  ASE,max(decode(CHEM_CD,'TI'  ,CHEM_VAL,NULL)) TI , 
           max(decode(CHEM_CD,'V'   ,CHEM_VAL,NULL))  V  ,max(decode(CHEM_CD,'MO'  ,CHEM_VAL,NULL)) MO , 
           max(decode(CHEM_CD,'B'   ,CHEM_VAL,NULL))  B  ,max(decode(CHEM_CD,'W'   ,CHEM_VAL,NULL)) W  ,
           max(decode(CHEM_CD,'AL'  ,CHEM_VAL,NULL))  AL ,max(decode(CHEM_CD,'ALS' ,CHEM_VAL,NULL)) ALS,
           max(decode(CHEM_CD,'ALT' ,CHEM_VAL,NULL))  ALT,max(decode(CHEM_CD,'ZN'  ,CHEM_VAL,NULL)) ZN ,
           max(decode(CHEM_CD,'PB'  ,CHEM_VAL,NULL))  PB ,max(decode(CHEM_CD,'SN'  ,CHEM_VAL,NULL)) SN ,
           max(decode(CHEM_CD,'CA'  ,CHEM_VAL,NULL))  CA ,max(decode(CHEM_CD,'LA'  ,CHEM_VAL,NULL)) LA ,
           max(decode(CHEM_CD,'SB'  ,CHEM_VAL,NULL))  SB ,max(decode(CHEM_CD,'SE'  ,CHEM_VAL,NULL)) SE ,
           max(decode(CHEM_CD,'MG'  ,CHEM_VAL,NULL))  MG ,max(decode(CHEM_CD,'NB'  ,CHEM_VAL,NULL)) NB ,
           max(decode(CHEM_CD,'CD'  ,CHEM_VAL,NULL))  CD ,max(decode(CHEM_CD,'O'   ,CHEM_VAL,NULL)) O  ,
           max(decode(CHEM_CD,'N'   ,CHEM_VAL,NULL))  N  ,max(decode(CHEM_CD,'H'   ,CHEM_VAL,NULL)) H  ,
           max(decode(CHEM_CD,'FE'  ,CHEM_VAL,NULL))  FE ,max(decode(CHEM_CD,'CS'  ,CHEM_VAL,NULL)) CS ,
           max(decode(CHEM_CD,'ZR'  ,CHEM_VAL,NULL))  ZR ,max(decode(CHEM_CD,'PSR' ,CHEM_VAL,NULL)) PSR 
       FROM   
        ( 
          SELECT 
             CHEM_SEQ  
            ,a.CHEM_CD
            ,a.CHEM_VAL
            ,DISPLAY_SEQ CD_SEQ
           FROM TBB02_WORK_INGR  a,
                TBB01_SEQ_INGR    b 
           WHERE CHARGE_NO = ?
            AND  PROC_CD   = ?
            AND  a.CHEM_CD = b.CHEM_CD
            ORDER BY DISPLAY_SEQ
           
            
         )  
           GROUP BY CHEM_SEQ
       )   
        ]]>
    </query>
	<query id="UIG020070_EMP.select" desc="查询CCM作业人信息，这里PROC_CD为JJJ " fetchSize="10">
		<![CDATA[
		SELECT  EMP_NM  label  
                ,EMP_NM  value  
         FROM   TBZ01_FAC_EMP_GROUP   
         WHERE  GROUP_CD = ? 
          AND   PROC_CD = 'JJ' 
		]]>
	</query> 
</queryMap>