SELECT R.CKDH00,G.BMMC00,Y.ZWXM00,R.QRRQ00,R.CKBMBH,
(SELECT L.ZWXM00 FROM BM_YGBM00 L WHERE R.LYR000=L.YGBH00) LYR000,
(SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.JYR000=I.YGBH00) JYR000
FROM YF_YPCKD0 R,VW_YF_YPCKFX G,BM_YGBM00 Y
WHERE R.YFBMBH=30
  AND R.CKZT00='1'
  AND R.CKBMBH=G.BMBH00
  AND R.CKLXBH='08'
  AND R.JYSFGH='N'
  AND R.CZY000=Y.YGBH00(+) 
ORDER BY G.BMMC00