Blitz Report Application Categories
Description
Categories: Enginatics
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.
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |