ORA-30365: left relation in the JOIN KEY clause cannot be same as right
Cause: The relation of the child columns on the left side of the JOIN KEY clause was the same as that of the parent level on the right side
Action: Remove the JOIN KEY clause. It is not required or allowed when the child and the parent are in the same relation
https://support.oracle.com/
http://www.oracle.com/