INSERT INTO T VALUES(.....) 
SELECT (......) 
FROM
(SELECT /+* parallel() */.....
  FROM
  WHERE d.field = 'aaa'
        a.id = b.id(+)
        a.field2 = b.field2
        a.date >= c.date
)ip,
(select  /+* parallel() */.....
  FROM p, q, r, (select /+* parallel() */... from m where ....)s
  WHERE p.field = q.field
        r. id = p. id
        s.date > r.date
 )sp

where ip.id = sp.id(+)
      ip.date >= sp.date
      .....