SELECT V.RCLXMC,V.YPMC00,V.YPGG00,V.JZRQ00,V.SHRQ00,V.JZSJ00,V.ZY0000,V.SFSH00, 
 B.KCDW00 JZDW00,B.K2J000 ZHL000,V.GJDJ00,V.FCDJ00,V.PFDJ00,
ROUND(V.FCSL00*V.ZHL000/B.K2J000,3) FCSL00,V.GJDJ00 as FCGJDJ,
(select MC0000 from BM_TYZD00 where NBBH00 in (select WZFLBH from BM_WZQTXX where ypnm00=V.YPNM00)) YPXZ00,
V.FCJE00,V.DJH000 AS CKDH00,V.YPBM00,V.PYSM00,V.ZBQMC0,V.SF4J70, 
V.LSDJH0,V.CRBMMC,V.LBMC00,V.YLMC00,V.YPMLBZ,V.GJFCJE,V.GHDWMC,V.SCPH00,V.YPSXRQ, 
 decode(V.JZXZ00,'C',(SELECT a.ZWXM00 FROM BM_YGBM00 a , YK_YPQLD0 b WHERE b.LYRBH0=a.YGBH00 and b.YPQLDH=V.DJH000 and rownum=1),null) LYR000, 
 (select YLMC00 From BM_YPYL00 a,bm_yd0000 b where a.YLBH00=b.YLBH00 and a.LBBH00=b.LBBH00 and b.YPNM00=V.YPNM00 and rownum=1) WZLX00, 
(SELECT R.SCCJZW from YK_YPRKMX R,YK_YPCKMX C where R.YPRKPC=C.YPRKPC and C.YPCKPC=V.YPCKPC) SCCJZW, 
(select CDMC00 from VW_YK_YPCDZD  where CDID00=B.CDID00) CDMC00,
(select R.PZWH00 from YK_YPRKMX R,YK_YPCKMX C where R.YPRKPC=C.YPRKPC and C.YPCKPC=V.YPCKPC) PZWH00, 
 (select BZ0000  from YK_YPCKMX C where C.YPCKPC=V.YPCKPC) MXBZ00, 
B.GJBZBM,B.GJBZMC,B.SFJCYY 
 ,K.ZCZXX0,K.ZCZRQ0,K.ZCSXRQ, 
 K.WZSX00, (select MC0000 from VW_WZ_WZSX where BH0000=K.WZSX00) WZSXMC 
FROM VW_YK_CKJZCX V,BM_YD0000 B 
,BM_WZQTXX K
WHERE V.YKBMBH+0=580
 and V.YPNM00=B.YPNM00 
 and V.YPNM00=K.YPNM00(+) 
 AND V.CRBMBH like '%'
AND V.JZRQ00>='20211201' AND V.JZRQ00<='20211206' 
AND V.JZRQ00||V.JZSJ00>='2021120100:00:00' AND V.JZRQ00||V.JZSJ00<='2021120623:59:59' 
 and ( (V.YLBH00 like 'WZ%'   ) or  ('-1'='-1') or  ('WZ'='WZ') )    
 and ((V.TYMBH0='ALL' or 'ALL'='ALL') or ('-1'='-1') ) 
 and K.WZSX00='0' 
ORDER BY V.JZRQ00,V.JZSJ00,V.DJH000,V.MXZLSH