XinYu_LZMES/.svn/pristine/8c/8c6dabf0412f72451d19affe782684c1b9d55569.svn-base

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="检验结果查询与导出">


<query id="UIB100207_01.SELECT" desc="检验结果查询">
<![CDATA[	
SELECT            T2.PROD_LINE
                 ,T2.COIL_NO
                 ,T2.SPEC_STL_GRD 
                 ,T1.SMP_NO
                 ,T1.SMP_CUT_LOC
                 ,T1.SMP_NO_TYPE
                 ,T2.SEND_ID
                 ,T2.SEND_DTIME
                 ,T2.COIL_THK
       			 ,T2.WEITO_NO
                 ,T2.COIL_STEEL_NO
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'CBCB' , T1.QLTY_VAL)    )    LL_CB
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'LLA.' , T1.QLTY_VAL)    )    LL_A
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'LLRe' , T1.QLTY_VAL)    )    LL_RE
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'LLRm' , T1.QLTY_VAL)    )    LL_RM
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'LLQxb' , T1.QLTY_VAL)   )   LL_QXB
                 
                 ,MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'SRSR', T1.QLTY_VAL)) SR--塑性应变比(r90)
       			 ,MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'N9N9', T1.QLTY_VAL)) N9--应变硬化指数
       			 ,MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'DC01', T1.QLTY_VAL)) DC01--铁损
                 ,MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'DC02', T1.QLTY_VAL)) DC02--磁感
                
                 --普通冲击
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'PCA1' , T1.QLTY_VAL)    )    PC_A1
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'PCA2' , T1.QLTY_VAL)    )    PC_A2
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'PCA3' , T1.QLTY_VAL)    )    PC_A3
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'PCAVG' , T1.QLTY_VAL)   )    PC_AVG
                 --夏比冲击
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'XCA1' , T1.QLTY_VAL)    )    XC_A1
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'XCA2' , T1.QLTY_VAL)    )    XC_A2
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'XCA3' , T1.QLTY_VAL)    )    XC_A3
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'XCAVG' , T1.QLTY_VAL)   )    XC_AVG
                 --落锤实验
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'DWA1' , T1.QLTY_VAL)    )    DW_A1
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'DWA2' , T1.QLTY_VAL)    )    DW_A2
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'DWA3' , T1.QLTY_VAL)    )    DW_A3
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'DWAVG' , T1.QLTY_VAL)   )    DW_AVG
                 --布氏硬度
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'BYA1' , T1.QLTY_VAL)    )    BY_A1
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'BYA2' , T1.QLTY_VAL)    )    BY_A2
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'BYA3' , T1.QLTY_VAL)    )    BY_A3
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'BYAVG' , T1.QLTY_VAL)   )    BY_AVG
                 --维氏硬度
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'WYA1' , T1.QLTY_VAL)    )    WY_A1
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'WYA2' , T1.QLTY_VAL)    )    WY_A2
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'WYA3' , T1.QLTY_VAL)    )    WY_A3
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'WYAVG' , T1.QLTY_VAL)   )    WY_AVG
                 --洛氏硬度
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'LYA1' , T1.QLTY_VAL)    )    LY_A1
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'LYA2' , T1.QLTY_VAL)    )    LY_A2
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'LYA3' , T1.QLTY_VAL)    )    LY_A3
                 ,MAX(DECODE(T1.QLTY_CD_2||T1.QLTY_OPE_CD , 'LYAVG' , T1.QLTY_VAL)   )    LY_AVG
                 
                 --峰值密度
      ,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'FZA1', T1.QLTY_VAL)) FZ_A1,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'FZA2', T1.QLTY_VAL)) FZ_A2,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'FZA3', T1.QLTY_VAL)) FZ_A3,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'FZAVG', T1.QLTY_VAL)) FZ_AVG
       --上表面粗糙度
      ,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'CSA1', T1.QLTY_VAL)) CS_A1,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'CSA2', T1.QLTY_VAL))CS_A2,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'CSA3', T1.QLTY_VAL)) CS_A3,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'CSAVG', T1.QLTY_VAL)) CS_AVG
       --下表面粗糙度
        ,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'CXA1', T1.QLTY_VAL)) CX_A1,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'CXA2', T1.QLTY_VAL))CX_A2,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'CXA3', T1.QLTY_VAL)) CX_A3,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'CXAVG', T1.QLTY_VAL)) CX_AVG
       --各向异性度
        ,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'GDA1', T1.QLTY_VAL)) GD_A1,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'GDA2', T1.QLTY_VAL))GD_A2,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'GDA3', T1.QLTY_VAL)) GD_A3,
       MAX(DECODE(T1.QLTY_CD_2 || T1.QLTY_OPE_CD, 'GDAVG', T1.QLTY_VAL)) GD_AVG
FROM              TBB10_QLTY_OPE         T1 
                 ,TBB10_QLTY_COIL        T2 
WHERE            (T1.QLTY_CD IS NOT NULL OR T1.QLTY_OPE_CD IN ('A1' , 'A2' ,'A3'))       
AND               T1.SMP_NO              =     T2.SMP_NO
AND               T1.SMP_CUT_LOC         =     T2.SMP_CUT_LOC
AND               T2.PROD_LINE           =     ?
AND               T2.WEITO_DTIME         BETWEEN    ?       AND    ?
AND               T2.SEND_DTIME          BETWEEN    ?       AND    ?
AND               SUBSTR(T2.COIL_NO  ,1,10 )  BETWEEN  NVL(? , SUBSTR(T2.COIL_NO  ,1,10 ))   AND  NVL(? , SUBSTR(T2.COIL_NO  ,1,10 ))
GROUP   BY        T2.PROD_LINE
                 ,T2.COIL_NO 
                 ,T2.SPEC_STL_GRD
                 ,T1.SMP_NO
                 ,T1.SMP_CUT_LOC
                 ,T1.SMP_NO_TYPE
                 ,T2.SEND_ID
                 ,T2.SEND_DTIME,
                 T2.COIL_THK,
          		 T2.WEITO_NO,
                 T2.COIL_STEEL_NO
ORDER  BY         T2.COIL_NO
                 ,T1.SMP_NO_TYPE
                 ,T2.SPEC_STL_GRD                      
	  ]]>
</query>

	
</queryMap>