XinYu_RZMES/.svn/pristine/25/259c484b54df27d9719ebf8f3b661b637095d971.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
    <query id="UIG040023_INIT.select" desc="   " fetchSize="10">
        <![CDATA[
		 SELECT SUBSTR(T.YARD_ADDR,5,1) SLAB_ROW,SUBSTR(T.YARD_ADDR,2,2) SLAB_COL FROM TBG04_SLAB_YARD T
	      WHERE T.YARD_ADDR LIKE :1||'%' 
	        AND SUBSTR(T.YARD_ADDR,4,1) = '-' 
	      GROUP BY SUBSTR(T.YARD_ADDR,5,1),SUBSTR(T.YARD_ADDR,2,2)
	      ORDER BY SUBSTR(T.YARD_ADDR,5,1),SUBSTR(T.YARD_ADDR,2,2) 
        ]]>
    </query> 
	<query id="UIG040023_INIT1.select" desc="   " fetchSize="10">
        <![CDATA[
		 SELECT SUBSTR(T.YARD_ADDR,3,2) SLAB_ROW,SUBSTR(T.YARD_ADDR,5,2) SLAB_COL FROM TBG04_SLAB_YARD T
	      WHERE T.YARD_ADDR LIKE :1||'%' 
	      GROUP BY SUBSTR(T.YARD_ADDR,3,2),SUBSTR(T.YARD_ADDR,5,2)
	      ORDER BY SUBSTR(T.YARD_ADDR,3,2),SUBSTR(T.YARD_ADDR,5,2) 
        ]]>
    </query> 
    <query id="UIG040023_01.select" desc="板坯库中所有位置的板坯数" fetchSize="10">
        <![CDATA[
			SELECT T.YARD_ADDR,SUM(DECODE(NVL(SLAB_NO,0),'0',0,1)) SLAB_CNT,
			    PKG_UIG.FIND_ORDFL_ONYARD(T.YARD_ADDR,:1) FLAG
		   FROM TBG04_SLAB_YARD T
	      WHERE T.YARD_ADDR LIKE :2||'%'
	      AND   SUBSTR(YARD_ADDR,4,1) = '-' 
	      GROUP BY T.YARD_ADDR 
	      ORDER BY SUBSTR(T.YARD_ADDR,5,1),SUBSTR(T.YARD_ADDR,2,2)
        ]]>
    </query> 
	<query id="UIG040023_11.select" desc="热轧原料库中所有位置的板坯数" fetchSize="10">
        <![CDATA[
			SELECT T.YARD_ADDR,SUM(DECODE(NVL(SLAB_NO,0),'0',0,1)) SLAB_CNT,
			    PKG_UIG.FIND_ORDFL_ONYARD1(T.YARD_ADDR) FLAG
		   FROM TBG04_SLAB_YARD T
	      WHERE T.YARD_ADDR LIKE :1||'%'
	      GROUP BY T.YARD_ADDR 
	      ORDER BY SUBSTR(T.YARD_ADDR,3,2),SUBSTR(T.YARD_ADDR,5,2) 
        ]]>
    </query>   
    <query id="UIG040021_TOT.select" desc=" UIG040030 INTI_PARAM   ">
        <![CDATA[
       SELECT
            ALL_T_CNT,PL_SLAB_CNT,CORR_DIR_SLAB_CNT,CORR_RST_SLAB_CNT,
            ORD_SLAB_CNT,NONORD_SLAB_CNT
       FROM 
       ( 
        SELECT  COUNT(slab_no) ALL_T_CNT
 	     FROM TBG04_SLAB_YARD  
	     WHERE  YARD_ADDR like 'L%'
	   ) a ,
	   ( 
         SELECT  count(a.SLAB_NO) PL_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE SUBSTR(PRODNM_CD,1,1) = 'P'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) b,
	   ( 
         SELECT  count(a.SLAB_NO) CORR_DIR_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE CORRECT_RSLT_CD = '1'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) c, 
	   ( 
         SELECT  count(a.SLAB_NO) CORR_RST_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE CORRECT_RSLT_CD = '2'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) d ,
	   ( 
         SELECT  count(a.SLAB_NO) ORD_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE ORD_FL = '1'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) e,
	   ( 
         SELECT  count(a.SLAB_NO) NONORD_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE ORD_FL = '2'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) f     
        ]]>
    </query>
</queryMap>