XLE Establishment and Legal Entity Associations
Description
- Categories
- Enginatics, R12 only
- Repository
- GitHub
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
- Legal Entities
- Operating Units
- Inventory Organizations
- Inventory Locations
- Bill To Locations
- Ship To Locations
- Balancing Segment Values
SQL 21 lines
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 |
Parameters 2
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Parent Legal Entity | LOV |
| |
| Entity Type | LOV |
|