Skip to content
Snippets Groups Projects

Update mv_intervenant.sql

Merged Update mv_intervenant.sql
myriam.poujol-master-patch-99886 into master
Merged Myriam Poujol requested to merge myriam.poujol-master-patch-99886 into master
Compare
and
1 file
+ 4
− 4
Compare changes
  • Side-by-side
  • Inline
doc/Connecteurs-Import/Siham/Partie_B_SIHAM_INTERV/B3_SIHAM_INTERV_Connecteur_OSE/mv_intervenant.sql
+ 4
− 4
@@ -24,7 +24,7 @@ SELECT
i.email_pro email_pro,
uad.w_mail_perso email_perso,
uad.batiment adresse_precisions,
uad.no_voie adresse_numero,
substr(substr(uad.no_voie,1,instr(uad.no_voie,' ')),1, 4) adresse_numero,
uad.numero_compl_code z_adresse_numero_compl_id,
uad.voirie_code z_adresse_voirie_id,
uad.nom_voie adresse_voie,
@@ -104,7 +104,7 @@ SELECT
i.email_pro email_pro,
uad.w_mail_perso email_perso,
uad.batiment adresse_precisions,
uad.no_voie adresse_numero,
substr(substr(uad.no_voie,1,instr(uad.no_voie,' ')),1,4) adresse_numero,
uad.numero_compl_code z_adresse_numero_compl_id,
uad.voirie_code z_adresse_voirie_id,
uad.nom_voie adresse_voie,
@@ -184,7 +184,7 @@ SELECT
i.email_pro email_pro,
uad.w_mail_perso email_perso,
uad.batiment adresse_precisions,
uad.no_voie adresse_numero,
substr(substr(uad.no_voie,1,instr(uad.no_voie,' ')),1,4) adresse_numero,
uad.numero_compl_code z_adresse_numero_compl_id,
uad.voirie_code z_adresse_voirie_id,
uad.nom_voie adresse_voie,
@@ -330,4 +330,4 @@ where a.source_code = i.source_code
-- and opr.source_code = payr.source_code
and i.w_statut_pip not in ('TITU1','STAGI')
and vr.code(+) = uad.voirie_code
;
\ No newline at end of file
;