XinYu_RZMES/.svn/pristine/a6/a653e4004f06e71ee647ccb4ae278c351d5985fc.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG040020_01.select" desc="板坯库区域信息查询 数据来源:TBG04_SLAB_YARD">
        <![CDATA[
       SELECT  a.YARD_ADDR,a.ROW_COUNT||'__('||nvl(b.ROW_COUNT,0)||')' ROW_COUNT,
               RHF_SCH
         FROM                                                 
         (
          SELECT DISTINCT YARD_ADDR
             	,COUNT(slab_no) ROW_COUNT
         	FROM TBG04_SLAB_YARD  
         	WHERE SUBSTR(YARD_ADDR,1,2) = ?
         	GROUP BY YARD_ADDR
         ) a,
         (
          SELECT DISTINCT YARD_ADDR
	           ,COUNT(a.slab_no) ROW_COUNT
	           ,'Y' RHF_SCH
	        FROM TBG04_SLAB_YARD a,
	             TBF02_MILL_IDX  b  
	        WHERE L2_SEND = 'Y'
	         AND  a.SLAB_NO = b.SLAB_NO 
	         AND  SUBSTR(YARD_ADDR,1,2) = ?
			 AND  b.STATUS_CD = 'A'
	        GROUP BY YARD_ADDR
	     ) b    
       WHERE a.YARD_ADDR = b.YARD_ADDR(+)
        ]]>
    </query>
    <query id="UIG040020_02.select" desc="板坯库区域信息查询 数据来源:TBG04_SLAB_YARD">
        <![CDATA[
       SELECT
         ALL_T_CNT,ALL_T_WGT,ALL_ORD_T_CNT,ALL_NONORD_T_CNT,ALL_RHF_SCH,
         LOC_T_CNT,LOC_T_WGT,LOC_ORD_CNT,LOC_NONORD_CNT,LOC_RHF_SCH
       FROM
       (
          SELECT  COUNT(SLAB_NO) ALL_T_CNT
           FROM TBG04_SLAB_YARD  
        WHERE  YARD_ADDR LIKE 'Z%'
  
       )  T1,
       (
          SELECT SUM(SLAB_WGT)/1000 ALL_T_WGT
          FROM TBG04_SLAB_YARD A
               ,TBG02_SLAB_COMM B
          WHERE A.SLAB_NO = B.SLAB_NO    
          AND   A.YARD_ADDR LIKE 'Z%'  
       )T5,
       (
          SELECT  COUNT(A.SLAB_NO) ALL_ORD_T_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 'Z%'
  
       )  T2,
       (
          SELECT  COUNT(A.SLAB_NO) ALL_NONORD_T_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 'Z%'
  
       )  T3,
       (
          SELECT  COUNT(A.SLAB_NO) ALL_RHF_SCH
            FROM TBG04_SLAB_YARD A,
                 TBG02_SLAB_COMM B,
                 TBF02_MILL_IDX  C  
       WHERE C.L2_SEND = 'Y'
         AND  A.SLAB_NO = C.SLAB_NO 
         AND  A.SLAB_NO = B.SLAB_NO    
         AND  SUBSTR(YARD_ADDR,1,2) LIKE 'Z%' 
       AND  C.STATUS_CD = 'A'
       ) T4, 
       (
          SELECT  COUNT(A.SLAB_NO) LOC_T_CNT
          FROM TBG04_SLAB_YARD  A,
               TBG02_SLAB_COMM  B
      WHERE SUBSTR(YARD_ADDR,1,2) = ? 
          AND   A.SLAB_NO = B.SLAB_NO
       ) L1 ,
       (
         SELECT SUM(SLAB_WGT)/1000 LOC_T_WGT
          FROM TBG04_SLAB_YARD A
               ,TBG02_SLAB_COMM B
          WHERE A.SLAB_NO = B.SLAB_NO
          AND SUBSTR(A.YARD_ADDR,1,2) = ?
       )L5,
       (
         SELECT  COUNT(A.SLAB_NO) LOC_ORD_CNT
           FROM TBG04_SLAB_YARD A,
                TBG02_SLAB_COMM B  
       WHERE ORD_FL = '1'
         AND  A.SLAB_NO = B.SLAB_NO    
         AND  SUBSTR(YARD_ADDR,1,2) = ? 
     
       )  L2 ,
       (
         SELECT  COUNT(A.SLAB_NO) LOC_NONORD_CNT
           FROM TBG04_SLAB_YARD A,
                TBG02_SLAB_COMM B  
        WHERE ORD_FL = '2'
         AND  A.SLAB_NO = B.SLAB_NO    
         AND  SUBSTR(YARD_ADDR,1,2) = ? 
     
       )  L3,
       (
          SELECT  COUNT(A.SLAB_NO) LOC_RHF_SCH
            FROM TBG04_SLAB_YARD A,
                 TBG02_SLAB_COMM B,
                 TBF02_MILL_IDX  C  
       WHERE C.L2_SEND = 'Y'
        AND  A.SLAB_NO = C.SLAB_NO 
        AND  A.SLAB_NO = B.SLAB_NO    
        AND  SUBSTR(YARD_ADDR,1,2) = ? 
            AND  C.STATUS_CD = 'A'
       )  L4 
	 
        ]]>
    </query>
	<query id="UIG040020_03.select" desc="板坯库区域信息查询 数据来源:TBG04_SLAB_YARD">
        <![CDATA[
       SELECT  a.YARD_ADDR,a.ROW_COUNT||'__('||nvl(b.ROW_COUNT,0)||')' ROW_COUNT,
               RHF_SCH
         FROM                                                 
         (
          SELECT DISTINCT YARD_ADDR
             	,COUNT(slab_no) ROW_COUNT
         	FROM TBG04_SLAB_YARD  
         	WHERE SUBSTR(YARD_ADDR,1,2) = ?
         	GROUP BY YARD_ADDR
         ) a,
         (
          SELECT DISTINCT YARD_ADDR
	           ,COUNT(a.slab_no) ROW_COUNT
	           ,'Y' RHF_SCH
	        FROM TBG04_SLAB_YARD a,
	             tbg02_slab_comm  b  
	        WHERE b.ORD_FL  = '2'
	         AND  a.SLAB_NO = b.SLAB_NO 
	         AND  SUBSTR(YARD_ADDR,1,2) = ?
	        GROUP BY YARD_ADDR
	     ) b    
       WHERE a.YARD_ADDR = b.YARD_ADDR(+)
        ]]>
    </query>
</queryMap>