XLE Establishment and Legal Entity Associations

Description
Categories: Enginatics
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Parameter Name SQL text Validation
Parent Legal Entity
xep.name=:parent_legal_entity
LOV
Entity Type
initcap(translate(xav.entity_type,'_',' '))=:entity_type
LOV