Don, I don't think the outer join can be dropped altogether, only the ambiguity of using the equality operator (=) on NULL columns; so, for the
rel_constraints_violated_one view I think it should be:
where rspm.segment_id(+) = constrained_rels.required_rel_segment
and constrained_rels.container_id is null
and rspm.party_id is null;
and for the
rel_constraints_violated_two view:
where rspm.segment_id(+) = constrained_rels.required_rel_segment
and constrained_rels.party_id is null
and rspm.party_id is null;
