这段存储过程是什么意思?
孙月魂 2012-05-27 11:57:03 cursor fhjsl is
select count(*) icount,
decode(yy_bmmc,
'城东',
'城东送货部',
'城南',
'城南送货部',
'城西',
'城西送货部',
'城北',
'城北送货部',
yy_bmmc) yy_bmmc,
yy_zbbmbh
from (select yy_fhlb.yy_fhsj,
yy_fhlb.yy_flag9,
yy_fhlb.yy_sametel,
yy_zbbmbh,
yy_fgstd,
yy_bmmc,
yy_sfzb,
yy_zyjb,
round((nvl(dhsj, sysdate) - nvl(nvl(zbsj,yy_fhsj), sysdate)) * 24,
0) dhsjc,
round((nvl(nvl(yy_completedtime, hfsj), sysdate) -
nvl(dhsj, sysdate)) * 24,
0) hfsjc,
decode(yy_zyjb, '1', 24, '2', 48, '3', 72, 24) ckz
from yy_fhlb,
yyv_bm,
(select yy_fhlbid, max(yy_hfsj) zbsj
from yy_fhlb_cl
where yy_clbz = '7'
group by yy_fhlbid) yy_zbsj,
(select yy_fhlbid, min(yy_hfsj) dhsj
from yy_fhlb_cl
where yy_clbz = '1'
group by yy_fhlbid) yy_dhsj,
(select yy_fhlbid, max(yy_hfsj) hfsj
from yy_fhlb_cl
where yy_clbz = '2'
group by yy_fhlbid) yy_hfsj,
(select yy_telid, yy_completedtime
from yy_tel_repairinfo, yy_fhlb
where yy_tel_repairinfo.yy_telid(+) = yy_fhlb.yy_fhlbid
and trunc(yy_fhsj) between
to_date(s_date, 'yyyy-mm-dd') and
to_date(e_date, 'yyyy-mm-dd')) yy_xfsj
where yy_fhlb.yy_fhztbz in ('1', '2', '3')
and yy_fhlb.yy_fhflbh in ('03', '16', '28','18','46')
and yy_fhlb.yy_fhlbid = yy_zbsj.yy_fhlbid(+)
and yy_fhlb.yy_fhlbid = yy_dhsj.yy_fhlbid(+)
and YY_JLLXBH = '0'
and yy_fhlb.yy_fhlbid = yy_hfsj.yy_fhlbid(+)
and yy_xfsj.yy_telid(+) = yy_fhlb.yy_fhlbid
and yy_bmbh = yy_zbbmbh) yy_cstj
where (((dhsjc <= 0.18 or hfsjc <= ckz) and s_date <= '2010-03-01') or
(hfsjc <= ckz and s_date >= '2010-04-01') or yy_flag9 = 1 or
yy_sametel = 1)
and yy_sfzb = 1
and yy_zbbmbh in ('01', '02', '03', '04')
and trunc(yy_fhsj) between to_date(s_date, 'yyyy-mm-dd') and
to_date(e_date, 'yyyy-mm-dd')
group by yy_bmmc, yy_zbbmbh
order by yy_bmmc;
希望能详细点!我是菜鸟~