We can use below query to find Patch Set Level in Oracle  E-Business Suite.
Query:

 select
abbreviation
,codelevel
from
ad_trackable_entities
where
abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
order by

abbreviation;


Note: We can change product in where condition as required.