SQL Statement from editor:
   
   
  /* Formatted on 2013/07/30 09:58 (Formatter Plus v4.8.7) */
  SELECT b.xypzid, b.xypzmc, c.jldw00, c.dj0000,
         NVL ((SELECT SUM (rksl00) rksl00
                 FROM xk_xyrk00 a
                WHERE xypzmc = b.xypzmc
                  AND rkrq00 < '20130730'
                  AND rkzt00 = '1'
                  AND (   (ckzt00 = '0')
                       OR (    ckzt00 = '1'
                           AND EXISTS (
                                  SELECT 1
                                    FROM xk_xyck00
                                   WHERE xdbh00 = a.xdbh00
                                     AND ckrq00 >= '20130730')
                          )
                      )),
              0
             ) sykc00,
         NVL ((SELECT SUM (rksl00) rksl00
                 FROM xk_xyrk00 a
                WHERE xypzmc = b.xypzmc
                  AND rkrq00 BETWEEN '20130730' AND '20130730'
                  AND rkzt00 = '1'),
              0
             ) byrk00,
         NVL ((SELECT SUM (cksl00) cksl00
                 FROM xk_xyck00 a
                WHERE xypzmc = b.xypzmc
                  AND ckrq00 BETWEEN '20130730' AND '20130730'
                  AND ckzt00 = '1'),
              0
             ) byck00,
         NVL ((SELECT SUM (rksl00) rksl00
                 FROM xk_xyrk00 a
                WHERE xypzmc = b.xypzmc
                  AND rkrq00 <= '20130730'
                  AND rkzt00 = '1'
                  AND (   ckzt00 = '0'
                       OR (    ckzt00 = '1'
                           AND EXISTS (
                                  SELECT 1
                                    FROM xk_xyck00
                                   WHERE xdbh00 = a.xdbh00
                                     AND ckrq00 > '20130730')
                          )
                      )),
              0
             ) bykc00,
         NVL ((SELECT SUM (je0000) rksl00
                 FROM xk_xyrk00 a
                WHERE xypzmc = b.xypzmc
                  AND rkrq00 < '20130730'
                  AND rkzt00 = '1'
                  AND (   (ckzt00 = '0')
                       OR (    ckzt00 = '1'
                           AND EXISTS (
                                  SELECT 1
                                    FROM xk_xyck00
                                   WHERE xdbh00 = a.xdbh00
                                     AND ckrq00 >= '20130730')
                          )
                      )),
              0
             ) syje00,
         NVL ((SELECT SUM (je0000) rksl00
                 FROM xk_xyrk00 a
                WHERE xypzmc = b.xypzmc
                  AND rkrq00 BETWEEN '20130730' AND '20130730'
                  AND rkzt00 = '1'),
              0
             ) rkje00,
         NVL ((SELECT SUM (je0000) cksl00
                 FROM xk_xyck00 a
                WHERE xypzmc = b.xypzmc
                  AND ckrq00 BETWEEN '20130730' AND '20130730'
                  AND ckzt00 = '1'),
              0
             ) ckje00,
         NVL ((SELECT SUM (je0000) rksl00
                 FROM xk_xyrk00 a
                WHERE xypzmc = b.xypzmc
                  AND rkrq00 <= '20130730'
                  AND rkzt00 = '1'
                  AND (   ckzt00 = '0'
                       OR (    ckzt00 = '1'
                           AND EXISTS (
                                  SELECT 1
                                    FROM xk_xyck00
                                   WHERE xdbh00 = a.xdbh00
                                     AND ckrq00 > '20130730')
                          )
                      )),
              0
             ) byje00
    FROM vw_xk_xypzbm b, bm_xyxx00 c
   WHERE b.xypzid = c.nbbh00
  ------------------------------------------------------------
    
  Statement Id=0   Type=
  Cost=2.77925427927569E-308  TimeStamp=30-07-13::10::05:03
  
    SELECT STATEMENT  RULE
    SORT AGGREGATE
           (4)  FILTER
               (2)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYRK00  [Not Analyzed] 
                    Tablespace: TS_ZY
               (3)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYCK00  [Not Analyzed] 
                    Tablespace: TS_ZY
    SORT AGGREGATE
           (6)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYRK00  [Not Analyzed] 
                Tablespace: TS_ZY
    SORT AGGREGATE
           (8)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYCK00  [Not Analyzed] 
                Tablespace: TS_ZY
    SORT AGGREGATE
           (12)  FILTER
               (10)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYRK00  [Not Analyzed] 
                    Tablespace: TS_ZY
               (11)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYCK00  [Not Analyzed] 
                    Tablespace: TS_ZY
    SORT AGGREGATE
           (16)  FILTER
               (14)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYRK00  [Not Analyzed] 
                    Tablespace: TS_ZY
               (15)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYCK00  [Not Analyzed] 
                    Tablespace: TS_ZY
    SORT AGGREGATE
           (18)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYRK00  [Not Analyzed] 
                Tablespace: TS_ZY
    SORT AGGREGATE
           (20)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYCK00  [Not Analyzed] 
                Tablespace: TS_ZY
    SORT AGGREGATE
           (24)  FILTER
               (22)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYRK00  [Not Analyzed] 
                    Tablespace: TS_ZY
               (23)  TABLE TABLE ACCESS FULL SD_ZY.XK_XYCK00  [Not Analyzed] 
                    Tablespace: TS_ZY
    NESTED LOOPS
           (26)  TABLE TABLE ACCESS FULL SD_HOSPITAL.BM_XYXX00  [Not Analyzed] 
                Tablespace: TS_YY
           (28)  TABLE TABLE ACCESS BY INDEX ROWID SD_HOSPITAL.BM_TYZD00  [Not Analyzed] 
                Tablespace: TS_YY
               (27)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_TYZD00_NBBH00  [Not Analyzed]