J’ai un problème qui me bloque avec Doctrine.
Je doit interfacer Doctrine sur une base de donnée ORACLE d'un des logiciels prestataire de mon boulot. je n'ai donc pas la main sur les nom des champs, etc.
J'ai un requete qui récupère toutes les infos d'un véhicule qui de base me renvoi plus de 100 champs. Je dois rajouter un champ.
Le champ que je souhaite rajouter est ID_STATUTS_CARTE_ACCREDITIVE. Ce champ me sert a jointer vers une autre table. Tant que je n’ai pas la jointure tout va bien même si on commence à voir mon problème.

Code : Sélectionner tout - Visualiser dans une fenêtre à part
v4_.ID_STATUTS_CARTE_ACCREDITIVE AS D_STATUTS_CARTE_ACCREDITIVE_33
=> dans le AS le nom du champ est tronqué le I manque.

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
SELECT 
  v0_.ID_VEHICULE AS ID_VEHICULE_0, 
  v0_.IDENTIFIANT AS IDENTIFIANT_1, 
  v0_.LIB_MARQUE AS LIB_MARQUE_2, 
  v0_.LIB_MODELE AS LIB_MODELE_3, 
  v0_.LIB_ENERGIE AS LIB_ENERGIE_4, 
  v0_.IMMATRICULATION AS IMMATRICULATION_5, 
  v0_.DATE_MISEENSERVICE AS DATE_MISEENSERVICE_6, 
  v0_.LIB_CATEGORIE_VEHICULE AS LIB_CATEGORIE_VEHICULE_7, 
  v0_.LIB_SOUSCATEGORIE_VEHICULE AS LIB_SOUSCATEGORIE_VEHICULE_8, 
  v0_.LIB_FOURNISSEUR AS LIB_FOURNISSEUR_9, 
  v0_.ID_CERTIF_IMMAT AS ID_CERTIF_IMMAT_10, 
  v0_.DATE_INCORPORATION AS DATE_INCORPORATION_11, 
  v1_.ID_AFFECTATION_VEHICULE AS ID_AFFECTATION_VEHICULE_12, 
  v1_.ID_VEHICULE AS ID_VEHICULE_13, 
  v1_.LIB_AFFECT2 AS LIB_AFFECT2_14, 
  v1_.LIB_AFFECT3 AS LIB_AFFECT3_15, 
  v1_.LIB_AFFECT4 AS LIB_AFFECT4_16, 
  v1_.LIB_AFFECT5 AS LIB_AFFECT5_17, 
  v2_.ID_CONTRAT AS ID_CONTRAT_18, 
  v2_.ID_VEHICULE AS ID_VEHICULE_19, 
  v2_.LIB_TIERS AS LIB_TIERS_20, 
  v2_.LIB_CATEGORIE_CONTRAT AS LIB_CATEGORIE_CONTRAT_21, 
  v2_.NUMERO AS NUMERO_22, 
  v2_.DATE_DEBUT_CONTRAT AS DATE_DEBUT_CONTRAT_23, 
  v2_.DATE_FIN_CONTRAT AS DATE_FIN_CONTRAT_24, 
  v2_.LIB_MODE_ECHEANCE AS LIB_MODE_ECHEANCE_25, 
  v3_.ID_ATTRIBUTION_CART_ACCRED AS ID_ATTRIBUTION_CART_ACCRED_26, 
  v3_.ID_VEHICULE AS ID_VEHICULE_27, 
  v3_.ID_CARTE_ACCREDITIVE AS ID_CARTE_ACCREDITIVE_28, 
  v4_.ID_CARTE_ACCREDITIVE AS ID_CARTE_ACCREDITIVE_29, 
  v4_.LIB_TIERS_F_PRESTANT AS LIB_TIERS_F_PRESTANT_30, 
  v4_.NUMERO AS NUMERO_31, 
  v4_.DEBUT_VALIDITE AS DEBUT_VALIDITE_32, 
  v4_.ID_STATUTS_CARTE_ACCREDITIVE AS D_STATUTS_CARTE_ACCREDITIVE_33, 
  t5_.ID_CERTIF_IMMAT AS ID_CERTIF_IMMAT_34, 
  t5_.NUANCE_COULEUR AS NUANCE_COULEUR_35, 
  t5_.MARQUE_CARROSSERIE AS MARQUE_CARROSSERIE_36, 
  t5_.NUMERO_SIREN AS NUMERO_SIREN_37, 
  t5_.CANTON AS CANTON_38, 
  t5_.REGION_ADMINISTRATIVE AS REGION_ADMINISTRATIVE_39, 
  t5_.PTR_PREFECTURE AS PTR_PREFECTURE_40, 
  t5_.TURBO_COMPRESSEUR AS TURBO_COMPRESSEUR_41, 
  t5_.VOIE_ARRIERE AS VOIE_ARRIERE_42, 
  t5_.TYPE_BOITE_VITESSE AS TYPE_BOITE_VITESSE_43, 
  t5_.STATUT_IMMATRICULATION AS STATUT_IMMATRICULATION_44, 
  t5_.COULEUR AS COULEUR_45, 
  t5_.DEPOLLUTION AS DEPOLLUTION_46, 
  t5_.HAUTEUR AS HAUTEUR_47, 
  t5_.DEPARTEMENT AS DEPARTEMENT_48, 
  t5_.CREDIT_BAIL AS CREDIT_BAIL_49, 
  t5_.NB_PROPRIETAIRES AS NB_PROPRIETAIRES_50, 
  t5_.TEMOIN_CESSION AS TEMOIN_CESSION_51, 
  t5_.PUISSANCE AS PUISSANCE_52, 
  t5_.CODE_VIN_PREFECTURE AS CODE_VIN_PREFECTURE_53, 
  t5_.VOIE_AVANT AS VOIE_AVANT_54, 
  t5_.CONSO_EXTRA_URBAINE AS CONSO_EXTRA_URBAINE_55, 
  t5_.MODELE_PREFECTURE AS MODELE_PREFECTURE_56, 
  t5_.CLASSE_ENVIRONNEMENTALE AS CLASSE_ENVIRONNEMENTALE_57, 
  t5_.MODELE_ETUDE AS MODELE_ETUDE_58, 
  t5_.CONSO_MIXTE AS CONSO_MIXTE_59, 
  t5_.CONSO_URBAINE AS CONSO_URBAINE_60, 
  t5_.MODE_REFROIDISSEMENT AS MODE_REFROIDISSEMENT_61, 
  t5_.MODE_INJECTION AS MODE_INJECTION_62, 
  t5_.CODE_APE AS CODE_APE_63, 
  t5_.EMPATTEMENT AS EMPATTEMENT_64, 
  t5_.NB_MAINS AS NB_MAINS_65, 
  t5_.CATEGORIE_CLIENT_VO AS CATEGORIE_CLIENT_VO_66, 
  t5_.CATEGORIE_CLIENT AS CATEGORIE_CLIENT_67, 
  t5_.CATEGORIE_VENDEUR AS CATEGORIE_VENDEUR_68, 
  t5_.PROPULSION AS PROPULSION_69, 
  t5_.NB_CYLINDRES AS NB_CYLINDRES_70, 
  t5_.NB_SOUPAPES AS NB_SOUPAPES_71, 
  t5_.NB_VOLUMES AS NB_VOLUMES_72, 
  t5_.NB_PORTES AS NB_PORTES_73, 
  t5_.NB_VITESSES AS NB_VITESSES_74, 
  t5_.CODE_VIN_CONSTRUCTEUR AS CODE_VIN_CONSTRUCTEUR_75, 
  t5_.PTAC AS PTAC_76, 
  t5_.PTR AS PTR_77, 
  t5_.PV AS PV_78, 
  t5_.NUM_SERIE AS NUM_SERIE_79, 
  v6_.ID_VEHICULE AS ID_VEHICULE_80, 
  v6_.LIB_GROUPE_ASSURANCE AS LIB_GROUPE_ASSURANCE_81, 
  v7_.ID_VEHICULE AS ID_VEHICULE_82, 
  v7_.cp_veh_lib1 AS CP_VEH_LIB1_83, 
  v7_.cp_veh_lib10 AS CP_VEH_LIB10_84, 
  v7_.cp_veh_bool2 AS CP_VEH_BOOL2_85, 
  v7_.cp_veh_bool3 AS CP_VEH_BOOL3_86, 
  v7_.cp_veh_bool4 AS CP_VEH_BOOL4_87, 
  v7_.cp_veh_qtte2 AS CP_VEH_QTTE2_88, 
  v7_.lib_cp_veh_ref5 AS LIB_CP_VEH_REF5_89, 
  v7_.lib_cp_veh_ref10 AS LIB_CP_VEH_REF10_90, 
  v7_.lib_cp_veh_liba1 AS LIB_CP_VEH_LIBA1_91, 
  v8_.ID_VEHICULE AS ID_VEHICULE_92, 
  v8_.ACTIVITE_HORAIRE_MAXIMALE AS ACTIVITE_HORAIRE_MAXIMALE_93, 
  v8_.DIMENSION_PNEU AS DIMENSION_PNEU_94, 
  v9_.ID_STATUTS_VEHICULE AS ID_STATUTS_VEHICULE_95, 
  v9_.ID_VEHICULE AS ID_VEHICULE_96, 
  v9_.LIB_STATUT_VEHIC_1 AS LIB_STATUT_VEHIC_1_97, 
  v10_.ID_AFFECTATION_VEHICULE AS ID_AFFECTATION_VEHICULE_98, 
  v10_.ID_VEHICULE_RATTACHEMENT AS ID_VEHICULE_RATTACHEMENT_99, 
  v10_.ID_VEHICULE_RATTACHE AS ID_VEHICULE_RATTACHE_100, 
  v10_.LIB_MARQUE AS LIB_MARQUE_101, 
  v10_.LIB_MODELE AS LIB_MODELE_102, 
  v10_.LIB_CATEGORIE_VEHICULE AS LIB_CATEGORIE_VEHICULE_103, 
  v10_.LIB_SOUSCATEGORIE_VEHICULE AS LIB_SOUSCATEGORIE_VEHICULE_104, 
  v11_.ID_VEHICULE AS ID_VEHICULE_105, 
  v11_.cp_veh_bool2 AS CP_VEH_BOOL2_106, 
  v11_.lib_cp_veh_ref3 AS LIB_CP_VEH_REF3_107, 
  v11_.cp_veh_lib2 AS CP_VEH_LIB2_108, 
  v11_.cp_veh_lib5 AS CP_VEH_LIB5_109, 
  v11_.cp_veh_qtte1 AS CP_VEH_QTTE1_110, 
  v11_.cp_veh_bool1 AS CP_VEH_BOOL1_111, 
  v11_.lib_cp_veh_ref4 AS LIB_CP_VEH_REF4_112, 
  v11_.lib_cp_veh_ref5 AS LIB_CP_VEH_REF5_113, 
  v11_.cp_veh_lib9 AS CP_VEH_LIB9_114, 
  v11_.cp_veh_qtte4 AS CP_VEH_QTTE4_115, 
  v11_.lib_cp_veh_ref6 AS LIB_CP_VEH_REF6_116, 
  v11_.cp_veh_qtte3 AS CP_VEH_QTTE3_117, 
  v11_.cp_veh_lib6 AS CP_VEH_LIB6_118, 
  v0_.ID_CERTIF_IMMAT AS ID_CERTIF_IMMAT_119, 
  v0_.ID_VEHICULE AS ID_VEHICULE_120, 
  v0_.ID_VEHICULE AS ID_VEHICULE_121, 
  v0_.ID_VEHICULE AS ID_VEHICULE_122, 
  v1_.ID_VEHICULE AS ID_VEHICULE_123, 
  v2_.ID_VEHICULE AS ID_VEHICULE_124, 
  v3_.ID_VEHICULE AS ID_VEHICULE_125, 
  v3_.ID_CARTE_ACCREDITIVE AS ID_CARTE_ACCREDITIVE_126, 
  v9_.ID_VEHICULE AS ID_VEHICULE_127, 
  v10_.ID_VEHICULE_RATTACHEMENT AS ID_VEHICULE_RATTACHEMENT_128, 
  v10_.ID_VEHICULE_RATTACHE AS ID_VEHICULE_RATTACHE_129 
FROM 
  V_VEHICULE_INFO v0_ 
  INNER JOIN V_VEHICULE_AFFECT_COURANTE v1_ ON v0_.ID_VEHICULE = v1_.ID_VEHICULE 
  LEFT JOIN V_CONTRAT_INFO v2_ ON v0_.ID_VEHICULE = v2_.ID_VEHICULE 
  LEFT JOIN V_CART_ACCR_ATTRIB_COURANTE v3_ ON v0_.ID_VEHICULE = v3_.ID_VEHICULE 
  LEFT JOIN V_CARTE_ACCREDITIVE_INFO v4_ ON v3_.ID_CARTE_ACCREDITIVE = v4_.ID_CARTE_ACCREDITIVE 
  INNER JOIN T_CERTIF_IMMAT t5_ ON v0_.ID_CERTIF_IMMAT = t5_.ID_CERTIF_IMMAT 
  LEFT JOIN V_VEHICULE_ASSURANCE v6_ ON v0_.ID_VEHICULE = v6_.ID_VEHICULE 
  LEFT JOIN V_VEHICULE_CAR_PERS v7_ ON v0_.ID_VEHICULE = v7_.ID_VEHICULE 
  LEFT JOIN V_VEHICULE_CAR_TECH v8_ ON v0_.ID_VEHICULE = v8_.ID_VEHICULE 
  INNER JOIN V_VEHICULE_STATUT_COURANT v9_ ON v0_.ID_VEHICULE = v9_.ID_VEHICULE 
  LEFT JOIN V_VEHIC_RATTACHES_A_VEHIC v10_ ON v0_.ID_VEHICULE = v10_.ID_VEHICULE_RATTACHEMENT 
  LEFT JOIN V_VEHICULE_CAR_PERS v11_ ON v10_.ID_VEHICULE_RATTACHE = v11_.ID_VEHICULE 
WHERE 
  v0_.ID_VEHICULE = 6526

Si je rajoute la jointure alors il me rajoute un champ dans le select à la fin de la requête pourquoi je ne sais pas mais Doctrine le rajoute.
Et du coup le « AS semble » limité à 30 caractères donc il enlève les deux premiers donc je me retrouve avec => v4_.ID_STATUTS_CARTE_ACCREDITIVE AS _STATUTS_CARTE_ACCREDITIVE_127 et une belle erreur oracle ORA-00911: invalid character a cause du _ au début du AS…..

Ci-après la requête.

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
SELECT 
  v0_.ID_VEHICULE AS ID_VEHICULE_0, 
  v0_.IDENTIFIANT AS IDENTIFIANT_1, 
  v0_.LIB_MARQUE AS LIB_MARQUE_2, 
  v0_.LIB_MODELE AS LIB_MODELE_3, 
  v0_.LIB_ENERGIE AS LIB_ENERGIE_4, 
  v0_.IMMATRICULATION AS IMMATRICULATION_5, 
  v0_.DATE_MISEENSERVICE AS DATE_MISEENSERVICE_6, 
  v0_.LIB_CATEGORIE_VEHICULE AS LIB_CATEGORIE_VEHICULE_7, 
  v0_.LIB_SOUSCATEGORIE_VEHICULE AS LIB_SOUSCATEGORIE_VEHICULE_8, 
  v0_.LIB_FOURNISSEUR AS LIB_FOURNISSEUR_9, 
  v0_.ID_CERTIF_IMMAT AS ID_CERTIF_IMMAT_10, 
  v0_.DATE_INCORPORATION AS DATE_INCORPORATION_11, 
  v1_.ID_AFFECTATION_VEHICULE AS ID_AFFECTATION_VEHICULE_12, 
  v1_.ID_VEHICULE AS ID_VEHICULE_13, 
  v1_.LIB_AFFECT2 AS LIB_AFFECT2_14, 
  v1_.LIB_AFFECT3 AS LIB_AFFECT3_15, 
  v1_.LIB_AFFECT4 AS LIB_AFFECT4_16, 
  v1_.LIB_AFFECT5 AS LIB_AFFECT5_17, 
  v2_.ID_CONTRAT AS ID_CONTRAT_18, 
  v2_.ID_VEHICULE AS ID_VEHICULE_19, 
  v2_.LIB_TIERS AS LIB_TIERS_20, 
  v2_.LIB_CATEGORIE_CONTRAT AS LIB_CATEGORIE_CONTRAT_21, 
  v2_.NUMERO AS NUMERO_22, 
  v2_.DATE_DEBUT_CONTRAT AS DATE_DEBUT_CONTRAT_23, 
  v2_.DATE_FIN_CONTRAT AS DATE_FIN_CONTRAT_24, 
  v2_.LIB_MODE_ECHEANCE AS LIB_MODE_ECHEANCE_25, 
  v3_.ID_ATTRIBUTION_CART_ACCRED AS ID_ATTRIBUTION_CART_ACCRED_26, 
  v3_.ID_VEHICULE AS ID_VEHICULE_27, 
  v3_.ID_CARTE_ACCREDITIVE AS ID_CARTE_ACCREDITIVE_28, 
  v4_.ID_CARTE_ACCREDITIVE AS ID_CARTE_ACCREDITIVE_29, 
  v4_.LIB_TIERS_F_PRESTANT AS LIB_TIERS_F_PRESTANT_30, 
  v4_.NUMERO AS NUMERO_31, 
  v4_.DEBUT_VALIDITE AS DEBUT_VALIDITE_32, 
  v4_.ID_STATUTS_CARTE_ACCREDITIVE AS D_STATUTS_CARTE_ACCREDITIVE_33, 
  t5_.ID_CERTIF_IMMAT AS ID_CERTIF_IMMAT_34, 
  t5_.NUANCE_COULEUR AS NUANCE_COULEUR_35, 
  t5_.MARQUE_CARROSSERIE AS MARQUE_CARROSSERIE_36, 
  t5_.NUMERO_SIREN AS NUMERO_SIREN_37, 
  t5_.CANTON AS CANTON_38, 
  t5_.REGION_ADMINISTRATIVE AS REGION_ADMINISTRATIVE_39, 
  t5_.PTR_PREFECTURE AS PTR_PREFECTURE_40, 
  t5_.TURBO_COMPRESSEUR AS TURBO_COMPRESSEUR_41, 
  t5_.VOIE_ARRIERE AS VOIE_ARRIERE_42, 
  t5_.TYPE_BOITE_VITESSE AS TYPE_BOITE_VITESSE_43, 
  t5_.STATUT_IMMATRICULATION AS STATUT_IMMATRICULATION_44, 
  t5_.COULEUR AS COULEUR_45, 
  t5_.DEPOLLUTION AS DEPOLLUTION_46, 
  t5_.HAUTEUR AS HAUTEUR_47, 
  t5_.DEPARTEMENT AS DEPARTEMENT_48, 
  t5_.CREDIT_BAIL AS CREDIT_BAIL_49, 
  t5_.NB_PROPRIETAIRES AS NB_PROPRIETAIRES_50, 
  t5_.TEMOIN_CESSION AS TEMOIN_CESSION_51, 
  t5_.PUISSANCE AS PUISSANCE_52, 
  t5_.CODE_VIN_PREFECTURE AS CODE_VIN_PREFECTURE_53, 
  t5_.VOIE_AVANT AS VOIE_AVANT_54, 
  t5_.CONSO_EXTRA_URBAINE AS CONSO_EXTRA_URBAINE_55, 
  t5_.MODELE_PREFECTURE AS MODELE_PREFECTURE_56, 
  t5_.CLASSE_ENVIRONNEMENTALE AS CLASSE_ENVIRONNEMENTALE_57, 
  t5_.MODELE_ETUDE AS MODELE_ETUDE_58, 
  t5_.CONSO_MIXTE AS CONSO_MIXTE_59, 
  t5_.CONSO_URBAINE AS CONSO_URBAINE_60, 
  t5_.MODE_REFROIDISSEMENT AS MODE_REFROIDISSEMENT_61, 
  t5_.MODE_INJECTION AS MODE_INJECTION_62, 
  t5_.CODE_APE AS CODE_APE_63, 
  t5_.EMPATTEMENT AS EMPATTEMENT_64, 
  t5_.NB_MAINS AS NB_MAINS_65, 
  t5_.CATEGORIE_CLIENT_VO AS CATEGORIE_CLIENT_VO_66, 
  t5_.CATEGORIE_CLIENT AS CATEGORIE_CLIENT_67, 
  t5_.CATEGORIE_VENDEUR AS CATEGORIE_VENDEUR_68, 
  t5_.PROPULSION AS PROPULSION_69, 
  t5_.NB_CYLINDRES AS NB_CYLINDRES_70, 
  t5_.NB_SOUPAPES AS NB_SOUPAPES_71, 
  t5_.NB_VOLUMES AS NB_VOLUMES_72, 
  t5_.NB_PORTES AS NB_PORTES_73, 
  t5_.NB_VITESSES AS NB_VITESSES_74, 
  t5_.CODE_VIN_CONSTRUCTEUR AS CODE_VIN_CONSTRUCTEUR_75, 
  t5_.PTAC AS PTAC_76, 
  t5_.PTR AS PTR_77, 
  t5_.PV AS PV_78, 
  t5_.NUM_SERIE AS NUM_SERIE_79, 
  v6_.ID_VEHICULE AS ID_VEHICULE_80, 
  v6_.LIB_GROUPE_ASSURANCE AS LIB_GROUPE_ASSURANCE_81, 
  v7_.ID_VEHICULE AS ID_VEHICULE_82, 
  v7_.cp_veh_lib1 AS CP_VEH_LIB1_83, 
  v7_.cp_veh_lib10 AS CP_VEH_LIB10_84, 
  v7_.cp_veh_bool2 AS CP_VEH_BOOL2_85, 
  v7_.cp_veh_bool3 AS CP_VEH_BOOL3_86, 
  v7_.cp_veh_bool4 AS CP_VEH_BOOL4_87, 
  v7_.cp_veh_qtte2 AS CP_VEH_QTTE2_88, 
  v7_.lib_cp_veh_ref5 AS LIB_CP_VEH_REF5_89, 
  v7_.lib_cp_veh_ref10 AS LIB_CP_VEH_REF10_90, 
  v7_.lib_cp_veh_liba1 AS LIB_CP_VEH_LIBA1_91, 
  v8_.ID_VEHICULE AS ID_VEHICULE_92, 
  v8_.ACTIVITE_HORAIRE_MAXIMALE AS ACTIVITE_HORAIRE_MAXIMALE_93, 
  v8_.DIMENSION_PNEU AS DIMENSION_PNEU_94, 
  v9_.ID_STATUTS_VEHICULE AS ID_STATUTS_VEHICULE_95, 
  v9_.ID_VEHICULE AS ID_VEHICULE_96, 
  v9_.LIB_STATUT_VEHIC_1 AS LIB_STATUT_VEHIC_1_97, 
  v10_.ID_AFFECTATION_VEHICULE AS ID_AFFECTATION_VEHICULE_98, 
  v10_.ID_VEHICULE_RATTACHEMENT AS ID_VEHICULE_RATTACHEMENT_99, 
  v10_.ID_VEHICULE_RATTACHE AS ID_VEHICULE_RATTACHE_100, 
  v10_.LIB_MARQUE AS LIB_MARQUE_101, 
  v10_.LIB_MODELE AS LIB_MODELE_102, 
  v10_.LIB_CATEGORIE_VEHICULE AS LIB_CATEGORIE_VEHICULE_103, 
  v10_.LIB_SOUSCATEGORIE_VEHICULE AS LIB_SOUSCATEGORIE_VEHICULE_104, 
  v11_.ID_VEHICULE AS ID_VEHICULE_105, 
  v11_.cp_veh_bool2 AS CP_VEH_BOOL2_106, 
  v11_.lib_cp_veh_ref3 AS LIB_CP_VEH_REF3_107, 
  v11_.cp_veh_lib2 AS CP_VEH_LIB2_108, 
  v11_.cp_veh_lib5 AS CP_VEH_LIB5_109, 
  v11_.cp_veh_qtte1 AS CP_VEH_QTTE1_110, 
  v11_.cp_veh_bool1 AS CP_VEH_BOOL1_111, 
  v11_.lib_cp_veh_ref4 AS LIB_CP_VEH_REF4_112, 
  v11_.lib_cp_veh_ref5 AS LIB_CP_VEH_REF5_113, 
  v11_.cp_veh_lib9 AS CP_VEH_LIB9_114, 
  v11_.cp_veh_qtte4 AS CP_VEH_QTTE4_115, 
  v11_.lib_cp_veh_ref6 AS LIB_CP_VEH_REF6_116, 
  v11_.cp_veh_qtte3 AS CP_VEH_QTTE3_117, 
  v11_.cp_veh_lib6 AS CP_VEH_LIB6_118, 
  v0_.ID_CERTIF_IMMAT AS ID_CERTIF_IMMAT_119, 
  v0_.ID_VEHICULE AS ID_VEHICULE_120, 
  v0_.ID_VEHICULE AS ID_VEHICULE_121, 
  v0_.ID_VEHICULE AS ID_VEHICULE_122, 
  v1_.ID_VEHICULE AS ID_VEHICULE_123, 
  v2_.ID_VEHICULE AS ID_VEHICULE_124, 
  v3_.ID_VEHICULE AS ID_VEHICULE_125, 
  v3_.ID_CARTE_ACCREDITIVE AS ID_CARTE_ACCREDITIVE_126, 
  v4_.ID_STATUTS_CARTE_ACCREDITIVE AS _STATUTS_CARTE_ACCREDITIVE_127, 
  v9_.ID_VEHICULE AS ID_VEHICULE_128, 
  v10_.ID_VEHICULE_RATTACHEMENT AS ID_VEHICULE_RATTACHEMENT_129, 
  v10_.ID_VEHICULE_RATTACHE AS ID_VEHICULE_RATTACHE_130 
FROM 
  V_VEHICULE_INFO v0_ 
  INNER JOIN V_VEHICULE_AFFECT_COURANTE v1_ ON v0_.ID_VEHICULE = v1_.ID_VEHICULE 
  LEFT JOIN V_CONTRAT_INFO v2_ ON v0_.ID_VEHICULE = v2_.ID_VEHICULE 
  LEFT JOIN V_CART_ACCR_ATTRIB_COURANTE v3_ ON v0_.ID_VEHICULE = v3_.ID_VEHICULE 
  LEFT JOIN V_CARTE_ACCREDITIVE_INFO v4_ ON v3_.ID_CARTE_ACCREDITIVE = v4_.ID_CARTE_ACCREDITIVE 
  INNER JOIN T_CERTIF_IMMAT t5_ ON v0_.ID_CERTIF_IMMAT = t5_.ID_CERTIF_IMMAT 
  LEFT JOIN V_VEHICULE_ASSURANCE v6_ ON v0_.ID_VEHICULE = v6_.ID_VEHICULE 
  LEFT JOIN V_VEHICULE_CAR_PERS v7_ ON v0_.ID_VEHICULE = v7_.ID_VEHICULE 
  LEFT JOIN V_VEHICULE_CAR_TECH v8_ ON v0_.ID_VEHICULE = v8_.ID_VEHICULE 
  INNER JOIN V_VEHICULE_STATUT_COURANT v9_ ON v0_.ID_VEHICULE = v9_.ID_VEHICULE 
  LEFT JOIN V_VEHIC_RATTACHES_A_VEHIC v10_ ON v0_.ID_VEHICULE = v10_.ID_VEHICULE_RATTACHEMENT 
  LEFT JOIN V_VEHICULE_CAR_PERS v11_ ON v10_.ID_VEHICULE_RATTACHE = v11_.ID_VEHICULE 
WHERE 
  v0_.ID_VEHICULE = 6526
Je suis preneur de tout conseil ou solution.... Peut etre que je loupe un truc mais la je ne vois pas.
J'ai essayer de voir si on pouvait via ORM forcer le AS généré mais je ne trouve pas.

D'avance merci de votre aide