edli, yours looks OK to me (apart from typos), the question is: will Oracle run it? outer joins are not what it does best. Why not try it? The rule is that the (+) goes on the side where you need to "add" unmatched rows.
(BTW, if I could I always wrote the joins with INNER's first then then LEFT OUTER's - you usually don't need any parentheses that way.)
I have tried to run it and it runs.But as my tables are empty I could not try (for sure) that it gave the right result.
As for the (+) thing I know it goes on that side.
But as I am bringing some sp from t-sql to oracle I have the queries
in t-sql and in T-sql u can do much like joining groups in different ways and I don't know if that make any difference in oracle.
from t1 inner join t2
inner join t3 on t2.id3=t3.id3
left outer join t4
inner join t5 on t4.id4=t5.id4
on t2.id2=t4.id2 and t3.id3=t5.id3;
in this case as in the previos it joins groups of joins and is very well specified.
So I can not escape from outer joins.Or I can??