Blitz Report Assignments

Description
Categories: Enginatics
Repository: Github

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 distinct
xrav.report_name,
xrv.type_dsp type,
xrv.category,
xxen_util.meaning(xrv.enabled,'YES_NO',0) enabled,
xxen_util.meaning(xrav.include_exclude,'INCLUDE_EXCLUDE',0) include_exclude,
xrav.assignment_level_desc level_name,
xrav.level_value value,
xrav.description,
xrav.block_name form_block,
&columns
xxen_util.user_name(xrav.created_by) created_by,
xxen_util.client_time(xrav.creation_date) creation_date,
xxen_util.user_name(xrav.last_updated_by) last_updated_by,
xxen_util.client_time(xrav.last_update_date) last_update_date,
xrav.report_id,
xrav.id1
from
xxen_reports_v xrv,
xxen_report_assignments_v xrav,
(select xrzpvv.* from xxen_report_zoom_param_vals_v xrzpvv where '&show_form_parameter_defaults'='Y') xrzpvv
where
1=1 and
xrv.report_id=xrav.report_id and
xrav.assignment_id=xrzpvv.assignment_id(+)
order by
xrav.report_name,
xrav.assignment_level_desc,
xrav.level_value,
xrav.block_name
&order_by
Parameter Name SQL text Validation
Type
xrv.type_dsp=:type
LOV
Category
xrv.report_id in (
select
xrca.report_id
from
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)
LOV
Assignment Level
xrav.assignment_level_desc=:assignment_level
LOV
Show Form Parameter Defaults
Y
LOV