ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFA79D2E0530100007F1FF2 Blitz Report Category Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US E606BF64BA46283DE0530100007F10D0 select xrpv1.report_name, xrpv1.category, xrpv1.parameter_name, xrpv2.parameter_name dependent_parameter_name, xrpd.flex_bind, xrpv1.display_sequence, xrpv2.display_sequence dependent_display_sequence, xxen_util.user_name(xrpd.created_by) created_by, xxen_util.client_time(xrpd.creation_date) creation_date, xxen_util.user_name(xrpd.last_updated_by) last_updated_by, xxen_util.client_time(xrpd.last_update_date) last_update_date, xrpd.report_id, xrpd.parameter_id, xrpd.dependent_parameter_id from xxen_report_param_dependencies xrpd, xxen_report_parameters_v xrpv1, xxen_report_parameters_v xrpv2 where 1=1 and xrpd.parameter_id=xrpv1.parameter_id and xrpd.dependent_parameter_id=xrpv2.parameter_id Y US Blitz Report Parameter Dependencies Enginatics 1=1 1 10 1=1 xrpv1.report_name=:report_name LOV custom Y select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv where xrv.report_id in (select xrpd.report_id from xxen_report_param_dependencies xrpd) order by xrv.report_name US Report Name 2 20 1=1 xrpv1.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 Blitz Report Category 8E2FF36EDEFA79D2E0530100007F1FF2 Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US Category 3 30 1=1 xrpv1.parameter_name=:parameter_name LOV custom Y select xrpv.parameter_name value, xrpv.report_name description from xxen_report_parameters_v xrpv where xrpv.report_name=nvl(:$flex$.report_name,xrpv.report_name) and xrpv.display_sequence is not null and xrpv.parameter_id in (select xrpd.parameter_id from xxen_report_param_dependencies xrpd) order by xrpv.parameter_name, xrpv.report_name US Parameter Name 4 40 1=1 xrpv2.parameter_name=:dependent_parameter_name LOV custom Y select xrpv.parameter_name value, xrpv.report_name description from xxen_report_parameters_v xrpv where xrpv.report_name=nvl(:$flex$.report_name,xrpv.report_name) and xrpv.display_sequence is not null and xrpv.parameter_id in (select xrpd.dependent_parameter_id from xxen_report_param_dependencies xrpd) order by xrpv.parameter_name, xrpv.report_name US Dependent Parameter Name :$flex$.report_name Report Name Dependent Parameter Name :$flex$.report_name Report Name Parameter Name