Combination of Pipelined Table Function and 'with'-clause very slow.

 Hi,

I have a Pipelined Table Function:

CREATE OR REPLACE FUNCTION DWH.etfaa_search_part_pipe3 (
   p refcur3_pkg.refcur3_t)
   RETURN resultTypeSet
   PIPELINED
   PARALLEL_ENABLE
IS
...

I use a query to pre-select the data and create a table. about 5 sec

create table dummy as
select
versid,quartal,jahr,arzeneimittel_daten
from etfaa_2
where
--jahr = 2007 and        --  weggelassen wegen unfair kleinerer Datenmenge
arzeneimittel_daten like '%;ac;L04AB04;%' and
tdia_daten not like '%§M07%' and
tdia_daten not like '%§L40%' and
tdia_daten not like '%§K50%' and
tdia_daten not like '%§K51%' ;