Blitz Report with only Filter in pivot table

Description

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
xrtv.report_name,
xrtv.template_name
from
xxen_report_template_pivot_v xrtpv,
xxen_report_templates_v xrtv
where
xrtv.template_id=xrtpv.template_id and
xrtpv.field_type='FILTER' and
not exists (
select
*
from
xxen_report_template_pivot_v xrtpv1
where
xrtpv1.field_type<>'FILTER' and
xrtpv1.template_id=xrtpv.template_id
)