Blitz Report Application Categories

select
trim(regexp_substr(flv.description,'[^,]+',1,rowgen.column_value)) category,
fav.application_name,
flv.lookup_code application_short_name
from
fnd_lookup_values flv,
table(xxen_util.rowgen(regexp_count(flv.description,',')+1)) rowgen,
fnd_application_vl fav
where
flv.language=userenv('lang') and
flv.description is not null and
flv.lookup_code not like 'ALL%' and
flv.lookup_type='XXEN_REPORT_APPS_CATEGORIES' and
flv.view_application_id=0 and
flv.security_group_id=0 and
flv.lookup_code=fav.application_short_name(+)
order by
category,
fav.application_name

select trim(regexp_substr(flv.description,'[^,]+',1,rowgen.column_value)) category, fav.application_name, flv.lookup_code application_short_name from fnd_lookup_values flv, table(xxen_util.rowgen(regexp_count(flv.description,',')+1)) rowgen, fnd_application_vl fav where flv.language=userenv('lang') and flv.description is not null and flv.lookup_code not like 'ALL%' and flv.lookup_type='XXEN_REPORT_APPS_CATEGORIES' and flv.view_application_id=0 and flv.security_group_id=0 and flv.lookup_code=fav.application_short_name(+) order by category, fav.application_name