XinYu_RZMES/.svn/pristine/d1/d14ea57dd3b8c10ad138936b20cfffb1609d6ac3.svn-base

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

	<query id="UIG040040_01.select" desc="it's selected query  from TBG04_SLAB_YARD table" fetchSize="10">
		<![CDATA[
		 SELECT a.CR_NO,'COMMON' ORD_KIND,a.FROM_ADDR,a.TO_ADDR,a.SLAB_CNT,a.ORD_DTIME,b.LOCK_YN,'N' CHK 
			FROM TBG04_SLAB_CRANE_ORDER a ,
			   TBG04_STD_SLAB_YARD  b 
			WHERE ORD_STAT = '1'
			  AND a.TO_ADDR = b.YARD_ADDR(+) 
			  AND SUBSTR(a.FROM_ADDR,1,1) != 'A'
			  AND SUBSTR(a.FROM_ADDR,1,1) != 'B'
			  AND a.CR_NO = ? 
			  AND SUBSTR(a.TO_ADDR,1,1) like ?||'%' 
        ]]>
	</query> 
	<query id="UIG040040_02.select" desc="it's selected query  from TBG04_SLAB_YARD table" fetchSize="10">
		<![CDATA[
		 SELECT  CR_NO,'LINE' ORD_KIND, FROM_ADDR, TO_ADDR, SLAB_CNT, ORD_DTIME, '' LOCK_YN,'N' CHK 
			FROM TBG04_SLAB_CRANE_ORDER    
			WHERE ORD_STAT = '1' 
			  AND  CR_NO = ?
			  AND SUBSTR( FROM_ADDR,1,1)  = 'B' OR  SUBSTR( FROM_ADDR,1,1)  = 'A'    
		  ]]>
	</query> 
	<query id="UIG040040_03.select" desc="it's selected query  from TBG04_SLAB_YARD table" fetchSize="10">
		<![CDATA[
		    SELECT a.CR_NO,CASE WHEN SUBSTR(a.FROM_ADDR,1,1)  = 'A' 
                        OR SUBSTR(a.FROM_ADDR,1,1)  = 'B'
                        THEN 'LINE' 
                      WHEN SUBSTR(a.TO_ADDR,1,1)    = 'A' 
                        THEN 'CHARGING'
                      ELSE 'COMM' 
                 END  ORD_KIND   , 
         a.FROM_ADDR,a.TO_ADDR,a.SLAB_CNT,a.ORD_DTIME,b.LOCK_YN,'N' CHK 
			FROM TBG04_SLAB_CRANE_ORDER a ,
			   TBG04_STD_SLAB_YARD  b 
			WHERE ORD_STAT = '1' 
			  AND a.CR_NO =  ?
			  AND a.TO_ADDR = b.YARD_ADDR(+)
			  
		   ]]>
	</query> 
	<query id="UIG040040_04.select" desc="it's selected query  from TBG04_SLAB_YARD table" fetchSize="10">
		<![CDATA[
		 SELECT a.CR_NO,'CHARGING' ORD_KIND,a.FROM_ADDR,a.TO_ADDR,a.SLAB_CNT,a.ORD_DTIME,b.LOCK_YN,'N' CHK 
			FROM TBG04_SLAB_CRANE_ORDER a ,
			   TBG04_STD_SLAB_YARD  b 
			WHERE ORD_STAT = '1'
			  AND a.TO_ADDR = b.YARD_ADDR(+) 
			  AND SUBSTR(a.FROM_ADDR,1,1) != 'A'
			  AND SUBSTR(a.FROM_ADDR,1,1) != 'B'
			  AND a.CR_NO = ? 
			  AND SUBSTR(a.TO_ADDR,1,1)  = 'A'
        ]]>
	</query>  
    
</queryMap>