XLE Establishment and Legal Entity Associations

➜ Back to Library
Description
Categories: Enginatics, Kcapps
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
Run XLE Establishment and Legal Entity Associations and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
IBY Payment Process Request Details CE Transactions Available for Reconciliation CE General Ledger Reconciliation orgs CE General Ledger Cash Account Usage CE Cleared Transactions CE Bank Statement and Reconciliation ZX Party Tax Profiles JE Italian Withholding Yearly
Blitz Report™

Blitz Report™ provides multiple benefits: