SQL Statement from editor:
   
   
  SELECT   *
      FROM (SELECT t1.*, sf_judge_result_zy (t1.pyrq00, t1.ybh000) lx0000,
                   sf_judge_result_jz (t1.pyrq00, t1.ybh000) sfjj00,
                   DECODE (t1.sfjm00,
                           'N', 'Y',
                           DECODE ((SELECT COUNT (*)
                                      FROM vw_jy_ygqxzd
                                     WHERE ygbh00 = '1489'
                                       AND qxlx00 = 'JGCL'
                                       AND qxgndh = 'CKJM'
                                       AND yqdh00 = t1.yqdh00),
                                   0, 'N',
                                   'Y'
                                  )
                          ) yxdy00
              FROM (SELECT DISTINCT a.brxm00, a.sqksmc, a.brlx00, a.ch0000,
                                    a.yqdh00, a.yxbz00, a.ybh000, a.pyrq00,
                                    a.jgzt00, a.sftj00, a.sfjm00, 'N' dy0000,
                                    a.bgysz0, a.sfyb00, a.mzzybz, a.cbgrq0
                               FROM vw_jy_yw0000 a
                              WHERE a.jgzt00 IN ('9', '6', '8')
                                AND a.pyrq00 BETWEEN '20130809' AND '20130816'
                                AND ((   (   a.sqks00 + 0 = '32'
                                          OR a.sqbq00 + 0 = '32'
                                         )
                                      OR (zyghid IN (
                                             SELECT zyghid
                                               FROM zy_brxxb0
                                              WHERE dqbq00 = '32'
                                                 OR dqks00 = '32')
                                         )
                                     )
                                    )) t1)
  ORDER BY cbgrq0 DESC, yqdh00, ybh000, ch0000 ASC
  
  ------------------------------------------------------------
    
  Statement Id=4203150   Type=
  Cost=2.64018716311899E-308  TimeStamp=16-08-13::15::47:56
  
    SELECT STATEMENT  RULE
       (3)  TABLE TABLE ACCESS BY INDEX ROWID SD_HOSPITAL.BM_BMBM00  [Not Analyzed] 
     Tablespace: TS_YY
           (2)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_HOSPITAL.PK_BM_BMBM00_BMBH00  [Not Analyzed]
       (5)  TABLE TABLE ACCESS BY INDEX ROWID SD_JY.JY_JYYQZD  [Not Analyzed] 
     Tablespace: TS_JY
           (4)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_JY.SYS_C0015411  [Not Analyzed]
    SORT AGGREGATE
           (21)  VIEW VIEW SD_HOSPITAL.VW_JY_YGQXZD
               (20)  SORT UNIQUE
                   (19)  UNION-ALL
                       (12)  NESTED LOOPS
                           (9)  TABLE TABLE ACCESS BY INDEX ROWID SD_JY.JY_YGQXZD  [Not Analyzed] 
                                Tablespace: TS_JY
                               (8)  AND-EQUAL
                                   (6)  INDEX INDEX RANGE SCAN SD_HOSPITAL.INDEX_JY_YGQXZD_YGBH00  [Not Analyzed]
                                   (7)  INDEX INDEX RANGE SCAN SD_HOSPITAL.INDEX_JY_YGQXZD_YQDH00  [Not Analyzed]
                           (11)  TABLE TABLE ACCESS BY INDEX ROWID SD_JY.JY_QXZD00  [Not Analyzed] 
                                Tablespace: TS_JY
                               (10)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_JY.SYS_C0015592  [Not Analyzed]
                       (18)  FILTER
                           (17)  NESTED LOOPS
                               (14)  TABLE TABLE ACCESS BY INDEX ROWID SD_JY.JY_YGQXZD  [Not Analyzed] 
                                    Tablespace: TS_JY
                                   (13)  INDEX INDEX RANGE SCAN SD_HOSPITAL.INDEX_JY_YGQXZD_YQDH00  [Not Analyzed]
                               (16)  TABLE TABLE ACCESS BY INDEX ROWID SD_JY.JY_QXZD00  [Not Analyzed] 
                                    Tablespace: TS_JY
                                   (15)  INDEX (UNIQUE) INDEX UNIQUE SCAN SD_JY.SYS_C0015592  [Not Analyzed]
    SORT ORDER BY
           (29)  VIEW (Embedded SQL)
               (28)  SORT UNIQUE
                   (27)  FILTER
                       (24)  TABLE TABLE ACCESS BY INDEX ROWID SD_JY.JY_YW0000  [Not Analyzed] 
                            Tablespace: TS_YY
                           (23)  INDEX INDEX RANGE SCAN SD_HOSPITAL.INDEX_JY_YW0000_PYRQ00_YBH000  [Not Analyzed]
                       (26)  FILTER
                           (25)  TABLE TABLE ACCESS FULL SD_ZY.ZY_BRXXB0  [Not Analyzed] 
                                Tablespace: TS_ZY