XinYu_RZMES/.svn/pristine/8e/8e2daeca92abeecde37d351e4926cb3bc8cbce76.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="成分（客户、标准、厂内）现状">
    <query id="UIB010020_01.INITSELECT" desc="客户参数号现状，初始化页面" fetchSize="10">  
        <![CDATA[
    	   SELECT DISTINCT
		      CUST_SPEC_NO    LABEL
			, CUST_SPEC_NO    VALUE
		   FROM TBB01_CUST_INGR
		   ORDER BY CUST_SPEC_NO
        ]]>   
    </query> 
	<query id="UIB010020_02.INITSELECT" desc="标准牌号参数现状，初始化页面">
		 <![CDATA[
			 SELECT DISTINCT 
			 SPEC_STL_GRD     LABEL
			 , SPEC_STL_GRD   VALUE
			  FROM TBB01_SPEC_INGR
			 ORDER BY SPEC_STL_GRD
		 ]]>   
	</query>
	<query id="UIB010020_03.INITSELECT" desc="厂内牌号参数现状，初始化页面">
		<![CDATA[
			SELECT DISTINCT 
			FAC_STL_GRD     LABEL
			, FAC_STL_GRD   VALUE 
			FROM TBB01_FAC_INGR
			ORDER BY FAC_STL_GRD
		 ]]>
	</query>
	
	<query id="UIB010020_04.INITSELECT" desc="厂内牌号参数现状，初始化页面">
		<![CDATA[
			SELECT T.SM_CD LABEL
			,T.SM_CD VALUE
			FROM TBZ00_COMMCD T 
			WHERE T.LG_CD = 'B01001'
			ORDER BY SM_CD
		 ]]>
	</query>	
	
	<query id="UIB010020_05.INITSELECT" desc="厂内牌号参数现状，初始化页面">
		<![CDATA[
			SELECT '---全部---' LABEL
			,'' VALUE FROM DUAL
			UNION ALL
			SELECT DISTINCT T.SPEC_STL_GRD LABEL
			,T.SPEC_STL_GRD VALUE   
			FROM TBB01_SPEC_INGR T WHERE T.SPEC_ABBSYM = ?
		 ]]>
	</query>
			
	<query id="UIB010020_04.SELECT" desc="动态成分查询，标准成分">
		<![CDATA[
			SELECT DISTINCT 
			  CHEM_CD
		  , decode(COMP_YN , 'Y' , COMP_CAL , CHEM_CD)  CHEM_NM              --用于前台的动态生成caption
		  , COMP_YN
		  , DISPLAY_SEQ
		    FROM 
			(
			SELECT DISTINCT T.CHEM_CD, TB.DISPLAY_SEQ, TB.COMP_YN , TB.COMP_CAL 
            FROM TBB01_SPEC_INGR T, TBB01_SEQ_INGR TB
            WHERE 
			T.SPEC_STL_GRD LIKE ?
            AND T.CHEM_CD =  TB.CHEM_CD 
            AND (CHEM_MIN IS NOT NULL OR CHEM_MAX IS NOT NULL)            
			)
			ORDER BY  COMP_YN  ,  DISPLAY_SEQ
		 ]]>
	</query>
	
	<query id="UIB010020_05.SELECT" desc="动态成分查询，客户成分">
		<![CDATA[
			SELECT   DISTINCT
 					 CHEM_CD    
				  ,  decode(COMP_YN , 'Y' , COMP_CAL , CHEM_CD)   CHEM_NM              --用于前台的动态生成caption
				  ,  COMP_YN
				  ,  DISPLAY_SEQ
			FROM 
				  (
					SELECT DISTINCT   CI.CHEM_CD  
									, SI.DISPLAY_SEQ 
									, SI.COMP_YN
									, SI.COMP_CAL 
					FROM              TBB01_CUST_INGR  CI  ,  TBB01_SEQ_INGR  SI
					WHERE             CI.CUST_SPEC_NO           LIKE   ?
					AND               CI.CHEM_CD     =     SI.CHEM_CD 
					AND               (CHEM_MIN  IS NOT NULL OR CHEM_MAX IS NOT NULL)
				  )
			ORDER BY  COMP_YN  ,  DISPLAY_SEQ
		 ]]>
	</query>
	<query id="UIB010020_06.SELECT" desc="动态成分查询，厂内成分">
		<![CDATA[
			SELECT DISTINCT
			   CHEM_CD 
			,  decode(COMP_YN , 'Y' , COMP_CAL , CHEM_CD)   CHEM_NM              --用于前台的动态生成caption
			,  COMP_YN
			,  DISPLAY_SEQ
		    FROM 
			(
			SELECT DISTINCT T.CHEM_CD, TB.DISPLAY_SEQ, TB.COMP_YN , TB.COMP_CAL
            FROM TBB01_FAC_INGR T, TBB01_SEQ_INGR TB
            WHERE 
			T.FAC_STL_GRD LIKE ?
            AND T.CHEM_CD  =  TB.CHEM_CD 
            AND (CHEM_MIN IS NOT NULL OR CHEM_MAX IS NOT NULL)
			)
			ORDER BY  COMP_YN  ,  DISPLAY_SEQ
		 ]]>
	</query>

	<query id="UIB010020_07.SELECT" desc="动态成分查询，炼钢放行成分">
		<![CDATA[
		SELECT DISTINCT
		CHEM_CD 
		,  decode(COMP_YN , 'Y' , COMP_CAL , CHEM_CD)   CHEM_NM              --用于前台的动态生成caption
		,  COMP_YN
		,  DISPLAY_SEQ
		FROM 
		(
		SELECT DISTINCT T.CHEM_CD, TB.DISPLAY_SEQ, TB.COMP_YN , TB.COMP_CAL
		FROM TBB01_TAFAC_INGR T, TBB01_SEQ_INGR TB
		WHERE 
		T.TAFAC_STL_GRD LIKE ? AND
		T.CHEM_CD  =  TB.CHEM_CD 
		AND (CHEM_MIN IS NOT NULL OR CHEM_MAX IS NOT NULL)
		)
		ORDER BY  COMP_YN  ,  DISPLAY_SEQ
		 ]]>
	</query>
		
	<query id="UIB010020_01.CUST.SELECT" desc="">
		SELECT   CUST_SPEC_NO   IDX
	</query>
	
	<query id="UIB010020_08.SELECT" desc="">
		SELECT  
DECODE(A.COMP_YN , 'Y' , A.COMP_CAL , A.CHEM_CD) CHEMCD
,A.CHEM_AIM
,A.MIN1
,A.MAX1
,B.*
,C.*
FROM 
(SELECT SEQ.CHEM_CD ,SEQ.DISPLAY_SEQ ,SEQ.COMP_YN , SEQ.COMP_CAL,FAC.CHEM_AIM , FAC.CHEM_MIN  MIN1, FAC.CHEM_MAX MAX1 FROM TBB01_SEQ_INGR  SEQ , TBB01_FAC_INGR    FAC  WHERE FAC.CHEM_CD(+) = SEQ.CHEM_CD AND FAC.FAC_STL_GRD(+)   = ? ) A ,
(SELECT SEQ.CHEM_CD ,SEQ.DISPLAY_SEQ , TAF.CHEM_MIN  MIN2, TAF.CHEM_MAX MAX2 FROM TBB01_SEQ_INGR  SEQ , TBB01_TAFAC_INGR  TAF  WHERE TAF.CHEM_CD(+) = SEQ.CHEM_CD AND TAF.TAFAC_STL_GRD(+) = ? ) B ,
(SELECT SEQ.CHEM_CD ,SEQ.DISPLAY_SEQ , SPE.CHEM_MIN  MIN3, SPE.CHEM_MAX MAX3 FROM TBB01_SEQ_INGR  SEQ , TBB01_SPEC_INGR   SPE  WHERE SPE.CHEM_CD(+) = SEQ.CHEM_CD AND SPE.SPEC_STL_GRD(+)  = ? ) C 
WHERE   A.CHEM_CD   =   B.CHEM_CD
    AND     A.CHEM_CD   =   C.CHEM_CD
ORDER   BY  A.COMP_YN , A.DISPLAY_SEQ 

	</query>
	
</queryMap>