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 49A8B1A8036908ACE0530100007FEB91 select x.* from ( select nvl(hg.geography_name,max(hg.geography_name) over (partition by xep.legal_entity_id)) jurisdiction_country, xep0.name parent_legal_entity, xep.type, xep.name, hp.party_number, hla.location_code, nvl2(hla.address_line_1,hla.address_line_1||' ','')|| nvl2(hla.address_line_2,hla.address_line_2||' ','')|| nvl2(hla.address_line_3,hla.address_line_3||' ','')|| nvl2(hla.town_or_city,hla.town_or_city||' ','')|| nvl2(hla.region_2,hla.region_2||' ','')|| hla.postal_code address, ftv.territory_short_name country, xep.main_establishment, xep.effective_from, xep.effective_to, xxen_util.meaning(xjv.legislative_cat_code,'LEGISLATIVE_CATEGORY',222) legislative_category, xjv.name jurisdiction_name, xr.registered_name, xr.registration_number, nvl2(flvv.meaning,flvv.meaning||' ('||flvv.description||')',null) registration_code, hp0.party_name legalauth_name, nvl2(hl.address1,hl.address1||' ','')|| nvl2(hl.address2,hl.address2||' ','')|| nvl2(hl.city,hl.city||' ','')|| nvl2(hl.state,hl.state||' ','')|| nvl2(hl.country,hl.country||' ','')|| hl.postal_code legalauth_address from ( select 'Legal Entity' type, xep.party_id, xep.legal_entity_id, 'XLE_ENTITY_PROFILES' source_table, xep.legal_entity_id source_id, xep.name, xep.effective_from, xep.effective_to, null main_establishment from xle_entity_profiles xep union all select 'Establishment' type, xestp.party_id, xestp.legal_entity_id, 'XLE_ETB_PROFILES' source_table, xestp.establishment_id source_id, xestp.name, xestp.effective_from, xestp.effective_to, decode(xestp.main_establishment_flag,'Y','Yes') main_establishment from xle_entity_profiles xep, xle_etb_profiles xestp where xep.legal_entity_id=xestp.legal_entity_id ) xep, hz_parties hp, xle_entity_profiles xep0, xle_registrations xr, xle_jurisdictions_vl xjv, hz_geographies hg, fnd_lookup_values_vl flvv, hr_locations_all hla, fnd_territories_vl ftv, hz_parties hp0, hz_party_sites hps, hz_locations hl where xep.party_id=hp.party_id and xep.legal_entity_id=xep0.legal_entity_id and xep.source_table=xr.source_table(+) and xep.source_id=xr.source_id(+) and xr.jurisdiction_id=xjv.jurisdiction_id(+) and xjv.geography_id=hg.geography_id(+) and xjv.registration_code_le=flvv.lookup_code(+) and flvv.lookup_type(+)='XLE_REG_CODE' and flvv.view_application_id(+)=204 and flvv.security_group_id(+)=0 and xr.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) and xr.issuing_authority_id=hp0.party_id(+) and xr.issuing_authority_site_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) ) x where 1=1 order by x.jurisdiction_country, x.parent_legal_entity, x.type desc, x.main_establishment, x.effective_to desc, x.party_number, x.legislative_category, x.registration_number Y AR XLE Legal Entities الكيانات القانونية والمؤسسات والسلطات القضائية والتسجيلات D XLE Legal Entities Juristische Personen, Niederlassungen, Gerichtsbarkeiten und Registrierungen E XLE Legal Entities Entidades jurídicas, establecimientos, jurisdicciones y registros F XLE Legal Entities Personnes morales, établissements, juridictions et enregistrements I XLE Legal Entities Persone giuridiche, stabilimenti, giurisdizioni e registrazioni JA XLE Legal Entities 法人、事業所、管轄および登録 KO XLE Legal Entities 법인, 시설, 관할권 및 등록 PTB XLE Legal Entities Pessoas jurídicas, estabelecimentos, jurisdições e registros RU XLE Legal Entities Юридические лица, учреждения, юрисдикции и регистрации S XLE Legal Entities Juridiska enheter, anläggningar, jurisdiktioner och registreringar TR XLE Legal Entities Tüzel kişiler, kuruluşlar, yargı bölgeleri ve kayıtlar US XLE Legal Entities Legal entities, establishments, jurisdictions and registrations ZHS XLE Legal Entities 法律实体、机构、管辖范围和注册情况 Enginatics R12 only 1=1 1 10 1=1 x.jurisdiction_country=:jurisdiction_country LOV custom Y select hg.geography_name value, hg.geography_code description from hz_geographies hg where hg.geography_type='COUNTRY' order by hg.geography_name F Juridiction Pays US Jurisdiction Country 2 20 1=1 x.parent_legal_entity=:legal_entity_name 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 Nom de l'entité juridique US Legal Entity Name