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 1F77CC607BF1DF42E0636ADA860AA93F ORB Logical Model Name Y select olf.property_value value, olf_desc.property_value description from xxorb.orb_logical_model olm, xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf, xxorb.orb_localizedstring_flat olf_desc where olm.id=olf.meta_object_id and olf.property_key = 'name' and omo.id=olm.id and olm.id=olf_desc.meta_object_id(+) and olf_desc.property_key(+) = 'description' and (:$flex$.domain_name is null or omo.parent_id =(select domain_id from xxorb.orb_domain_v odv where odv.property_value=:$flex$.domain_name) ) US 1F77CC607BF3DF42E0636ADA860AA93F ORB Physical Model Name Y select olf.property_value value, olf_desc.property_value description from xxorb.orb_sql_physical_model opm, xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf, xxorb.orb_localizedstring_flat olf_desc where opm.id=olf.meta_object_id and olf.property_key = 'name' and omo.id=opm.id and opm.id=olf_desc.meta_object_id(+) and olf_desc.property_key(+) = 'description' and (:$flex$.domain_name is null or omo.parent_id =(select domain_id from xxorb.orb_domain_v odv where odv.property_value=:$flex$.domain_name) ) US 1F77CC607BF2DF42E0636ADA860AA93FY select orb_lm_details.report_id, orb_lm_details.report_name, orb_lm_details.domain_name, orb_lm_details.business_object_name, orb_lm_details.logical_model_name, orb_lm_details.physical_model_name, orb_lm_details.datasource_name, orb_lm_details.logical_model_obj_name, orb_lm_details.physical_model_obj_name, orb_lm_details.logical_model_obj_key, orb_lm_details.physical_model_obj_key, orb_lm_details.logical_model_obj_id, orb_lm_details.physical_model_obj_id, orb_lm_details.table_type, orb_lm_details.target_table_type, orb_lm_details.target_schema, case when lengthb(orb_lm_details.target_table)=3999 and orb_lm_details.target_table_type='INLINE_SQL' then xxen_orb_util.get_inline_sql_obj_blob(orb_lm_details.physical_model_obj_id) when lengthb(orb_lm_details.target_table)<3999 and orb_lm_details.target_table_type='INLINE_SQL' then to_clob(orb_lm_details.target_table) else to_clob(orb_lm_details.target_table) end target_table from ( select report.report_id, report.report_name, inherited_obj.obj_key business_object_key, category_name.property_value business_object_name, domain_name.property_value domain_name, logical_physical_model_link.id logical_model_obj_id, logical_physical_model_link.obj_key logical_model_obj_key, logical_model_base.id logical_model_id, logical_model.obj_key logical_model_key, logical_model_name.property_value logical_model_name, physical_model_object.id physical_model_obj_id, physical_model_object.obj_key physical_model_obj_key, physical_model_obj_name.property_value physical_model_obj_name, logical_model_obj_name.property_value logical_model_obj_name, physical_model_name.property_value physical_model_name, physical_model.id physical_model_id, physical_model.obj_key physical_model_key, datasource_name.property_value datasource_name, (select property_value from xxorb.orb_properties_flat opf where opf.meta_object_id=physical_model_object.id and opf.property_key='tt')table_type, (select property_value from xxorb.orb_properties_flat opf where opf.meta_object_id=physical_model_object.id and opf.property_key='sts')target_schema, (select property_value from xxorb.orb_properties_flat opf where opf.meta_object_id=physical_model_object.id and opf.property_key='stt')target_table, (select property_value from xxorb.orb_properties_flat opf where opf.meta_object_id=physical_model_object.id and opf.property_key='sttt')target_table_type from xxorb.orb_report_v report, xxorb.orb_meta_object inherited_obj, xxorb.orb_meta_object logical_model, xxorb.orb_logical_model logical_model_base, xxorb.orb_meta_object logical_physical_model_link, xxorb.orb_meta_object physical_model_object, xxorb.orb_meta_object physical_model, xxorb.orb_meta_object domain, xxorb.orb_sql_physical_model physical_model_base, xxorb.orb_meta_object datasource, xxorb.orb_localizedstring_flat domain_name, xxorb.orb_localizedstring_flat category_name, xxorb.orb_localizedstring_flat logical_model_name, xxorb.orb_localizedstring_flat physical_model_name, xxorb.orb_localizedstring_flat physical_model_obj_name, xxorb.orb_localizedstring_flat logical_model_obj_name, xxorb.orb_localizedstring_flat datasource_name where 1=1 and --report.report_type='Data Report' report.inherited_meta_obj_id = inherited_obj.id and exists (select null from xxen_orb_report_columns_v xorc where xorc.report_id=report.report_id and xorc.logical_model_obj_id=logical_physical_model_link.id ) and inherited_obj.parent_id = logical_model.id and logical_model_base.id=logical_model.id and logical_model.parent_id = domain.id and domain_name.meta_object_id = domain.id and logical_model_name.meta_object_id = logical_model.id and inherited_obj.id = category_name.meta_object_id and logical_physical_model_link.parent_id=logical_model.id and logical_physical_model_link.id<>inherited_obj.id and physical_model_object.id=logical_physical_model_link.physical_meta_obj_id and physical_model_base.id=physical_model_object.parent_id and physical_model.id=physical_model_object.parent_id and physical_model_name.meta_object_id = physical_model_base.id and datasource.id = physical_model_base.datasource_id and datasource_name.meta_object_id = datasource.id and physical_model_obj_name.meta_object_id=physical_model_object.id and logical_model_obj_name.meta_object_id=logical_physical_model_link.id and inherited_obj.obj_type = 10 and logical_model.obj_type = 6 and physical_model.obj_type = 2 and --datasource.obj_type = 3 and domain.obj_type = 1 and category_name.property_key = 'name' and domain_name.property_key = 'name' and logical_model_name.property_key = 'name' and physical_model_name.property_key = 'name' and datasource_name.property_key = 'name' and physical_model_obj_name.property_key = 'name' and logical_model_obj_name.property_key = 'name' ) orb_lm_details order by orb_lm_details.domain_name,orb_lm_details.report_id US ORB Logical and Physical Model Details(Data Report) List the details of ORB Logical and Physical Model including the Database table name and INLINE SQL details for the Report ORBIT 1=1 1 10 1=1 domain_name.property_value=: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 2 20 1=1 report.report_name=:report_name LOV custom Y select orv.report_name value, orv.report_desc description from xxorb.orb_report_v orv, xxorb.orb_report_domain_v ordv where --orv.report_type='Data Report' and ordv.report_id(+)=orv.report_id and (:$flex$.domain_name is null or ordv.domain_name=:$flex$.domain_name) US Report Name 3 30 1=1 logical_model_name.property_value =:logical_model_name LOV ORB Logical Model Name 1F77CC607BF1DF42E0636ADA860AA93F Y select olf.property_value value, olf_desc.property_value description from xxorb.orb_logical_model olm, xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf, xxorb.orb_localizedstring_flat olf_desc where olm.id=olf.meta_object_id and olf.property_key = 'name' and omo.id=olm.id and olm.id=olf_desc.meta_object_id(+) and olf_desc.property_key(+) = 'description' and (:$flex$.domain_name is null or omo.parent_id =(select domain_id from xxorb.orb_domain_v odv where odv.property_value=:$flex$.domain_name) ) US Logical Model Name 4 40 1=1 physical_model_name.property_value=:physical_model_name LOV ORB Physical Model Name 1F77CC607BF3DF42E0636ADA860AA93F Y select olf.property_value value, olf_desc.property_value description from xxorb.orb_sql_physical_model opm, xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf, xxorb.orb_localizedstring_flat olf_desc where opm.id=olf.meta_object_id and olf.property_key = 'name' and omo.id=opm.id and opm.id=olf_desc.meta_object_id(+) and olf_desc.property_key(+) = 'description' and (:$flex$.domain_name is null or omo.parent_id =(select domain_id from xxorb.orb_domain_v odv where odv.property_value=:$flex$.domain_name) ) US Physical Model Name