XinYu_RZMES/.svn/pristine/02/023ec80f1ba5ec0f382030a5ddaa90058d9340e2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="材质（客户、标准）现状">
    <query id="UIB010120_01.INITSELECT" desc="获取所有客户公司代码  CustCD ">  
        <![CDATA[
    	   SELECT DISTINCT 
      	   T2.CUST_NM LABEL
		   ,SUBSTR(CUST_SPEC_NO , 0 ,6) VALUE  
		   FROM TBB01_CUST_QLTY T1 ,TBZ00_CUSTOMER T2
		   WHERE SUBSTR(CUST_SPEC_NO , 0 ,6) = T2.CUST_CD(+)
        ]]>   
    </query> 
	
	<query id="UIB010120_02.INITSELECT" desc="获取所有标准号 SpecAbbsym">
		SELECT  DISTINCT 
		  SPEC_ABBSYM    LABEL 
		, SPEC_ABBSYM    VALUE
		FROM TBB01_SPEC_QLTY
	</query>
	
	
	<query id="UIB010120_03.INITSELECT" desc="根据标准号查钢号">
		<![CDATA[
			SELECT DISTINCT T.SPEC_STL_GRD LABEL
			,T.SPEC_STL_GRD VALUE   
			FROM TBB01_SPEC_QLTY T WHERE T.SPEC_ABBSYM = ?
			ORDER BY SPEC_STL_GRD
		 ]]>
	</query>	
	
	<query id="UIB010120_01.SELECT" desc="查询出满足条件的所有客户材质代码">
		SELECT    DISTINCT
		          CQ.QLTY_CD
		        , SQ.QLTY_CD_CFNM
		FROM      TBB01_CUST_QLTY CQ
		        , TBB01_SEQ_QLTY SQ
		WHERE     CQ.QLTY_CD                      =   SQ.QLTY_CD
		AND       substr(CQ.CUST_SPEC_NO , 1 , 6) LIKE   ?
		AND      (   CQ.QLTY_MIN  IS NOT NULL
    			  OR CQ.QLTY_MAX  IS NOT NULL
				  OR CQ.QLTY_UNIT IS NOT NULL
				  OR CQ.QLTY_TYPE IS NOT NULL)
	</query>
	
	<query id="UIB010120_02.SELECT" desc="查询出满足条件的所有标准材质代码">
		SELECT    DISTINCT
		          SPE.QLTY_CD , SEQ.QLTY_CD_CFNM , SEQ.DISPLAY_SEQ     
		FROM      TBB01_SPEC_QLTY SPE , TBB01_SEQ_QLTY SEQ
	    WHERE     SPE.QLTY_CD      =  SEQ.QLTY_CD
	    AND       SPE.SPEC_ABBSYM LIKE ?
		AND       SPE.SPEC_STL_GRD LIKE ?
	    AND      (   SPE.QLTY_MIN  IS NOT NULL
			      OR SPE.QLTY_MAX  IS NOT NULL
			      OR SPE.QLTY_UNIT IS NOT NULL
			      OR SPE.QLTY_TYPE IS NOT NULL)
		ORDER BY SEQ.DISPLAY_SEQ  	      
	</query>
	
	<query id="UIB010120.MID" desc="SQL中需要动态生成的部分{0}用具体的材质代码替代，{1}用序号来代替">
		, max(decode(QLTY_CD , '{0}' , QLTY_MIN , NULL))   QLTY_MIN{1} 
		, max(decode(QLTY_CD , '{0}' , QLTY_MAX , NULL))   QLTY_MAX{1} 
		, max(decode(QLTY_CD , '{0}' , QLTY_UNIT , NULL))  QLTY_UNIT{1} 
		, max(decode(QLTY_CD , '{0}' , QLTY_TYPE , NULL))  QLTY_TYPE{1} 
	</query>
	
	<query id="UIB010120_CUST.END" desc="客户材质信息查询">
		FROM  TBB01_CUST_QLTY  WHERE  substr(CUST_SPEC_NO , 1 , 6) LIKE ?  GROUP BY CUST_SPEC_NO
	</query>
	
	<query id="UIB010120_SPEC.START" desc="标准材质信息查询开始部分">
		SELECT 
		   PRDNM_CD 
		,  PKG_QUALITY_COMM.FZ00_COMM('A01007' , ORD_USE_TP)  ORD_USE_TP 
		,  SPEC_ABBSYM 
		,  SPEC_STL_GRD
		,  THK_MIN 
		,  THK_MAX 
		,  max(SMP_LOT_CD||SMP_LEN_LOC||SMP_TEST_DIR||SMP_FORM)   SAMPLING_CODE 
	</query>
	
	<query id="UIB010120_SPEC.END" desc="标准材质信息查询结束部分">
		FROM         TBB01_SPEC_QLTY   
		WHERE        SPEC_ABBSYM LIKE ? 
		AND          SPEC_STL_GRD LIKE ?   
		GROUP BY     PRDNM_CD , ORD_USE_TP , SPEC_ABBSYM , SPEC_STL_GRD , THK_MIN  , THK_MAX
		ORDER BY  SPEC_STL_GRD
	</query>
</queryMap>