XinYu_LZMES/.svn/pristine/cb/cb68563a1a0d9c7c4b12090f4f570b033d7685bf.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="入库待机钢卷查询">
	<query id="UIK050090_01.SELECT"  desc="查询材质信息">
		<![CDATA[
		SELECT   CT.*,T1.QLTY_MIN,T1.QLTY_MAX 
		FROM TBB01_ORD_QLTY T1,(SELECT T4.QLTY_CD_CFNM,T3.QLTY_CD ,T3.QLTY_VAL_WK,T2.ORD_NO,T2.ORD_SEQ 
        FROM C_TBK02_COIL_COMM T2,TBB02_WORK_QLTY T3,TBB01_SEQ_QLTY T4 WHERE  
										  T2.SMP_NO                =   T3.SMP_NO
                                AND       T2.SMP_CUT_LOC           =   T3.SMP_CUT_LOC
                                AND       T3.QLTY_CD               =   T4.QLTY_CD
                                AND       T2.COIL_NO               =   NVL(? , T2.COIL_NO))  CT
		WHERE    T1.ORD_NO(+)       =   CT.ORD_NO
		AND      T1.ORD_SEQ(+)      =   CT.ORD_SEQ
		AND      T1.QLTY_CD(+)      =   CT.QLTY_CD
		AND      T1.DSN_KIND(+)     =   '2'

		 ]]>
	</query>
	
	<query id="UIK050090_02.SELECT"  desc="查询成分信息">
		<![CDATA[
		SELECT nvl(QQ.CHEM_CD, CC.CHEM_CD) CHEM_CD,
       QQ.CHEM_VAL,
       CC.CHEM_MIN,
       CC.CHEM_MAX,
       CC.CHEM_DEC_CD
  from (SELECT T2.CHEM_CD,
               T2.CHEM_VAL
          FROM TBB02_WORK_INGR     T2,
               C_TBK02_COIL_COMM   T3,
               TBG02_CHARGE_COMM_D T4,
               TBB01_SEQ_INGR      T5
         WHERE T2.CHARGE_NO = SUBSTR(T3.SLAB_NO, 1, 10)
           AND T2.CHARGE_NO = T4.CHARGE_NO
           AND T2.PROC_CD || T2.CHEM_SEQ = T4.LST_INGR_CD
           AND T2.CHEM_CD = T5.CHEM_CD
           AND T5.COMP_YN = 'N'
           AND T3.COIL_NO = NVL(?, T3.COIL_NO)
         ORDER BY  T5.DISPLAY_SEQ) QQ
  full join (SELECT T1.CHEM_CD, T1.CHEM_MIN, T1.CHEM_MAX,T1.CHEM_DEC_CD
               FROM TBB01_ORD_INGR T1
              WHERE T1.DSN_KIND = '2'
                AND T1.ORD_NO = ?
                AND T1.ORD_SEQ = ?
              ORDER BY T1.CHEM_CD) CC
    on QQ.CHEM_CD = CC.CHEM_CD
		 ]]>
	</query>
</queryMap>