XinYu_RZMES/.svn/pristine/9c/9c92504a8beba7bc853aa06047379c33662757ea.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="炉次号目标钢号成分现况">
		
  <query id="UIB020021_01.SELECT" desc="获取满足条件的成分代码，多条件查询">
	  SELECT       DISTINCT     
	               decode(SI.COMP_YN , 'Y' , SI.COMP_CAL , SI.CHEM_CD) CHEM
                 , WI.CHEM_CD  , SI.COMP_YN , SI.DISPLAY_SEQ  
	  FROM         TBB02_WORK_INGR  WI , TBB01_SEQ_INGR SI
      WHERE        WI.CHEM_CD         =  SI.CHEM_CD
      AND          WI.CHEM_VAL_TP     =  'L'      --'L'表示炉次，'P'表示钢卷，'S'表示板坯
      AND          CHEM_VAL        IS  NOT NULL
     
  </query>	
	
  <query id="UIB020021_CHARGENO" desc="炉次号">
	  AND      WI.CHARGE_NO(+)   LIKE    ?
  </query>	
	
  <query id="UIB020021_SEQ" desc="次数">
	  AND      WI.CHEM_SEQ    =    ?
  </query>		
	
  <query id="UIB020021_02.MID" desc="循环部分">
	    , max(decode(WI.CHEM_CD , '{0}' , CHEM_VAL )) CHEM_VAL{1}
	    , max(decode(TI.CHEM_CD , '{0}' , CHEM_MIN )) CHEM_MIN{1}
	    , max(decode(TI.CHEM_CD , '{0}' , CHEM_MAX )) CHEM_MAX{1}
  </query>	
	
  <query id="UIB020021_02.START" desc="炉次号成分现况查询">
	  SELECT  
		  WI.CHARGE_NO
		, WI.PROC_CD
		, WI.CHEM_SEQ
		, GC.STL_GRD
		, decode(WI.PROC_CD||MAX(WI.CHEM_SEQ) , GC.LST_INGR_CD , GC.INGR_DEC_GRD , NULL) INGR_DEC_GRD
	    , max(decode(TDI.CHEM_CD , 'TT' , CHEM_DCS_RST )) CHEM_DCS_RST      
	    , TI.tafac_stl_grd                  
	    , GC.SLAB_RT
	    , decode(GC.LST_INGR_CD, WI.PROC_CD||WI.CHEM_SEQ , GC.LST_INGR_REG_DTIME , '') LST_INGR_REG_DTIME  
  </query>		
	
  <query id="UIB020021_TIME" desc="成分判定时间">
	  AND      SUBSTR(GC.INGR_DEC_DTIME , 1 , 8) BETWEEN  ?  AND ?
  </query>		
	
  <query id="UIB020021_02.GROUPBY" desc="">
	  GROUP BY 
	  WI.CHARGE_NO
	, WI.PROC_CD
	, WI.CHEM_SEQ
	, GC.STL_GRD
	, GC.BEF_STL_GRD
	, GC.INGR_DEC_GRD  
	, GC.LST_INGR_REG_DTIME
	, GC.LST_INGR_CD
	, GC.SLAB_RT
	, TI.tafac_stl_grd 
	  ORDER BY  WI.CHARGE_NO DESC  ,  INGR_DEC_GRD  DESC
  </query>			
	
  <query id="UIB020021_02.END" desc="">
	  FROM      TBB02_WORK_INGR WI  , TBG02_CHARGE_COMM GC , TBB01_MAP_INGR MI,TBB01_TAFAC_INGR TI,TBB02_TADCS_INGR TDI
	  WHERE     WI.CHARGE_NO    =   GC.CHARGE_NO(+)
	  AND       WI.CHARGE_NO    =   TDI.CHARGE_NO(+)
	  AND       WI.PROC_CD      =   TDI.PROC_CD(+)
	  AND       WI.CHEM_SEQ     =   TDI.CHEM_SEQ(+)
	  AND GC.STL_GRD = MI.FAC_STL_GRD(+)
	  AND GC.SLAB_RT = MI.FAC_CODE(+)
      AND MI.TAFAC_STL_GRD = TI.TAFAC_STL_GRD
  </query>		
</queryMap>