OK, so my title is confusing...

Anyway, I am trying to blend in several views into a single view. Before, the views broke down kind of like this:

View1

Select p.plat_id,
a.thisandthat,
a.somethingorother,
b.thisandthat,
b.somethingorother
from
platform p,
otherview1 a,
otherview2 b
where
p.plat_id = a.plat_id(+)
and p.plat_id = b.plat_id(+)

the "otherviews" went like:

select a.plat_id,
a.thisandthat,
b.somethingorother
from table1 a,
table2 b
where a.org_id=b.org_id
and a.code="only thing different for both views";


And life was good... however, the REAL view I am blending involved 12 views, and this is causing a distribution nightmare. Therefore, I was just going to make everything into one big query. I can get it to parse fine, but the problem I am having is with foreign keys, since the "otherviews" involved multiple tables.

This is what I have right now:

select p.plat_id,
a1.thisandthat a1_thisandthat,
b1.somethingorother b1_somethingorother,
a2.thisandthat a2_thisandthat,
b2.somethingorother b2_somethingorother
from
platform p,
table1 a1,
table2 b1,
table1 a2,
table2 b2
where
p.plat_id = a1.plat_id(+)
and a1.org_id = b1.org_id
and a1.code="only thing different for both views"
and p.plat_id = a2.plat_id(+)
and a2.org_id = b2.org_id
and a2.code="only thing different for both views";

The data comes out fine except for the outer joins. Wherever there is missing data (remember this is done over 12 different tables), it will discard the whole record. Even though I have an outer join indicator on the main linkage, it still throws out the record.

Does anyone have any idea how I can resolve this?