XinYu_RZMES/.svn/pristine/47/476df7bac0c42fc2613b4116569cbe75aeb9dc66.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH051800_01.select" desc=" 规格 ">
        <![CDATA[
            select count(a.old_sampl_no) coil_cnt,
       NVL(sum(a.act_wgt)/1000,0) coil_wgt,
       min(a.instr_coil_thk) instr_coil_thk,
       min(a.instr_coil_wth) instr_coil_wth
       
 from tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,12) >= :3
  AND SUBSTR(A.MILL_DTIME,1,12) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
  group by a.instr_coil_thk,a.instr_coil_wth
  order by a.instr_coil_thk,a.instr_coil_wth
		]]>
    </query>
	<query id="UIH051800_02.select" desc=" 牌号 ">
        <![CDATA[
            select count(a.old_sampl_no) coil_cnt,
 	 NVL(sum(a.act_wgt)/1000,0) coil_wgt,
	  max(a.spec_stl_grd) spec_stl_grd
from tbh02_coil_comm A,TBH02_REHEATFUR B
WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
 AND SUBSTR(A.MILL_DTIME,1,12) >= :3
 AND SUBSTR(A.MILL_DTIME,1,12) <= :4
 AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
 AND A.OLD_SAMPL_NO >= :6
 AND A.OLD_SAMPL_NO <= :7
 group by a.spec_stl_grd
 order by a.spec_stl_grd
		]]>
    </query>
	<query id="UIH051800_03.select" desc="正此统计 ">
        <![CDATA[
			 select count(a.old_sampl_no) coil_cnt,
       NVL(sum(a.act_wgt)/1000,0) coil_wgt,
       DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','次品','','待判定') EXTSHAPE_DEC_GRD
       
 from tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,12) >= :3
  AND SUBSTR(A.MILL_DTIME,1,12) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
  group by A.EXTSHAPE_DEC_GRD
  order by a.EXTSHAPE_DEC_GRD
		]]>
    </query>
	<query id="UIH051800_04.select" desc=" 按照规格，牌号统计 ">
        <![CDATA[
			 select count(a.old_sampl_no) coil_cnt,
       NVL(sum(a.act_wgt)/1000,0) coil_wgt,
       min(a.instr_coil_thk) instr_coil_thk,
       min(a.instr_coil_wth) instr_coil_wth,
       min(a.spec_stl_grd) spec_stl_grd
       
 from tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,12) >= :3
  AND SUBSTR(A.MILL_DTIME,1,12) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
  group by a.instr_coil_thk,a.instr_coil_wth,a.spec_stl_grd
  order by a.instr_coil_thk,a.instr_coil_wth
		]]>
    </query>
	<query id="UIH051800_05.select" desc=" 按照规格，正次统计 ">
        <![CDATA[
			 select count(a.old_sampl_no) coil_cnt,
       NVL(sum(a.act_wgt)/1000,0) coil_wgt,
       min(a.instr_coil_thk) instr_coil_thk,
       min(a.instr_coil_wth) instr_coil_wth,
       DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','次品','','待判定') EXTSHAPE_DEC_GRD
       
 from tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,12) >= :3
  AND SUBSTR(A.MILL_DTIME,1,12) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
  group by a.instr_coil_thk,a.instr_coil_wth,A.EXTSHAPE_DEC_GRD
  order by a.instr_coil_thk,a.instr_coil_wth,A.EXTSHAPE_DEC_GRD
		]]>
    </query>
	<query id="UIH051800_06.select" desc=" 按照牌号，正此统计 ">
        <![CDATA[
			 select count(a.old_sampl_no) coil_cnt,
       NVL(sum(a.act_wgt)/1000,0) coil_wgt,
       min(a.spec_stl_grd) spec_stl_grd,
       DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','次品','','待判定') EXTSHAPE_DEC_GRD
       
 from tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,12) >= :3
  AND SUBSTR(A.MILL_DTIME,1,12) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
  group by a.SPEC_STL_GRD,A.EXTSHAPE_DEC_GRD
  order by a.SPEC_STL_GRD,A.EXTSHAPE_DEC_GRD
		]]>
    </query>
	<query id="UIH051800_07.select" desc=" 全部统计 ">
        <![CDATA[
			 select count(a.old_sampl_no) coil_cnt,
       NVL(sum(a.act_wgt)/1000,0) coil_wgt,
       min(a.spec_stl_grd) spec_stl_grd,
       min(a.instr_coil_thk) instr_coil_thk,
       min(a.instr_coil_wth) instr_coil_wth,
       DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','次品','','待判定') EXTSHAPE_DEC_GRD
       
 from tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,12) >= :3
  AND SUBSTR(A.MILL_DTIME,1,12) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
  group by a.instr_coil_thk,a.instr_coil_wth,a.SPEC_STL_GRD,A.EXTSHAPE_DEC_GRD
  order by a.instr_coil_thk,a.instr_coil_wth,a.SPEC_STL_GRD,A.EXTSHAPE_DEC_GRD
		]]>
    </query>
		<query id="UIH051800_08.select" desc=" 订单材/余材 ">
        <![CDATA[
			select decode(ORD_FL,'1','订单材','2','余材') ORD_FL,sum(ACT_WGT) COIL_WGT,count(OLD_SAMPL_NO)COIL_CNT from 
(
select (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_THK) ELSE (A.COIL_THK) END) coil_cnt_thk,
       (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_WTH) ELSE (A.COIL_WTH) END) coil_cnt_wth,
       A.ORD_FL,
       CASE WHEN A.ORD_FL = '1' THEN A.INSTR_COIL_THK ELSE A.COIL_THK END THK,
       CASE WHEN A.ORD_FL = '1' THEN A.INSTR_COIL_WTH ELSE A.COIL_WTH END WTH,
       A.SPEC_STL_GRD,
       a.ACT_WGT,
       a.OLD_SAMPL_NO 
 FROM  tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,8) >= :3
  AND SUBSTR(A.MILL_DTIME,1,8) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
) group by ORD_FL
order by ORD_FL
		]]>
    </query>
		<query id="UIH051800_09.select" desc=" 订单材/余材 和规格">
        <![CDATA[
		        select decode(ORD_FL,'1','订单材','2','余材') ORD_FL,coil_cnt_thk instr_coil_thk,coil_cnt_wth instr_coil_wth,sum(ACT_WGT) COIL_WGT,count(OLD_SAMPL_NO)COIL_CNT from 
(
select (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_THK) ELSE (A.COIL_THK) END) coil_cnt_thk,
       (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_WTH) ELSE (A.COIL_WTH) END) coil_cnt_wth,
       A.ORD_FL,
       A.SPEC_STL_GRD,
       a.ACT_WGT,
       a.OLD_SAMPL_NO 
 FROM  tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,8) >= :3
  AND SUBSTR(A.MILL_DTIME,1,8) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
) group by ORD_FL,coil_cnt_thk,coil_cnt_wth
order by ORD_FL,coil_cnt_thk,coil_cnt_wth
		]]>
    </query>
		<query id="UIH051800_10.select" desc=" 订单材/余材 和牌号">
        <![CDATA[
		          select decode(ORD_FL,'1','订单材','2','余材') ORD_FL,SPEC_STL_GRD,sum(ACT_WGT) COIL_WGT,count(OLD_SAMPL_NO)COIL_CNT from 
(
select (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_THK) ELSE (A.COIL_THK) END) coil_cnt_thk,
       (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_WTH) ELSE (A.COIL_WTH) END) coil_cnt_wth,
       A.ORD_FL,
       A.SPEC_STL_GRD,
       a.ACT_WGT,
       a.OLD_SAMPL_NO 
 FROM  tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,8) >= :3
  AND SUBSTR(A.MILL_DTIME,1,8) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
) group by ORD_FL,SPEC_STL_GRD
order by ORD_FL,SPEC_STL_GRD
		]]>
    </query>
		<query id="UIH051800_11.select" desc=" 订单材/余材 和正次品">
        <![CDATA[
  select decode(ORD_FL,'1','订单材','2','余材') ORD_FL,
         DECODE(EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','次品','','待判定') EXTSHAPE_DEC_GRD,
         sum(ACT_WGT) COIL_WGT,count(OLD_SAMPL_NO)COIL_CNT from 
(
select (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_THK) ELSE (A.COIL_THK) END) coil_cnt_thk,
       (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_WTH) ELSE (A.COIL_WTH) END) coil_cnt_wth,
       A.ORD_FL,
       A.SPEC_STL_GRD,
       a.ACT_WGT,
       a.OLD_SAMPL_NO,
       EXTSHAPE_DEC_GRD  
 FROM  tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,8) >= :3
  AND SUBSTR(A.MILL_DTIME,1,8) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
) group by ORD_FL,EXTSHAPE_DEC_GRD
order by ORD_FL,EXTSHAPE_DEC_GRD
		]]>
    </query>
		<query id="UIH051800_12.select" desc=" 订单材/余材 和规格、牌号">
        <![CDATA[
    select decode(ORD_FL,'1','订单材','2','余材') ORD_FL,
         coil_cnt_thk INSTR_COIL_THK,
         coil_cnt_wth INSTR_COIL_WTH,
         SPEC_STL_GRD,
         sum(ACT_WGT) COIL_WGT,count(OLD_SAMPL_NO)COIL_CNT from 
(
select (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_THK) ELSE (A.COIL_THK) END) coil_cnt_thk,
       (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_WTH) ELSE (A.COIL_WTH) END) coil_cnt_wth,
       A.ORD_FL,
       A.SPEC_STL_GRD,
       a.ACT_WGT,
       a.OLD_SAMPL_NO,
       EXTSHAPE_DEC_GRD  
 FROM  tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,8) >= :3
  AND SUBSTR(A.MILL_DTIME,1,8) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
) group by ORD_FL,coil_cnt_thk,coil_cnt_wth,SPEC_STL_GRD
order by ORD_FL,coil_cnt_thk,coil_cnt_wth,SPEC_STL_GRD
		]]>
    </query>
		<query id="UIH051800_13.select" desc=" 订单材/余材 和规格、正次">
        <![CDATA[
  select decode(ORD_FL,'1','订单材','2','余材') ORD_FL,
         coil_cnt_thk INSTR_COIL_THK,
         coil_cnt_wth INSTR_COIL_WTH,
         DECODE(EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','次品','','待判定') EXTSHAPE_DEC_GRD,
         sum(ACT_WGT) COIL_WGT,count(OLD_SAMPL_NO)COIL_CNT from 
(
select (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_THK) ELSE (A.COIL_THK) END) coil_cnt_thk,
       (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_WTH) ELSE (A.COIL_WTH) END) coil_cnt_wth,
       A.ORD_FL,
       A.SPEC_STL_GRD,
       a.ACT_WGT,
       a.OLD_SAMPL_NO,
       EXTSHAPE_DEC_GRD  
 FROM  tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,8) >= :3
  AND SUBSTR(A.MILL_DTIME,1,8) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
) group by ORD_FL,coil_cnt_thk,coil_cnt_wth,EXTSHAPE_DEC_GRD
order by ORD_FL,coil_cnt_thk,coil_cnt_wth,EXTSHAPE_DEC_GRD
		]]>
    </query>
		<query id="UIH051800_14.select" desc=" 订单材/余材 和牌号、正次">
        <![CDATA[
 select decode(ORD_FL,'1','订单材','2','余材') ORD_FL,
         SPEC_STL_GRD,
         DECODE(EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','次品','','待判定') EXTSHAPE_DEC_GRD,
         sum(ACT_WGT) COIL_WGT,count(OLD_SAMPL_NO)COIL_CNT from 
(
select (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_THK) ELSE (A.COIL_THK) END) coil_cnt_thk,
       (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_WTH) ELSE (A.COIL_WTH) END) coil_cnt_wth,
       A.ORD_FL,
       A.SPEC_STL_GRD,
       a.ACT_WGT,
       a.OLD_SAMPL_NO,
       EXTSHAPE_DEC_GRD  
 FROM  tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,8) >= :3
  AND SUBSTR(A.MILL_DTIME,1,8) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
) group by ORD_FL,SPEC_STL_GRD,EXTSHAPE_DEC_GRD
order by ORD_FL,SPEC_STL_GRD,EXTSHAPE_DEC_GRD
		]]>
    </query>
		<query id="UIH051800_15.select" desc=" 订单材/余材 和规格、牌号、正次">
        <![CDATA[
select decode(ORD_FL,'1','订单材','2','余材') ORD_FL,
         SPEC_STL_GRD,
         DECODE(EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','次品','','待判定') EXTSHAPE_DEC_GRD,
         coil_cnt_thk INSTR_COIL_THK,
         coil_cnt_wth INSTR_COIL_WTH,
         sum(ACT_WGT) COIL_WGT,count(OLD_SAMPL_NO)COIL_CNT from 
(
select (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_THK) ELSE (A.COIL_THK) END) coil_cnt_thk,
       (CASE WHEN A.ORD_FL = '1' THEN (A.INSTR_COIL_WTH) ELSE (A.COIL_WTH) END) coil_cnt_wth,
       A.ORD_FL,
       A.SPEC_STL_GRD,
       a.ACT_WGT,
       a.OLD_SAMPL_NO,
       EXTSHAPE_DEC_GRD  
 FROM  tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,8) >= :3
  AND SUBSTR(A.MILL_DTIME,1,8) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
) group by ORD_FL,coil_cnt_thk,coil_cnt_wth,SPEC_STL_GRD,EXTSHAPE_DEC_GRD
order by ORD_FL,coil_cnt_thk,coil_cnt_wth,SPEC_STL_GRD,EXTSHAPE_DEC_GRD
		]]>
    </query>
	<query id="UIH051800_01.sum" desc=" 入库的总数应该是一样的，所以一个求和即可 ">
        <![CDATA[
            select count(a.old_sampl_no) coil_cnt,
				   NVL(sum(a.act_wgt)/1000,0) coil_wgt 
       
 from tbh02_coil_comm A,TBH02_REHEATFUR B
 WHERE A.COIL_NO = B.COIL_NO
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) >= :1
  AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,A.TRNF_USE_TIME),1,8) <= :2
  AND SUBSTR(A.MILL_DTIME,1,12) >= :3
  AND SUBSTR(A.MILL_DTIME,1,12) <= :4
  AND B.EXTRACT_WKSHIFT||'&' LIKE :5||'%'
  AND A.OLD_SAMPL_NO >= :6
  AND A.OLD_SAMPL_NO <= :7
		]]>
    </query>
</queryMap>