ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9F79D2E0530100007F1FF2 XLE Legal Entity Name Y select xep.name value, xep.legal_entity_identifier description from xle_entity_profiles xep order by xep.name US 49A8B1A8037208ACE0530100007FEB91Y select initcap(translate(xav.context,'_',' ')) context, xep.name parent_legal_entity, initcap(translate(xav.legal_construct,'_',' ')) construct_type, xav.legal_construct_name construct_name, initcap(translate(xav.entity_type,'_',' ')) entity_type, xav.entity_name, xav.effective_from, xav.effective_to from xle_associations_v xav, xle_entity_profiles xep where 1=1 and xav.legal_parent_id=xep.legal_entity_id(+) order by xep.name, xav.legal_construct, xav.legal_construct_name, xav.entity_type, xav.entity_name US XLE Establishment and Legal Entity Associations Master data report showing the legal entity associations to other business entities such as: - Legal Entities - Operating Units - Inventory Organizations - Inventory Locations - Bill To Locations - Ship To Locations - Balancing Segment Values Enginatics R12 only 1=1 1 10 1=1 xep.name=:parent_legal_entity LOV XLE Legal Entity Name 8E2FF36EDE9F79D2E0530100007F1FF2 Y select xep.name value, xep.legal_entity_identifier description from xle_entity_profiles xep order by xep.name F Entité juridique mère US Parent Legal Entity 2 20 1=1 initcap(translate(xav.entity_type,'_',' '))=:entity_type LOV custom Y select 'Balancing Segment Value' value, null description from dual union all select 'Bill To Location' value, null description from dual union all select 'Inventory Location' value, null description from dual union all select 'Inventory Organization' value, null description from dual union all select 'Legal Entity' value, null description from dual union all select 'Operating Unit' value, null description from dual union all select 'Ship To Location' value, null description from dual F Type d'entité US Entity Type