XinYu_RZMES/.svn/pristine/e4/e48d8ccd1a6af9b8b6d8353796a51d5b01e09ab2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
     
    <query id="NIH050010_COIL.select" desc=" " fetchSize="10">
		<![CDATA[
	     SELECT  STL_GRD
	          ,  ORD_FL
	          ,  COIL_WTH
	          ,  COIL_OUTDIA
	          ,  ACT_WGT
	          ,  PRODNM_CD
	          ,  SPM_YN    
	          ,  RTN_CAU_CD
	          ,  SCRAP_CAUSE_CD
           FROM  TBH02_COIL_COMM   
	      WHERE   
	               COIL_NO  = ?
	     
		]]>
	</query>
    
	<query id="NIH050010_STD_YARD.select" desc=" " fetchSize="10">
		<![CDATA[
	     SELECT YARD_ADDR ,FROM_STL_GRD,TO_STL_GRD
	           ,STL_GRD1,STL_GRD2,STL_GRD3,STL_GRD4
	           ,STL_GRD5,STL_GRD6,STL_GRD7
	       FROM TBH05_YARD_STD_STOCK
	      WHERE SUBSTR(AREA_KIND,1,1) = ? 
		]]>
	</query>
	
	<query id="NIH050010_LOAD_YARD.select" desc=" " fetchSize="10">
		<![CDATA[
	    SELECT  YARD_ADDR,STORELAY,COIL_NO
        FROM 
        (      
           SELECT YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ YARD_ADDR
                 ,STORELAY
	             ,COIL_NO
	         FROM TBH05_COIL_YARD
	        WHERE (COIL_NO IS NULL OR COIL_NO = '')  
	          AND  (RESERV_FL IS NULL OR  RESERV_FL = '')
	          AND  YARD_CLF||STEP_CLF LIKE ?||'%'    
	           
	    )       
	     
        ORDER BY STORELAY, YARD_ADDR   
		]]>
	</query>
	<query id="NIH050010_ORDER_SEQ.select" desc=" " fetchSize="10">
		<![CDATA[
	    SELECT  MAX(ORD_SEQ) ORD_SEQ
        FROM  TBH05_COIL_CRANE_ORDER 
		]]>
	</query>
	<query id="NIH050010_NEW_ADDR.select" desc=" " fetchSize="10">
		<![CDATA[
	    SELECT  YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ YARD_ADDR
        FROM  TBH05_COIL_YARD
        WHERE YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ = ? 
          AND COIL_NO IS NOT NULL 
		]]>
	</query>
	<query id="NIH050010_CR_COMM.select" desc=" " fetchSize="10">
		<![CDATA[
	    SELECT  ORD_SEQ,AREA_CD,CR_NO,FROM_ADDR,TO_ADDR,COIL_NO
        FROM  TBH05_COIL_CRANE_ORDER
	     WHERE COIL_NO = ? 
	       AND FROM_ADDR = ? 
	       AND TO_ADDR  =  ? 
	       AND ORD_STAT = '1'
		]]>
	</query>
	<query id="NIH050010_CR_COMM.update" desc=" " fetchSize="10">
		<![CDATA[
	    UPDATE  TBH05_COIL_CRANE_ORDER SET 
           CR_NO     = ? 
	     WHERE COIL_NO = ? 
	       AND FROM_ADDR = ? 
	       AND TO_ADDR  =  ? 
	       AND ORD_SEQ  =  ? 
		]]>
	</query>
	<query id="NIH050010_CR_COMM.insert" desc=" " fetchSize="10">
		<![CDATA[
		INSERT INTO TBH05_COIL_CRANE_ORDER
		(
		   ORD_SEQ
		  ,AREA_CD
		  ,CR_NO
		  ,FROM_ADDR
		  ,TO_ADDR
		  ,COIL_NO
		  ,ORD_STAT  
		  ,REG_ID
		  ,REG_DTIME 
		)
		VALUES
		(
		  COIL_CRANE_ORDER_SEQ.NEXTVAL
		 ,?
		 ,?
		 ,?
		 ,?
		 ,?
		 ,'1' 
		 ,'XinCoilYardDec'
		 ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		)
	     
		]]>
	</query>
	<query id="NIH050010_RES_YARD.update" desc=" " fetchSize="10">
		<![CDATA[
	    UPDATE  TBH05_COIL_YARD SET 
           RESERV_FL     = ?
	     WHERE YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ  = ?  
		]]>
	</query> 
	<query id="NIH050010_COIL_COMM.update" desc=" " fetchSize="10">
		<![CDATA[
	    UPDATE  TBH02_COIL_COMM SET 
           ROUTE     = ?
	     WHERE COIL_NO  = ?  
		]]>
	</query> 
	 		
</queryMap>