XinYu_RZMES/.svn/pristine/a5/a54522fe4050af369bbe68bf4075a1972f965db6.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="标准是否有效无效标准">
	
	<query  id="UIB016001_01.SELECT" desc="获得错误代码的相信信息 ErrorMessage">
		 SELECT    DISTINCT
				   INGR.PRDNM_CD , INGR.SPEC_ABBSYM , INGR.SPEC_STL_GRD , INGR.USED_YN
		 FROM      TBB01_SPEC_INGR  INGR , TBB01_SPEC_QLTY  QLTY
		 WHERE     INGR.SPEC_ABBSYM        =    QLTY.SPEC_ABBSYM
		 AND       INGR.SPEC_STL_GRD       =    QLTY.SPEC_STL_GRD
		 AND       INGR.PRDNM_CD           =    QLTY.PRDNM_CD
		 AND       INGR.USED_YN            =    DECODE(?,'ALL' , INGR.USED_YN , ?)
		 ORDER BY  INGR.SPEC_ABBSYM
	</query>
	
	<query id="UIB016001_01.CALL" desc="标准过滤有效无效">
		{call ZL_NORM_MANAGE.SAVE_SPEC_USED(?,?,?,?,?)}
	</query>
	
</queryMap>