Ungenutzte LOVs finden (per SQL)

Wie findet man (per SQL) alle ungenutzten LOVs einer App?

select list_of_values_name
from apex_application_lovs l
where l.application_id = :APP_ID
 
minus
 
select distinct
    list_of_values_name
from
(
    select
        l.list_of_values_name
    from apex_application_lovs l
    join apex_application_page_items i on l.list_of_values_name = i.lov_named_lov
    where l.application_id = :APP_ID
    union
    select
        l.list_of_values_name
    from apex_application_lovs l
    join apex_application_page_rpt_cols c on l.list_of_values_name = c.named_list_of_values
    where l.application_id = :APP_ID   
    union
    select
        l.list_of_values_name
    from apex_application_lovs l
    join apex_application_page_ir_col t on l.list_of_values_name = t.named_lov
    where l.application_id = :APP_ID     
    union
    select
        l.list_of_values_name
    from apex_application_lovs l
    join apex_appl_page_ig_columns t on l.lov_id = t.lov_id
    where l.application_id = :APP_ID   
    union
    select
        l.list_of_values_name
    from apex_application_lovs l
    join apex_appl_page_filters f on l.list_of_values_name = f.lov_named_lov
    where l.application_id = :APP_ID  
);

Die verschiedenen APEX-Views findet man z.B. via

select distinct apex_view_name from apex_dictionary where column_name like '%NAMED_LOV%' or column_name like '%LOV_ID%';