SELECT V.RCLXMC,V.YPMC00,V.YPGG00,V.FPH000,NVL(decode(V.RCLXBH,'09',decode(V.GJSLJE,0,V.GJFCJE,V.GJSLJE),NVL(V.YGJJE0,V.GJJE00)),0) GJJE00,
V.JZRQ00,V.SHRQ00,V.JZSJ00,V.CRBMBH,V.ZY0000,
 B.KCDW00 JZDW00,B.K2J000 ZHL000,V.GJDJ00,V.SLDJ00,V.PFDJ00,
ROUND(V.SLSL00*V.ZHL000/B.K2J000,3) SLSL00,V.GJDJ00 as SLGJDJ,
V.SLJE00,V.DJH000 AS RKDH00,V.SFSH00,V.YPBM00,V.PYSM00,V.ZBQ000,V.SF4J70, 
V.SCCJZW,V.CDMC00,V.GHDWMC,V.YPSXRQ,NVL(V.SLJE00,0)-NVL(decode(V.RCLXBH,'09',decode(V.GJSLJE,0,V.GJFCJE,V.GJSLJE),NVL(V.YGJJE0,V.GJJE00)),0) JXCJ00,V.JXMC00,
V.LSDJH0,V.LBMC00,V.YLMC00,V.YPMLBZ,V.SCPH00,V.PZWH00,V.FPDM00,V.FPRQ00,(select MC0000 from VW_YK_YDYPXZ where BH0000=B.YPXZ00) YPXZ00 
FROM VW_YK_RKJZ00 V,BM_YD0000 B
WHERE V.YKBMBH+0=121
 and B.YPNM00=V.YPNM00
 AND CRBMBH like '%'
AND V.JZRQ00>='20200401' AND V.JZRQ00<='20200429' 
AND V.JZRQ00||V.JZSJ00>='2020040100:00:00' AND V.JZRQ00||V.JZSJ00<='2020042923:59:59' 
 and ( (V.YLBH00 like 'WZ%'   ) or  ('-1'='-1')  or  ('WZ'='WZ') )    
 and ((V.TYMBH0='ALL' or 'ALL'='ALL') or ('-1'='-1') ) 
ORDER BY V.JZRQ00,V.JZSJ00,V.DJH000,V.MXZLSH