XinYu_LZMES/.svn/pristine/1a/1aab1d0a7ce28d28d2d9329eabfe5c92227c7c3d.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="入库待机钢卷查询">
	<query id="UIK050010_01.SELECT"  desc="全查询"> 
		<![CDATA[
		select QQ.*,CC.VALUE_C,CC.VALUE_Mn,CC.VALUE_S,CC.VALUE_P,CC.VALUE_Si,CC.VALUE_Ti,CC.VALUE_N from (
			select A.OLD_SAMPL_NO,A.STL_GRD,DECODE(A.CR_PLANT_TRS_CLF,'Z','常化','') CR_PLANT_TRS_CLF,
			B.C_SPEC_ABBSYM SPEC_ABBSYM,B.ORD_THK INSTR_COIL_THK,B.ORD_WTH INSTR_COIL_WTH,B.ORD_LEN INSTR_COIL_LEN,B.ORD_INDIA INSTR_COIL_INDIA,
			DECODE(H.EDGE_PROC_YN, NULL, 'N', H.EDGE_PROC_YN) EDGE_PROC_YN,
            H.C_SPEC_STL_GRD,
			B.ORD_OUTDIA INSTR_COIL_OUTDIA,B.ORD_UNIT_WGT INSTR_COIL_WGT,A.ACT_WGT,TS.SLAB_DCS_DETAIL,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD1) CRK_CD1,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD2) CRK_CD2,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD3) CRK_CD3,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD4) CRK_CD4,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD5) CRK_CD5,A.FM_EXT_STRIP_TEMP_AVG,
			A.DC_TEMP_AVG,F.FM_EXT_STRIP_CROWN_AVG HC_TU_DU,F.FM_STRIP_WDG_AVG HC_XIE_XIN,decode(A.TOT_DEC_GRD,'1','合格','2','不合格','3','外观异常','4','废品') TOT_DEC_GRD,
			A.OLD_ORD_NO,A.OLD_ORD_SEQ,C_PKG_UIM.GET_STDDATESTR(B.DEL_TO_DATE) DEL_TO_DATE,substr(A.SLAB_NO,1,10) HEAT_NO,
			decode(A.ORD_FL,'1','订单材','2','余材') ORD_FL,decode(A.CUR_PROG_CD,'PAB','基料卷入库待机') CUR_PROG_CD,A.COIL_LEN,
			A.COIL_INDIA,A.COIL_OUTDIA,A.COIL_THK,A.COIL_WTH
			,C_PKG_UIM.GET_STDDATESTR(A.CR_PLANT_TRS_DTIME) CR_PLANT_TRS_DTIME
			,A.CR_PLANT_TRS_SEQ  from c_tbk02_coil_comm A,TBE02_ORD_PRC B,TBH02_MILL_RESULT F, TBH02_COIL_COMM  T1,TBG02_SLAB_COMM TS , tbb01_ord_head    h
			where A.OLD_ORD_NO = B.ORD_NO AND A.OLD_ORD_SEQ = B.ORD_SEQ   AND A.OLD_ORD_NO = H.ORD_NO(+)
           AND A.OLD_ORD_SEQ = H.ORD_SEQ(+) AND A.COIL_NO = T1.OLD_SAMPL_NO AND A.SLAB_NO = TS.SLAB_NO(+) AND T1.COIL_NO = F.COIL_NO and A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' order by CR_PLANT_TRS_DTIME,CR_PLANT_TRS_SEQ
		 )  QQ
 full join
(select A.OLD_SAMPL_NO,
       max(DECODE(WI.CHEM_CD, 'C', WI.CHEM_VAL)) VALUE_C,
       max(DECODE(WI.CHEM_CD, 'Mn', WI.CHEM_VAL)) VALUE_Mn,
       max(DECODE(WI.CHEM_CD, 'S', WI.CHEM_VAL)) VALUE_S,
       max(DECODE(WI.CHEM_CD, 'P', WI.CHEM_VAL)) VALUE_P,
       max(DECODE(WI.CHEM_CD, 'Si', WI.CHEM_VAL)) VALUE_Si,
       max(DECODE(WI.CHEM_CD, 'Ti', WI.CHEM_VAL)) VALUE_Ti,
       max(DECODE(WI.CHEM_CD, 'N', WI.CHEM_VAL)) VALUE_N
    from c_tbk02_coil_comm A,TBE02_ORD_PRC B,TBB02_WORK_INGR WI,TBG02_CHARGE_COMM_D D
    where A.OLD_ORD_NO = B.ORD_NO AND A.OLD_ORD_SEQ = B.ORD_SEQ and A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' 
     AND WI.CHARGE_NO = D.CHARGE_NO AND WI.PROC_CD || WI.CHEM_SEQ = D.LST_INGR_CD
     AND  SUBSTR(A.SLAB_NO, 1, 10) = WI.CHARGE_NO AND WI.CHEM_CD IN ('C','Mn','S','P','Si','Ti','N')
     GROUP BY A.OLD_SAMPL_NO)  CC on  QQ.OLD_SAMPL_NO = CC.OLD_SAMPL_NO
		 ]]>
	</query>
	
	<query id="UIK050010_02.SELECT"  desc="时间相等查询">
		<![CDATA[
		select QQ.*,CC.VALUE_C,CC.VALUE_Mn,CC.VALUE_S,CC.VALUE_P,CC.VALUE_Si,CC.VALUE_Ti,CC.VALUE_N from (
			select A.OLD_SAMPL_NO,A.STL_GRD,DECODE(A.CR_PLANT_TRS_CLF,'Z','常化','') CR_PLANT_TRS_CLF,
			B.C_SPEC_ABBSYM SPEC_ABBSYM,B.ORD_THK INSTR_COIL_THK,B.ORD_WTH INSTR_COIL_WTH,B.ORD_LEN INSTR_COIL_LEN,B.ORD_INDIA INSTR_COIL_INDIA,
			B.ORD_OUTDIA INSTR_COIL_OUTDIA,B.ORD_UNIT_WGT INSTR_COIL_WGT,A.ACT_WGT,TS.SLAB_DCS_DETAIL,
			DECODE(H.EDGE_PROC_YN, NULL, 'N', H.EDGE_PROC_YN) EDGE_PROC_YN,
            H.C_SPEC_STL_GRD,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD1) CRK_CD1,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD2) CRK_CD2,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD3) CRK_CD3,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD4) CRK_CD4,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD5) CRK_CD5,
			A.FM_EXT_STRIP_TEMP_AVG,F.FM_EXT_STRIP_CROWN_AVG HC_TU_DU,F.FM_STRIP_WDG_AVG HC_XIE_XIN,
			A.DC_TEMP_AVG,decode(A.TOT_DEC_GRD,'1','合格','2','不合格','3','外观异常','4','废品') TOT_DEC_GRD,
			A.OLD_ORD_NO,A.OLD_ORD_SEQ,C_PKG_UIM.GET_STDDATESTR(B.DEL_TO_DATE) DEL_TO_DATE,substr(A.SLAB_NO,1,10) HEAT_NO,
			decode(A.ORD_FL,'1','订单材','2','余材') ORD_FL,decode(A.CUR_PROG_CD,'PAB','基料卷入库待机') CUR_PROG_CD,A.COIL_LEN,
			A.COIL_INDIA,A.COIL_OUTDIA,A.COIL_THK,A.COIL_WTH
			,C_PKG_UIM.GET_STDDATESTR(A.CR_PLANT_TRS_DTIME) CR_PLANT_TRS_DTIME
			,A.CR_PLANT_TRS_SEQ from c_tbk02_coil_comm A,TBE02_ORD_PRC B,TBH02_MILL_RESULT F, TBH02_COIL_COMM  T1,TBG02_SLAB_COMM TS, tbb01_ord_head    h
			where A.OLD_ORD_NO = B.ORD_NO AND A.OLD_ORD_SEQ = B.ORD_SEQ AND A.COIL_NO = T1.OLD_SAMPL_NO AND A.SLAB_NO = TS.SLAB_NO(+) AND T1.COIL_NO = F.COIL_NO AND A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' 
			AND A.OLD_ORD_NO = H.ORD_NO(+)
            AND A.OLD_ORD_SEQ = H.ORD_SEQ(+) 
			AND TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') >= to_date(?,'YYYY-MM-DD HH24:MI:SS')
			and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date(?,'YYYY-MM-DD HH24:MI:SS')+1
			order by CR_PLANT_TRS_DTIME,CR_PLANT_TRS_SEQ
		 )  QQ
	 full join
	(select A.OLD_SAMPL_NO,
       max(DECODE(WI.CHEM_CD, 'C', WI.CHEM_VAL)) VALUE_C,
       max(DECODE(WI.CHEM_CD, 'Mn', WI.CHEM_VAL)) VALUE_Mn,
       max(DECODE(WI.CHEM_CD, 'S', WI.CHEM_VAL)) VALUE_S,
       max(DECODE(WI.CHEM_CD, 'P', WI.CHEM_VAL)) VALUE_P,
       max(DECODE(WI.CHEM_CD, 'Si', WI.CHEM_VAL)) VALUE_Si,
       max(DECODE(WI.CHEM_CD, 'Ti', WI.CHEM_VAL)) VALUE_Ti,
       max(DECODE(WI.CHEM_CD, 'N', WI.CHEM_VAL)) VALUE_N
    from c_tbk02_coil_comm A,TBE02_ORD_PRC B,TBB02_WORK_INGR WI,TBG02_CHARGE_COMM_D D
    where A.OLD_ORD_NO = B.ORD_NO AND A.OLD_ORD_SEQ = B.ORD_SEQ and A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' 
   	 AND TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') >= to_date(?,'YYYY-MM-DD HH24:MI:SS')
	 and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date(?,'YYYY-MM-DD HH24:MI:SS')+1
     AND WI.CHARGE_NO = D.CHARGE_NO AND WI.PROC_CD || WI.CHEM_SEQ = D.LST_INGR_CD
     AND  SUBSTR(A.SLAB_NO, 1, 10) = WI.CHARGE_NO AND WI.CHEM_CD IN ('C','Mn','S','P','Si','Ti','N')
     GROUP BY A.OLD_SAMPL_NO)  CC on  QQ.OLD_SAMPL_NO = CC.OLD_SAMPL_NO
		 ]]>
	</query>
	
	<query id="UIK050010_03.SELECT"  desc="时间不等查询">
		<![CDATA[
		select QQ.*,CC.VALUE_C,CC.VALUE_Mn,CC.VALUE_S,CC.VALUE_P,CC.VALUE_Si,CC.VALUE_Ti,CC.VALUE_N from (
			select A.OLD_SAMPL_NO,A.STL_GRD,DECODE(A.CR_PLANT_TRS_CLF,'Z','常化','') CR_PLANT_TRS_CLF,
			B.C_SPEC_ABBSYM SPEC_ABBSYM,B.ORD_THK INSTR_COIL_THK,B.ORD_WTH INSTR_COIL_WTH,B.ORD_LEN INSTR_COIL_LEN,B.ORD_INDIA INSTR_COIL_INDIA,
			DECODE(H.EDGE_PROC_YN, NULL, 'N', H.EDGE_PROC_YN) EDGE_PROC_YN,
            H.C_SPEC_STL_GRD,
			B.ORD_OUTDIA INSTR_COIL_OUTDIA,B.ORD_UNIT_WGT INSTR_COIL_WGT,A.ACT_WGT,TS.SLAB_DCS_DETAIL,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD1) CRK_CD1,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD2) CRK_CD2,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD3) CRK_CD3,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD4) CRK_CD4,
			(select SM_CFNM FROM  TBZ00_COMMCD T WHERE LG_CD='H02001' and T.SM_CD = A.CRK_CD5) CRK_CD5,
			A.FM_EXT_STRIP_TEMP_AVG,F.FM_EXT_STRIP_CROWN_AVG HC_TU_DU,F.FM_STRIP_WDG_AVG HC_XIE_XIN,
			A.DC_TEMP_AVG,decode(A.TOT_DEC_GRD,'1','合格','2','不合格','3','外观异常','4','废品') TOT_DEC_GRD,
			A.OLD_ORD_NO,A.OLD_ORD_SEQ,C_PKG_UIM.GET_STDDATESTR(B.DEL_TO_DATE) DEL_TO_DATE,substr(A.SLAB_NO,1,10) HEAT_NO,
			decode(A.ORD_FL,'1','订单材','2','余材') ORD_FL,decode(A.CUR_PROG_CD,'PAB','基料卷入库待机') CUR_PROG_CD,A.COIL_LEN,
			A.COIL_INDIA,A.COIL_OUTDIA,A.COIL_THK,A.COIL_WTH
			,C_PKG_UIM.GET_STDDATESTR(A.CR_PLANT_TRS_DTIME) CR_PLANT_TRS_DTIME
			,A.CR_PLANT_TRS_SEQ from c_tbk02_coil_comm A,TBE02_ORD_PRC B,TBH02_MILL_RESULT F, TBH02_COIL_COMM  T1,TBG02_SLAB_COMM TS, tbb01_ord_head    h
			where A.OLD_ORD_NO = B.ORD_NO AND A.OLD_ORD_SEQ = B.ORD_SEQ AND A.COIL_NO = T1.OLD_SAMPL_NO  AND A.SLAB_NO = TS.SLAB_NO(+) AND T1.COIL_NO = F.COIL_NO  AND A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' 
			AND A.OLD_ORD_NO = H.ORD_NO(+)
            AND A.OLD_ORD_SEQ = H.ORD_SEQ(+) 
			AND TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') >= to_date(?,'YYYY-MM-DD HH24:MI:SS')
			and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date(?,'YYYY-MM-DD HH24:MI:SS')+1
			order by CR_PLANT_TRS_DTIME,CR_PLANT_TRS_SEQ
			 )  QQ
	 full join
	(select A.OLD_SAMPL_NO,
       max(DECODE(WI.CHEM_CD, 'C', WI.CHEM_VAL)) VALUE_C,
       max(DECODE(WI.CHEM_CD, 'Mn', WI.CHEM_VAL)) VALUE_Mn,
       max(DECODE(WI.CHEM_CD, 'S', WI.CHEM_VAL)) VALUE_S,
       max(DECODE(WI.CHEM_CD, 'P', WI.CHEM_VAL)) VALUE_P,
       max(DECODE(WI.CHEM_CD, 'Si', WI.CHEM_VAL)) VALUE_Si,
       max(DECODE(WI.CHEM_CD, 'Ti', WI.CHEM_VAL)) VALUE_Ti,
       max(DECODE(WI.CHEM_CD, 'N', WI.CHEM_VAL)) VALUE_N
    from c_tbk02_coil_comm A,TBE02_ORD_PRC B,TBB02_WORK_INGR WI,TBG02_CHARGE_COMM_D D
    where A.OLD_ORD_NO = B.ORD_NO AND A.OLD_ORD_SEQ = B.ORD_SEQ and A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' 
   	 AND TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') >= to_date(?,'YYYY-MM-DD HH24:MI:SS')
	 and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date(?,'YYYY-MM-DD HH24:MI:SS')+1
     AND WI.CHARGE_NO = D.CHARGE_NO AND WI.PROC_CD || WI.CHEM_SEQ = D.LST_INGR_CD
     AND  SUBSTR(A.SLAB_NO, 1, 10) = WI.CHARGE_NO AND WI.CHEM_CD IN ('C','Mn','S','P','Si','Ti','N')
     GROUP BY A.OLD_SAMPL_NO)  CC on  QQ.OLD_SAMPL_NO = CC.OLD_SAMPL_NO
		 ]]>
	</query>
	<query id="UIK050010_04.SELECT"  desc="时间不等查询">
		<![CDATA[
		select A.OLD_SAMPL_NO,
       A.STL_GRD,
       '' SPEC_ABBSYM,
       '' INSTR_COIL_THK,
       '' INSTR_COIL_WTH,
       '' INSTR_COIL_LEN,
       '' INSTR_COIL_INDIA,
       '' INSTR_COIL_OUTDIA,
       '' INSTR_COIL_WGT,
       A.ACT_WGT,
       DECODE(H.EDGE_PROC_YN, NULL, 'N', H.EDGE_PROC_YN) EDGE_PROC_YN,
       H.C_SPEC_STL_GRD,
       (select SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE LG_CD = 'H02001'
           and T.SM_CD = A.CRK_CD1) CRK_CD1,
       (select SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE LG_CD = 'H02001'
           and T.SM_CD = A.CRK_CD2) CRK_CD2,
       (select SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE LG_CD = 'H02001'
           and T.SM_CD = A.CRK_CD3) CRK_CD3,
       (select SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE LG_CD = 'H02001'
           and T.SM_CD = A.CRK_CD4) CRK_CD4,
       (select SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE LG_CD = 'H02001'
           and T.SM_CD = A.CRK_CD5) CRK_CD5,
       A.FM_EXT_STRIP_TEMP_AVG,
       A.DC_TEMP_AVG,
       
       decode(A.TOT_DEC_GRD,
              '1',
              '合格',
              '2',
              '不合格',
              '3',
              '外观异常',
              '4',
              '废品') TOT_DEC_GRD,
       A.ORD_NO OLD_ORD_NO,
       A.ORD_SEQ OLD_ORD_SEQ,
       '' DEL_TO_DATE,
       substr(A.SLAB_NO, 1, 10) HEAT_NO,
       decode(A.ORD_FL, '1', '订单材', '2', '余材') ORD_FL,
       decode(A.CUR_PROG_CD, 'PAB', '基料卷入库待机') CUR_PROG_CD,
       A.COIL_LEN,
       A.COIL_INDIA,
       A.COIL_OUTDIA,
       A.COIL_THK,
       A.COIL_WTH,
       C_PKG_UIM.GET_STDDATESTR(A.CR_PLANT_TRS_DTIME) CR_PLANT_TRS_DTIME,
       A.CR_PLANT_TRS_SEQ
  from C_TBK02_COIL_COMM A, TBH02_COIL_COMM T1,tbb01_ord_head    h
 WHERE A.OLD_SAMPL_NO = T1.OLD_SAMPL_NO
  and A.ORD_NO = H.ORD_NO(+)
    AND A.ORD_SEQ = H.ORD_SEQ(+)
   AND A.COIL_STAT = '3'
   AND A.OUT_YARD_KIND = '2'
   AND T1.DLIV_DIRNO IS NULL
   AND T1.COIL_STAT = '3'
   AND SUBSTR(T1.MILL_DTIME,1,8) BETWEEN ? AND ?
 order by CR_PLANT_TRS_DTIME, CR_PLANT_TRS_SEQ
		 ]]>
	</query>
	
	<query id="UIK050010_05.SELECT"  desc="时间不等查询">
		<![CDATA[
		
select t.OLD_SAMPL_NO,
       t.CR_PLANT_TRS_DTIME,
       t.ORD_NO,
       t.ORD_SEQ,
       t.ORG_ORD_NO,
       t.ORG_ORD_SEQ,
       t1.DEL_TO_DATE,
       t1.H_SPEC_STL_GRD,
       t1.C_SPEC_STL_GRD,
       substr(t.SLAB_NO, 1, 10) HEAT_NO,
        '' JSSJ,
       t.INSTR_COIL_THK,
       t.INSTR_COIL_WTH,
       t.COIL_THK,
       t.COIL_WTH,
       t.ACT_WGT,
       decode(t.ORD_FL,'1','订单材','2','余材') ORD_FL,
       decode(t.TOT_DEC_GRD,
              '1',
              '合格',
              '2',
              '不合格',
              '3',
              '外观异常',
              '4',
              '废品') TOT_DEC_GRD,
       '' bz
      
  from tbh02_coil_comm t, tbe02_ord_prc t1, tba01_ord_line t2
 where t.ORD_NO = t1.ORD_NO
   and t.ORD_SEQ = t1.ORD_SEQ
   and t.ORD_NO = t2.ORD_NO
   and t.ORD_SEQ = t2.ORD_SEQ
   and t2.RZHQX = 'Z'
   AND T.CR_PLANT_TRS_CLF = 'Z'
   AND T.CR_PLANT_TRS_DTIME BETWEEN nvl(?,'000000') AND nvl(?,'999999')
   AND T.OLD_SAMPL_NO LIKE ? || '%'
   AND T.ORD_NO LIKE ? || '%'
   AND T.ORD_SEQ LIKE ? || '%'
   AND T.ORG_ORD_NO LIKE ? || '%'
   AND T.ORG_ORD_SEQ LIKE ? || '%'
		 ]]>
	</query>
	
	<query id="UIK050010_06.SELECT"  desc="外购卷时间不等查询">
	<![CDATA[
			select A.OLD_SAMPL_NO,
		       A.STL_GRD,
		       A.SPEC_ABBSYM,
		       '' INSTR_COIL_THK,
		       '' INSTR_COIL_WTH,
		       '' INSTR_COIL_LEN,
		       '' INSTR_COIL_INDIA,
		       '' INSTR_COIL_OUTDIA,
		       '' INSTR_COIL_WGT,
		       A.ACT_WGT,
		       '' EDGE_PROC_YN,
		       '' C_SPEC_STL_GRD,
		       (select SM_CFNM
		          FROM TBZ00_COMMCD T
		         WHERE LG_CD = 'H02001'
		           and T.SM_CD = A.CRK_CD1) CRK_CD1,
		       (select SM_CFNM
		          FROM TBZ00_COMMCD T
		         WHERE LG_CD = 'H02001'
		           and T.SM_CD = A.CRK_CD2) CRK_CD2,
		       (select SM_CFNM
		          FROM TBZ00_COMMCD T
		         WHERE LG_CD = 'H02001'
		           and T.SM_CD = A.CRK_CD3) CRK_CD3,
		       (select SM_CFNM
		          FROM TBZ00_COMMCD T
		         WHERE LG_CD = 'H02001'
		           and T.SM_CD = A.CRK_CD4) CRK_CD4,
		       (select SM_CFNM
		          FROM TBZ00_COMMCD T
		         WHERE LG_CD = 'H02001'
		           and T.SM_CD = A.CRK_CD5) CRK_CD5,
		       A.FM_EXT_STRIP_TEMP_AVG,
		       A.DC_TEMP_AVG,
		       
		       decode(A.TOT_DEC_GRD,
		              '1',
		              '合格',
		              '2',
		              '不合格',
		              '3',
		              '外观异常',
		              '4',
		              '废品') TOT_DEC_GRD,
		       A.ORD_NO OLD_ORD_NO,
		       A.ORD_SEQ OLD_ORD_SEQ,
		       '' DEL_TO_DATE,
		       substr(A.SLAB_NO, 1, 10) HEAT_NO,
		       decode(A.ORD_FL, '1', '订单材', '2', '余材') ORD_FL,
		       decode(A.CUR_PROG_CD, 'PAB', '基料卷入库待机') CUR_PROG_CD,
		       A.COIL_LEN,
		       A.COIL_INDIA,
		       A.COIL_OUTDIA,
		       A.COIL_THK,
		       A.COIL_WTH,
		       C_PKG_UIM.GET_STDDATESTR(A.CR_PLANT_TRS_DTIME) CR_PLANT_TRS_DTIME,
		       A.CR_PLANT_TRS_SEQ
		  from C_TBK02_COIL_COMM A
		 WHERE A.OLD_SAMPL_NO LIKE '%W%'
		 AND A.CUR_LOAD_LOC IS NULL
		 AND A.COIL_STAT = '2'
		 AND SUBSTR(A.CR_PLANT_TRS_DTIME,1,8) BETWEEN ? AND ?
		 ORDER BY CR_PLANT_TRS_DTIME
	]]>
	</query>
	
	<query id="UIK050010_01.CALL"  desc="">
		<![CDATA[
		{ call PKG_UIK020010.takeOverCoilBack(?)}
		 ]]>
	</query>
	<query id="UIK050010_02.CALL"  desc="">
		<![CDATA[
		{ call PKG_UIK020010.takeOverCoilBackSx(?)}
		 ]]>
	</query>
</queryMap>