filter

 with filter as (
select *
from (
select inst_id,sql_id, 'inst_id='||inst_id||' and sql_id= '||chr(39)||sql_id||chr(39) ||' and CHILD_NUMBER='||child_number|| ' and plan_hash_value=' ||plan_hash_value FilterPred
from gv$sql gvs
where sql_id ='aq8yqxyyb40nn' order by last_active_time desc )
where rownum < 2 )
select plan_table_output
from filter a , table(dbms_xplan.display('GV$SQL_PLAN_STATISTICS_ALL',null,null,a.filterPred)) t