SELECT V.RCLXMC,V.YPMC00,V.YPGG00,NVL(decode(V.RCLXBH,'09',decode(V.GJSLJE,0,V.GJFCJE,V.GJSLJE),NVL(V.YGJJE0,V.GJJE00)),0) GJJE00,
 decode(RCLXBH,'09',nvl((select FPH000 from YK_YPCKMX where YPRKPC=V.YPRKPC and ypqldh=V.DJH000 and rownum=1),V.fph000),V.fph000) FPH000, 
V.JZRQ00,V.SHRQ00,V.JZSJ00,V.CRBMBH,V.ZY0000,
(select CGDBH0 from YK_YPDHD0 where RKDH00=V.DJH000 and rownum=1) CGJHDH,0 FLAG00,V.YPNM00,
(select B.CGMXXH from YK_YPDHD0 A,YK_CGJHMX B where TO_CHAR(A.CGDBH0)=B.CGJHDH and A.YPNM00=B.YPNM00 and A.RKDH00=V.DJH000 and A.YPNM00=V.YPNM00) CGMXXH,
 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,
(select MC0000 from BM_TYZD00 where NBBH00 in (select WZFLBH from BM_WZQTXX where ypnm00=V.YPNM00)) YPXZ00,
 W.ZCZXX0,B.WZXH00,decode(W.ZCZXX0,null,null,V.YPMC00) as ZCZMC0,(select BZ0000 from YK_YPRKMX where YPRKPC=v.YPRKPC) BZ0000,' ' DDRQ01,V.MXBZ00, 
 replace(to_char(SF_XT_STRTODATEVALUE(W.ZCSXRQ),'YYYY/MM/DD'),'/0','/') as ZCSXRQ1,
 replace(to_char(SF_XT_STRTODATEVALUE(V.JZRQ00),'YYYY/MM/DD'),'/0','/') as DDRQ00,
 W.ZCZRQ0,W.ZCSXRQ, 
V.LSDJH0,V.LBMC00,V.YLMC00,V.YPMLBZ,V.SCPH00,V.PZWH00,V.FPDM00,V.FPRQ00  
FROM VW_YK_RKJZ00 V,BM_YD0000 B
,BM_WZQTXX W
WHERE V.YKBMBH+0=121
 AND CRBMBH like '%'
AND V.JZRQ00>='20200101' AND V.JZRQ00<='20201231' 
AND V.JZRQ00||V.JZSJ00>='2020010100:00:00' AND V.JZRQ00||V.JZSJ00<='2020123123:59:59'   
 and ( (V.YLBH00 like 'WZ%'   ) or  ('-1'='-1')  or  ('WZ'='WZ') )    
 and ((V.TYMBH0='ALL' or 'ALL'='ALL') or ('-1'='-1') )  
and V.YPNM00=W.YPNM00
 and B.YPNM00=V.YPNM00
ORDER BY V.JZRQ00,V.JZSJ00,V.DJH000,V.MXZLSH