understanding sqltxplan to resolve problem query

hi all guru,

    I try to understand sqltxplan. because I have a problem of performance of several queries.

I can see a high cpu for the fetch and waits times for several events.

I do not understand where may I search to find a good approach for my issue.

I join you my tkprof and a zip file from sqltxplan.

best regards

JP

my tkprof's part

>>>>>>

call     count       cpu    elapsed       disk      query    current        rows

------- ------  -------- ---------- ---------- ---------- ----------  ----------

Parse        1      0.00       0.00          0          0          0           0

Execute      2      0.22       0.24          0          0          0           0

Fetch        3     99.09    1883.44     216554    3798211          6          33

------- ------  -------- ---------- ---------- ---------- ----------  ----------

total        6     99.31    1883.68     216554    3798211          6          33

Elapsed times include waiting on following events: