XinYu_RZMES/.svn/pristine/01/0108a652330b59d4ba9c245c22dfb2f466d93032.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH090010_01.select" desc=" 成品出库班报表 " fetchSize="10">
		<![CDATA[
			select ROWNUM,
       a.SHIP_INVNO,
       a.TRANS_CAR_NO,
       a.STL_GRD,
       a.OLD_SAMPL_NO,
       a.TOT_DEC_GRD,
       a.COIL_THK||'*'||a.COIL_WTH COIL_SPEC,
       a.ACT_WGT,
       '' REG_ID,
       '' REM
          from tbh02_coil_comm a,tbj01_dliv_dir b
       where a.DLIV_DIRNO = b.DLIV_DIRNO
             and a.SHIP_PROG_CD = '08'
			 --这里下面两个条件是否需要，收货单位、出库人、备注、出库班次、组、未定
			 -- and a.CUR_PROG_CD = 'SFF'
             --AND A.COIL_STAT = '3'
		]]>
	</query>
</queryMap>