Reports2017-11-18T12:27:27+00:00

XLE Establishment and Legal Entity Associations

Description
Categories: Enginatics, Financials, Setup
Establishments and 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

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

By continuing to use the site, you agree to the use of cookies. Accept