SELECT
  e.emplacement as numero,
  e.complement as complement,
  e.superficie as superficie,
  c.cimetierelib as cimetiere,
  to_char(o.date,'DD/MM/YYYY') as dateoperation,
  o.heure as heureoperation,
  e.numero as num_adresse,
  voie_type.libelle as voietype,
  v.voielib as voielib,
  zone_type.libelle as zonetype,
  z.zonelib as zonelib,
  to_char(e.datevente,'DD/MM/YYYY') as datevente,
  e.superficie as surface,
  o.numdossier as numdossier,
  o.societe_coordonnee as societe,
  o.particulier as particulier,
  o.pf_coordonnee as pompesfunebres,
  o.observation as observation

FROM 
  &DB_PREFIXEoperation o,
  &DB_PREFIXEemplacement e,
  &DB_PREFIXEcimetiere c,
  &DB_PREFIXEzone z
  LEFT JOIN &DB_PREFIXEzone_type on z.zonetype = zone_type.zone_type,
  &DB_PREFIXEvoie v
  LEFT JOIN &DB_PREFIXEvoie_type on v.voietype = voie_type.voie_type

WHERE 
  z.cimetiere = c.cimetiere AND
  v.zone = z.zone AND
  e.voie = v.voie AND
  e.emplacement = o.emplacement AND
  o.operation = '&idx'