XinYu_RZMES/.svn/pristine/72/72505d13d0e2a789ef9cefac4af9a8df943f1f6d.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
    <query id="UIG040042_01.select" desc="" fetchSize="10">
        <![CDATA[
          SELECT '' CHK,FROM_ADDR,TO_ADDR,SLAB_CNT,CR_NO,REG_DTIME,SEQ_NO,ORD_SLAB_NO1 SLAB_NO,ORD_TYPE
		  FROM TBG04_SLAB_CRANE_ORDER
	      WHERE DECODE(FROM_ADDR,'A1','Z1','A2','Z1','A3','Z2','A4','Z2','A5','Z3','A6','Z3','C7','Z1','C8','Z1','C9','Z2','C10','Z2','C11','Z3','C12','Z3',FROM_ADDR) LIKE ?||'%'
		  AND CR_NO LIKE ?||'%'
		  AND ORD_TYPE LIKE ?||'%'
		  AND ORD_STAT = '1'
		  ORDER BY REG_DTIME
        ]]>
    </query> 
     <query id="UIG040042_02.select" desc="" fetchSize="10">
        <![CDATA[
          SELECT '' CHK,STORELAY ,SLAB_NO ,YARD_ADDR FROM TBG04_SLAB_YARD
		  WHERE  YARD_ADDR = ? ORDER BY STORELAY DESC
        ]]>
    </query> 
    <query id="UIG040042_01.update" desc="" fetchSize="10">
        <![CDATA[
          UPDATE TBG04_SLAB_YARD SET SLAB_NO = ?
								 ,ORD_FLAG = ''
		  WHERE YARD_ADDR = ? 
		    AND STORELAY = ?  
        ]]>
    </query> 
	<query id="UIG040042_02.update" desc="" fetchSize="10">
        <![CDATA[
			UPDATE TBG04_SLAB_CRANE_ORDER SET ORD_STAT = '2'
			WHERE SEQ_NO = ? 
        ]]>
    </query>
    <query id="UIG040042_L2_LOCK.insert" desc="" fetchSize="10">
        <![CDATA[
			INSERT INTO TBH06_L1_SEND_SLAB_LOCK 
	      (	 SEQ_NO
			,MSG_FLAG 
            ,TC_ID
            ,TRANS_DTIME
            ,LOCK_FLAG
            ,LINE_POSITION
            ,SEND_DTIME
		  ) VALUES
		  ( 
		    TBH06_L1_SEND_SLAB_LOCK_SEQ.NEXTVAL
		   ,'N'
		   ,?
		   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		   ,?
		   ,?
		   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		  )	  
        ]]>
    </query>
	
	<query id="UIG040042_L2_LOCK.update" desc="" fetchSize="10">
        <![CDATA[
          UPDATE  TBH06_L1_SEND_SLAB_LOCK  SET
          
             MSG_FLAG       = 'N'
            ,TC_ID          = ?
            ,TRANS_DTIME    = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            ,LOCK_FLAG      = ?
            ,LINE_POSITION  = ?
            ,SEND_DTIME     = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
           WHERE SEQ_NO = ?
        ]]>
    </query>
    <query id="UIG040042_L1_TAKEIN.insert" desc="" fetchSize="10">
        <![CDATA[
			INSERT INTO TBH06_L1_SEND_SLAB_TAKEIN  
	      (	 SEQ_NO
			,MSG_FLAG  
            ,TC_ID
            ,TRANS_DTIME
            ,SLAB_NO
            ,LINE_POSITION
            ,HCR_CLF 
            ,DEST_POSITION
		  ) VALUES
		  ( 
		    TBH06_L1_SEND_SLAB_TAKEIN_SEQ.NEXTVAL
		   ,'N'
		   ,?
		   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		   ,?
		   ,?
		   ,?
		   ,?
		  )	  
        ]]>
    </query>
	<query id="UIG040042_L1_TAKEIN.update" desc="" fetchSize="10">
        <![CDATA[
          UPDATE TBH06_L1_SEND_SLAB_TAKEIN SET    
             MSG_FLAG       = 'N' 
            ,TC_ID          =  ? 
            ,TRANS_DTIME    = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            ,SLAB_NO        = ?
            ,LINE_POSITION  = ?
            ,HCR_CLF        = ?
            ,DEST_POSITION  = ?
		  WHERE SEQ_NO = ?
        ]]>
    </query>
	
	<query id="UIG040042_L2_TAKEIN.insert" desc="" fetchSize="10">
        <![CDATA[
            INSERT INTO TBH06_L2_SEND_SLAB_TAKEIN  
          (  SEQ_NO
            ,MSG_FLAG  
            ,TC_ID
            ,TRANS_DTIME
			,SEND_DC
			,RECV_DC
			,SERIAL_NO
			,RESERVED 
            ,LINE_POSITON
			,SLAB_NO
			,COIL_NO
            ,LINE_UP_DTIME 
          ) VALUES
          ( 
            TBH06_L1_SEND_SLAB_TAKEIN_SEQ.NEXTVAL
           ,'N'
           ,?
           ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		   ,'FU'
		   ,'HM'
		   ,''
		   ,''   			
           ,?
           ,?
           ,?
           ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
          )   
        ]]>
    </query>
	<query id="UIG040042_L2_TAKEIN.update" desc="" fetchSize="10">
        <![CDATA[
          UPDATE  TBH06_L2_SEND_SLAB_TAKEIN   SET
           
             MSG_FLAG        =  'N'
            ,TC_ID           = ?
            ,TRANS_DTIME     = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            ,SEND_DC         = 'FU'
            ,RECV_DC         = 'HM'
            ,SERIAL_NO       = ' '
            ,RESERVED        = ' '
            ,LINE_POSITON    = ?
            ,SLAB_NO         = ?
            ,COIL_NO         = ? 
            ,LINE_UP_DTIME   = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
           WHERE SEQ_NO = ?
        ]]>
    </query>
	
	<query id="UIG040042_L1_TAKEOUT.insert" desc="" fetchSize="10">
        <![CDATA[
			INSERT INTO TBH06_L1_SEND_SLAB_TAKEOUT  
        	(   SEQ_NO
				,MSG_FLAG  
				,TC_ID
				,TRANS_DTIME
				,SLAB_NO
				,LINE_POSITION
				,YARD_POS
				,TAKE_OUT_DTIME
		  ) VALUES
		  ( 
			TBH06_L1_SEND_SLAB_TAKEIN_SEQ.NEXTVAL
		   ,'N'
		   ,?
		   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		   ,?
		   ,?
		   ,?
		   ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		  )	  
        ]]>
    </query>
	<query id="UIG040042_L1_TAKEOUT.update" desc="" fetchSize="10">
        <![CDATA[
           UPDATE TBH06_L1_SEND_SLAB_TAKEOUT   SET 
                MSG_FLAG       = 'N' 
               ,TC_ID          = ?
               ,TRANS_DTIME    = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
               ,SLAB_NO        = ?
               ,LINE_POSITION  = ?
               ,YARD_POS       = ? 
               ,TAKE_OUT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
           WHERE SEQ_NO = ?
        ]]>
    </query>
	<query id="UIG040042_COIL_NO.select" desc="" fetchSize="10">
        <![CDATA[
          SELECT COIL_NO,HCR_CLF 
			FROM TBF02_SPEC_MILL
          WHERE  SLAB_NO = ? AND STATUS_CD = 'A'
        ]]>
    </query>
    <query id="UIG040042_03.select" desc="" fetchSize="10">
        <![CDATA[
          SELECT YARD_ADDR,LOCK_YN FROM TBG04_STD_SLAB_YARD
		  WHERE  YARD_ADDR = ? 
        ]]>
    </query>
	<query id="UIG040042_04.select" desc=" 板坯入库记录修改 " fetchSize="10">
        <![CDATA[
          update tbg02_slab_comm 
          set    hcr_clf = 'C'  
                 ,slab_stock_ent_dtime = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
          where  slab_no = ?
        ]]>
    </query> 
    <query id="UIG040042_05.select" desc=" 板坯入库记录修改 " fetchSize="10">
        <![CDATA[
          SELECT       ROLL_MANA_NO||'-'|| ROLL_SLAB_SEQ ROLL_SEQ
             , a.SLAB_NO 
             , 'A7' TO_ADDR
             , SUBSTR(A.CUR_LOAD_LOC,1,6)  FROM_ADDR
             , SUBSTR(A.CUR_LOAD_LOC,7,2)  SLAB_CNT
             , DECODE(SUBSTR(A.CUR_LOAD_LOC,1,2),'Z1','一跨','Z2','二跨','Z3','三跨') cr_no
             , '' CHK    
             ,'B' ORD_TYPE
             ,'' seq_no
         FROM TBG02_SLAB_COMM a ,
             (SELECT b.SLAB_NO,b.COIL_NO,b.ROLL_MANA_NO,b.ROLL_SLAB_SEQ,b.spec_stl_grd   
                FROM  TBF02_MILL_IDX a,
                      TBF02_SPEC_MILL b
               WHERE a.SLAB_EDT_SEQ = b.SLAB_EDT_SEQ 
                 AND b.STATUS_CD = 'A'
                 AND L2_SEND = 'Y'        
             ) d
            WHERE a.SLAB_NO = d.SLAB_NO  
            and   a.CUR_LOAD_LOC NOT LIKE 'A7%'
            AND   DECODE(A.CUR_LOAD_LOC,'A1','Z1','A2','Z1','A3','Z2','A4','Z2','A5','Z3','A6','Z3','C7','Z1','C8','Z1','C9','Z2','C10','Z2','C11','Z3','C12','Z3',A.CUR_LOAD_LOC) LIKE ?||'%'
          ORDER BY  d.ROLL_MANA_NO,d.ROLL_SLAB_SEQ
        ]]>
    </query>
    <query id="UIG040042_std_yd.update" desc=" 板坯入库记录修改 " fetchSize="10">
        <![CDATA[
          UPDATE TBG04_STD_SLAB_YARD 
           SET    LOCK_YN = ?  
          WHERE  YARD_ADDR = ?
        ]]>
    </query> 
    <query id="UIG040042_FROM_CMD.select" desc="" fetchSize="10">
        <![CDATA[
          SELECT   ORD_SLAB_NO1,ORD_SLAB_NO2,ORD_SLAB_NO3  
		  FROM TBG04_SLAB_CRANE_ORDER
	      WHERE FROM_ADDR LIKE ?|| '%' 
		  AND ORD_STAT = '1'
        ]]>
    </query> 
     <query id="UIG040042_FROM_YD.update" desc="" fetchSize="10">
        <![CDATA[
          UPDATE TBG04_SLAB_YARD SET
				  SLAB_NO = ''
				  ,BEF_STORE_LOC = ''
				  ,CR_NO = ''
		          ,ORD_FLAG = ''
		          ,REG_ID =  ''
		          ,REG_DTIME = ''
		  WHERE YARD_ADDR = ?  
		  AND  SLAB_NO = ?
        ]]>
    </query> 
    <query id="UIG040042_TO_ADDR.select" desc="" fetchSize="10">
        <![CDATA[
          SELECT  STORELAY ,SLAB_NO ,YARD_ADDR FROM TBG04_SLAB_YARD
		  WHERE  YARD_ADDR = ? 
		   AND   SLAB_NO IS NOT NULL
		   ORDER BY STORELAY DESC
        ]]>
    </query> 
    <query id="UIG040042_TO_YD.update" desc="" fetchSize="10">
        <![CDATA[
			UPDATE TBG04_SLAB_YARD SET
              			SLAB_NO = ?
						  ,bef_store_loc = ?
						  ,cr_no = ?
						  ,reg_id = 'UIG040042'
						  ,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')  
						  ,ORD_FLAG = ''
			WHERE YARD_ADDR = ? 
			AND STORELAY = ?
        ]]>
    </query> 
    <query id="UIG040042_SLAB.update" desc="  " fetchSize="10">
        <![CDATA[
          UPDATE TBG02_SLAB_COMM SET 
               CUR_LOAD_LOC   = ?
              ,HCR_CLF        = 'C' 
              ,SLAB_STOCK_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')  
              ,CUR_LOAD_LOC_DTIME   = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
              ,BEF_LOAD_LOC         = CUR_LOAD_LOC
              ,BEF_LOAD_LOC_DTIME   = CUR_LOAD_LOC_DTIME
              ,MILL_SCH_STAT   = ?
           WHERE SLAB_NO = ?
        ]]>
    </query> 
     <query id="UIG040042_SPEC_SLAB.select" desc="" fetchSize="10">
        <![CDATA[
        SELECT  a.MILL_FL,b.HCR_CLF  
          FROM  TBF01_SPEC_SLAB a ,
                TBG02_SLAB_COMM b 
	     WHERE  SLAB_MANA_NO = PLAN_SLAB_NO
	        AND  b.HCR_CLF = 'H'
           AND  SLAB_NO = ? 
        ]]>
    </query>  
    <query id="UIG040042_MILL_SCH_CHK.select" desc="" fetchSize="10">
        <![CDATA[
       SELECT YARD_ADDR||STORELAY YARD_ADDR,a.SLAB_NO,SLAB_EDT_SEQ
         FROM TBG04_SLAB_YARD a,
        (
         SELECT a.SLAB_NO ,b.SLAB_EDT_SEQ
           FROM  TBG02_SLAB_COMM a, 
              TBF02_MILL_IDX b, 
              TBF02_SPEC_MILL D,
           (SELECT SLAB_EDT_SEQ 
             FROM TBF02_MILL_IDX  
            WHERE SLAB_NO = ?
             AND L2_SEND = 'Y' 
           ) c
         WHERE  ( a.MILL_SCH_STAT IS NULL OR a.MILL_SCH_STAT != 'A7T') 
          AND   D.STATUS_CD = 'A'
          AND 	D.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ
          AND   b.SLAB_NO = a.SLAB_NO  
          AND   b.SLAB_EDT_SEQ < c.SLAB_EDT_SEQ   
         ORDER BY  b.SLAB_EDT_SEQ DESC
         )  b
         WHERE  a.SLAB_NO = b.SLAB_NO   
           AND  a.SLAB_NO IS NOT NULL
           AND  ROWNUM =1 
        ]]>
    </query> 
	<query id="UIG040042_SPEC_SLAB_MILL_FL.select" desc="" fetchSize="10">
        <![CDATA[
        select t.MILL_FL from tbf01_spec_slab t 
                ,tbg02_slab_comm tt
                where t.SLAB_MANA_NO  = tt.PLAN_SLAB_NO 
                and   tt.SLAB_NO = ?
        ]]>
    </query>
	<query id="UIG040042_L1_SLAB_TAKEIN.delete" desc="" fetchSize="10">
        <![CDATA[
             DELETE  TBH06_L1_SEND_SLAB_TAKEIN A WHERE A.TRANS_DTIME < ?
        ]]>
    </query>
</queryMap>