XinYu_RZMES/.svn/pristine/33/3390f2a01cc5f569091aaf55f39f845285823454.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="品质设计结果之成分（分）">
    <query id="UIB015030_01.SELECT" desc="复合元素" fetchSize="10">   
        <![CDATA[
SELECT  B.COMP_DETAIL,B.COMP_CAL, A.* FROM
		(SELECT T.CHEM_CD CD,
		MAX(CASE WHEN T.DSN_KIND = '1' THEN T.CHEM_MIN END)    MIN1,
		MAX(CASE WHEN T.DSN_KIND = '1' THEN T.CHEM_MAX END)    MAX1,
		MAX(CASE WHEN T.DSN_KIND = '2' THEN T.CHEM_MIN END)    MIN2,
		MAX(CASE WHEN T.DSN_KIND = '2' THEN T.CHEM_MAX END)    MAX2,
		MAX(CASE WHEN T.DSN_KIND = '2' THEN T.CHEM_DEC_CD END) CHEM_DEC_CD2, 
		MAX(CASE WHEN T.DSN_KIND = '3' THEN T.CHEM_AIM END)    AIM3,
		MAX(CASE WHEN T.DSN_KIND = '3' THEN T.CHEM_MIN END)    MIN3,
		MAX(CASE WHEN T.DSN_KIND = '3' THEN T.CHEM_MAX END)    MAX3,
		MAX(CASE WHEN T.DSN_KIND = '4' THEN T.CHEM_MIN END)    MIN4,         --冷轧标准要求
		MAX(CASE WHEN T.DSN_KIND = '4' THEN T.CHEM_MAX END)    MAX4,         --冷轧标准要求
		MAX(CASE WHEN T.DSN_KIND = '4' THEN T.CHEM_DEC_CD END) CHEM_DEC_CD4, --冷轧标准要求
		MAX(CASE WHEN T.DSN_KIND = '5' THEN T.CHEM_MIN END)    MIN5,         --冷轧特殊要求
		MAX(CASE WHEN T.DSN_KIND = '5' THEN T.CHEM_MAX END)    MAX5          --冷轧特殊要求
		FROM TBB01_DSN_INGR   T
		WHERE T.ORD_NO        =    ?   AND    T.ORD_SEQ   =   ?
		GROUP BY T.CHEM_CD) A
       ,TBB01_SEQ_INGR B
WHERE   A.CD(+) = B.CHEM_CD AND B.COMP_YN = 'Y'
ORDER BY B.COMP_YN ASC , B.DISPLAY_SEQ ASC
        ]]>   
    </query> 
    <query id="UIB015030_02.SELECT" desc="复合元素" fetchSize="10">   
        <![CDATA[
SELECT  B.COMP_DETAIL,B.COMP_CAL, A.* FROM
		(SELECT T.CHEM_CD CD,
		MAX(CASE WHEN T.DSN_KIND = '1' THEN T.CHEM_MIN END)    MIN1,
		MAX(CASE WHEN T.DSN_KIND = '1' THEN T.CHEM_MAX END)    MAX1,
		MAX(CASE WHEN T.DSN_KIND = '2' THEN T.CHEM_MIN END)    MIN2,
		MAX(CASE WHEN T.DSN_KIND = '2' THEN T.CHEM_MAX END)    MAX2,
		MAX(CASE WHEN T.DSN_KIND = '2' THEN T.CHEM_DEC_CD END) CHEM_DEC_CD2, 
		MAX(CASE WHEN T.DSN_KIND = '3' THEN T.CHEM_AIM END)    AIM3,
		MAX(CASE WHEN T.DSN_KIND = '3' THEN T.CHEM_MIN END)    MIN3,
		MAX(CASE WHEN T.DSN_KIND = '3' THEN T.CHEM_MAX END)    MAX3,
		MAX(CASE WHEN T.DSN_KIND = '4' THEN T.CHEM_MIN END)    MIN4,         --冷轧标准要求
		MAX(CASE WHEN T.DSN_KIND = '4' THEN T.CHEM_MAX END)    MAX4,         --冷轧标准要求
		MAX(CASE WHEN T.DSN_KIND = '4' THEN T.CHEM_DEC_CD END) CHEM_DEC_CD4, --冷轧标准要求
		MAX(CASE WHEN T.DSN_KIND = '5' THEN T.CHEM_MIN END)    MIN5,         --冷轧特殊要求
		MAX(CASE WHEN T.DSN_KIND = '5' THEN T.CHEM_MAX END)    MAX5          --冷轧特殊要求
		FROM TBB01_ORD_INGR   T
		WHERE T.ORD_NO        =    ?   AND    T.ORD_SEQ   =   ?
		GROUP BY T.CHEM_CD) A
       ,TBB01_SEQ_INGR B
WHERE   A.CD(+) = B.CHEM_CD AND B.COMP_YN = 'Y'
ORDER BY B.COMP_YN ASC , B.DISPLAY_SEQ ASC
        ]]>   
    </query> 	
</queryMap>