XinYu_LZMES/.svn/pristine/4c/4c4d26f6fcc96c42019531dbcb32a81e24390a6f.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="原料库存现况查询">
	<query id="UIM010070_01.SELECT"  desc="查询区域信息">
	 <![CDATA[
		select distinct (a.area_no),
		                a.area_name || '(' ||
		                (select min(clf_row)
		                   from c_tbk08_coil_yard
		                  where area_no = a.AREA_NO) || '-' ||
		                (select max(clf_row)
		                   from c_tbk08_coil_yard
		                  where area_no = a.AREA_NO) || ') 剩余垛位:' ||
		                (select count(1)
		                   from c_tbk08_coil_yard
		                  where area_no = a.AREA_NO
		                    and coil_no is null
		                    and clf_fl = 1) area_name
		  from c_tbk08_coil_yard_area a, c_tbk08_coil_yard y
		 where a.AREA_NO = y.AREA_NO
		   and a.area_type = ?
		 order by a.AREA_NO
        ]]>
	</query>
</queryMap>