XinYu_LZMES/.svn/pristine/3d/3da8736743f5eaa3c7f24d0b60182f8bfc96ff10.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="原料库入库报表">
	<query id="UIK050020_01.SELECT"  desc="日查询">
		<![CDATA[
			SELECT distinct A.STL_GRD ,
       F.ORD_THK || '*' || F.ORD_WTH GUIGE,
       (select count(D.COIL_NO)
        FROM C_TBK02_COIL_COMM D,TBE02_ORD_PRC B
        WHERE D.STL_GRD = A.STL_GRD AND F.ORD_THK || '*' || F.ORD_WTH =
              B.ORD_THK || '*' || B.ORD_WTH
                      AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 8)>= SUBSTR(?, 1, 8) AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 8) <= SUBSTR(?, 1, 8)AND D.YARD_ENTRY_DTIME IS NOT NULL
                      and D.OLD_ORD_NO = B.ORD_NO(+)  AND D.OLD_ORD_SEQ  = B.ORD_SEQ(+)  /*AND A.OLD_SAMPL_NO =  D.OLD_SAMPL_NO*/
                      and D.IN_YARD_KIND = ?             
         ) date_roll_in_total,
         (select sum(D.ACT_WGT)
        FROM C_TBK02_COIL_COMM D,TBE02_ORD_PRC B
        WHERE D.STL_GRD = A.STL_GRD AND F.ORD_THK || '*' || F.ORD_WTH =
              B.ORD_THK || '*' || B.ORD_WTH
                      AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 8)>= SUBSTR(?, 1, 8) AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 8) <= SUBSTR(?, 1, 8)AND D.YARD_ENTRY_DTIME IS NOT NULL
                      and D.OLD_ORD_NO = B.ORD_NO(+)  AND D.OLD_ORD_SEQ  = B.ORD_SEQ(+)  /*AND A.OLD_SAMPL_NO =  D.OLD_SAMPL_NO*/
                      and D.IN_YARD_KIND = ?             
         ) date_roll_wgt_total,
         '' mon_roll_in_total ,
         '' mon_roll_wgt_total,
         '' year_roll_in_total,
         '' year_roll_wgt_total         
FROM C_TBK02_COIL_COMM A ,TBE02_ORD_PRC F
WHERE A.OLD_ORD_NO = F.ORD_NO(+) AND A.OLD_ORD_SEQ = F.ORD_SEQ(+)
AND SUBSTR(A.YARD_ENTRY_DTIME, 1, 8)>= SUBSTR(?, 1, 8) AND SUBSTR(A.YARD_ENTRY_DTIME, 1, 8) <= SUBSTR(?, 1, 8)AND A.YARD_ENTRY_DTIME is not null
AND A.STL_GRD LIKE ?|| '%'
order by A.STL_GRD
					 ]]>  
	</query>
	<query id="UIK050020_02.SELECT"  desc="月查询">
		<![CDATA[
	SELECT distinct A.STL_GRD ,
       F.ORD_THK || '*' || F.ORD_WTH GUIGE,
       '' date_roll_in_total,
       '' date_roll_wgt_total,
       (select count(D.COIL_NO)
        FROM C_TBK02_COIL_COMM D,TBE02_ORD_PRC B
        WHERE D.STL_GRD = A.STL_GRD AND F.ORD_THK || '*' || F.ORD_WTH =
              B.ORD_THK || '*' || B.ORD_WTH
                      AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 6)>= SUBSTR(?, 1, 6) AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 6) <= SUBSTR(?, 1, 6)AND D.YARD_ENTRY_DTIME IS NOT NULL
                      and D.OLD_ORD_NO = B.ORD_NO(+)  AND D.OLD_ORD_SEQ  = B.ORD_SEQ(+)  /*AND A.OLD_SAMPL_NO =  D.OLD_SAMPL_NO*/
                      and D.IN_YARD_KIND = ?             
         ) mon_roll_in_total,
         (select sum(D.ACT_WGT)
        FROM C_TBK02_COIL_COMM D,TBE02_ORD_PRC B
        WHERE D.STL_GRD = A.STL_GRD AND F.ORD_THK || '*' || F.ORD_WTH =
              B.ORD_THK || '*' || B.ORD_WTH
                      AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 6)>= SUBSTR(?, 1, 6) AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 6) <= SUBSTR(?, 1, 6)AND D.YARD_ENTRY_DTIME IS NOT NULL
                      and D.OLD_ORD_NO = B.ORD_NO(+)  AND D.OLD_ORD_SEQ  = B.ORD_SEQ(+)  /*AND A.OLD_SAMPL_NO =  D.OLD_SAMPL_NO*/
                      and D.IN_YARD_KIND = ?             
         ) mon_roll_wgt_total,
         '' year_roll_in_total,
         '' year_roll_wgt_total        
FROM C_TBK02_COIL_COMM A ,TBE02_ORD_PRC F
WHERE A.OLD_ORD_NO = F.ORD_NO(+) AND A.OLD_ORD_SEQ = F.ORD_SEQ(+)
AND SUBSTR(A.YARD_ENTRY_DTIME, 1, 6)>= SUBSTR(?, 1, 6) AND SUBSTR(A.YARD_ENTRY_DTIME, 1, 6) <= SUBSTR(?, 1, 6)AND A.YARD_ENTRY_DTIME is not null
AND A.STL_GRD LIKE ? || '%'
order by A.STL_GRD
	 ]]>
	</query>
	<query id="UIK050020_03.SELECT"  desc="年查询">
		<![CDATA[
SELECT distinct A.STL_GRD ,
       F.ORD_THK || '*' || F.ORD_WTH GUIGE,
       '' date_roll_in_total,
       '' date_roll_wgt_total,
       '' mon_roll_in_total ,
         '' mon_roll_wgt_total,
       (select count(D.COIL_NO)
        FROM C_TBK02_COIL_COMM D,TBE02_ORD_PRC B
        WHERE D.STL_GRD = A.STL_GRD AND F.ORD_THK || '*' || F.ORD_WTH =
              B.ORD_THK || '*' || B.ORD_WTH
                      AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 4)>= SUBSTR(?, 1, 4) AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 4) <= SUBSTR(?, 1, 4)AND D.YARD_ENTRY_DTIME IS NOT NULL
                      and D.OLD_ORD_NO = B.ORD_NO(+)  AND D.OLD_ORD_SEQ  = B.ORD_SEQ(+)  /*AND A.OLD_SAMPL_NO =  D.OLD_SAMPL_NO*/
                      and D.IN_YARD_KIND = ?             
         ) year_roll_in_total,
         (select sum(D.ACT_WGT)
        FROM C_TBK02_COIL_COMM D,TBE02_ORD_PRC B
        WHERE D.STL_GRD = A.STL_GRD AND F.ORD_THK || '*' || F.ORD_WTH =
              B.ORD_THK || '*' || B.ORD_WTH
                      AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 4)>= SUBSTR(?, 1, 4) AND SUBSTR(D.YARD_ENTRY_DTIME, 1, 4) <= SUBSTR(?, 1, 4)AND D.YARD_ENTRY_DTIME IS NOT NULL
                      and D.OLD_ORD_NO = B.ORD_NO(+)  AND D.OLD_ORD_SEQ  = B.ORD_SEQ(+)  /*AND A.OLD_SAMPL_NO =  D.OLD_SAMPL_NO*/
                      and D.IN_YARD_KIND = ?             
         ) year_roll_wgt_total         
FROM C_TBK02_COIL_COMM A ,TBE02_ORD_PRC F
WHERE A.OLD_ORD_NO = F.ORD_NO(+) AND A.OLD_ORD_SEQ = F.ORD_SEQ(+)
AND SUBSTR(A.YARD_ENTRY_DTIME, 1, 4)>= SUBSTR(?, 1, 4) AND SUBSTR(A.YARD_ENTRY_DTIME, 1, 4) <= SUBSTR(?, 1, 4)AND A.YARD_ENTRY_DTIME is not null
AND A.STL_GRD LIKE ? || '%'
order by A.STL_GRD
	 ]]>
	</query>
</queryMap>