I managed to solve it.

SELECT O.ow_id

FROM props.dp_owner O

JOIN props.dp_entry E

ON O.ow_id = E.dp_person

JOIN props.dp_item I

ON E.dp_id = I.dpi_dp_id

WHERE I.dpi_status NOT IN ( '7' ) --DISPOSED

AND O.ow_id IN (SELECT O.ow_id

FROM props.dp_owner O

JOIN props.dp_entry E

ON O.ow_id = E.dp_person

JOIN props.dp_item I

ON E.dp_id = I.dpi_dp_id

WHERE I.dpi_status IN ( '7' ) --DISPOSED

GROUP BY O.ow_id)

GROUP BY O.ow_id