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 1F77CC607BF0DF42E0636ADA860AA93F select distinct omo.obj_key bo_obj_key, olf_bo_name.property_value business_object_name, olf_bo_description.property_value business_object_description, olf_parent_name.property_value bo_logical_model_name, omo_domain_name.property_value domain_name, case when omos.role_id is not null then 'ROLE' when omos.user_id is not null then 'USER' end bo_assignment_type, case when omos.user_id is not null then xxen_orb_util.orb_user(omos.user_id) end bo_assigned_user_name, case when omos.role_id is not null then (select name from xxorb.orb_role orole where id=omos.role_id) end bo_assigned_role_name from xxorb.orb_business_object obo, xxorb.orb_meta_object_security omos, xxorb.orb_meta_object omo, xxorb.orb_meta_object omo_parent, xxorb.orb_meta_object omo_domain, xxorb.orb_localizedstring_flat omo_domain_name, xxorb.orb_localizedstring_flat olf_parent_name, xxorb.orb_localizedstring_flat olf_bo_name, xxorb.orb_localizedstring_flat olf_bo_description where 1=1 and obo.id=omo.id and omo.obj_type=10 and omo_parent.id=omo.parent_id and omos.meta_object_id(+)=obo.id and olf_parent_name.meta_object_id=omo.parent_id and olf_parent_name.property_key = 'name' and olf_bo_name.property_key = 'name' and olf_bo_name.meta_object_id=omo.id and olf_bo_description.meta_object_id(+)=omo.id and olf_bo_description.property_key(+) = 'description' and omo_parent.parent_id=omo_domain.id and omo_domain.obj_type=1 and omo_domain_name.meta_object_id=omo_domain.id and omo_domain_name.property_key = 'name' order by omo_domain_name.property_value Y Y US ORB Business Object and Assignments List all business objects available to create report with domain name,logical model name and current assignment. ORBIT 1=1 1 10 1=1 omo_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 olf_parent_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 :$flex$.domain_name Domain Name Logical Model Name