XinYu_RZMES/.svn/pristine/7c/7ca3fe02ed48399db681a22c6d977a1ab11126c0.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
   <query id="UIG020100_01.select" desc=" " fetchSize="10">
   <![CDATA[ 
    	select 
	       a.CHARGE_NO
	       ,a.PLAN_CHARGE_NO 
	       ,a.STL_GRD
	       ,a.CAST_EDT_CHARGE_CNT ||'-'||a.CAST_CHARGE_SEQ  CAST_SEQ  
	       ,b.XIN_DATE 
	       ,b.VD_NO
	       ,b.WKSHIFT
	       ,b.WKGROUP
	       ,decode(b.MOD_ID,null,b.REG_ID,b.MOD_ID) EMP_ID
	       ,b.LD_NO
	       ,c.LD_CYCLIC_CNT
	       ,d.VD_TGT_TEMP 
	       ,d.VD_WK_HOUR_MIN  
	       ,d.VD_WK_HOUR_MAX
	      from  TBG02_CHARGE_COMM a,
	            TBG02_VD_RESULT  b,
	            TBG03_LADLE_PROG  c,
	            TBG01_OPRN_STD    d 
	      where  c.LD_NO(+)  = a.LD_NO 
	        and  a.STL_GRD   = d.STL_GRD(+)
	        and  a.CHARGE_NO = b.CHARGE_NO(+)  
	        and  a.CHARGE_NO = :1
	 ]]>
   </query> 
   
   <query id="UIG020200_02.select" desc=" " fetchSize="10">
   <![CDATA[ 
    	SELECT 
	       ,B.ARRV_WGT
	       ,B.VD_TREAT_WGT
	       ,B.VD_TREAT_CNT
	       ,B.STEEL_TEMP --
	       ,B.SLAG_NET_WGT
	       ,B.VD_STA_DTIME
	       ,B.VD_END_DTIME
	       ,B.START_TEMP
	       ,B.START_TEMP_TIME
	       ,B.START_HYD_CON
	       ,B.START_HYD_CON_TIME
	       ,B.END_TEMP
	       ,B.END_TEMP_TIME
	       ,B.END_HYD_CON
	       ,B.END_HYD_CON_TIME
	       ,B.PRE_TIME
	       ,B.MID_TIME
	       ,B.POST_TIME
	       ,B.SOFT_TIME
	       ,B.VACUUM_DEGREE
	       ,B.VACUUM_DURATION
	       ,B.STEAM_TEMP
	       ,B.STEAM_PRESS
	       ,B.STEAM_FLOW
	      FROM  TBG02_CHARGE_COMM A,
	            TBG02_VD_RESULT  B,
	            TBG03_LADLE_PROG  C,
	            TBG01_OPRN_STD    D 
	      WHERE  C.LD_NO(+)  = A.LD_NO 
	        AND  A.STL_GRD   = D.STL_GRD(+)
	        AND  A.CHARGE_NO = B.CHARGE_NO(+)  
	        AND  A.CHARGE_NO = :1
	 ]]>
   </query>
   <query id="UIG020110_RHF1_CH.select" desc="  " fetchSize="10">
		<![CDATA[
	  SELECT SLAB_NO SLAB_NO5, SLAB_EDT_SEQ SLAB_EDT_SEQ5,C2_1 SLAB_NO6,C2_Q SLAB_EDT_SEQ6
        FROM (
          SELECT ROW_NUMBER() OVER (ORDER BY b.SLAB_EDT_SEQ) AS RN
               , a.SLAB_NO, b.SLAB_EDT_SEQ
               , LEAD(a.SLAB_NO, 1) OVER (ORDER BY b.SLAB_EDT_SEQ) C2_1
               , LEAD(b.SLAB_EDT_SEQ, 1) OVER (ORDER BY b.SLAB_EDT_SEQ) C2_Q
            FROM  TBH02_REHEATFUR a ,
                  TBF02_MILL_IDX  b ,
                  TBF02_SPEC_MILL c
           WHERE DEVNO  = '1'
             AND  RHF_STAT = '1' 
             AND  a.COIL_NO = c.COIL_NO
             AND  b.SLAB_EDT_SEQ = c.SLAB_EDT_SEQ
             AND  L2_SEND = 'Y'
        ) X
        WHERE MOD(RN,2) = 1
 
        ]]>
	</query> 
	<query id="UIG020110_RHF2_CH.select" desc="  " fetchSize="10">
		<![CDATA[
	  SELECT SLAB_NO SLAB_NO3, SLAB_EDT_SEQ SLAB_EDT_SEQ3,C2_1 SLAB_NO4,C2_Q SLAB_EDT_SEQ4
        FROM (
          SELECT ROW_NUMBER() OVER (ORDER BY b.SLAB_EDT_SEQ) AS RN
               , a.SLAB_NO, b.SLAB_EDT_SEQ
               , LEAD(a.SLAB_NO, 1) OVER (ORDER BY b.SLAB_EDT_SEQ) C2_1
               , LEAD(b.SLAB_EDT_SEQ, 1) OVER (ORDER BY b.SLAB_EDT_SEQ) C2_Q
            FROM  TBH02_REHEATFUR a ,
                  TBF02_MILL_IDX  b ,
                  TBF02_SPEC_MILL c
           WHERE DEVNO  = '2'
             AND  RHF_STAT = '1' 
             AND  a.COIL_NO = c.COIL_NO
             AND  b.SLAB_EDT_SEQ = c.SLAB_EDT_SEQ
             AND  L2_SEND = 'Y'
        ) X
        WHERE MOD(RN,2) = 1
        ]]>
	</query> 
	<query id="UIG020110_RHF3_CH.select" desc="  " fetchSize="10">
		<![CDATA[
	  SELECT SLAB_NO SLAB_NO1, SLAB_EDT_SEQ SLAB_EDT_SEQ1,C2_1 SLAB_NO2,C2_Q SLAB_EDT_SEQ2
        FROM (
          SELECT ROW_NUMBER() OVER (ORDER BY b.SLAB_EDT_SEQ) AS RN
               , a.SLAB_NO, b.SLAB_EDT_SEQ
               , LEAD(a.SLAB_NO, 1) OVER (ORDER BY b.SLAB_EDT_SEQ) C2_1
               , LEAD(b.SLAB_EDT_SEQ, 1) OVER (ORDER BY b.SLAB_EDT_SEQ) C2_Q
            FROM  TBH02_REHEATFUR a ,
                  TBF02_MILL_IDX  b ,
                  TBF02_SPEC_MILL c
           WHERE DEVNO  = '3'
             AND  RHF_STAT = '1' 
             AND  a.COIL_NO = c.COIL_NO
             AND  b.SLAB_EDT_SEQ = c.SLAB_EDT_SEQ
             AND  L2_SEND = 'Y'
          ) X
        WHERE MOD(RN,2) = 1   
        ]]>
	</query> 
	<query id="UIG020110_RHF_EXT.select" desc="  " fetchSize="10">
		<![CDATA[
	      SELECT MAX(DECODE(DEVNO,'3', SLAB_NO ,NULL)) SLAB_NO3
               , MAX(DECODE(DEVNO,'2', SLAB_NO ,NULL)) SLAB_NO2
               , MAX(DECODE(DEVNO,'1', SLAB_NO ,NULL)) SLAB_NO1
            FROM  TBH02_REHEATFUR   
           WHERE   RHF_STAT = '2'   
           ORDER BY EXTRACT_DTIME DESC 
        ]]>
	</query> 
	<query id="UIG020110_RHF_ENT.select" desc="  " fetchSize="10">
		<![CDATA[ 
          SELECT  YARD_ADDR,STORELAY,SLAB_NO 
            FROM   TBG04_SLAB_YARD 
           WHERE STORELAY = '01'
             AND YARD_ADDR > 'A00' 
             AND YARD_ADDR < 'C13'  
           ORDER BY  YARD_ADDR DESC
        ]]>
	</query> 
</queryMap>