1       16:43:27  SQL Execute: ORACLE -  select a.ypbm00 ypbm00,nvl(k.sjkcsl,0) sjkcsl,nvl(k.kcje00,0) kcje00,' ' BMMC00,decode(a.YPMC00,'',0,1) PX0000,a.YPMC00,a.PYSM00,a.WBSM00,a.YPMLBZ,a.YPGG00,a.KCDW00 KCDW00,
 b.YPNM00,NVL(b.SLSL00,0) SLSL00,NVL(b.SLJE00,0) SLJE00,NVL(b.FCSL00,0) FCSL00,NVL(b.FCJE00,0) FCJE00,NVL(b.GJSLJE,0) GJSLJE,nvl(b.GJFCJE,0) GJFCJE,nvl(k.GJZJE0,0) JCGJJE,nvl(b.sldj00,0) sldj00,nvl(b.fcdj00,0) fcdj00,
 a.gjj000,a.lsj000,nvl(a.NSBL00,1) NSBL00,a.DDD000 DDD000 
 from BM_YD0000 a,(select * from vw_yf_pckchz where yfbmbh+0=479 ) k ,
 (select c.YPNM00,sum(ROUND(SLSL00*ZHL000/D.K2J000,3)) SLSL00,
 sum(SLJE00) SLJE00,sum(ROUND(FCSL00*ZHL000/D.K2J000,3)) FCSL00,sum(FCJE00) FCJE00,SUM(nvl(GJSLJE,round(SLSL00*ZHL000/D.K2J000*c.gjdj00,2))) GJSLJE,
 SUM(nvl(GJFCJE,round(FCSL00*ZHL000/D.K2J000*c.gjdj00,2))) GJFCJE,round(avg(sldj00),4) sldj00,round(avg(fcdj00),4) fcdj00 
 from YF_YPMXZ0 c,BM_YD0000 d
 where c.YPNM00=d.YPNM00
 and ((c.JZXZ00='R' and c.RCLXBH in ('12','13','01','02','03','04','05','06','07','08','09','10','11'))
   or (c.JZXZ00 = 'C' and c.RCLXBH in ('14','01','02','03','04','05','06','07','08','09','11','12','13','10','19')
))
 and LBBH00 like '0%'
 and YLBH00 like '%'
 and JXBH00 like '%'
 and YPXZ00 like '%' 
 and c.YFBMBH+0=479
 and c.JZRQ00>='20240109' and c.JZRQ00<='20240109'
 and c.JZRQ00||c.JZSJ00>='2024010900:00:00' and c.JZRQ00||c.JZSJ00<='2024010923:59:59'
AND c.CRBMBH <> 66666
 group by c.YPNM00
 order by c.YPNM00 desc) b
 where a.YPNM00(+)=b.YPNM00  and k.ypnm00(+)=b.ypnm00 
 order by PX0000