
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,
 v.voietype as voietype,
 v.voielib as voielib,
 z.zonetype 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, &DB_PREFIXEvoie v

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