I have it!!!!! I've just done an SQL Tuning Advisory over Enterprise Manager for that statement. He gave me two solutions with new explain plans an one of them i've integrated. Now the statement runs under 1 minute!
Thanks to all for the awesome support and help! You guys rock! ;)
Edited by: David_Pasternak on 24.04.2013 03:26