You have the same object name under different owner that is the reason you are receiving the error. You can use the case statement to get your output