WITH w1 AS (
SELECT b.CDRID, b.BASE_CDRID, b.START_TIME, b.REPORT_TIME, b.IMSI
  FROM CDR_DATA_A20111024 B
 WHERE ((B.START_TIME BETWEEN
       TO_DATE('2011-10-24 08:07:47', 'yyyy-mm-dd hh24:mi:ss') - 2 / 24 AND
       TO_DATE('2011-10-24 23:57:47', 'yyyy-mm-dd hh24:mi:ss')) AND
       (B.REPORT_TIME >
       TO_DATE('2011-10-24 08:07:47', 'yyyy-mm-dd hh24:mi:ss')))
   AND (B.IMSI IN ('460022517717646') OR
       B.PEER_NUMBER IN ('460022517717646')))
SELECT T1.START_TIME, T1.REPORT_TIME, T1.IMSI, T1.CDRID
  FROM W1 T1
 WHERE EXISTS (SELECT T2.CDRID
          FROM W1 T2
         WHERE T1. CDRID = T2.CDRID
            OR T1.BASE_CDRID = T2.BASE_CDRID)

------解决方案--------------------
你的sql需求是什么呢？表a的条件和表b的条件除了（b.cdrid = a.cdrid OR b.base_cdrid = a.cdrid）其他都一样的，因为表A和表B同一个表，（b.cdrid = a.cdrid OR b.base_cdrid = a.cdrid）在cdrid不为null的时候永远是true,所以你的sql等价：
SQL code

SELECT a.start_time,
       a.report_time,
       a.imsi,
       a.cdrid
  FROM cdr_data_a20111024 a
 WHERE (
           (a.start_time BETWEEN TO_DATE('2011-10-24 08:07:47', 'yyyy-mm-dd hh24:mi:ss') - 2 / 24 AND TO_DATE('2011-10-24 23:57:47', 'yyyy-mm-dd hh24:mi:ss')) AND
           (a.report_time > TO_DATE('2011-10-24 08:07:47', 'yyyy-mm-dd hh24:mi:ss'))
       )
   AND (a.imsi = '460022517717646' OR a.peer_number = '460022517717646')