Blitz Report Application Categories
Description
Categories: Enginatics, Kcapps
Repository: Github
Repository: Github
Oracle application -> Blitz Report assignment via lookup XXEN_REPORT_APPS_CATEGORIES.
This setup controls how automatically imported BI publisher reports and concurrent programs are assigned to Blitz Report categories.
This setup controls how automatically imported BI publisher reports and concurrent programs are assigned to Blitz Report categories.
Run
Blitz Report Application Categories and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
