265: Select etb.town_or_city, etb.region_2
266: From
267: xle_establishment_v etb
268: ,xle_bsv_associations bsv
269: ,gl_ledger_le_v gl
270: Where
271: etb.legal_entity_id = gl.legal_entity_id
272: And bsv.legal_parent_id = etb.legal_entity_id
273: And etb.establishment_id = bsv.legal_construct_id