Rule Definition
ANSI syntax allow a clear separation between joins clause and the where clause restrictions. The ANSI notation makes the relations between the tables explicit, and saves you from coding equality tests for join conditions in the WHERE clause. Thus the mix of both join notations makes the readability & maintainability of the code more complex. Moreover ANSI joins allows having optimization hints. And last, this historic syntax notation will probably be deprecated in a future release

Remediation
Transform the queries including the two different notations with only the use of the ANSI syntax As a consequence Reconsider tthe statement. For that check the business rule(s) to fully understand the objective of the statement in term of result set. Use ANSI Join syntax notation to rewrite the part of the code.

Violation Code Sample

Select *
From T1, T2
Where
T1.c1=T2.c1 AND
 T1.c2 in 
 (select T3.c1 from T4 left outer JOIN T3 on T3.c4=T4.c4)

Fixed Code Sample

Select * 
From T1 JOIN  T2 
ON T1.c1=T2.c1
Where  T1.c2 in 
 (select T3.c1 from T4 left outer JOIN T3 on T3.c4=T4.c4)

Oracle SQL Student Guide Volume 1