XinYu_RZMES/.svn/pristine/71/710e554683187759c5adab0dcf13f339cd5a6b9f.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">

	<query id="UCG040050_01.select" desc="it's selected query  from TBG04_SLAB_YARD table" fetchSize="10">
		<![CDATA[
			 
					
           SELECT STORELAY
                ,a.SLAB_NO
                ,b.SLAB_THK
                ,b.SLAB_WTH 
                ,b.SLAB_LEN
                ,b.SLAB_WGT
                ,b.SF_METHOD
                ,b.RHF_SCH_YN    
            FROM TBG04_SLAB_YARD a,
                 TBG02_SLAB_COMM b 
           WHERE a.SLAB_NO = b.SLAB_NO(+) 
            AND YARD_ADDR  = ?
           ORDER BY STORELAY DESC					  
        ]]>
	</query> 
	<query id="UCG040050.update" desc="it's selected query  from TBG04_SLAB_YARD table" fetchSize="10">
		<![CDATA[
			UPDATE TBG04_SLAB_YARD SET
				SLAB_NO = ?
			WHERE YARD_ADDR  = ?
			  AND STORELAY = ?
        ]]>
	</query> 
    
</queryMap>