select 
  c.*,
  c.GJTJSY as C_TJSYGJ,
  c.LSTJSY as C_TJSY 
from 
  (select 
     A.*,
     B.PYSM00,
     B.WBSM00,
     B.YPBM00,
     (select J.SCCJZW from BM_YPSCCJ J where J.SCCJBH=B.SCCJBH) SCCJZW ,
     B.CPID00,
     (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) GHDWMC, 
     round(a.XLSDJ0-a.YLSDJ0,5) as C_LSCJ,
     round(a.XPFDJ0-a.YPFDJ0,5) as C_GJCJ,
     a.XPFDJ1-a.YPFDJ1 as C_PFCJ 
  from VW_YK_YPTJCX_ALLKF A,BM_YD0000 B
  WHERE A.YPNM00 = B.YPNM00 
  AND A.YKBMBH=27 and A.YKBMBH=A.YXBMBH
  --AND B.LBBH00 LIKE %%
  AND A.QRRQ00>='20220601'
  AND A.QRRQ00<='20220630'
  AND A.QRRQ00||A.QRSJ00>='2022060100:00:00' 
  AND A.QRRQ00||A.QRSJ00<='2022063023:59:59'
  oRDER BY A.QRRQ00,A.YPTJPC,A.YPNM00 ) c

-----------------------------------------

 select 
   c.*,
   round(c.C_GJCJ*c.SJKC00,2) as C_GJSY,
   round(c.C_LSCJ*c.SJKC00,2) as C_TJSY 
   from 
  (select 
    A.*,
    B.BMMC00 AS YXYF00,
    (select f.GHDWMC from YK_YPRKD0 g,YK_YPRKMX h,BM_YPGHDW f where h.YPRKPC=A.YPRKPC and g.RKDH00=h.RKDH00 and g.GHDWNM=f.GHDWNM and rownum=1) GHDWMC, 
    round(a.XLSDJ0-a.YLSDJ0,5) as C_LSCJ,
    round(a.XPFDJ0-a.YPFDJ0,5) as C_GJCJ,
    a.XPFDJ1-a.YPFDJ0 as C_PFCJ, 
    DECODE(decode(A.YPFDJ1,0,A.XPFDJ0,A.XPFDJ0),0,0,round((A.XPFDJ0/decode(A.YPFDJ1,0,A.XPFDJ0,A.XPFDJ0))-1,4)*100) YPJCL0,
    SF_YF_YPSLZH(nvl(A.SJKC00*A.ZHL000,0),A.YPNM00,3) TJSL00  
  from YK_YPTJMX A,BM_BMBM00 B where  --YPTJPC= '06018'  AND YPNM00='9000016308.000000' AND 
A.YXBMBH=B.BMBH00  and A.YSBZ00='0' and SFQR00='Y' and A.SFCYTJ='1' and nvl(a.SJKC00,0)>0 ORDER BY B.BMXZ00,b.PXXH00 ) c