https://www.oracleerpappsguide.com/2011/11/inline-view-subqueries-in-a-from-clause.html
Inline view : Subqueries in a from Clause