select * from (select A.*,nvl(B.BMMC00,nvl((select BMMC00 from BM_BMBM00 where BMBH00=A.CRBMBH  and rownum=1),'未知部门')) TJXMMC from (
SELECT Z.CRBMBH,
SUM(DECODE(D.LBBH00,'0',Z.FCJE00,0)) AS XYLSJE,
SUM(DECODE(D.LBBH00,'1',Z.FCJE00,0)) AS CYLSJE,
SUM(DECODE(D.LBBH00,'2',Z.FCJE00,0)) AS ZYLSJE,
SUM(DECODE(D.LBBH00,'3',Z.FCJE00,0)) AS YXLSJE,
SUM(DECODE(D.LBBH00,'0',NVL(GJFCJE,ROUND(round(Z.FCSL00*Z.ZHL000/D.K2J000,3)*Z.GJDJ00,2)),0)) AS XYGJJE,
SUM(DECODE(D.LBBH00,'1',NVL(GJFCJE,ROUND(round(Z.FCSL00*Z.ZHL000/D.K2J000,3)*Z.GJDJ00,2)),0)) AS CYGJJE,
SUM(DECODE(D.LBBH00,'2',NVL(GJFCJE,ROUND(round(Z.FCSL00*Z.ZHL000/D.K2J000,3)*Z.GJDJ00,2)),0)) AS ZYGJJE,
SUM(DECODE(D.LBBH00,'3',NVL(GJFCJE,ROUND(round(Z.FCSL00*Z.ZHL000/D.K2J000,3)*Z.GJDJ00,2)),0)) AS YXGJJE 
FROM YF_YPMXZ0 Z,BM_YD0000 D 
 where  Z.YPNM00=D.YPNM00 
 and Z.YFBMBH+0=497
AND Z.JZXZ00='C' 
AND Z.RCLXBH like '%'
AND Z.JZRQ00>='20210201' AND Z.JZRQ00<='20210219' 
 AND JZRQ00||JZSJ00>='2021020100:00:00' AND JZRQ00||JZSJ00<='2021021923:59:59'
AND Z.CRBMBH <=10000
GROUP BY  Z.CRBMBH 
) A,VW_YF_YPCKFX B where A.CRBMBH=B.BMBH00(+)
ORDER BY  A.CRBMBH )
union all
select * from (SELECT Z.CRBMBH,
SUM(DECODE(D.LBBH00,'0',Z.FCJE00,0)) AS XYLSJE,
SUM(DECODE(D.LBBH00,'1',Z.FCJE00,0)) AS CYLSJE,
SUM(DECODE(D.LBBH00,'2',Z.FCJE00,0)) AS ZYLSJE,
SUM(DECODE(D.LBBH00,'3',Z.FCJE00,0)) AS YXLSJE,
SUM(DECODE(D.LBBH00,'0',NVL(GJFCJE,ROUND(round(Z.FCSL00*Z.ZHL000/D.K2J000,3)*Z.GJDJ00,2)),0)) AS XYGJJE,
SUM(DECODE(D.LBBH00,'1',NVL(GJFCJE,ROUND(round(Z.FCSL00*Z.ZHL000/D.K2J000,3)*Z.GJDJ00,2)),0)) AS CYGJJE,
SUM(DECODE(D.LBBH00,'2',NVL(GJFCJE,ROUND(round(Z.FCSL00*Z.ZHL000/D.K2J000,3)*Z.GJDJ00,2)),0)) AS ZYGJJE,
SUM(DECODE(D.LBBH00,'3',NVL(GJFCJE,ROUND(round(Z.FCSL00*Z.ZHL000/D.K2J000,3)*Z.GJDJ00,2)),0)) AS YXGJJE,Z.ZY0000 AS TJXMMC 
FROM YF_YPMXZ0 Z,BM_YD0000 D 
WHERE  Z.YPNM00=D.YPNM00 
AND Z.YFBMBH+0=497
AND Z.JZXZ00='C' 
AND Z.RCLXBH like '%'
AND Z.JZRQ00>='20210201' AND Z.JZRQ00<='20210219' 
 AND JZRQ00||JZSJ00>='2021020100:00:00' AND JZRQ00||JZSJ00<='2021021923:59:59'
AND Z.CRBMBH>10000
AND Z.CRBMBH <> 66666
GROUP BY  Z.CRBMBH,Z.ZY0000 
ORDER BY  Z.CRBMBH )