XinYu_RZMES/.svn/pristine/3b/3bc09b250484e9112d03f3bb5e57f9ee908961ac.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
   <query id="UIH020040_RHF1_CH.select" desc="  " fetchSize="10">
		<![CDATA[
	SELECT  A.SLAB_NO
       ,B.SLAB_EDT_SEQ
       ,A.ROW_NUM
       ,CHARING_DTIME   
     FROM TBH02_REHEATFUR A
        ,(SELECT SLAB_EDT_SEQ FROM TBF02_MILL_IDX WHERE L2_SEND = 'Y') B     
        , TBF02_SPEC_MILL C
     WHERE A.COIL_NO = C.COIL_NO
     AND C.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ
     AND A.DEVNO  = '1'
     AND A.RHF_STAT = '1'
  ORDER BY CHARING_DTIME   
 
        ]]>
	</query> 
	<query id="UIH020040_RHF2_CH.select" desc="  " fetchSize="10">
		<![CDATA[
	 SELECT  A.SLAB_NO
       ,B.SLAB_EDT_SEQ
       ,A.ROW_NUM
       ,CHARING_DTIME   
     FROM TBH02_REHEATFUR A
        ,(SELECT SLAB_EDT_SEQ FROM TBF02_MILL_IDX WHERE L2_SEND = 'Y') B     
        , TBF02_SPEC_MILL C
     WHERE A.COIL_NO = C.COIL_NO
     AND C.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ
     AND A.DEVNO  = '2'
     AND A.RHF_STAT = '1'
  ORDER BY CHARING_DTIME  


        ]]>
	</query> 
	<query id="UIH020040_RHF3_CH.select" desc="  " fetchSize="10">
		<![CDATA[
    SELECT  A.SLAB_NO
       ,B.SLAB_EDT_SEQ
       ,A.ROW_NUM
       ,CHARING_DTIME   
     FROM TBH02_REHEATFUR A
        ,(SELECT SLAB_EDT_SEQ FROM TBF02_MILL_IDX WHERE L2_SEND = 'Y') B     
        , TBF02_SPEC_MILL C
     WHERE A.COIL_NO = C.COIL_NO
     AND C.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ
     AND A.DEVNO  = '3'
     AND A.RHF_STAT = '1'
  ORDER BY CHARING_DTIME  
        ]]>
	</query> 
	<query id="UIH020040_RHF_EXT.select" desc="  " fetchSize="10">
		<![CDATA[
	    SELECT MAX(DECODE(X.DEVNO,'3', X.SLAB_NO ,NULL)) EXT_SLAB_NO3
             , MAX(DECODE(X.DEVNO,'2', X.SLAB_NO ,NULL)) EXT_SLAB_NO2
             , MAX(DECODE(X.DEVNO,'1', X.SLAB_NO ,NULL)) EXT_SLAB_NO1
        FROM 
        (
          SELECT DEVNO, SLAB_NO, EXTRACT_DTIME
            , ROW_NUMBER() OVER (PARTITION BY DEVNO ORDER BY EXTRACT_DTIME DESC) AS RN
           FROM TBH02_REHEATFUR
          WHERE RHF_STAT = '2'
        ) X
        WHERE X.RN = 1
        ]]>
	</query> 
	<query id="UIH020040_RHF_ENT.select" desc="  " fetchSize="10">
		<![CDATA[ 
      SELECT  MAX(DECODE(YARD_ADDR,'C12', SLAB_NO,NULL)) C12_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'C11', SLAB_NO,NULL)) C11_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'C10', SLAB_NO,NULL)) C10_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'C9', SLAB_NO,NULL)) C09_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'C8', SLAB_NO,NULL)) C08_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'C7', SLAB_NO,NULL)) C07_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'A7', SLAB_NO,NULL)) A07_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'A6', SLAB_NO,NULL)) A06_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'A5', SLAB_NO,NULL)) A05_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'A4', SLAB_NO,NULL)) A04_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'A3', SLAB_NO,NULL)) A03_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'A2', SLAB_NO,NULL)) A02_SLAB_NO
      , MAX(DECODE(YARD_ADDR,'A1', SLAB_NO,NULL)) A01_SLAB_NO
     FROM   TBG04_SLAB_YARD 
           WHERE STORELAY = '01'
             AND YARD_ADDR > 'A00' 
             AND YARD_ADDR < 'C13'  
           ORDER BY  YARD_ADDR DESC
        ]]>
	</query> 
	<query id="UIH020040_NEXT_EXT.select" desc="  " fetchSize="10">
		<![CDATA[
	   SELECT  MIN(SLAB_EDT_SEQ) SLAB_EDT_SEQ
              ,DEVNO
        FROM 
        (
          SELECT   b.SLAB_EDT_SEQ   
                  ,DEVNO
            FROM  TBH02_REHEATFUR a ,
                  TBF02_MILL_IDX  b ,
                  TBF02_SPEC_MILL c
           WHERE  
                   RHF_STAT = '1' 
             AND  a.COIL_NO = c.COIL_NO
             AND  b.SLAB_EDT_SEQ = c.SLAB_EDT_SEQ
             AND  L2_SEND = 'Y' 
             ORDER BY b.SLAB_EDT_SEQ 
        )      
        GROUP BY   DEVNO
        ]]>
	</query> 
</queryMap>