Query to improve is losing cpu's time

hello gurus,

    I have this next query which is losing cpu's time.

i am trying to improve it with tkprof. i see in the report of tkprof that i have for 1 execute 2931.97/83= 35s to this next  sql_id : fjd0cvzfc16u6.

>>> for me when i have for 1 execute more 1 seconde i try to imprve it then i have 35s.

>>> in the tkprof report i have next :

call     count       cpu    elapsed       disk      query    current        rows

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

Parse        0      0.00       0.00          0          0          0           0

Execute     83   2931.97    2974.27      18106    7422457   14987571     3007950

Fetch        0      0.00       0.00          0          0          0           0

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

total       83   2931.97    2974.27      18106    7422457   14987571     3007950

>>> and i notice that i have the explain plan is formated like next :::