select SUM(DECODE(a.year, 2003, a.month, 0)),
         a.FID,
         a.OID,
         a.GID,
         a.CID,
         a.PRODUCT_ID,
         a.TID,
         a.CURR
    from table1 a
   where a.CID = 500
   and a.OID IN
         (SELECT leaf_node
            FROM table2
           WHERE table2.id = 101069
             and (table2.node02 = 7009 or
                 table2.node01 = -99000 or
                 table2.node01 = 7011))
     and a.year IN (2003)
   group by a.FID,
            a.OID,
            a.GID,
            a.CID,
            a.PRODUCT_ID,
            a.TID,
            a.CURR

SELECT /*+NO_REWRITE*/ ...