ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 1F0480A8258A6E8BE0636ADA860A3BB8 ORB Domain Name Y select olf_name.property_value value, olf_desc.property_value description from xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf_name, xxorb.orb_localizedstring_flat olf_desc where olf_name.meta_object_id = omo.id and olf_name.property_key = 'name' and olf_desc.meta_object_id(+) = omo.id and olf_desc.property_key(+) = 'description' and omo.obj_type=1 US 1F77CC607BF4DF42E0636ADA860AA93F ORB Report Folder Name Y select olf.property_value value, olf_desc.property_value description from xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf, xxorb.orb_localizedstring_flat olf_desc where omo.id=olf.meta_object_id and olf.property_key = 'name' and omo.obj_type=12 and omo.id=olf_desc.meta_object_id(+) and olf_desc.property_key(+) = 'description' US 1F0480A825896E8BE0636ADA860A3BB8 ORB Report Name Y select olf_name.property_value value, olf_desc.property_value description from xxorb.orb_report orr, xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf_name, xxorb.orb_localizedstring_flat olf_desc where olf_name.meta_object_id = orr.id and olf_name.property_key = 'name' and olf_desc.meta_object_id(+) = orr.id and omo.id=orr.id and olf_desc.property_key(+) = 'description' and (:$flex$.report_folder_name is null or omo.parent_id=( select omo.id from xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf where omo.id=olf.meta_object_id and olf.property_key = 'name' and omo.obj_type=12 and olf.property_value=:$flex$.report_folder_name ) ) US 1F0480A8258B6E8BE0636ADA860A3BB8 ORB Report Type Y select 'Data Report' value , null description from dual union select 'Pivot Report' value , null description from dual union select 'Custom Report' value , null description from dual union select 'Dashboard Report' value , null description from dual union select 'Script Report' value , null description from dual union select 'Publisher Report' value , null description from dual union select 'Analysis Report' value , null description from dual US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 1F0480A825886E8BE0636ADA860A3BB8Y select orr.report_id, orr.report_name, orr.report_description, orr.report_folder_name, orr.domain_name, orr.report_type, orr.widget_type, orr.inherited_object_key business_object_key, ordv.category_name, ordv.logical_model_name, ordv.physical_model_name, ordv.datasource_name, orr.report_language, orr.created_by, orr.created_date, orr.last_modified_by, orr.last_modified_date from ( select orr.id report_id, olf_repname.property_value report_name, olf_repdesc.property_value report_description, olf_repfolname.property_value report_folder_name, olf_domain.property_value domain_name, case when orr.widget_type = 'oper' then 'Data Report' when orr.widget_type in ('Pivot-grid', 'pivot-grid') then 'Pivot Report' when orr.widget_type = 'custom' then 'Custom Report' when orr.widget_type = 'dashboard' then 'Dashboard Report' when orr.widget_type = 'script' then 'Script Report' when orr.widget_type = 'pub' then 'Publisher Report' else 'Analysis Report' end report_type, orr.widget_type, omo_inh_obj.obj_key inherited_object_key, olf_repname.locale report_language, xxen_orb_util.orb_user(omo_rep.created_by) created_by, xxen_util.client_time(omo_rep.created_date) created_date, xxen_orb_util.orb_user(omo_rep.last_modified_by) last_modified_by, xxen_util.client_time(omo_rep.last_modified_date) last_modified_date from xxorb.orb_report orr, xxorb.orb_meta_object omo_rep, xxorb.orb_meta_object omo_inh_obj, xxorb.orb_meta_object omo_lm, xxorb.orb_meta_object omo_domain, xxorb.orb_localizedstring_flat olf_repname, xxorb.orb_meta_object omo_rep_folder, xxorb.orb_localizedstring_flat olf_repdesc, xxorb.orb_localizedstring_flat olf_repfolname, xxorb.orb_localizedstring_flat olf_domain where omo_rep.id = orr.id and omo_rep.parent_id = omo_rep_folder.id(+) and olf_repname.meta_object_id = omo_rep.id and omo_rep.inherited_meta_obj_id = omo_inh_obj.id and omo_inh_obj.parent_id = omo_lm.id and omo_lm.parent_id = omo_domain.id and olf_domain.meta_object_id = omo_domain.id and olf_domain.property_key = 'name' and olf_repname.property_key = 'name' and omo_rep.id = olf_repdesc.meta_object_id(+) and olf_repdesc.property_key(+) = 'description' and omo_rep_folder.id = olf_repfolname.meta_object_id(+) and olf_repfolname.property_key(+) = 'name' and omo_rep.obj_type = 13 and omo_rep_folder.obj_type(+) = 12 and omo_inh_obj.obj_type = 10 and omo_lm.obj_type = 6 and omo_domain.obj_type = 1 union all select orr.id report_id, olf_repname.property_value report_name, olf_repdesc.property_value report_description, olf_repfolname.property_value report_folder_name, null domain_name, case when orr.widget_type = 'oper' then 'Data Report' when orr.widget_type in ('Pivot-grid', 'pivot-grid') then 'Pivot Report' when orr.widget_type = 'custom' then 'Custom Report' when orr.widget_type = 'dashboard' then 'Dashboard Report' when orr.widget_type = 'script' then 'Script Report' when orr.widget_type = 'pub' then 'Publisher Report' else 'Analysis Report' end report_type, orr.widget_type, null inherited_object_key, olf_repname.locale report_language, xxen_orb_util.orb_user(omo_rep.created_by) created_by, xxen_util.client_time(omo_rep.created_date) created_date, xxen_orb_util.orb_user(omo_rep.last_modified_by) last_modified_by, xxen_util.client_time(omo_rep.last_modified_date) last_modified_date from xxorb.orb_report orr, xxorb.orb_meta_object omo_rep, xxorb.orb_localizedstring_flat olf_repname, xxorb.orb_meta_object omo_rep_folder, xxorb.orb_localizedstring_flat olf_repdesc, xxorb.orb_localizedstring_flat olf_repfolname where omo_rep.id = orr.id and omo_rep.parent_id = omo_rep_folder.id(+) and olf_repname.meta_object_id(+) = omo_rep.id and omo_rep.inherited_meta_obj_id is null and olf_repname.property_key(+) = 'name' and omo_rep.id = olf_repdesc.meta_object_id(+) and olf_repdesc.property_key(+) = 'description' and omo_rep_folder.id = olf_repfolname.meta_object_id(+) and olf_repfolname.property_key(+) = 'name' and omo_rep.obj_type = 13 and orr.widget_type<>'oper' and omo_rep_folder.obj_type(+) = 12 ) orr, xxorb.orb_report_domain_v ordv where 1=1 and orr.report_id=ordv.report_id(+) US ORB Report and Details Orbit Reporting reports, folders ,business object ,logical model ,physical model and domain these reports resides in. ORBIT 1=1 1 10 1=1 orr.report_folder_name=:report_folder_name LOV ORB Report Folder Name 1F77CC607BF4DF42E0636ADA860AA93F Y select olf.property_value value, olf_desc.property_value description from xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf, xxorb.orb_localizedstring_flat olf_desc where omo.id=olf.meta_object_id and olf.property_key = 'name' and omo.obj_type=12 and omo.id=olf_desc.meta_object_id(+) and olf_desc.property_key(+) = 'description' US Report Folder Name 2 20 1=1 orr.report_name=:report_name LOV ORB Report Name 1F0480A825896E8BE0636ADA860A3BB8 Y select olf_name.property_value value, olf_desc.property_value description from xxorb.orb_report orr, xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf_name, xxorb.orb_localizedstring_flat olf_desc where olf_name.meta_object_id = orr.id and olf_name.property_key = 'name' and olf_desc.meta_object_id(+) = orr.id and omo.id=orr.id and olf_desc.property_key(+) = 'description' and (:$flex$.report_folder_name is null or omo.parent_id=( select omo.id from xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf where omo.id=olf.meta_object_id and olf.property_key = 'name' and omo.obj_type=12 and olf.property_value=:$flex$.report_folder_name ) ) US Report Name 3 30 1=1 orr.domain_name=:domain_name LOV ORB Domain Name 1F0480A8258A6E8BE0636ADA860A3BB8 Y select olf_name.property_value value, olf_desc.property_value description from xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf_name, xxorb.orb_localizedstring_flat olf_desc where olf_name.meta_object_id = omo.id and olf_name.property_key = 'name' and olf_desc.meta_object_id(+) = omo.id and olf_desc.property_key(+) = 'description' and omo.obj_type=1 US Domain Name 4 40 1=1 orr.report_type=:report_type LOV ORB Report Type 1F0480A8258B6E8BE0636ADA860A3BB8 Y select 'Data Report' value , null description from dual union select 'Pivot Report' value , null description from dual union select 'Custom Report' value , null description from dual union select 'Dashboard Report' value , null description from dual union select 'Script Report' value , null description from dual union select 'Publisher Report' value , null description from dual union select 'Analysis Report' value , null description from dual US Report Type 5 50 1=1 orr.report_folder_name is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Active