ORA-30365

Error: ORA-30365: left relation in the JOIN KEY clause cannot be same as right

Causa: 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.

Acción: Remove the JOIN KEY clause. It is not required or allowed when the child and the parent are in the same relation.