XinYu_RZMES/.svn/pristine/32/32d777da23e1bb8997edc8f3de6c7f0384a2a848.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH090120_01.select" desc=" 销售打印 " fetchSize="10">
		<![CDATA[
			SELECT A.ORD_NO,
			 A.SPEC_STL_GRD,
			 A.OLD_SAMPL_NO,
             substr(A.SLAB_NO, 1, 10) CHARGE_NO,
             A.INSTR_COIL_THK,
             A.INSTR_COIL_WTH,
             A.ACT_WGT,
             D.FM_EXT_STRIP_TEMP,
             D.DC_TEMP_AVG,
             A.COIL_INDIA,
             A.MILL_DTIME,
             MAX(decode(b.CHEM_CD, 'C', b.CHEM_VAL)) C,
             MAX(decode(b.CHEM_CD, 'Mn', b.CHEM_VAL)) MN,
             MAX(decode(b.CHEM_CD, 'S', b.CHEM_VAL)) S,
             MAX(decode(b.CHEM_CD, 'P', b.CHEM_VAL)) P,
             MAX(decode(b.CHEM_CD, 'Si', b.CHEM_VAL)) SI,
             MAX(decode(b.CHEM_CD, 'Cr', b.CHEM_VAL)) CR,
             MAX(decode(b.CHEM_CD, 'Ni', b.CHEM_VAL)) NI,
             MAX(decode(b.CHEM_CD, 'Cu', b.CHEM_VAL)) CU,
             MAX(decode(b.CHEM_CD, 'Alt', b.CHEM_VAL)) ALT,
             MAX(decode(b.CHEM_CD, 'N', b.CHEM_VAL)) N,
             MAX(decode(b.CHEM_CD, 'B', b.CHEM_VAL)) B
        FROM TBH02_COIL_COMM A, TBB02_WORK_INGR B, TBB02_MS_COIL C ,   TBH02_MILL_RESULT D
       WHERE B.PROC_CD = C.PROC_CD
         AND B.CHEM_SEQ = C.CHEM_SEQ
         AND A.COIL_NO = C.COIL_NO
         AND A.COIL_NO = D.COIL_NO(+)
         AND SUBSTR(A.SLAB_NO, 1, 10) = B.CHARGE_NO
         AND A.ORD_NO = ?
       GROUP BY A.ORD_NO,
                A.ORD_SEQ,
                substr(A.SLAB_NO, 1, 10),
                A.SPEC_STL_GRD,
                A.OLD_SAMPL_NO,
                A.INSTR_COIL_THK,
                A.INSTR_COIL_WTH,
                A.ACT_WGT,
                D.FM_EXT_STRIP_TEMP,
             D.DC_TEMP_AVG,
             A.COIL_INDIA,
             A.MILL_DTIME
      union
      SELECT A.ORD_NO,
             substr(A.SLAB_NO, 1, 10) CHARGE_NO,
             A.SPEC_STL_GRD,
             A.OLD_SAMPL_NO,
             A.INSTR_COIL_THK,
             A.INSTR_COIL_WTH,
             A.ACT_WGT,
             D.FM_EXT_STRIP_TEMP,
             D.DC_TEMP_AVG,
             A.COIL_INDIA,
             A.MILL_DTIME,
             MAX(decode(b.CHEM_CD, 'C', b.CHEM_VAL)) C,
             MAX(decode(b.CHEM_CD, 'Mn', b.CHEM_VAL)) MN,
             MAX(decode(b.CHEM_CD, 'S', b.CHEM_VAL)) S,
             MAX(decode(b.CHEM_CD, 'P', b.CHEM_VAL)) P,
             MAX(decode(b.CHEM_CD, 'Si', b.CHEM_VAL)) SI,
             MAX(decode(b.CHEM_CD, 'Cr', b.CHEM_VAL)) CR,
             MAX(decode(b.CHEM_CD, 'Ni', b.CHEM_VAL)) NI,
             MAX(decode(b.CHEM_CD, 'Cu', b.CHEM_VAL)) CU,
             MAX(decode(b.CHEM_CD, 'Alt', b.CHEM_VAL)) ALT,
             MAX(decode(b.CHEM_CD, 'N', b.CHEM_VAL)) N,
             MAX(decode(b.CHEM_CD, 'B', b.CHEM_VAL)) B
        FROM c_tbl02_coil_comm A, TBB02_WORK_INGR B, TBB02_MS_COIL C ,   TBH02_MILL_RESULT D
       WHERE B.PROC_CD = C.PROC_CD
         AND B.CHEM_SEQ = C.CHEM_SEQ
         AND A.COIL_NO = C.COIL_NO
         AND A.COIL_NO = D.COIL_NO(+)
         AND SUBSTR(A.SLAB_NO, 1, 10) = B.CHARGE_NO
         AND A.ORD_NO = ?
       GROUP BY A.ORD_NO,
                A.ORD_SEQ,
                substr(A.SLAB_NO, 1, 10),
                A.SPEC_STL_GRD,
                A.OLD_SAMPL_NO,
                A.INSTR_COIL_THK,
                A.INSTR_COIL_WTH,
                A.ACT_WGT,
                D.FM_EXT_STRIP_TEMP,
             D.DC_TEMP_AVG,
             A.COIL_INDIA,
            A.MILL_DTIME
						
		]]>
	</query>
</queryMap>