XinYu_RZMES/.svn/pristine/ad/ad513c5013ef38efb99527c1dff1c1cb233548d2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="牌号对应及组批规则制定">
	
    <query id="UIB010181_01.SELECT" desc="查询试片LOT代码 LotResult" fetchSize="10">  
        <![CDATA[
			SELECT SC.* , AA.* , DECODE(SC.SPEC_STL_GRD , NULL , 'N' , 'Y') CUNZAI
			FROM  TBB01_SMP_CODE SC ,(
			SELECT A.SPEC_STL_GRD FROM TBB01_SPEC_INGR A
			UNION  
			SELECT B.SPEC_STL_GRD FROM TBB01_SPEC_QLTY B) AA
			WHERE  SC.SPEC_STL_GRD(+)     =               AA.SPEC_STL_GRD
			AND    DECODE(? , 'Y' , SC.SMP_CHARGE_YN  , 'N', SC.SMP_CHARGE_YN , 'A') =  ?
        ]]>   
    </query> 
	
	<query id="UIB010181_02.SELECT" desc="">
		   SELECT DISTINCT T.FAC_STL_GRD LABEL, T.FAC_STL_GRD VALUE FROM TBB01_FAC_INGR T ORDER BY T.FAC_STL_GRD
	</query>
	
	<query  id="UIB010181_01.INSERT" desc="">
		INSERT  INTO  TBB01_SMP_CODE(SPEC_STL_GRD , CHARGE_CNT , SMP_CHARGE_YN , REG_ID , REG_DTIME  )
        VALUES(?,?,?,?,to_char(sysdate , 'YYYYMMDDHH24MISS'))
	</query>
	
	<query id="UIB010181_01.UPDATE" desc="">
		UPDATE   TBB01_SMP_CODE SC
		SET      SC.CHARGE_CNT                    =   ?
				,SC.SMP_CHARGE_YN                 =   ?
				,SC.MOD_ID                        =   ?
				,SC.MOD_DTIME                     =   to_char(sysdate , 'YYYYMMDDHH24MISS')
		WHERE    SC.SPEC_STL_GRD                  =   ?
	</query>
</queryMap>