XinYu_RZMES/.svn/pristine/a9/a978f6ebce01941c5d567da9493c67710e60f9f3.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS    ">
              
   <query id="NIG040100_SLAB_COMM.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         SELECT SLAB_WAY,HCR_CLF,STL_GRD,SLAB_WTH,SLAB_LEN,ORD_NO,
                PRODNM_CD    
           FROM TBG02_SLAB_COMM
          WHERE SLAB_NO = ?
        ]]>
    </query>
    <query id="NIG040100_STD_SEARCH.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         SELECT YARD_ADDR ,YARD_COND_CLF
          FROM TBG04_YARD_STD_SEARCH a,
         TBG04_STD_SLAB_YARD  b
       WHERE a.YARD_COND_CLF = b.ADDR_SERVICE 
        AND  ? like a.STL_GRD ||'%'
        ]]>
    </query>
    <query id="NIG040100_YARD_MAP.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
        SELECT STORELAY,SLAB_NO 
          FROM TBG04_SLAB_YARD  
         WHERE  YARD_ADDR = ?  
        ]]>
    </query>
    <query id="NIG040100_SLAB_YARD.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
        SELECT
           SLAB_NO,STL_GRD,PRODNM_CD,ORD_NO,SLAB_LEN,SLAB_WTH,YARD_ADDR,STORELAY
         FROM 
         (
           SELECT  SLAB_NO,STL_GRD,PRODNM_CD,ORD_NO,SLAB_LEN,SLAB_WTH 
             FROM  TBG02_SLAB_COMM   
            WHERE  SLAB_NO =     
             (SELECT  SLAB_NO
                FROM 
                (
                  SELECT  a.* 
                     , ROW_NUMBER() OVER (ORDER BY STORELAY DESC) RN
                  FROM    TBG04_SLAB_YARD a
                  WHERE a.YARD_ADDR = ?
                    AND  a.SLAB_NO IS NOT NULL 
                )
                WHERE RN = 1
             )
         ) a,  
         (
            SELECT  YARD_ADDR,STORELAY
              FROM 
            (
              SELECT  a.* 
                    , ROW_NUMBER() OVER (ORDER BY STORELAY DESC) RN
                FROM    TBG04_SLAB_YARD a
               WHERE a.YARD_ADDR = ?
                AND  a.SLAB_NO IS NOT NULL 
            )
            WHERE RN = 1
     
        ) b
        ]]>
    </query>
     <query id="NIG040100_YARD_COMMAND.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
         SELECT MAX(ORD_SEQ) ORD_SEQ  
           FROM TBG04_SLAB_CRANE_ORDER 
        ]]>
    </query>
     <query id="NIG040100_YARD_COMMAND.insert" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
       INSERT TBG04_SLAB_CRANE_ORDER INTO
       (
          ORD_SEQ
         ,AREA_CD
         ,CR_NO
         ,FROM_ADDR
         ,TO_ADDR
         ,SLAB_CNT
         ,ORD_DTIME
         ,ORD_STAT
       )
       VALUES 
       ( 
          ?
         ,?
         ,?
         ,'A0'
         ,?
         ,1
         ,to_char(sysdate,'yyyymmddhh24miss')
         ,'1'  
       )
        ]]>
    </query>
</queryMap>