XinYu_RZMES/.svn/pristine/e8/e81af6bab112bc8e1f5fc7dc47b8422307054773.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="充当超量检查">
              
	<query id="ORD_CHK.SELECT" desc="订单余重" fetchSize="10">
        <![CDATA[
			
--检查发货完成没有结束的
--检查发货完成没有结束的
SELECT A.ORD_NO,A.ORD_SEQ
  FROM TBE02_ORD_PRC    A
 WHERE A.ORD_NO       = ?
   AND A.ORD_SEQ      = ?
   AND (A.ORD_PRC_WGT   + A.PROD_END_WGT + A.SHIP_END_WGT > A.WGT_ACVAL_MAX OR  A.SHIP_END_WGT > A.WGT_ACVAL_MAX )
			
		]]>
    </query> 
</queryMap>