Re: Outer join - same query, different results...

Just fyi, I even tried:

select count(1)
from mtl_material_transactions m
, (select *

from po_headers_all ph
, po_lines_all pl

where ph.po_header_id = pl.po_header_id) phpl
, mtl_unit_transactions mu
, mtl_generic_dispositions g
, wip_entities w
, oe_order_lines_all o
, rcv_transactions r

where
m.SOURCE_LINE_ID = r.transaction_id(+)

and r.po_line_id = phpl.PO_LINE_ID(+)
and m.ORGANIZATION_ID = w.organization_id(+)
and m.TRANSACTION_SOURCE_ID = w.wip_entity_id(+)
and m.SOURCE_LINE_ID = o.line_id(+)
and m.TRANSACTION_ID = mu.transaction_id(+)
and m.ORGANIZATION_ID = g.organization_id (+)
and m.TRANSACTION_SOURCE_ID = g.disposition_id(+)

so that 'phpl' is an inline view rather than 2 seprate tables.

And this query still works, no ORA errors. Received on Thu Aug 18 2005 - 16:23:51 CDT