XinYu_RZMES/.svn/pristine/b1/b1674b831f7b28f3a5e726c0b7a3ac408481094c.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">

  <query id="UIG020100_01.select" desc=" " fetchSize="10">
   <![CDATA[ 
    SELECT CHARGE_NO
       ,PROC_CD
       ,TREAT_CD
       ,TREAT_CD_DESC
       ,TREAT_TEMP
       ,TREAT_WGT
       ,REG_DTIME
       ,STL_GRD
       ,LD_NO
       ,CAST_NO
       ,(SELECT SM_CFNM FROM TBZ00_COMMCD T
         WHERE LG_CD = 'F01001' 
         AND   SUBSTR(SM_CD,1,1) = 'J' 
         AND   SUBSTR(SM_CD,2,1) = SUBSTR(NXT_RPOC_CD,1,1))||SUBSTR(NXT_RPOC_CD,2,1) NXT_RPOC_CD
FROM (       
SELECT
      a.CHARGE_NO
     ,TREAT_CD PROC_CD 
     ,EVENT_CD TREAT_CD
     ,SM_CFNM TREAT_CD_DESC
     ,a.TREAT_TEMP
     ,a.TREAT_WGT
     ,TREAT_DTIME REG_DTIME
     ,a.STL_GRD
     ,CAS_ARRV_WGT
     ,CAS_DEP_WGT
     ,RH_ARRV_WGT
     ,RH_DEP_WGT
     ,LF_ARRV_WGT
     ,LF_DEP_WGT
     ,CCM_ARRV_WGT 
   	 ,LD_NO
     ,b.MD_NO1
     ,b.MD_NO2
     ,a.CAST_NO
     ,d.line_proc_cd
     ,SUBSTR(d.line_proc_cd,INSTR(d.line_proc_cd,SUBSTR(?,1,1),1)+2,2) NXT_RPOC_CD
    FROM TBG03_SMS_TRACKING a,
       TBG02_CHARGE_COMM b ,
       TBF01_SPEC_CHARGE d,
       (SELECT SM_CFNM,SM_CD FROM TBZ00_COMMCD 
         WHERE LG_CD = 'G02001') c
       
     WHERE a.EVENT_CD  = c.SM_CD 
       AND a.CHARGE_NO = b.CHARGE_NO
       AND d.charge_mana_no = b.plan_charge_no 
       AND  TREAT_CD = ?
 )
      
  ]]>
 </query> 
 <query id="UIG020100_03.select" desc=" " fetchSize="10">
		<![CDATA[
		SELECT A.KR_TREAT_NO,C.SM_CFNM EVENT_CD,B.LD_NO,A.TREAT_WGT,A.TREAT_TEMP,A.TREAT_DTIME
        FROM   TBG03_SMS_TRACKING A,
               TBG02_KR_RESULT B,
               (               SELECT TREAT_CD,SM_CFNM
                               FROM TBG03_SMS_TRACKING D,
                                    TBZ00_COMMCD E
                               WHERE D.EVENT_CD = E.SM_CD
                               
               ) C
               
        WHERE  A.KR_TREAT_NO = B.KR_CHARGE_NO
        AND    A.TREAT_CD = C.TREAT_CD
        AND    A.TREAT_CD = ?
        ]]>
  </query> 
  <query id="UIG020100_02.select" desc=" " fetchSize="10">
		<![CDATA[
	
   SELECT 	A.CHARGE_NO SLAB_CUT_CHARGE_NO 
   			,SLAB_CNT PLAN_SLAB_CNT
   			,COUNT(CASE WHEN B.SLAB_STAT = '2' THEN SLAB_NO END) ACT_SLAB_CNT
     FROM  TBG03_SMS_TRACKING a,
           TBG02_SLAB_COMM    b,
           TBF01_SPEC_CHARGE  c
     WHERE SUBSTR(b.PLAN_SLAB_NO,1,10) = CHARGE_MANA_NO
       AND a.CHARGE_NO = SUBSTR(b.SLAB_NO,1,10) 
       AND TREAT_CD = ?
       GROUP BY A.CHARGE_NO,SLAB_CNT
        ]]>
	</query> 	
	 
</queryMap>