SQL Statement from editor:
   
   
  SELECT  C.CFLSH0,C.GHH000,C.BRXM00,B.BRBLH0,C.XB0000,
  C.CSRQ00,C.YSXM00,M.BMMC00 AS GHKS00,C.ZYTS00,F.FBMC00,
  C.SRRQ00,C.JZRQ00,C.JZSJ00,C.CFZJE0,C.CFZT00,C.YPDLBH,
  C.DJH000,C.FYRQ00,C.FYSJ00,G.ZWXM00 AS LRY000,C.ZYDJS0,
  C.BCCFH0||TRIM(C.BZ0000) AS BZ0000,H.ZWXM00 AS FYR000,
  (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000,
  (SELECT Trim(ZDMC00) FROM YS_BRZDXX  WHERE GHH000=C.GHH000
   AND ZZDBZ0='3'  and rownum='1') as ZZDMC0,
   NVL(C.CFDGS0,'5') CFDGS0,G.QYRQ00,G.QYSJ00,G.JYDH00 
   FROM BM_BRXXB0 B,YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,VW_YF_MZBRZH F,YF_JYXXB0 G 
   WHERE C.YFBMBH+0=73
   AND C.YPDLBH='2' AND C.ZYDJS0>0 
   AND C.FYRQ00>='20130813'
   AND C.FYRQ00<='20130813'
   AND C.CFZT00='2' AND CFBDCS IS  NULL
   AND C.GHKS00=M.BMBH00
   AND C.CZY000=G.YGBH00
   AND C.BRID00=B.BRID00
   AND C.BRID00=F.BRID00
   AND C.GHH000=F.GHH000
   AND C.FYR000=H.YGBH00(+)
   AND C.CFLSH0=G.CFLSH0(+)  
   and G.PFRQ00='20991231' and G.QXDJRQ='20991231'  ORDER BY C.JZRQ00 DESC,G.QYRQ00,G.QYSJ00
  ------------------------------------------------------------
    
  Statement Id=22   Type=INDEX
  Cost=0  TimeStamp=13-08-13::17::26:08
  
    SELECT STATEMENT  RULE
       (3)  TABLE TABLE ACCESS BY INDEX ROWID SD_HOSPITAL.BM_YGBM00  [Not Analyzed] 
     Tablespace: TS_YY
           (2)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_YGBM00_YGBH00  [Not Analyzed]
    COUNT STOPKEY
           (5)  TABLE TABLE ACCESS BY INDEX ROWID SD_MZ.YS_BRZDXX  [Not Analyzed] 
                Tablespace: TS_MZ
               (4)  INDEX INDEX RANGE SCAN SD_MZ.INDEX_YS_BRZDXX_GHH000  [Not Analyzed]
    SORT ORDER BY
           (32)  FILTER
               (31)  NESTED LOOPS OUTER
                   (28)  NESTED LOOPS
                       (25)  NESTED LOOPS
                           (22)  NESTED LOOPS
                               (19)  NESTED LOOPS OUTER
                                   (16)  NESTED LOOPS OUTER
                                       (13)  NESTED LOOPS OUTER
                                           (11)  NESTED LOOPS
                                               (8)  TABLE TABLE ACCESS BY INDEX ROWID SD_YF.YF_MZCF00  [Not Analyzed] 
                                                    Tablespace: TS_YF
                                                   (7)  INDEX INDEX RANGE SCAN SD_HOSPITAL.INDEX_YF_MZCF00_YPDLBH  [Not Analyzed]
                                               (10)  TABLE TABLE ACCESS BY INDEX ROWID SD_SF.SF_BRXXB0  [Not Analyzed] 
                                                    Tablespace: TS_SF
                                                   (9)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_SF.UQ_SF_BRXXB0_GHH000  [Not Analyzed]
                                           (12)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_BRXXB0_BRID00  [Not Analyzed]
                                       (15)  TABLE TABLE ACCESS BY INDEX ROWID SD_HOSPITAL.BM_BRFBB0  [Not Analyzed] 
                                            Tablespace: TS_YY
                                           (14)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_BRFBB0_FBBH00  [Not Analyzed]
                                   (18)  TABLE TABLE ACCESS BY INDEX ROWID SD_HOSPITAL.BM_YGBM00  [Not Analyzed] 
                                        Tablespace: TS_YY
                                       (17)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_YGBM00_YGBH00  [Not Analyzed]
                               (21)  TABLE TABLE ACCESS BY INDEX ROWID SD_HOSPITAL.BM_YGBM00  [Not Analyzed] 
                                    Tablespace: TS_YY
                                   (20)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_YGBM00_YGBH00  [Not Analyzed]
                           (24)  TABLE TABLE ACCESS BY INDEX ROWID SD_HOSPITAL.BM_BMBM00  [Not Analyzed] 
                                Tablespace: TS_YY
                               (23)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_BMBM00_BMBH00  [Not Analyzed]
                       (27)  TABLE TABLE ACCESS BY INDEX ROWID SD_HOSPITAL.BM_BRXXB0  [Not Analyzed] 
                            Tablespace: TS_YY
                           (26)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_BRXXB0_BRID00  [Not Analyzed]
                   (30)  TABLE TABLE ACCESS BY INDEX ROWID SD_YF.YF_JYXXB0  [Not Analyzed] 
                        Tablespace: TS_YF
                       (29)  INDEX INDEX RANGE SCAN SD_YF.YF_JYXXB0_INDEX_CFLSH0  [Not Analyzed]