-- View: mf.vu_acte_details

-- DROP VIEW mf.vu_acte_details;

CREATE OR REPLACE VIEW mf.vu_acte_details AS 
 SELECT join1.code_acte, join1.date_acte, type_acte.type_acte, type_acte.cat_acte, join1.type_maitrise, join1.cat_maitrise, join1.nom_notaire, join1.prix_acquisition, join1.origine_propriete, join1.duree_conv, join1.echeance_prevue, join1.createur, join1.last_modif_by, join1.saisie_access
   FROM ( SELECT acte.code_acte, acte.natr_acte, acte.date_acte, acte.nom_notaire, acte.maitrise_fonciere, acte.prix_acquisition, acte.origine_propriete, acte.duree_conv, acte.echeance_prevue, acte.createur, acte.last_modif_by, acte.saisie_access, acte.ref_type_acte, acte.ref_type_maitrise, type_maitrise.type_maitrise, type_maitrise.cat_maitrise
           FROM mf.acte
      LEFT JOIN mf.type_maitrise ON acte.ref_type_maitrise = type_maitrise.id_type_maitrise) join1
   LEFT JOIN mf.type_acte ON join1.ref_type_acte = type_acte.id_type_acte;

ALTER TABLE mf.vu_acte_details OWNER TO ludodo;
GRANT ALL ON TABLE mf.vu_acte_details TO ludodo;
GRANT ALL ON TABLE mf.vu_acte_details TO geomatique;
GRANT SELECT, REFERENCES, TRIGGER ON TABLE mf.vu_acte_details TO cpnrc;
GRANT SELECT ON TABLE mf.vu_acte_details TO public;

