XinYu_RZMES/.svn/pristine/31/31d30e773abb0d6550ad90ced2c85839f988abc2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="合同完成情况汇总">

	<query id="UID087777_UPDATE_ORDPROGCD" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBE02_ORD_PRC T
			   SET T.ORD_PROG_CD   = NVL(:1, T.ORD_PROG_CD),
				   T.PROD_END_GP   = '',
				   T.PROD_END_DATE = '',
				   T.SHIP_END_DATE = ''
			 WHERE T.ORD_NO = :2
			   AND T.ORD_SEQ LIKE :3||'%'
		]]>
	</query> 
	<query id="UID087777_UPDATE1_ORDWGTMIN" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBE02_ORD_PRC T              --修改订单重量下限  TBE02_ORD_PRC
			   SET T.WGT_ACVAL_MIN = NVL(:1 ,  T.WGT_ACVAL_MIN)
			 WHERE T.ORD_NO = :2
			   AND T.ORD_SEQ LIKE :3||'%'
		]]>
	</query> 
	<query id="UID087777_UPDATE2_ORDWGTMIN" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBA01_ORD_LINE T --修改订单重量下限  TBA01_ORD_LINE
			   SET T.WGT_ACVAL_MIN = NVL(:1 , T.WGT_ACVAL_MIN )
			 WHERE T.ORD_NO = :2
			   AND T.ORD_SEQ LIKE :3||'%'
		]]>
	</query> 
	<query id="UID087777_UPDATE1_ORDWGTMAX" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBE02_ORD_PRC T --修改订单重量上限  TBE02_ORD_PRC
			   SET T.WGT_ACVAL_MAX = NVL(:1 , T.WGT_ACVAL_MAX )
			 WHERE T.ORD_NO = :2
			   AND T.ORD_SEQ LIKE :3||'%'
		]]>
	</query> 
	<query id="UID087777_UPDATE2_ORDWGTMAX" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBA01_ORD_LINE T --修改订单重量上限  TBA01_ORD_LINE
			   SET T.WGT_ACVAL_MAX = NVL(:1 , T.WGT_ACVAL_MAX)
			 WHERE T.ORD_NO = :2
			   AND T.ORD_SEQ LIKE :3||'%'
		]]>
	</query> 
	<query id="UID087777_UPDATE1_DELTODATE" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBE02_ORD_PRC T  --修改订单交货期  TBE02_ORD_PRC
			   SET T.DEL_TO_DATE = :1
			 WHERE T.ORD_NO = :2
			   AND T.ORD_SEQ LIKE :3||'%'
		]]>
	</query> 
	<query id="UID087777_UPDATE2_DELTODATE" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBA01_ORD_LINE T  --修改订单交货期  TBA01_ORD_LINE
			   SET T.ORD_DEVLMT_DATE = :1,
				   T.CMT_DLIV_DEVLMT_DATE = :2
			 WHERE T.ORD_NO = :3
			   AND T.ORD_SEQ LIKE :4||'%'
		]]>
	</query> 
	<query id="UID087777_UPDATE3_DELTODATE" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBB01_ORD_HEAD T  --修改订单交货期  TBB01_ORD_HEAD
			   SET T.ORD_DEVLMT_DATE = :1
			 WHERE T.ORD_NO = :2
			   AND T.ORD_SEQ LIKE :3||'%'
		]]>
	</query> 
</queryMap>