XinYu_LZMES/.svn/pristine/18/181305759bc4e39c2f2b72b554cc14dfd0a6cf72.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="成品不合格品报表">
	<query id="UIM010211_01.SELECT"  desc="成品不合格品报表">
		<![CDATA[
		SELECT C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME,
       A.OLD_SAMPL_NO,
       A.SPEC_STL_GRD,
       A.INSTR_COIL_THK,
       A.INSTR_COIL_WTH,
       A.ACT_WGT,
       A.ORD_NO,
       a.ORD_SEQ,
       (SELECT SM_CFNM
          FROM TBZ00_COMMCD WQ
         WHERE LG_CD = 'B02001'
           AND WQ.SM_CD = A.CRK_CD1) CRK_CD1,
       (SELECT SM_CFNM
          FROM TBZ00_COMMCD WQ
         WHERE LG_CD = 'B02001'
           AND WQ.SM_CD = A.CRK_CD2) CRK_CD2,
       (SELECT SM_CFNM
          FROM TBZ00_COMMCD WQ
         WHERE LG_CD = 'B02001'
           AND WQ.SM_CD = A.CRK_CD3) CRK_CD3,
       (SELECT SM_CFNM
          FROM TBZ00_COMMCD WQ
         WHERE LG_CD = 'B02001'
           AND WQ.SM_CD = A.CRK_CD4) CRK_CD4,
       (SELECT SM_CFNM
          FROM TBZ00_COMMCD WQ
         WHERE LG_CD = 'B02001'
           AND WQ.SM_CD = A.CRK_CD5) CRK_CD5
  FROM C_TBC02_COIL_COMM A
 WHERE (SUBSTR(A.YARD_ENTRY_DTIME, 1, 8) >= ?)
   AND (SUBSTR(A.YARD_ENTRY_DTIME, 1, 8) <= ?)
   AND A.SPEC_STL_GRD LIKE ? || '%'
   AND A.OLD_SAMPL_NO LIKE '%' || ? || '%'
   AND (A.ORD_NO LIKE '57%' OR A.ORD_NO LIKE '51%')
 order by a.YARD_ENTRY_DTIME, a.spec_stl_grd
		 ]]>
	</query>
</queryMap>