Apows_sql

SELECT
  this_.COD_ANU                      AS COD_ANU1_80_153_,
  this_.COD_ETP                      AS COD_ETP2_80_153_,
  this_.COD_IND                      AS COD_IND3_80_153_,
  this_.COD_VRS_VET                  AS COD_VRS_VET4_80_153_,
  this_.NUM_OCC_IAE                  AS NUM_OCC_IAE5_80_153_,
  this_.COD_ETB_PI_1                 AS COD_ETB_PI_8_80_153_,
  this_.COD_ETB_PI_2                 AS COD_ETB_PI_9_80_153_,
  this_.COD_ETB_PI_3                 AS COD_ETB_PI_10_80_153_,
  this_.COD_ETB_PI_4                 AS COD_ETB_PI_11_80_153_,
  this_.TEM_PI_CII                   AS TEM_PI_CII6_80_153_,
  this_.TEM_VAE_CII                  AS TEM_VAE_CII7_80_153_,
  etablissem2_.COD_ETB               AS COD_ETB1_194_0_,
  etablissem2_.COD_AFF_DEP_ETB       AS COD_AFF_DEP_ETB2_194_0_,
  etablissem2_.COD_AFF_ETB           AS COD_AFF_ETB3_194_0_,
  etablissem2_.COD_ESU_ESE           AS COD_ESU_ESE4_194_0_,
  etablissem2_.COD_POS_ADR_ETB       AS COD_POS_ADR_ETB25_194_0_,
  etablissem2_.COD_COM_ADR_ETB       AS COD_COM_ADR_ETB26_194_0_,
  etablissem2_.COD_DEP               AS COD_DEP27_194_0_,
  etablissem2_.LIB_AD1_ETB           AS LIB_AD5_194_0_,
  etablissem2_.LIB_AD2_ETB           AS LIB_AD6_194_0_,
  etablissem2_.LIB_AD3_ETB           AS LIB_AD7_194_0_,
  etablissem2_.LIB_ADE_ETB           AS LIB_ADE_ETB8_194_0_,
  etablissem2_.LIB_ART_OFF_ETB       AS LIB_ART_OFF_ETB9_194_0_,
  etablissem2_.LIB_CMT_ETB           AS LIB_CMT_ETB10_194_0_,
  etablissem2_.LIB_ETB               AS LIB_ETB11_194_0_,
  etablissem2_.LIB_OFF_ETB           AS LIB_OFF_ETB12_194_0_,
  etablissem2_.LIB_WEB_ETB           AS LIB_WEB_ETB13_194_0_,
  etablissem2_.LIC_ETB               AS LIC_ETB14_194_0_,
  etablissem2_.LIM1_ETB              AS LIM15_194_0_,
  etablissem2_.LIM2_ETB              AS LIM16_194_0_,
  etablissem2_.LIM3_ETB              AS LIM17_194_0_,
  etablissem2_.NUM_ORD_ETB           AS NUM_ORD_ETB18_194_0_,
  etablissem2_.COD_PAY_ADR_ETB       AS COD_PAY_ADR_ETB28_194_0_,
  etablissem2_.COD_PRU_CHG           AS COD_PRU_CHG29_194_0_,
  etablissem2_.COD_PRU_PRL           AS COD_PRU_PRL30_194_0_,
  etablissem2_.COD_STE               AS COD_STE31_194_0_,
  etablissem2_.TEM_AUT_SIS_ETB       AS TEM_AUT_SIS_ETB19_194_0_,
  etablissem2_.TEM_CNV_ETB           AS TEM_CNV_ETB20_194_0_,
  etablissem2_.TEM_EN_SVE_ETB        AS TEM_EN_SVE_ETB21_194_0_,
  etablissem2_.TEM_MIN_ETB           AS TEM_MIN_ETB22_194_0_,
  etablissem2_.TEM_PRE_SIS_ETB       AS TEM_PRE_SIS_ETB23_194_0_,
  etablissem2_.TEM_PUB_ETB           AS TEM_PUB_ETB24_194_0_,
  etablissem2_.COD_TPE               AS COD_TPE32_194_0_,
  combdivo3_.COD_BDI                 AS COD_BDI1_110_1_,
  combdivo3_.COD_COM                 AS COD_COM2_110_1_,
  combdivo3_.COD_FIC_CBD             AS COD_FIC_CBD3_110_1_,
  combdivo3_.ETA_PTC_ACH             AS ETA_PTC_ACH4_110_1_,
  combdivo3_.ETA_PTC_LOC             AS ETA_PTC_LOC5_110_1_,
  combdivo3_.LIB_ACH                 AS LIB_ACH6_110_1_,
  combdivo3_.TEM_EN_SVE_CBD          AS TEM_EN_SVE_CBD7_110_1_,
  bureaudisv4_.COD_BDI               AS COD_BDI1_78_2_,
  bureaudisv4_.LIB_BDI               AS LIB_BDI2_78_2_,
  bureaudisv4_.TEM_EN_SVE_BDI        AS TEM_EN_SVE_BDI3_78_2_,
  communevo5_.COD_COM                AS COD_COM1_106_3_,
  communevo5_.COD_DEP                AS COD_DEP4_106_3_,
  communevo5_.LIB_COM                AS LIB_COM2_106_3_,
  communevo5_.TEM_EN_SVE_COM         AS TEM_EN_SVE_COM3_106_3_,
  departemen6_.COD_DEP               AS COD_DEP1_132_4_,
  departemen6_.COD_ACD               AS COD_ACD5_132_4_,
  departemen6_.LIB_DEP               AS LIB_DEP2_132_4_,
  departemen6_.LIC_DEP               AS LIC_DEP3_132_4_,
  departemen6_.TEM_EN_SVE_DEP        AS TEM_EN_SVE_DEP4_132_4_,
  academievo7_.COD_ACD               AS COD_ACD1_0_5_,
  academievo7_.COD_SIS_ACD           AS COD_SIS_ACD2_0_5_,
  academievo7_.LIB_ACD               AS LIB_ACD3_0_5_,
  academievo7_.LIC_ACD               AS LIC_ACD4_0_5_,
  academievo7_.TEM_EN_SVE_ACD        AS TEM_EN_SVE_ACD5_0_5_,
  communevo8_.COD_COM                AS COD_COM1_106_6_,
  communevo8_.COD_DEP                AS COD_DEP4_106_6_,
  communevo8_.LIB_COM                AS LIB_COM2_106_6_,
  communevo8_.TEM_EN_SVE_COM         AS TEM_EN_SVE_COM3_106_6_,
  departemen9_.COD_DEP               AS COD_DEP1_132_7_,
  departemen9_.COD_ACD               AS COD_ACD5_132_7_,
  departemen9_.LIB_DEP               AS LIB_DEP2_132_7_,
  departemen9_.LIC_DEP               AS LIC_DEP3_132_7_,
  departemen9_.TEM_EN_SVE_DEP        AS TEM_EN_SVE_DEP4_132_7_,
  paysvo10_.COD_PAY                  AS COD_PAY1_304_8_,
  paysvo10_.COD_PAY_SIS_NAT          AS COD_PAY_SIS_NAT2_304_8_,
  paysvo10_.COD_SIS_PAY              AS COD_SIS_PAY3_304_8_,
  paysvo10_.LIB_NAT                  AS LIB_NAT4_304_8_,
  paysvo10_.LIB_PAY                  AS LIB_PAY5_304_8_,
  paysvo10_.LIC_PAY                  AS LIC_PAY6_304_8_,
  paysvo10_.TEM_AFL_DEC_IND_PAY      AS TEM_AFL_DEC_IND_PA7_304_8_,
  paysvo10_.TEM_DEL                  AS TEM_DEL8_304_8_,
  paysvo10_.TEM_EN_SVE_PAY           AS TEM_EN_SVE_PAY9_304_8_,
  paysvo10_.TEM_OUV_DRT_SSO_PAY      AS TEM_OUV_DRT_SSO_P10_304_8_,
  profiletuv11_.COD_PRU              AS COD_PRU1_323_9_,
  profiletuv11_.LIB_PRU              AS LIB_PRU2_323_9_,
  profiletuv11_.LIB_WEB_PRU          AS LIB_WEB_PRU3_323_9_,
  profiletuv11_.LIC_PRU              AS LIC_PRU4_323_9_,
  profiletuv11_.LIM1_PRU             AS LIM5_323_9_,
  profiletuv11_.LIM2_PRU             AS LIM6_323_9_,
  profiletuv11_.LIM3_PRU             AS LIM7_323_9_,
  profiletuv11_.LIX_1_PRU            AS LIX_8_323_9_,
  profiletuv11_.LIX_2_PRU            AS LIX_9_323_9_,
  profiletuv11_.LIX_3_PRU            AS LIX_10_323_9_,
  profiletuv11_.LIX_4_PRU            AS LIX_11_323_9_,
  profiletuv11_.NUM_ORD_PRU          AS NUM_ORD_PRU12_323_9_,
  profiletuv11_.TEM_DEL              AS TEM_DEL13_323_9_,
  profiletuv11_.TEM_EN_SVE_PRU       AS TEM_EN_SVE_PRU14_323_9_,
  profiletuv11_.TEM_MIN_PRU          AS TEM_MIN_PRU15_323_9_,
  profiletuv11_.TEM_PAI_WEB          AS TEM_PAI_WEB16_323_9_,
  profiletuv11_.TEM_PEC_MIN_PRU      AS TEM_PEC_MIN_PRU17_323_9_,
  profiletuv11_.TEM_SPE_PRU          AS TEM_SPE_PRU18_323_9_,
  profiletuv11_.TEM_TYP_ETP_PRU      AS TEM_TYP_ETP_PRU19_323_9_,
  profiletuv12_.COD_PRU              AS COD_PRU1_323_10_,
  profiletuv12_.LIB_PRU              AS LIB_PRU2_323_10_,
  profiletuv12_.LIB_WEB_PRU          AS LIB_WEB_PRU3_323_10_,
  profiletuv12_.LIC_PRU              AS LIC_PRU4_323_10_,
  profiletuv12_.LIM1_PRU             AS LIM5_323_10_,
  profiletuv12_.LIM2_PRU             AS LIM6_323_10_,
  profiletuv12_.LIM3_PRU             AS LIM7_323_10_,
  profiletuv12_.LIX_1_PRU            AS LIX_8_323_10_,
  profiletuv12_.LIX_2_PRU            AS LIX_9_323_10_,
  profiletuv12_.LIX_3_PRU            AS LIX_10_323_10_,
  profiletuv12_.LIX_4_PRU            AS LIX_11_323_10_,
  profiletuv12_.NUM_ORD_PRU          AS NUM_ORD_PRU12_323_10_,
  profiletuv12_.TEM_DEL              AS TEM_DEL13_323_10_,
  profiletuv12_.TEM_EN_SVE_PRU       AS TEM_EN_SVE_PRU14_323_10_,
  profiletuv12_.TEM_MIN_PRU          AS TEM_MIN_PRU15_323_10_,
  profiletuv12_.TEM_PAI_WEB          AS TEM_PAI_WEB16_323_10_,
  profiletuv12_.TEM_PEC_MIN_PRU      AS TEM_PEC_MIN_PRU17_323_10_,
  profiletuv12_.TEM_SPE_PRU          AS TEM_SPE_PRU18_323_10_,
  profiletuv12_.TEM_TYP_ETP_PRU      AS TEM_TYP_ETP_PRU19_323_10_,
  statutetbv13_.COD_STE              AS COD_STE1_385_11_,
  statutetbv13_.LIB_STE              AS LIB_STE2_385_11_,
  statutetbv13_.LIC_STE              AS LIC_STE3_385_11_,
  statutetbv13_.TEM_EN_SVE_STE       AS TEM_EN_SVE_STE4_385_11_,
  typetbvo14_.COD_TPE                AS COD_TPE1_498_12_,
  typetbvo14_.COD_SIS_TPE            AS COD_SIS_TPE2_498_12_,
  typetbvo14_.LIB_TPE                AS LIB_TPE3_498_12_,
  typetbvo14_.LIB_WEB_TPE            AS LIB_WEB_TPE4_498_12_,
  typetbvo14_.LIC_TPE                AS LIC_TPE5_498_12_,
  typetbvo14_.LIM1_TPE               AS LIM6_498_12_,
  typetbvo14_.LIM2_TPE               AS LIM7_498_12_,
  typetbvo14_.LIM3_TPE               AS LIM8_498_12_,
  typetbvo14_.NUM_ORD_TPE            AS NUM_ORD_TPE9_498_12_,
  typetbvo14_.COD_PRU_CHG            AS COD_PRU_CHG15_498_12_,
  typetbvo14_.COD_PRU_PRL            AS COD_PRU_PRL16_498_12_,
  typetbvo14_.TEM_DET_TPE            AS TEM_DET_TPE10_498_12_,
  typetbvo14_.TEM_EN_SVE_TPE         AS TEM_EN_SVE_TPE11_498_12_,
  typetbvo14_.TEM_GES_TRF_TPE        AS TEM_GES_TRF_TPE12_498_12_,
  typetbvo14_.TEM_MIN_TPE            AS TEM_MIN_TPE13_498_12_,
  typetbvo14_.TEM_PROP_AUTRE_ETB     AS TEM_PROP_AUTRE_ET14_498_12_,
  profiletuv15_.COD_PRU              AS COD_PRU1_323_13_,
  profiletuv15_.LIB_PRU              AS LIB_PRU2_323_13_,
  profiletuv15_.LIB_WEB_PRU          AS LIB_WEB_PRU3_323_13_,
  profiletuv15_.LIC_PRU              AS LIC_PRU4_323_13_,
  profiletuv15_.LIM1_PRU             AS LIM5_323_13_,
  profiletuv15_.LIM2_PRU             AS LIM6_323_13_,
  profiletuv15_.LIM3_PRU             AS LIM7_323_13_,
  profiletuv15_.LIX_1_PRU            AS LIX_8_323_13_,
  profiletuv15_.LIX_2_PRU            AS LIX_9_323_13_,
  profiletuv15_.LIX_3_PRU            AS LIX_10_323_13_,
  profiletuv15_.LIX_4_PRU            AS LIX_11_323_13_,
  profiletuv15_.NUM_ORD_PRU          AS NUM_ORD_PRU12_323_13_,
  profiletuv15_.TEM_DEL              AS TEM_DEL13_323_13_,
  profiletuv15_.TEM_EN_SVE_PRU       AS TEM_EN_SVE_PRU14_323_13_,
  profiletuv15_.TEM_MIN_PRU          AS TEM_MIN_PRU15_323_13_,
  profiletuv15_.TEM_PAI_WEB          AS TEM_PAI_WEB16_323_13_,
  profiletuv15_.TEM_PEC_MIN_PRU      AS TEM_PEC_MIN_PRU17_323_13_,
  profiletuv15_.TEM_SPE_PRU          AS TEM_SPE_PRU18_323_13_,
  profiletuv15_.TEM_TYP_ETP_PRU      AS TEM_TYP_ETP_PRU19_323_13_,
  profiletuv16_.COD_PRU              AS COD_PRU1_323_14_,
  profiletuv16_.LIB_PRU              AS LIB_PRU2_323_14_,
  profiletuv16_.LIB_WEB_PRU          AS LIB_WEB_PRU3_323_14_,
  profiletuv16_.LIC_PRU              AS LIC_PRU4_323_14_,
  profiletuv16_.LIM1_PRU             AS LIM5_323_14_,
  profiletuv16_.LIM2_PRU             AS LIM6_323_14_,
  profiletuv16_.LIM3_PRU             AS LIM7_323_14_,
  profiletuv16_.LIX_1_PRU            AS LIX_8_323_14_,
  profiletuv16_.LIX_2_PRU            AS LIX_9_323_14_,
  profiletuv16_.LIX_3_PRU            AS LIX_10_323_14_,
  profiletuv16_.LIX_4_PRU            AS LIX_11_323_14_,
  profiletuv16_.NUM_ORD_PRU          AS NUM_ORD_PRU12_323_14_,
  profiletuv16_.TEM_DEL              AS TEM_DEL13_323_14_,
  profiletuv16_.TEM_EN_SVE_PRU       AS TEM_EN_SVE_PRU14_323_14_,
  profiletuv16_.TEM_MIN_PRU          AS TEM_MIN_PRU15_323_14_,
  profiletuv16_.TEM_PAI_WEB          AS TEM_PAI_WEB16_323_14_,
  profiletuv16_.TEM_PEC_MIN_PRU      AS TEM_PEC_MIN_PRU17_323_14_,
  profiletuv16_.TEM_SPE_PRU          AS TEM_SPE_PRU18_323_14_,
  profiletuv16_.TEM_TYP_ETP_PRU      AS TEM_TYP_ETP_PRU19_323_14_,
  etablissem17_.COD_ETB              AS COD_ETB1_194_15_,
  etablissem17_.COD_AFF_DEP_ETB      AS COD_AFF_DEP_ETB2_194_15_,
  etablissem17_.COD_AFF_ETB          AS COD_AFF_ETB3_194_15_,
  etablissem17_.COD_ESU_ESE          AS COD_ESU_ESE4_194_15_,
  etablissem17_.COD_POS_ADR_ETB      AS COD_POS_ADR_ETB25_194_15_,
  etablissem17_.COD_COM_ADR_ETB      AS COD_COM_ADR_ETB26_194_15_,
  etablissem17_.COD_DEP              AS COD_DEP27_194_15_,
  etablissem17_.LIB_AD1_ETB          AS LIB_AD5_194_15_,
  etablissem17_.LIB_AD2_ETB          AS LIB_AD6_194_15_,
  etablissem17_.LIB_AD3_ETB          AS LIB_AD7_194_15_,
  etablissem17_.LIB_ADE_ETB          AS LIB_ADE_ETB8_194_15_,
  etablissem17_.LIB_ART_OFF_ETB      AS LIB_ART_OFF_ETB9_194_15_,
  etablissem17_.LIB_CMT_ETB          AS LIB_CMT_ETB10_194_15_,
  etablissem17_.LIB_ETB              AS LIB_ETB11_194_15_,
  etablissem17_.LIB_OFF_ETB          AS LIB_OFF_ETB12_194_15_,
  etablissem17_.LIB_WEB_ETB          AS LIB_WEB_ETB13_194_15_,
  etablissem17_.LIC_ETB              AS LIC_ETB14_194_15_,
  etablissem17_.LIM1_ETB             AS LIM15_194_15_,
  etablissem17_.LIM2_ETB             AS LIM16_194_15_,
  etablissem17_.LIM3_ETB             AS LIM17_194_15_,
  etablissem17_.NUM_ORD_ETB          AS NUM_ORD_ETB18_194_15_,
  etablissem17_.COD_PAY_ADR_ETB      AS COD_PAY_ADR_ETB28_194_15_,
  etablissem17_.COD_PRU_CHG          AS COD_PRU_CHG29_194_15_,
  etablissem17_.COD_PRU_PRL          AS COD_PRU_PRL30_194_15_,
  etablissem17_.COD_STE              AS COD_STE31_194_15_,
  etablissem17_.TEM_AUT_SIS_ETB      AS TEM_AUT_SIS_ETB19_194_15_,
  etablissem17_.TEM_CNV_ETB          AS TEM_CNV_ETB20_194_15_,
  etablissem17_.TEM_EN_SVE_ETB       AS TEM_EN_SVE_ETB21_194_15_,
  etablissem17_.TEM_MIN_ETB          AS TEM_MIN_ETB22_194_15_,
  etablissem17_.TEM_PRE_SIS_ETB      AS TEM_PRE_SIS_ETB23_194_15_,
  etablissem17_.TEM_PUB_ETB          AS TEM_PUB_ETB24_194_15_,
  etablissem17_.COD_TPE              AS COD_TPE32_194_15_,
  etablissem18_.COD_ETB              AS COD_ETB1_194_16_,
  etablissem18_.COD_AFF_DEP_ETB      AS COD_AFF_DEP_ETB2_194_16_,
  etablissem18_.COD_AFF_ETB          AS COD_AFF_ETB3_194_16_,
  etablissem18_.COD_ESU_ESE          AS COD_ESU_ESE4_194_16_,
  etablissem18_.COD_POS_ADR_ETB      AS COD_POS_ADR_ETB25_194_16_,
  etablissem18_.COD_COM_ADR_ETB      AS COD_COM_ADR_ETB26_194_16_,
  etablissem18_.COD_DEP              AS COD_DEP27_194_16_,
  etablissem18_.LIB_AD1_ETB          AS LIB_AD5_194_16_,
  etablissem18_.LIB_AD2_ETB          AS LIB_AD6_194_16_,
  etablissem18_.LIB_AD3_ETB          AS LIB_AD7_194_16_,
  etablissem18_.LIB_ADE_ETB          AS LIB_ADE_ETB8_194_16_,
  etablissem18_.LIB_ART_OFF_ETB      AS LIB_ART_OFF_ETB9_194_16_,
  etablissem18_.LIB_CMT_ETB          AS LIB_CMT_ETB10_194_16_,
  etablissem18_.LIB_ETB              AS LIB_ETB11_194_16_,
  etablissem18_.LIB_OFF_ETB          AS LIB_OFF_ETB12_194_16_,
  etablissem18_.LIB_WEB_ETB          AS LIB_WEB_ETB13_194_16_,
  etablissem18_.LIC_ETB              AS LIC_ETB14_194_16_,
  etablissem18_.LIM1_ETB             AS LIM15_194_16_,
  etablissem18_.LIM2_ETB             AS LIM16_194_16_,
  etablissem18_.LIM3_ETB             AS LIM17_194_16_,
  etablissem18_.NUM_ORD_ETB          AS NUM_ORD_ETB18_194_16_,
  etablissem18_.COD_PAY_ADR_ETB      AS COD_PAY_ADR_ETB28_194_16_,
  etablissem18_.COD_PRU_CHG          AS COD_PRU_CHG29_194_16_,
  etablissem18_.COD_PRU_PRL          AS COD_PRU_PRL30_194_16_,
  etablissem18_.COD_STE              AS COD_STE31_194_16_,
  etablissem18_.TEM_AUT_SIS_ETB      AS TEM_AUT_SIS_ETB19_194_16_,
  etablissem18_.TEM_CNV_ETB          AS TEM_CNV_ETB20_194_16_,
  etablissem18_.TEM_EN_SVE_ETB       AS TEM_EN_SVE_ETB21_194_16_,
  etablissem18_.TEM_MIN_ETB          AS TEM_MIN_ETB22_194_16_,
  etablissem18_.TEM_PRE_SIS_ETB      AS TEM_PRE_SIS_ETB23_194_16_,
  etablissem18_.TEM_PUB_ETB          AS TEM_PUB_ETB24_194_16_,
  etablissem18_.COD_TPE              AS COD_TPE32_194_16_,
  etablissem19_.COD_ETB              AS COD_ETB1_194_17_,
  etablissem19_.COD_AFF_DEP_ETB      AS COD_AFF_DEP_ETB2_194_17_,
  etablissem19_.COD_AFF_ETB          AS COD_AFF_ETB3_194_17_,
  etablissem19_.COD_ESU_ESE          AS COD_ESU_ESE4_194_17_,
  etablissem19_.COD_POS_ADR_ETB      AS COD_POS_ADR_ETB25_194_17_,
  etablissem19_.COD_COM_ADR_ETB      AS COD_COM_ADR_ETB26_194_17_,
  etablissem19_.COD_DEP              AS COD_DEP27_194_17_,
  etablissem19_.LIB_AD1_ETB          AS LIB_AD5_194_17_,
  etablissem19_.LIB_AD2_ETB          AS LIB_AD6_194_17_,
  etablissem19_.LIB_AD3_ETB          AS LIB_AD7_194_17_,
  etablissem19_.LIB_ADE_ETB          AS LIB_ADE_ETB8_194_17_,
  etablissem19_.LIB_ART_OFF_ETB      AS LIB_ART_OFF_ETB9_194_17_,
  etablissem19_.LIB_CMT_ETB          AS LIB_CMT_ETB10_194_17_,
  etablissem19_.LIB_ETB              AS LIB_ETB11_194_17_,
  etablissem19_.LIB_OFF_ETB          AS LIB_OFF_ETB12_194_17_,
  etablissem19_.LIB_WEB_ETB          AS LIB_WEB_ETB13_194_17_,
  etablissem19_.LIC_ETB              AS LIC_ETB14_194_17_,
  etablissem19_.LIM1_ETB             AS LIM15_194_17_,
  etablissem19_.LIM2_ETB             AS LIM16_194_17_,
  etablissem19_.LIM3_ETB             AS LIM17_194_17_,
  etablissem19_.NUM_ORD_ETB          AS NUM_ORD_ETB18_194_17_,
  etablissem19_.COD_PAY_ADR_ETB      AS COD_PAY_ADR_ETB28_194_17_,
  etablissem19_.COD_PRU_CHG          AS COD_PRU_CHG29_194_17_,
  etablissem19_.COD_PRU_PRL          AS COD_PRU_PRL30_194_17_,
  etablissem19_.COD_STE              AS COD_STE31_194_17_,
  etablissem19_.TEM_AUT_SIS_ETB      AS TEM_AUT_SIS_ETB19_194_17_,
  etablissem19_.TEM_CNV_ETB          AS TEM_CNV_ETB20_194_17_,
  etablissem19_.TEM_EN_SVE_ETB       AS TEM_EN_SVE_ETB21_194_17_,
  etablissem19_.TEM_MIN_ETB          AS TEM_MIN_ETB22_194_17_,
  etablissem19_.TEM_PRE_SIS_ETB      AS TEM_PRE_SIS_ETB23_194_17_,
  etablissem19_.TEM_PUB_ETB          AS TEM_PUB_ETB24_194_17_,
  etablissem19_.COD_TPE              AS COD_TPE32_194_17_,
  insadmetpv20_.COD_ANU              AS COD_ANU1_250_18_,
  insadmetpv20_.COD_ETP              AS COD_ETP2_250_18_,
  insadmetpv20_.COD_IND              AS COD_IND3_250_18_,
  insadmetpv20_.COD_VRS_VET          AS COD_VRS_VET4_250_18_,
  insadmetpv20_.NUM_OCC_IAE          AS NUM_OCC_IAE5_250_18_,
  insadmetpv20_.COD_BRS              AS COD_BRS37_250_18_,
  insadmetpv20_.COD_CGE              AS COD_CGE38_250_18_,
  insadmetpv20_.COD_ANU_ACC_IAE      AS COD_ANU_ACC_IAE6_250_18_,
  insadmetpv20_.COD_DEP_PAY_ACC      AS COD_DEP_PAY_ACC7_250_18_,
  insadmetpv20_.COD_DFM              AS COD_DFM8_250_18_,
  insadmetpv20_.COD_ETB_ACC_IAE      AS COD_ETB_ACC_IAE9_250_18_,
  insadmetpv20_.COD_NAT_TIT_ACC_IAE  AS COD_NAT_TIT_ACC_I10_250_18_,
  insadmetpv20_.COD_SES_IAE          AS COD_SES_IAE11_250_18_,
  insadmetpv20_.COD_TPE_ACC_IAE      AS COD_TPE_ACC_IAE12_250_18_,
  insadmetpv20_.COD_TYP_DEP_PAY_ACC  AS COD_TYP_DEP_PAY_A13_250_18_,
  insadmetpv20_.COD_CMP              AS COD_CMP39_250_18_,
  insadmetpv20_.COD_CNV              AS COD_CNV40_250_18_,
  insadmetpv20_.DAT_ACC_IAE          AS DAT_ACC_IAE14_250_18_,
  insadmetpv20_.DAT_ANNUL_RES_IAE    AS DAT_ANNUL_RES_IAE15_250_18_,
  insadmetpv20_.DAT_CRE_IAE          AS DAT_CRE_IAE16_250_18_,
  insadmetpv20_.DAT_MOD_IAE          AS DAT_MOD_IAE17_250_18_,
  insadmetpv20_.DAT_OBS_SIS_IAE      AS DAT_OBS_SIS_IAE18_250_18_,
  insadmetpv20_.COD_DAC_ACC          AS COD_DAC_ACC41_250_18_,
  insadmetpv20_.COD_EDO_IAE          AS COD_EDO_IAE42_250_18_,
  insadmetpv20_.ETA_IAE              AS ETA_IAE19_250_18_,
  insadmetpv20_.ETA_PMT_IAE          AS ETA_PMT_IAE20_250_18_,
  insadmetpv20_.COD_ETB_IFM_1        AS COD_ETB_IFM_43_250_18_,
  insadmetpv20_.COD_ETB_IFM_2        AS COD_ETB_IFM_44_250_18_,
  insadmetpv20_.LIB_REF_ACC          AS LIB_REF_ACC21_250_18_,
  insadmetpv20_.NBR_CRD_VDI_INS      AS NBR_CRD_VDI_INS22_250_18_,
  insadmetpv20_.NBR_INS_CYC          AS NBR_INS_CYC23_250_18_,
  insadmetpv20_.NBR_INS_DIP          AS NBR_INS_DIP24_250_18_,
  insadmetpv20_.NBR_INS_ETP          AS NBR_INS_ETP25_250_18_,
  insadmetpv20_.NUM_BRS_ETU          AS NUM_BRS_ETU26_250_18_,
  insadmetpv20_.COD_PRU              AS COD_PRU45_250_18_,
  insadmetpv20_.COD_RGE              AS COD_RGE46_250_18_,
  insadmetpv20_.COD_TLS              AS COD_TLS47_250_18_,
  insadmetpv20_.TEM_CHG_SUR_ETP      AS TEM_CHG_SUR_ETP27_250_18_,
  insadmetpv20_.TEM_CUR_AMG          AS TEM_CUR_AMG28_250_18_,
  insadmetpv20_.TEM_DIP_IAE          AS TEM_DIP_IAE29_250_18_,
  insadmetpv20_.TEM_IAE_PRM          AS TEM_IAE_PRM30_250_18_,
  insadmetpv20_.TEM_INS_ELP_ATMQ_IAE AS TEM_INS_ELP_ATMQ_31_250_18_,
  insadmetpv20_.TEM_ORI_INS          AS TEM_ORI_INS32_250_18_,
  insadmetpv20_.TEM_PREXAM           AS TEM_PREXAM33_250_18_,
  insadmetpv20_.TEM_TLS_IAE          AS TEM_TLS_IAE34_250_18_,
  insadmetpv20_.COD_TYP_CPG          AS COD_TYP_CPG48_250_18_,
  insadmetpv20_.COD_UTI              AS COD_UTI49_250_18_,
  insadmetpv20_.COD_UTI_ACC          AS COD_UTI_ACC50_250_18_,
  insadmetpv20_.COD_UTI_MOD          AS COD_UTI_MOD51_250_18_,
  insadmetpv20_.COD_DIP              AS COD_DIP52_250_18_,
  insadmetpv20_.COD_VRS_VDI          AS COD_VRS_VDI53_250_18_,
  insadmetpv20_.COD_DIP_ACC          AS COD_DIP_ACC54_250_18_,
  insadmetpv20_.COD_VRS_VDI_ACC      AS COD_VRS_VDI_ACC55_250_18_,
  insadmetpv20_.ZBL_ETB_1            AS ZBL_ETB_35_250_18_,
  insadmetpv20_.ZBL_ETB_2            AS ZBL_ETB_36_250_18_,
  (
    SELECT
      TO_CHAR(NVL(vc.dat_val_cer, vds.dat_val_vds))
    FROM
      v_dat_certif vc
    LEFT JOIN v_dat_dip_san vds
    ON
      vds.cod_ind       = vc.cod_ind
    AND vds.cod_anu     = vc.cod_anu
    AND vds.cod_dip     = vc.cod_dip
    AND vds.cod_vrs_vdi = vc.cod_vrs_vdi
    WHERE
      vc.cod_ind       = insadmetpv20_.COD_IND
    AND vc.cod_dip     = insadmetpv20_.COD_DIP
    AND vc.cod_vrs_vdi = insadmetpv20_.COD_VRS_VDI
    AND vc.cod_anu     = insadmetpv20_.COD_ANU
  )                                     AS formula9_18_,
  boursevo21_.COD_BRS                   AS COD_BRS1_77_19_,
  boursevo21_.COD_SIS_AFI_BRS           AS COD_SIS_AFI_BRS2_77_19_,
  boursevo21_.LIB_WEB_BRS               AS LIB_WEB_BRS3_77_19_,
  boursevo21_.LIB_BRS                   AS LIB_BRS4_77_19_,
  boursevo21_.LIC_BRS                   AS LIC_BRS5_77_19_,
  boursevo21_.LIM1_BRS                  AS LIM6_77_19_,
  boursevo21_.LIM2_BRS                  AS LIM7_77_19_,
  boursevo21_.LIM3_BRS                  AS LIM8_77_19_,
  boursevo21_.NUM_ORD_BRS               AS NUM_ORD_BRS9_77_19_,
  boursevo21_.COD_SOC                   AS COD_SOC15_77_19_,
  boursevo21_.TEM_BRS_COND              AS TEM_BRS_COND10_77_19_,
  boursevo21_.TEM_EN_SVE_BRS            AS TEM_EN_SVE_BRS11_77_19_,
  boursevo21_.TEM_MIN_BRS               AS TEM_MIN_BRS12_77_19_,
  boursevo21_.TEM_PAI_WEB               AS TEM_PAI_WEB13_77_19_,
  boursevo21_.TEM_SAI_NUM_BRS           AS TEM_SAI_NUM_BRS14_77_19_,
  sitsociale22_.COD_SOC                 AS COD_SOC1_376_20_,
  sitsociale22_.LIB_SOC                 AS LIB_SOC2_376_20_,
  sitsociale22_.LIB_WEB_SOC             AS LIB_WEB_SOC3_376_20_,
  sitsociale22_.LIC_SOC                 AS LIC_SOC4_376_20_,
  sitsociale22_.LIM1_SOC                AS LIM5_376_20_,
  sitsociale22_.LIM2_SOC                AS LIM6_376_20_,
  sitsociale22_.LIM3_SOC                AS LIM7_376_20_,
  sitsociale22_.LIX_1_SOC               AS LIX_8_376_20_,
  sitsociale22_.LIX_2_SOC               AS LIX_9_376_20_,
  sitsociale22_.LIX_3_SOC               AS LIX_10_376_20_,
  sitsociale22_.LIX_4_SOC               AS LIX_11_376_20_,
  sitsociale22_.NUM_ORD_SOC             AS NUM_ORD_SOC12_376_20_,
  sitsociale22_.TEM_DEL                 AS TEM_DEL13_376_20_,
  sitsociale22_.TEM_EN_SVE_SOC          AS TEM_EN_SVE_SOC14_376_20_,
  sitsociale22_.TEM_MIN_SOC             AS TEM_MIN_SOC15_376_20_,
  sitsociale22_.TEM_PAI_WEB             AS TEM_PAI_WEB16_376_20_,
  sitsociale22_.TEM_PEC_MIN_SOC         AS TEM_PEC_MIN_SOC17_376_20_,
  centregest23_.COD_CGE                 AS COD_CGE1_84_21_,
  centregest23_.COD_MOD_PAI_MIN_CGE     AS COD_MOD_PAI_MIN_CG2_84_21_,
  centregest23_.COD_MOD_PAI_MINP_CGE    AS COD_MOD_PAI_MINP_C3_84_21_,
  centregest23_.COD_POS_ADR_CGE         AS COD_POS_ADR_CGE33_84_21_,
  centregest23_.COD_COM_ADR_CGE         AS COD_COM_ADR_CGE34_84_21_,
  centregest23_.COD_CPA                 AS COD_CPA35_84_21_,
  centregest23_.DAT_DEB_INS_CGE         AS DAT_DEB_INS_CGE4_84_21_,
  centregest23_.DAT_FIN_INS_CGE         AS DAT_FIN_INS_CGE5_84_21_,
  centregest23_.ETA_TYP_EDT_CRT_CGE     AS ETA_TYP_EDT_CRT_CG6_84_21_,
  centregest23_.LIB_AD1_CGE             AS LIB_AD7_84_21_,
  centregest23_.LIB_AD2_CGE             AS LIB_AD8_84_21_,
  centregest23_.LIB_AD3_CGE             AS LIB_AD9_84_21_,
  centregest23_.LIB_CGE                 AS LIB_CGE10_84_21_,
  centregest23_.LIB_CMT_CGE             AS LIB_CMT_CGE11_84_21_,
  centregest23_.LIB_CMT_PCJ_MIN_CGE     AS LIB_CMT_PCJ_MIN_C12_84_21_,
  centregest23_.LIB_CMT_PCJ_MINP_CGE    AS LIB_CMT_PCJ_MINP_13_84_21_,
  centregest23_.LIB_NOM_RESP_CGE        AS LIB_NOM_RESP_CGE14_84_21_,
  centregest23_.LIC_CGE                 AS LIC_CGE15_84_21_,
  centregest23_.MOD_EDT_CRT             AS MOD_EDT_CRT16_84_21_,
  centregest23_.NBR_ETU_CPT             AS NBR_ETU_CPT17_84_21_,
  centregest23_.NBR_MAX_INS_AUT         AS NBR_MAX_INS_AUT18_84_21_,
  centregest23_.NUM_CHR_QUT_CGE         AS NUM_CHR_QUT_CGE19_84_21_,
  centregest23_.NUM_OCC_PRM_QUT_VAL     AS NUM_OCC_PRM_QUT_V20_84_21_,
  centregest23_.NUM_OCC_QUT_EDT         AS NUM_OCC_QUT_EDT21_84_21_,
  centregest23_.NUM_OCC_QUT_EDT_LCH     AS NUM_OCC_QUT_EDT_L22_84_21_,
  centregest23_.NUM_OCC_QUT_EDT_VDR     AS NUM_OCC_QUT_EDT_V23_84_21_,
  centregest23_.NUM_OCC_QUT_VAL         AS NUM_OCC_QUT_VAL24_84_21_,
  centregest23_.TEM_CTRL_PAI            AS TEM_CTRL_PAI25_84_21_,
  centregest23_.TEM_CTRL_RMB            AS TEM_CTRL_RMB26_84_21_,
  centregest23_.TEM_EN_SVE_CGE          AS TEM_EN_SVE_CGE27_84_21_,
  centregest23_.TEM_MIN_CGE             AS TEM_MIN_CGE28_84_21_,
  centregest23_.TEM_MIN_DEMAT_CGE       AS TEM_MIN_DEMAT_CGE29_84_21_,
  centregest23_.TEM_MINP_DEMAT_CGE      AS TEM_MINP_DEMAT_CG30_84_21_,
  centregest23_.TEM_PAI_MEME_POS        AS TEM_PAI_MEME_POS31_84_21_,
  centregest23_.TEM_PMT_3F_CGE_WEB      AS TEM_PMT_32_84_21_,
  combdivo24_.COD_BDI                   AS COD_BDI1_110_22_,
  combdivo24_.COD_COM                   AS COD_COM2_110_22_,
  combdivo24_.COD_FIC_CBD               AS COD_FIC_CBD3_110_22_,
  combdivo24_.ETA_PTC_ACH               AS ETA_PTC_ACH4_110_22_,
  combdivo24_.ETA_PTC_LOC               AS ETA_PTC_LOC5_110_22_,
  combdivo24_.LIB_ACH                   AS LIB_ACH6_110_22_,
  combdivo24_.TEM_EN_SVE_CBD            AS TEM_EN_SVE_CBD7_110_22_,
  cpamvo25_.COD_CPA                     AS COD_CPA1_119_23_,
  cpamvo25_.COD_CPA_TRM_CPA             AS COD_CPA_TRM_CPA2_119_23_,
  cpamvo25_.COD_POS_ADR_CPA             AS COD_POS_ADR_CPA10_119_23_,
  cpamvo25_.COD_COM_ADR_CPA             AS COD_COM_ADR_CPA11_119_23_,
  cpamvo25_.LIB_AD1_CPA                 AS LIB_AD3_119_23_,
  cpamvo25_.LIB_AD2_CPA                 AS LIB_AD4_119_23_,
  cpamvo25_.LIB_AD3_CPA                 AS LIB_AD5_119_23_,
  cpamvo25_.LIB_CPA                     AS LIB_CPA6_119_23_,
  cpamvo25_.LIC_CPA                     AS LIC_CPA7_119_23_,
  cpamvo25_.NUM_BRD_TRM_SSO_CPA         AS NUM_BRD_TRM_SSO_CP8_119_23_,
  cpamvo25_.TEM_EN_SVE_CPA              AS TEM_EN_SVE_CPA9_119_23_,
  combdivo26_.COD_BDI                   AS COD_BDI1_110_24_,
  combdivo26_.COD_COM                   AS COD_COM2_110_24_,
  combdivo26_.COD_FIC_CBD               AS COD_FIC_CBD3_110_24_,
  combdivo26_.ETA_PTC_ACH               AS ETA_PTC_ACH4_110_24_,
  combdivo26_.ETA_PTC_LOC               AS ETA_PTC_LOC5_110_24_,
  combdivo26_.LIB_ACH                   AS LIB_ACH6_110_24_,
  combdivo26_.TEM_EN_SVE_CBD            AS TEM_EN_SVE_CBD7_110_24_,
  composante27_.COD_CMP                 AS COD_CMP1_107_25_,
  composante27_.COD_NAT_CMP             AS COD_NAT_CMP2_107_25_,
  composante27_.COD_RNE_CMP             AS COD_RNE_CMP3_107_25_,
  composante27_.COD_POS_ADR_CMP         AS COD_POS_ADR_CMP21_107_25_,
  composante27_.COD_COM_ADR_CMP         AS COD_COM_ADR_CMP22_107_25_,
  composante27_.INT_1_EDI_DIP_CMP       AS INT_4_107_25_,
  composante27_.INT_2_EDI_DIP_CMP       AS INT_5_107_25_,
  composante27_.LIB_AD1_CMP             AS LIB_AD6_107_25_,
  composante27_.LIB_AD2_CMP             AS LIB_AD7_107_25_,
  composante27_.LIB_AD3_CMP             AS LIB_AD8_107_25_,
  composante27_.LIB_WEB_CMP             AS LIB_WEB_CMP9_107_25_,
  composante27_.LIB_CMP                 AS LIB_CMP10_107_25_,
  composante27_.LIB_CMT_CMP             AS LIB_CMT_CMP11_107_25_,
  composante27_.LIC_CMP                 AS LIC_CMP12_107_25_,
  composante27_.LIM1_CMP                AS LIM13_107_25_,
  composante27_.LIM2_CMP                AS LIM14_107_25_,
  composante27_.LIM3_CMP                AS LIM15_107_25_,
  composante27_.NUM_ORD_CMP             AS NUM_ORD_CMP16_107_25_,
  composante27_.COD_SIG                 AS COD_SIG23_107_25_,
  composante27_.TEM_COU_ACC_TRV_CMP     AS TEM_COU_ACC_TRV_C17_107_25_,
  composante27_.TEM_ELC_CMP             AS TEM_ELC_CMP18_107_25_,
  composante27_.TEM_EN_SVE_CMP          AS TEM_EN_SVE_CMP19_107_25_,
  composante27_.TEM_MIN_CMP             AS TEM_MIN_CMP20_107_25_,
  composante27_.COD_TPC                 AS COD_TPC24_107_25_,
  combdivo28_.COD_BDI                   AS COD_BDI1_110_26_,
  combdivo28_.COD_COM                   AS COD_COM2_110_26_,
  combdivo28_.COD_FIC_CBD               AS COD_FIC_CBD3_110_26_,
  combdivo28_.ETA_PTC_ACH               AS ETA_PTC_ACH4_110_26_,
  combdivo28_.ETA_PTC_LOC               AS ETA_PTC_LOC5_110_26_,
  combdivo28_.LIB_ACH                   AS LIB_ACH6_110_26_,
  combdivo28_.TEM_EN_SVE_CBD            AS TEM_EN_SVE_CBD7_110_26_,
  signataire29_.COD_SIG                 AS COD_SIG1_367_27_,
  signataire29_.NOM_SIG                 AS NOM_SIG2_367_27_,
  signataire29_.QUA_SIG                 AS QUA_SIG3_367_27_,
  signataire29_.TEM_EN_SVE_SIG          AS TEM_EN_SVE_SIG4_367_27_,
  typcomposa30_.COD_TPC                 AS COD_TPC1_489_28_,
  typcomposa30_.LIB_TPC                 AS LIB_TPC2_489_28_,
  typcomposa30_.COD_SIS                 AS COD_SIS4_489_28_,
  typcomposa30_.TEM_EN_SVE_TPC          AS TEM_EN_SVE_TPC3_489_28_,
  situations31_.COD_SIS                 AS COD_SIS1_372_29_,
  situations31_.LIB_SIS                 AS LIB_SIS2_372_29_,
  situations31_.LIB_WEB_SIS             AS LIB_WEB_SIS3_372_29_,
  situations31_.LIC_SIS                 AS LIC_SIS4_372_29_,
  situations31_.LIM1_SIS                AS LIM5_372_29_,
  situations31_.LIM2_SIS                AS LIM6_372_29_,
  situations31_.LIM3_SIS                AS LIM7_372_29_,
  situations31_.NUM_ORD_SIS             AS NUM_ORD_SIS8_372_29_,
  situations31_.TEM_ACC_ETA_SIS         AS TEM_ACC_ETA_SIS9_372_29_,
  situations31_.TEM_ACC_LIE_SIS         AS TEM_ACC_LIE_SIS10_372_29_,
  situations31_.TEM_ANN_PRM_INS_SIS     AS TEM_ANN_PRM_INS_S11_372_29_,
  situations31_.TEM_EN_SVE_SIS          AS TEM_EN_SVE_SIS12_372_29_,
  situations31_.TEM_MIN_SIS             AS TEM_MIN_SIS13_372_29_,
  dipautcurv32_.COD_DAC                 AS COD_DAC1_138_30_,
  dipautcurv32_.COD_SIS_DAC             AS COD_SIS_DAC2_138_30_,
  dipautcurv32_.LIB_DAC                 AS LIB_DAC3_138_30_,
  dipautcurv32_.LIB_WEB_DAC             AS LIB_WEB_DAC4_138_30_,
  dipautcurv32_.LIC_DAC                 AS LIC_DAC5_138_30_,
  dipautcurv32_.NUM_ORD_DAC             AS NUM_ORD_DAC6_138_30_,
  dipautcurv32_.TEM_EN_SVE_DAC          AS TEM_EN_SVE_DAC7_138_30_,
  dipautcurv32_.TEM_MIN_DAC             AS TEM_MIN_DAC8_138_30_,
  ecoledocto33_.COD_EDO                 AS COD_EDO1_156_31_,
  ecoledocto33_.COD_NAT_EDO             AS COD_NAT_EDO2_156_31_,
  ecoledocto33_.LIB_EDO                 AS LIB_EDO3_156_31_,
  ecoledocto33_.LIB_WEB_EDO             AS LIB_WEB_EDO4_156_31_,
  ecoledocto33_.LIC_EDO                 AS LIC_EDO5_156_31_,
  ecoledocto33_.NUM_ORD_EDO             AS NUM_ORD_EDO6_156_31_,
  ecoledocto33_.TEM_EN_SVE_EDO          AS TEM_EN_SVE_EDO7_156_31_,
  ecoledocto33_.TEM_MIN_EDO             AS TEM_MIN_EDO8_156_31_,
  ecoledocto33_.TEM_PAI_WEB             AS TEM_PAI_WEB9_156_31_,
  etablissem34_.COD_ETB                 AS COD_ETB1_194_32_,
  etablissem34_.COD_AFF_DEP_ETB         AS COD_AFF_DEP_ETB2_194_32_,
  etablissem34_.COD_AFF_ETB             AS COD_AFF_ETB3_194_32_,
  etablissem34_.COD_ESU_ESE             AS COD_ESU_ESE4_194_32_,
  etablissem34_.COD_POS_ADR_ETB         AS COD_POS_ADR_ETB25_194_32_,
  etablissem34_.COD_COM_ADR_ETB         AS COD_COM_ADR_ETB26_194_32_,
  etablissem34_.COD_DEP                 AS COD_DEP27_194_32_,
  etablissem34_.LIB_AD1_ETB             AS LIB_AD5_194_32_,
  etablissem34_.LIB_AD2_ETB             AS LIB_AD6_194_32_,
  etablissem34_.LIB_AD3_ETB             AS LIB_AD7_194_32_,
  etablissem34_.LIB_ADE_ETB             AS LIB_ADE_ETB8_194_32_,
  etablissem34_.LIB_ART_OFF_ETB         AS LIB_ART_OFF_ETB9_194_32_,
  etablissem34_.LIB_CMT_ETB             AS LIB_CMT_ETB10_194_32_,
  etablissem34_.LIB_ETB                 AS LIB_ETB11_194_32_,
  etablissem34_.LIB_OFF_ETB             AS LIB_OFF_ETB12_194_32_,
  etablissem34_.LIB_WEB_ETB             AS LIB_WEB_ETB13_194_32_,
  etablissem34_.LIC_ETB                 AS LIC_ETB14_194_32_,
  etablissem34_.LIM1_ETB                AS LIM15_194_32_,
  etablissem34_.LIM2_ETB                AS LIM16_194_32_,
  etablissem34_.LIM3_ETB                AS LIM17_194_32_,
  etablissem34_.NUM_ORD_ETB             AS NUM_ORD_ETB18_194_32_,
  etablissem34_.COD_PAY_ADR_ETB         AS COD_PAY_ADR_ETB28_194_32_,
  etablissem34_.COD_PRU_CHG             AS COD_PRU_CHG29_194_32_,
  etablissem34_.COD_PRU_PRL             AS COD_PRU_PRL30_194_32_,
  etablissem34_.COD_STE                 AS COD_STE31_194_32_,
  etablissem34_.TEM_AUT_SIS_ETB         AS TEM_AUT_SIS_ETB19_194_32_,
  etablissem34_.TEM_CNV_ETB             AS TEM_CNV_ETB20_194_32_,
  etablissem34_.TEM_EN_SVE_ETB          AS TEM_EN_SVE_ETB21_194_32_,
  etablissem34_.TEM_MIN_ETB             AS TEM_MIN_ETB22_194_32_,
  etablissem34_.TEM_PRE_SIS_ETB         AS TEM_PRE_SIS_ETB23_194_32_,
  etablissem34_.TEM_PUB_ETB             AS TEM_PUB_ETB24_194_32_,
  etablissem34_.COD_TPE                 AS COD_TPE32_194_32_,
  etablissem35_.COD_ETB                 AS COD_ETB1_194_33_,
  etablissem35_.COD_AFF_DEP_ETB         AS COD_AFF_DEP_ETB2_194_33_,
  etablissem35_.COD_AFF_ETB             AS COD_AFF_ETB3_194_33_,
  etablissem35_.COD_ESU_ESE             AS COD_ESU_ESE4_194_33_,
  etablissem35_.COD_POS_ADR_ETB         AS COD_POS_ADR_ETB25_194_33_,
  etablissem35_.COD_COM_ADR_ETB         AS COD_COM_ADR_ETB26_194_33_,
  etablissem35_.COD_DEP                 AS COD_DEP27_194_33_,
  etablissem35_.LIB_AD1_ETB             AS LIB_AD5_194_33_,
  etablissem35_.LIB_AD2_ETB             AS LIB_AD6_194_33_,
  etablissem35_.LIB_AD3_ETB             AS LIB_AD7_194_33_,
  etablissem35_.LIB_ADE_ETB             AS LIB_ADE_ETB8_194_33_,
  etablissem35_.LIB_ART_OFF_ETB         AS LIB_ART_OFF_ETB9_194_33_,
  etablissem35_.LIB_CMT_ETB             AS LIB_CMT_ETB10_194_33_,
  etablissem35_.LIB_ETB                 AS LIB_ETB11_194_33_,
  etablissem35_.LIB_OFF_ETB             AS LIB_OFF_ETB12_194_33_,
  etablissem35_.LIB_WEB_ETB             AS LIB_WEB_ETB13_194_33_,
  etablissem35_.LIC_ETB                 AS LIC_ETB14_194_33_,
  etablissem35_.LIM1_ETB                AS LIM15_194_33_,
  etablissem35_.LIM2_ETB                AS LIM16_194_33_,
  etablissem35_.LIM3_ETB                AS LIM17_194_33_,
  etablissem35_.NUM_ORD_ETB             AS NUM_ORD_ETB18_194_33_,
  etablissem35_.COD_PAY_ADR_ETB         AS COD_PAY_ADR_ETB28_194_33_,
  etablissem35_.COD_PRU_CHG             AS COD_PRU_CHG29_194_33_,
  etablissem35_.COD_PRU_PRL             AS COD_PRU_PRL30_194_33_,
  etablissem35_.COD_STE                 AS COD_STE31_194_33_,
  etablissem35_.TEM_AUT_SIS_ETB         AS TEM_AUT_SIS_ETB19_194_33_,
  etablissem35_.TEM_CNV_ETB             AS TEM_CNV_ETB20_194_33_,
  etablissem35_.TEM_EN_SVE_ETB          AS TEM_EN_SVE_ETB21_194_33_,
  etablissem35_.TEM_MIN_ETB             AS TEM_MIN_ETB22_194_33_,
  etablissem35_.TEM_PRE_SIS_ETB         AS TEM_PRE_SIS_ETB23_194_33_,
  etablissem35_.TEM_PUB_ETB             AS TEM_PUB_ETB24_194_33_,
  etablissem35_.COD_TPE                 AS COD_TPE32_194_33_,
  insadmanuv36_.COD_ANU                 AS COD_ANU1_249_34_,
  insadmanuv36_.COD_IND                 AS COD_IND2_249_34_,
  insadmanuv36_.COD_AFI                 AS COD_AFI32_249_34_,
  insadmanuv36_.COD_ASR                 AS COD_ASR33_249_34_,
  insadmanuv36_.COD_PCS_ETUDIANT        AS COD_PCS_ETUDIANT34_249_34_,
  insadmanuv36_.COD_PCS_PARENT          AS COD_PCS_PARENT35_249_34_,
  insadmanuv36_.COD_PCS_PARENT_AUTRE    AS COD_PCS_PARENT_AU36_249_34_,
  insadmanuv36_.COD_CTP                 AS COD_CTP37_249_34_,
  insadmanuv36_.COD_DEP_PAY_DER_DPL     AS COD_DEP_PAY_DER_DP3_249_34_,
  insadmanuv36_.COD_PAY_ANN_PRE         AS COD_PAY_ANN_PRE4_249_34_,
  insadmanuv36_.COD_PAY_ANT             AS COD_PAY_ANT5_249_34_,
  insadmanuv36_.COD_PAYS_PRG            AS COD_PAYS_PRG6_249_34_,
  insadmanuv36_.COD_PRL_CHG             AS COD_PRL_CHG7_249_34_,
  insadmanuv36_.COD_RGP_IAA             AS COD_RGP_IAA8_249_34_,
  insadmanuv36_.COD_TPT                 AS COD_TPT9_249_34_,
  insadmanuv36_.COD_TYP_DEP_PAY_DER_DPL AS COD_TYP_DEP_PAY_D10_249_34_,
  insadmanuv36_.COD_CPA                 AS COD_CPA38_249_34_,
  insadmanuv36_.DAA_ETB_ANT_IAA         AS DAA_ETB_ANT_IAA11_249_34_,
  insadmanuv36_.DAA_ETB_DER_DPL         AS DAA_ETB_DER_DPL12_249_34_,
  insadmanuv36_.DAT_AFL_SSO             AS DAT_AFL_SSO13_249_34_,
  insadmanuv36_.DAT_ANNUL_RES_IAA       AS DAT_ANNUL_RES_IAA14_249_34_,
  insadmanuv36_.DAT_CRE_IAA             AS DAT_CRE_IAA15_249_34_,
  insadmanuv36_.DAT_EDT_CRT             AS DAT_EDT_CRT16_249_34_,
  insadmanuv36_.DAT_MOD_IAA             AS DAT_MOD_IAA17_249_34_,
  insadmanuv36_.DAT_PMT_COT_SSO         AS DAT_PMT_COT_SSO18_249_34_,
  insadmanuv36_.DAT_TRM_SSO             AS DAT_TRM_SSO19_249_34_,
  insadmanuv36_.COD_DEP_ANN_PRE         AS COD_DEP_ANN_PRE39_249_34_,
  insadmanuv36_.COD_DEP_ANT             AS COD_DEP_ANT40_249_34_,
  insadmanuv36_.COD_DAP                 AS COD_DAP41_249_34_,
  insadmanuv36_.COD_DRT_MUT             AS COD_DRT_MUT42_249_34_,
  insadmanuv36_.ETA_EDT_CRT             AS ETA_EDT_CRT20_249_34_,
  insadmanuv36_.ETA_IAA                 AS ETA_IAA21_249_34_,
  insadmanuv36_.COD_ETB_ANN_PRE         AS COD_ETB_ANN_PRE43_249_34_,
  insadmanuv36_.COD_ETB_ANT             AS COD_ETB_ANT44_249_34_,
  insadmanuv36_.COD_ETB_DER_DPL         AS COD_ETB_DER_DPL45_249_34_,
  insadmanuv36_.COD_ETB_PRL_CHG         AS COD_ETB_PRL_CHG46_249_34_,
  insadmanuv36_.COD_ETB_TPT             AS COD_ETB_TPT47_249_34_,
  insadmanuv36_.COD_ETR                 AS COD_ETR48_249_34_,
  insadmanuv36_.LIB_MTF_DOS_IAA_INC     AS LIB_MTF_DOS_IAA_I22_249_34_,
  insadmanuv36_.COD_MFS                 AS COD_MFS49_249_34_,
  insadmanuv36_.COD_MNS                 AS COD_MNS50_249_34_,
  insadmanuv36_.NUM_BRD_TRM_SSO_IAA     AS NUM_BRD_TRM_SSO_I23_249_34_,
  insadmanuv36_.COD_PRG                 AS COD_PRG51_249_34_,
  insadmanuv36_.TEM_SNS_PRG             AS TEM_SNS_PRG52_249_34_,
  insadmanuv36_.COD_PRU                 AS COD_PRU53_249_34_,
  insadmanuv36_.COD_QTR                 AS COD_QTR54_249_34_,
  insadmanuv36_.COD_RGI                 AS COD_RGI55_249_34_,
  insadmanuv36_.COD_RSS                 AS COD_RSS56_249_34_,
  insadmanuv36_.COD_SOC                 AS COD_SOC57_249_34_,
  insadmanuv36_.COD_SIS_ANN_PRE         AS COD_SIS_ANN_PRE58_249_34_,
  insadmanuv36_.COD_SPO                 AS COD_SPO59_249_34_,
  insadmanuv36_.COD_STU                 AS COD_STU60_249_34_,
  insadmanuv36_.TEM_AFL_SSO             AS TEM_AFL_SSO24_249_34_,
  insadmanuv36_.TEM_BRS_IAA             AS TEM_BRS_IAA25_249_34_,
  insadmanuv36_.TEM_DOS_IAA_INC         AS TEM_DOS_IAA_INC26_249_34_,
  insadmanuv36_.TEM_ETB_IAA_1           AS TEM_ETB_IAA_27_249_34_,
  insadmanuv36_.TEM_ETB_IAA_2           AS TEM_ETB_IAA_28_249_34_,
  insadmanuv36_.TEM_PMT_3F              AS TEM_PMT_29_249_34_,
  insadmanuv36_.TEM_RGM_AMG_ETU_IAA     AS TEM_RGM_AMG_ETU_I30_249_34_,
  insadmanuv36_.TEM_TRM_SSO_IAA         AS TEM_TRM_SSO_IAA31_249_34_,
  insadmanuv36_.COD_TDE_DER_DPL         AS COD_TDE_DER_DPL61_249_34_,
  insadmanuv36_.COD_TDS_ANN_PRE         AS COD_TDS_ANN_PRE62_249_34_,
  insadmanuv36_.COD_TPE_ANT             AS COD_TPE_ANT63_249_34_,
  insadmanuv36_.COD_TPE_PRL_CHG         AS COD_TPE_PRL_CHG64_249_34_,
  insadmanuv36_.COD_UTI                 AS COD_UTI65_249_34_,
  insadmanuv36_.COD_UTI_MOD             AS COD_UTI_MOD66_249_34_,
  aidefinanc37_.COD_AFI                 AS COD_AFI1_17_35_,
  aidefinanc37_.COD_SIS_AFI_AFI         AS COD_SIS_AFI_AFI2_17_35_,
  aidefinanc37_.LIB_AFI                 AS LIB_AFI3_17_35_,
  aidefinanc37_.LIB_WEB_AFI             AS LIB_WEB_AFI4_17_35_,
  aidefinanc37_.LIC_AFI                 AS LIC_AFI5_17_35_,
  aidefinanc37_.LIM1_AFI                AS LIM6_17_35_,
  aidefinanc37_.LIM2_AFI                AS LIM7_17_35_,
  aidefinanc37_.LIM3_AFI                AS LIM8_17_35_,
  aidefinanc37_.NUM_ORD_AFI             AS NUM_ORD_AFI9_17_35_,
  aidefinanc37_.TEM_COU_AUT_REG_AFI     AS TEM_COU_AUT_REG_A10_17_35_,
  aidefinanc37_.TEM_EN_SVE_AFI          AS TEM_EN_SVE_AFI11_17_35_,
  aidefinanc37_.TEM_MIN_AFI             AS TEM_MIN_AFI12_17_35_,
  aidefinanc37_.TEM_THS_AFI             AS TEM_THS_AFI13_17_35_,
  anneeunivo38_.COD_ANU                 AS COD_ANU1_18_36_,
  anneeunivo38_.DAT_FRM_OPI             AS DAT_FRM_OPI2_18_36_,
  anneeunivo38_.DAT_OUV_OPI             AS DAT_OUV_OPI3_18_36_,
  anneeunivo38_.ETA_ANU_AGL             AS ETA_ANU_AGL4_18_36_,
  anneeunivo38_.ETA_ANU_APB             AS ETA_ANU_APB5_18_36_,
  anneeunivo38_.ETA_ANU_IAE             AS ETA_ANU_IAE6_18_36_,
  anneeunivo38_.ETA_ANU_IPE             AS ETA_ANU_IPE7_18_36_,
  anneeunivo38_.ETA_ANU_RES             AS ETA_ANU_RES8_18_36_,
  anneeunivo38_.LIB_ANU                 AS LIB_ANU9_18_36_,
  anneeunivo38_.LIC_ANU                 AS LIC_ANU10_18_36_,
  anneeunivo38_.NUM_OCC_OBT_ADD         AS NUM_OCC_OBT_ADD11_18_36_,
  anneeunivo38_.NUM_OCC_OBT_CER         AS NUM_OCC_OBT_CER12_18_36_,
  anneeunivo38_.NUM_OCC_OBT_VDI         AS NUM_OCC_OBT_VDI13_18_36_,
  anneeunivo38_.NUM_OCC_OBT_VDI_UNI     AS NUM_OCC_OBT_VDI_U14_18_36_,
  assrspcivv39_.COD_ASR                 AS COD_ASR1_42_37_,
  assrspcivv39_.LIB_ASR                 AS LIB_ASR2_42_37_,
  assrspcivv39_.LIB_WEB_ASR             AS LIB_WEB_ASR3_42_37_,
  assrspcivv39_.LIC_ASR                 AS LIC_ASR4_42_37_,
  assrspcivv39_.LIM1_ASR                AS LIM5_42_37_,
  assrspcivv39_.LIM2_ASR                AS LIM6_42_37_,
  assrspcivv39_.LIM3_ASR                AS LIM7_42_37_,
  assrspcivv39_.NUM_ORD_ASR             AS NUM_ORD_ASR8_42_37_,
  assrspcivv39_.TEM_EN_SVE_ASR          AS TEM_EN_SVE_ASR9_42_37_,
  assrspcivv39_.TEM_MIN_ASR             AS TEM_MIN_ASR10_42_37_,
  assrspcivv39_.TEM_MUT_ASR             AS TEM_MUT_ASR11_42_37_,
  catsocpflv40_.COD_PCS                 AS COD_PCS1_83_38_,
  catsocpflv40_.COD_SIS_PCS             AS COD_SIS_PCS2_83_38_,
  catsocpflv40_.LIB_PCS                 AS LIB_PCS3_83_38_,
  catsocpflv40_.LIB_WEB_PCS             AS LIB_WEB_PCS4_83_38_,
  catsocpflv40_.LIC_PCS                 AS LIC_PCS5_83_38_,
  catsocpflv40_.LIM1_PCS                AS LIM6_83_38_,
  catsocpflv40_.LIM2_PCS                AS LIM7_83_38_,
  catsocpflv40_.LIM3_PCS                AS LIM8_83_38_,
  catsocpflv40_.NUM_ORD_PCS             AS NUM_ORD_PCS9_83_38_,
  catsocpflv40_.TEM_DEL                 AS TEM_DEL10_83_38_,
  catsocpflv40_.TEM_EN_SVE_PCS          AS TEM_EN_SVE_PCS11_83_38_,
  catsocpflv40_.TEM_MIN_PCS             AS TEM_MIN_PCS12_83_38_,
  catsocpflv40_.TEM_SAI_QTR             AS TEM_SAI_QTR13_83_38_,
  catsocpflv41_.COD_PCS                 AS COD_PCS1_83_39_,
  catsocpflv41_.COD_SIS_PCS             AS COD_SIS_PCS2_83_39_,
  catsocpflv41_.LIB_PCS                 AS LIB_PCS3_83_39_,
  catsocpflv41_.LIB_WEB_PCS             AS LIB_WEB_PCS4_83_39_,
  catsocpflv41_.LIC_PCS                 AS LIC_PCS5_83_39_,
  catsocpflv41_.LIM1_PCS                AS LIM6_83_39_,
  catsocpflv41_.LIM2_PCS                AS LIM7_83_39_,
  catsocpflv41_.LIM3_PCS                AS LIM8_83_39_,
  catsocpflv41_.NUM_ORD_PCS             AS NUM_ORD_PCS9_83_39_,
  catsocpflv41_.TEM_DEL                 AS TEM_DEL10_83_39_,
  catsocpflv41_.TEM_EN_SVE_PCS          AS TEM_EN_SVE_PCS11_83_39_,
  catsocpflv41_.TEM_MIN_PCS             AS TEM_MIN_PCS12_83_39_,
  catsocpflv41_.TEM_SAI_QTR             AS TEM_SAI_QTR13_83_39_,
  catsocpflv42_.COD_PCS                 AS COD_PCS1_83_40_,
  catsocpflv42_.COD_SIS_PCS             AS COD_SIS_PCS2_83_40_,
  catsocpflv42_.LIB_PCS                 AS LIB_PCS3_83_40_,
  catsocpflv42_.LIB_WEB_PCS             AS LIB_WEB_PCS4_83_40_,
  catsocpflv42_.LIC_PCS                 AS LIC_PCS5_83_40_,
  catsocpflv42_.LIM1_PCS                AS LIM6_83_40_,
  catsocpflv42_.LIM2_PCS                AS LIM7_83_40_,
  catsocpflv42_.LIM3_PCS                AS LIM8_83_40_,
  catsocpflv42_.NUM_ORD_PCS             AS NUM_ORD_PCS9_83_40_,
  catsocpflv42_.TEM_DEL                 AS TEM_DEL10_83_40_,
  catsocpflv42_.TEM_EN_SVE_PCS          AS TEM_EN_SVE_PCS11_83_40_,
  catsocpflv42_.TEM_MIN_PCS             AS TEM_MIN_PCS12_83_40_,
  catsocpflv42_.TEM_SAI_QTR             AS TEM_SAI_QTR13_83_40_,
  centrepaye43_.COD_CTP                 AS COD_CTP1_88_41_,
  centrepaye43_.COD_TRM_SSO_CTP         AS COD_TRM_SSO_CTP2_88_41_,
  centrepaye43_.COD_POS_ADR_CTP         AS COD_POS_ADR_CTP15_88_41_,
  centrepaye43_.COD_COM_ADR_CTP         AS COD_COM_ADR_CTP16_88_41_,
  centrepaye43_.LIB_AD1_CTP             AS LIB_AD3_88_41_,
  centrepaye43_.LIB_AD2_CTP             AS LIB_AD4_88_41_,
  centrepaye43_.LIB_AD3_CTP             AS LIB_AD5_88_41_,
  centrepaye43_.LIB_CTP                 AS LIB_CTP6_88_41_,
  centrepaye43_.LIB_WEB_CTP             AS LIB_WEB_CTP7_88_41_,
  centrepaye43_.LIC_CTP                 AS LIC_CTP8_88_41_,
  centrepaye43_.LIM1_CTP                AS LIM9_88_41_,
  centrepaye43_.LIM2_CTP                AS LIM10_88_41_,
  centrepaye43_.LIM3_CTP                AS LIM11_88_41_,
  centrepaye43_.COD_MUT                 AS COD_MUT17_88_41_,
  centrepaye43_.NUM_ORD_CTP             AS NUM_ORD_CTP12_88_41_,
  centrepaye43_.TEM_EN_SVE_CTP          AS TEM_EN_SVE_CTP13_88_41_,
  centrepaye43_.TEM_MIN_CTP             AS TEM_MIN_CTP14_88_41_,
  combdivo44_.COD_BDI                   AS COD_BDI1_110_42_,
  combdivo44_.COD_COM                   AS COD_COM2_110_42_,
  combdivo44_.COD_FIC_CBD               AS COD_FIC_CBD3_110_42_,
  combdivo44_.ETA_PTC_ACH               AS ETA_PTC_ACH4_110_42_,
  combdivo44_.ETA_PTC_LOC               AS ETA_PTC_LOC5_110_42_,
  combdivo44_.LIB_ACH                   AS LIB_ACH6_110_42_,
  combdivo44_.TEM_EN_SVE_CBD            AS TEM_EN_SVE_CBD7_110_42_,
  mutuellevo45_.COD_MUT                 AS COD_MUT1_283_43_,
  mutuellevo45_.COD_POS_ADR_MUT         AS COD_POS_ADR_MUT14_283_43_,
  mutuellevo45_.COD_COM_ADR_MUT         AS COD_COM_ADR_MUT15_283_43_,
  mutuellevo45_.LIB_AD1_MUT             AS LIB_AD2_283_43_,
  mutuellevo45_.LIB_AD2_MUT             AS LIB_AD3_283_43_,
  mutuellevo45_.LIB_AD3_MUT             AS LIB_AD4_283_43_,
  mutuellevo45_.LIB_NOM_MUT             AS LIB_NOM_MUT5_283_43_,
  mutuellevo45_.LIB_WEB_MUT             AS LIB_WEB_MUT6_283_43_,
  mutuellevo45_.LIM1_MUT                AS LIM7_283_43_,
  mutuellevo45_.LIM2_MUT                AS LIM8_283_43_,
  mutuellevo45_.LIM3_MUT                AS LIM9_283_43_,
  mutuellevo45_.NUM_BRD_TRM_SSO_MUT     AS NUM_BRD_TRM_SSO_M10_283_43_,
  mutuellevo45_.NUM_ORD_MUT             AS NUM_ORD_MUT11_283_43_,
  mutuellevo45_.TEM_EN_SVE_MUT          AS TEM_EN_SVE_MUT12_283_43_,
  mutuellevo45_.TEM_MIN_MUT             AS TEM_MIN_MUT13_283_43_,
  combdivo46_.COD_BDI                   AS COD_BDI1_110_44_,
  combdivo46_.COD_COM                   AS COD_COM2_110_44_,
  combdivo46_.COD_FIC_CBD               AS COD_FIC_CBD3_110_44_,
  combdivo46_.ETA_PTC_ACH               AS ETA_PTC_ACH4_110_44_,
  combdivo46_.ETA_PTC_LOC               AS ETA_PTC_LOC5_110_44_,
  combdivo46_.LIB_ACH                   AS LIB_ACH6_110_44_,
  combdivo46_.TEM_EN_SVE_CBD            AS TEM_EN_SVE_CBD7_110_44_,
  cpamvo47_.COD_CPA                     AS COD_CPA1_119_45_,
  cpamvo47_.COD_CPA_TRM_CPA             AS COD_CPA_TRM_CPA2_119_45_,
  cpamvo47_.COD_POS_ADR_CPA             AS COD_POS_ADR_CPA10_119_45_,
  cpamvo47_.COD_COM_ADR_CPA             AS COD_COM_ADR_CPA11_119_45_,
  cpamvo47_.LIB_AD1_CPA                 AS LIB_AD3_119_45_,
  cpamvo47_.LIB_AD2_CPA                 AS LIB_AD4_119_45_,
  cpamvo47_.LIB_AD3_CPA                 AS LIB_AD5_119_45_,
  cpamvo47_.LIB_CPA                     AS LIB_CPA6_119_45_,
  cpamvo47_.LIC_CPA                     AS LIC_CPA7_119_45_,
  cpamvo47_.NUM_BRD_TRM_SSO_CPA         AS NUM_BRD_TRM_SSO_CP8_119_45_,
  cpamvo47_.TEM_EN_SVE_CPA              AS TEM_EN_SVE_CPA9_119_45_,
  departemen48_.COD_DEP                 AS COD_DEP1_132_46_,
  departemen48_.COD_ACD                 AS COD_ACD5_132_46_,
  departemen48_.LIB_DEP                 AS LIB_DEP2_132_46_,
  departemen48_.LIC_DEP                 AS LIC_DEP3_132_46_,
  departemen48_.TEM_EN_SVE_DEP          AS TEM_EN_SVE_DEP4_132_46_,
  departemen49_.COD_DEP                 AS COD_DEP1_132_47_,
  departemen49_.COD_ACD                 AS COD_ACD5_132_47_,
  departemen49_.LIB_DEP                 AS LIB_DEP2_132_47_,
  departemen49_.LIC_DEP                 AS LIC_DEP3_132_47_,
  departemen49_.TEM_EN_SVE_DEP          AS TEM_EN_SVE_DEP4_132_47_,
  domaineact50_.COD_DAP                 AS COD_DAP1_144_48_,
  domaineact50_.COD_SIS_DAP_1           AS COD_SIS_DAP_2_144_48_,
  domaineact50_.LIB_DAP                 AS LIB_DAP3_144_48_,
  domaineact50_.LIB_WEB_DAP             AS LIB_WEB_DAP4_144_48_,
  domaineact50_.LIC_DAP                 AS LIC_DAP5_144_48_,
  domaineact50_.LIM1_DAP                AS LIM6_144_48_,
  domaineact50_.LIM2_DAP                AS LIM7_144_48_,
  domaineact50_.LIM3_DAP                AS LIM8_144_48_,
  domaineact50_.NUM_ORD_DAP             AS NUM_ORD_DAP9_144_48_,
  domaineact50_.TEM_EN_SVE_DAP          AS TEM_EN_SVE_DAP10_144_48_,
  domaineact50_.TEM_MIN_DAP             AS TEM_MIN_DAP11_144_48_,
  droitvo51_.COD_DRT                    AS COD_DRT1_147_49_,
  droitvo51_.LIB_DRT                    AS LIB_DRT2_147_49_,
  droitvo51_.LIB_WEB_DRT                AS LIB_WEB_DRT3_147_49_,
  droitvo51_.LIC_DRT                    AS LIC_DRT4_147_49_,
  droitvo51_.LIM1_DRT                   AS LIM5_147_49_,
  droitvo51_.LIM2_DRT                   AS LIM6_147_49_,
  droitvo51_.MNT_DRT                    AS MNT_DRT7_147_49_,
  droitvo51_.COD_MUT                    AS COD_MUT12_147_49_,
  droitvo51_.COD_NRG                    AS COD_NRG13_147_49_,
  droitvo51_.NUM_ORD_DRT                AS NUM_ORD_DRT8_147_49_,
  droitvo51_.TEM_EN_SVE_DRT             AS TEM_EN_SVE_DRT9_147_49_,
  droitvo51_.TEM_MIN_DRT                AS TEM_MIN_DRT10_147_49_,
  droitvo51_.TEM_RMB_ETB                AS TEM_RMB_ETB11_147_49_,
  droitvo51_.COD_TDR                    AS COD_TDR14_147_49_,
  mutuellevo52_.COD_MUT                 AS COD_MUT1_283_50_,
  mutuellevo52_.COD_POS_ADR_MUT         AS COD_POS_ADR_MUT14_283_50_,
  mutuellevo52_.COD_COM_ADR_MUT         AS COD_COM_ADR_MUT15_283_50_,
  mutuellevo52_.LIB_AD1_MUT             AS LIB_AD2_283_50_,
  mutuellevo52_.LIB_AD2_MUT             AS LIB_AD3_283_50_,
  mutuellevo52_.LIB_AD3_MUT             AS LIB_AD4_283_50_,
  mutuellevo52_.LIB_NOM_MUT             AS LIB_NOM_MUT5_283_50_,
  mutuellevo52_.LIB_WEB_MUT             AS LIB_WEB_MUT6_283_50_,
  mutuellevo52_.LIM1_MUT                AS LIM7_283_50_,
  mutuellevo52_.LIM2_MUT                AS LIM8_283_50_,
  mutuellevo52_.LIM3_MUT                AS LIM9_283_50_,
  mutuellevo52_.NUM_BRD_TRM_SSO_MUT     AS NUM_BRD_TRM_SSO_M10_283_50_,
  mutuellevo52_.NUM_ORD_MUT             AS NUM_ORD_MUT11_283_50_,
  mutuellevo52_.TEM_EN_SVE_MUT          AS TEM_EN_SVE_MUT12_283_50_,
  mutuellevo52_.TEM_MIN_MUT             AS TEM_MIN_MUT13_283_50_,
  nivregroup53_.COD_NRG                 AS COD_NRG1_290_51_,
  nivregroup53_.LIB_NRG                 AS LIB_NRG2_290_51_,
  nivregroup53_.LIB_WEB_NRG             AS LIB_WEB_NRG3_290_51_,
  nivregroup53_.LIC_NRG                 AS LIC_NRG4_290_51_,
  nivregroup53_.LIM1_NRG                AS LIM5_290_51_,
  nivregroup53_.LIM2_NRG                AS LIM6_290_51_,
  nivregroup53_.NUM_ORD_NRG             AS NUM_ORD_NRG7_290_51_,
  nivregroup53_.TEM_EN_SVE_NRG          AS TEM_EN_SVE_NRG8_290_51_,
  typdroitvo54_.COD_TDR                 AS COD_TDR1_495_52_,
  typdroitvo54_.LIB_TDR                 AS LIB_TDR2_495_52_,
  typdroitvo54_.LIC_TDR                 AS LIC_TDR3_495_52_,
  typdroitvo54_.TEM_DEL                 AS TEM_DEL4_495_52_,
  typdroitvo54_.TEM_EN_SVE_TDR          AS TEM_EN_SVE_TDR5_495_52_,
  etablissem55_.COD_ETB                 AS COD_ETB1_194_53_,
  etablissem55_.COD_AFF_DEP_ETB         AS COD_AFF_DEP_ETB2_194_53_,
  etablissem55_.COD_AFF_ETB             AS COD_AFF_ETB3_194_53_,
  etablissem55_.COD_ESU_ESE             AS COD_ESU_ESE4_194_53_,
  etablissem55_.COD_POS_ADR_ETB         AS COD_POS_ADR_ETB25_194_53_,
  etablissem55_.COD_COM_ADR_ETB         AS COD_COM_ADR_ETB26_194_53_,
  etablissem55_.COD_DEP                 AS COD_DEP27_194_53_,
  etablissem55_.LIB_AD1_ETB             AS LIB_AD5_194_53_,
  etablissem55_.LIB_AD2_ETB             AS LIB_AD6_194_53_,
  etablissem55_.LIB_AD3_ETB             AS LIB_AD7_194_53_,
  etablissem55_.LIB_ADE_ETB             AS LIB_ADE_ETB8_194_53_,
  etablissem55_.LIB_ART_OFF_ETB         AS LIB_ART_OFF_ETB9_194_53_,
  etablissem55_.LIB_CMT_ETB             AS LIB_CMT_ETB10_194_53_,
  etablissem55_.LIB_ETB                 AS LIB_ETB11_194_53_,
  etablissem55_.LIB_OFF_ETB             AS LIB_OFF_ETB12_194_53_,
  etablissem55_.LIB_WEB_ETB             AS LIB_WEB_ETB13_194_53_,
  etablissem55_.LIC_ETB                 AS LIC_ETB14_194_53_,
  etablissem55_.LIM1_ETB                AS LIM15_194_53_,
  etablissem55_.LIM2_ETB                AS LIM16_194_53_,
  etablissem55_.LIM3_ETB                AS LIM17_194_53_,
  etablissem55_.NUM_ORD_ETB             AS NUM_ORD_ETB18_194_53_,
  etablissem55_.COD_PAY_ADR_ETB         AS COD_PAY_ADR_ETB28_194_53_,
  etablissem55_.COD_PRU_CHG             AS COD_PRU_CHG29_194_53_,
  etablissem55_.COD_PRU_PRL             AS COD_PRU_PRL30_194_53_,
  etablissem55_.COD_STE                 AS COD_STE31_194_53_,
  etablissem55_.TEM_AUT_SIS_ETB         AS TEM_AUT_SIS_ETB19_194_53_,
  etablissem55_.TEM_CNV_ETB             AS TEM_CNV_ETB20_194_53_,
  etablissem55_.TEM_EN_SVE_ETB          AS TEM_EN_SVE_ETB21_194_53_,
  etablissem55_.TEM_MIN_ETB             AS TEM_MIN_ETB22_194_53_,
  etablissem55_.TEM_PRE_SIS_ETB         AS TEM_PRE_SIS_ETB23_194_53_,
  etablissem55_.TEM_PUB_ETB             AS TEM_PUB_ETB24_194_53_,
  etablissem55_.COD_TPE                 AS COD_TPE32_194_53_,
  etablissem56_.COD_ETB                 AS COD_ETB1_194_54_,
  etablissem56_.COD_AFF_DEP_ETB         AS COD_AFF_DEP_ETB2_194_54_,
  etablissem56_.COD_AFF_ETB             AS COD_AFF_ETB3_194_54_,
  etablissem56_.COD_ESU_ESE             AS COD_ESU_ESE4_194_54_,
  etablissem56_.COD_POS_ADR_ETB         AS COD_POS_ADR_ETB25_194_54_,
  etablissem56_.COD_COM_ADR_ETB         AS COD_COM_ADR_ETB26_194_54_,
  etablissem56_.COD_DEP                 AS COD_DEP27_194_54_,
  etablissem56_.LIB_AD1_ETB             AS LIB_AD5_194_54_,
  etablissem56_.LIB_AD2_ETB             AS LIB_AD6_194_54_,
  etablissem56_.LIB_AD3_ETB             AS LIB_AD7_194_54_,
  etablissem56_.LIB_ADE_ETB             AS LIB_ADE_ETB8_194_54_,
  etablissem56_.LIB_ART_OFF_ETB         AS LIB_ART_OFF_ETB9_194_54_,
  etablissem56_.LIB_CMT_ETB             AS LIB_CMT_ETB10_194_54_,
  etablissem56_.LIB_ETB                 AS LIB_ETB11_194_54_,
  etablissem56_.LIB_OFF_ETB             AS LIB_OFF_ETB12_194_54_,
  etablissem56_.LIB_WEB_ETB             AS LIB_WEB_ETB13_194_54_,
  etablissem56_.LIC_ETB                 AS LIC_ETB14_194_54_,
  etablissem56_.LIM1_ETB                AS LIM15_194_54_,
  etablissem56_.LIM2_ETB                AS LIM16_194_54_,
  etablissem56_.LIM3_ETB                AS LIM17_194_54_,
  etablissem56_.NUM_ORD_ETB             AS NUM_ORD_ETB18_194_54_,
  etablissem56_.COD_PAY_ADR_ETB         AS COD_PAY_ADR_ETB28_194_54_,
  etablissem56_.COD_PRU_CHG             AS COD_PRU_CHG29_194_54_,
  etablissem56_.COD_PRU_PRL             AS COD_PRU_PRL30_194_54_,
  etablissem56_.COD_STE                 AS COD_STE31_194_54_,
  etablissem56_.TEM_AUT_SIS_ETB         AS TEM_AUT_SIS_ETB19_194_54_,
  etablissem56_.TEM_CNV_ETB             AS TEM_CNV_ETB20_194_54_,
  etablissem56_.TEM_EN_SVE_ETB          AS TEM_EN_SVE_ETB21_194_54_,
  etablissem56_.TEM_MIN_ETB             AS TEM_MIN_ETB22_194_54_,
  etablissem56_.TEM_PRE_SIS_ETB         AS TEM_PRE_SIS_ETB23_194_54_,
  etablissem56_.TEM_PUB_ETB             AS TEM_PUB_ETB24_194_54_,
  etablissem56_.COD_TPE                 AS COD_TPE32_194_54_,
  etablissem57_.COD_ETB                 AS COD_ETB1_194_55_,
  etablissem57_.COD_AFF_DEP_ETB         AS COD_AFF_DEP_ETB2_194_55_,
  etablissem57_.COD_AFF_ETB             AS COD_AFF_ETB3_194_55_,
  etablissem57_.COD_ESU_ESE             AS COD_ESU_ESE4_194_55_,
  etablissem57_.COD_POS_ADR_ETB         AS COD_POS_ADR_ETB25_194_55_,
  etablissem57_.COD_COM_ADR_ETB         AS COD_COM_ADR_ETB26_194_55_,
  etablissem57_.COD_DEP                 AS COD_DEP27_194_55_,
  etablissem57_.LIB_AD1_ETB             AS LIB_AD5_194_55_,
  etablissem57_.LIB_AD2_ETB             AS LIB_AD6_194_55_,
  etablissem57_.LIB_AD3_ETB             AS LIB_AD7_194_55_,
  etablissem57_.LIB_ADE_ETB             AS LIB_ADE_ETB8_194_55_,
  etablissem57_.LIB_ART_OFF_ETB         AS LIB_ART_OFF_ETB9_194_55_,
  etablissem57_.LIB_CMT_ETB             AS LIB_CMT_ETB10_194_55_,
  etablissem57_.LIB_ETB                 AS LIB_ETB11_194_55_,
  etablissem57_.LIB_OFF_ETB             AS LIB_OFF_ETB12_194_55_,
  etablissem57_.LIB_WEB_ETB             AS LIB_WEB_ETB13_194_55_,
  etablissem57_.LIC_ETB                 AS LIC_ETB14_194_55_,
  etablissem57_.LIM1_ETB                AS LIM15_194_55_,
  etablissem57_.LIM2_ETB                AS LIM16_194_55_,
  etablissem57_.LIM3_ETB                AS LIM17_194_55_,
  etablissem57_.NUM_ORD_ETB             AS NUM_ORD_ETB18_194_55_,
  etablissem57_.COD_PAY_ADR_ETB         AS COD_PAY_ADR_ETB28_194_55_,
  etablissem57_.COD_PRU_CHG             AS COD_PRU_CHG29_194_55_,
  etablissem57_.COD_PRU_PRL             AS COD_PRU_PRL30_194_55_,
  etablissem57_.COD_STE                 AS COD_STE31_194_55_,
  etablissem57_.TEM_AUT_SIS_ETB         AS TEM_AUT_SIS_ETB19_194_55_,
  etablissem57_.TEM_CNV_ETB             AS TEM_CNV_ETB20_194_55_,
  etablissem57_.TEM_EN_SVE_ETB          AS TEM_EN_SVE_ETB21_194_55_,
  etablissem57_.TEM_MIN_ETB             AS TEM_MIN_ETB22_194_55_,
  etablissem57_.TEM_PRE_SIS_ETB         AS TEM_PRE_SIS_ETB23_194_55_,
  etablissem57_.TEM_PUB_ETB             AS TEM_PUB_ETB24_194_55_,
  etablissem57_.COD_TPE                 AS COD_TPE32_194_55_,
  etablissem58_.COD_ETB                 AS COD_ETB1_194_56_,
  etablissem58_.COD_AFF_DEP_ETB         AS COD_AFF_DEP_ETB2_194_56_,
  etablissem58_.COD_AFF_ETB             AS COD_AFF_ETB3_194_56_,
  etablissem58_.COD_ESU_ESE             AS COD_ESU_ESE4_194_56_,
  etablissem58_.COD_POS_ADR_ETB         AS COD_POS_ADR_ETB25_194_56_,
  etablissem58_.COD_COM_ADR_ETB         AS COD_COM_ADR_ETB26_194_56_,
  etablissem58_.COD_DEP                 AS COD_DEP27_194_56_,
  etablissem58_.LIB_AD1_ETB             AS LIB_AD5_194_56_,
  etablissem58_.LIB_AD2_ETB             AS LIB_AD6_194_56_,
  etablissem58_.LIB_AD3_ETB             AS LIB_AD7_194_56_,
  etablissem58_.LIB_ADE_ETB             AS LIB_ADE_ETB8_194_56_,
  etablissem58_.LIB_ART_OFF_ETB         AS LIB_ART_OFF_ETB9_194_56_,
  etablissem58_.LIB_CMT_ETB             AS LIB_CMT_ETB10_194_56_,
  etablissem58_.LIB_ETB                 AS LIB_ETB11_194_56_,
  etablissem58_.LIB_OFF_ETB             AS LIB_OFF_ETB12_194_56_,
  etablissem58_.LIB_WEB_ETB             AS LIB_WEB_ETB13_194_56_,
  etablissem58_.LIC_ETB                 AS LIC_ETB14_194_56_,
  etablissem58_.LIM1_ETB                AS LIM15_194_56_,
  etablissem58_.LIM2_ETB                AS LIM16_194_56_,
  etablissem58_.LIM3_ETB                AS LIM17_194_56_,
  etablissem58_.NUM_ORD_ETB             AS NUM_ORD_ETB18_194_56_,
  etablissem58_.COD_PAY_ADR_ETB         AS COD_PAY_ADR_ETB28_194_56_,
  etablissem58_.COD_PRU_CHG             AS COD_PRU_CHG29_194_56_,
  etablissem58_.COD_PRU_PRL             AS COD_PRU_PRL30_194_56_,
  etablissem58_.COD_STE                 AS COD_STE31_194_56_,
  etablissem58_.TEM_AUT_SIS_ETB         AS TEM_AUT_SIS_ETB19_194_56_,
  etablissem58_.TEM_CNV_ETB             AS TEM_CNV_ETB20_194_56_,
  etablissem58_.TEM_EN_SVE_ETB          AS TEM_EN_SVE_ETB21_194_56_,
  etablissem58_.TEM_MIN_ETB             AS TEM_MIN_ETB22_194_56_,
  etablissem58_.TEM_PRE_SIS_ETB         AS TEM_PRE_SIS_ETB23_194_56_,
  etablissem58_.TEM_PUB_ETB             AS TEM_PUB_ETB24_194_56_,
  etablissem58_.COD_TPE                 AS COD_TPE32_194_56_,
  etablissem59_.COD_ETB                 AS COD_ETB1_194_57_,
  etablissem59_.COD_AFF_DEP_ETB         AS COD_AFF_DEP_ETB2_194_57_,
  etablissem59_.COD_AFF_ETB             AS COD_AFF_ETB3_194_57_,
  etablissem59_.COD_ESU_ESE             AS COD_ESU_ESE4_194_57_,
  etablissem59_.COD_POS_ADR_ETB         AS COD_POS_ADR_ETB25_194_57_,
  etablissem59_.COD_COM_ADR_ETB         AS COD_COM_ADR_ETB26_194_57_,
  etablissem59_.COD_DEP                 AS COD_DEP27_194_57_,
  etablissem59_.LIB_AD1_ETB             AS LIB_AD5_194_57_,
  etablissem59_.LIB_AD2_ETB             AS LIB_AD6_194_57_,
  etablissem59_.LIB_AD3_ETB             AS LIB_AD7_194_57_,
  etablissem59_.LIB_ADE_ETB             AS LIB_ADE_ETB8_194_57_,
  etablissem59_.LIB_ART_OFF_ETB         AS LIB_ART_OFF_ETB9_194_57_,
  etablissem59_.LIB_CMT_ETB             AS LIB_CMT_ETB10_194_57_,
  etablissem59_.LIB_ETB                 AS LIB_ETB11_194_57_,
  etablissem59_.LIB_OFF_ETB             AS LIB_OFF_ETB12_194_57_,
  etablissem59_.LIB_WEB_ETB             AS LIB_WEB_ETB13_194_57_,
  etablissem59_.LIC_ETB                 AS LIC_ETB14_194_57_,
  etablissem59_.LIM1_ETB                AS LIM15_194_57_,
  etablissem59_.LIM2_ETB                AS LIM16_194_57_,
  etablissem59_.LIM3_ETB                AS LIM17_194_57_,
  etablissem59_.NUM_ORD_ETB             AS NUM_ORD_ETB18_194_57_,
  etablissem59_.COD_PAY_ADR_ETB         AS COD_PAY_ADR_ETB28_194_57_,
  etablissem59_.COD_PRU_CHG             AS COD_PRU_CHG29_194_57_,
  etablissem59_.COD_PRU_PRL             AS COD_PRU_PRL30_194_57_,
  etablissem59_.COD_STE                 AS COD_STE31_194_57_,
  etablissem59_.TEM_AUT_SIS_ETB         AS TEM_AUT_SIS_ETB19_194_57_,
  etablissem59_.TEM_CNV_ETB             AS TEM_CNV_ETB20_194_57_,
  etablissem59_.TEM_EN_SVE_ETB          AS TEM_EN_SVE_ETB21_194_57_,
  etablissem59_.TEM_MIN_ETB             AS TEM_MIN_ETB22_194_57_,
  etablissem59_.TEM_PRE_SIS_ETB         AS TEM_PRE_SIS_ETB23_194_57_,
  etablissem59_.TEM_PUB_ETB             AS TEM_PUB_ETB24_194_57_,
  etablissem59_.COD_TPE                 AS COD_TPE32_194_57_,
  etablissem60_.COD_ETB                 AS COD_ETB1_194_58_,
  etablissem60_.COD_AFF_DEP_ETB         AS COD_AFF_DEP_ETB2_194_58_,
  etablissem60_.COD_AFF_ETB             AS COD_AFF_ETB3_194_58_,
  etablissem60_.COD_ESU_ESE             AS COD_ESU_ESE4_194_58_,
  etablissem60_.COD_POS_ADR_ETB         AS COD_POS_ADR_ETB25_194_58_,
  etablissem60_.COD_COM_ADR_ETB         AS COD_COM_ADR_ETB26_194_58_,
  etablissem60_.COD_DEP                 AS COD_DEP27_194_58_,
  etablissem60_.LIB_AD1_ETB             AS LIB_AD5_194_58_,
  etablissem60_.LIB_AD2_ETB             AS LIB_AD6_194_58_,
  etablissem60_.LIB_AD3_ETB             AS LIB_AD7_194_58_,
  etablissem60_.LIB_ADE_ETB             AS LIB_ADE_ETB8_194_58_,
  etablissem60_.LIB_ART_OFF_ETB         AS LIB_ART_OFF_ETB9_194_58_,
  etablissem60_.LIB_CMT_ETB             AS LIB_CMT_ETB10_194_58_,
  etablissem60_.LIB_ETB                 AS LIB_ETB11_194_58_,
  etablissem60_.LIB_OFF_ETB             AS LIB_OFF_ETB12_194_58_,
  etablissem60_.LIB_WEB_ETB             AS LIB_WEB_ETB13_194_58_,
  etablissem60_.LIC_ETB                 AS LIC_ETB14_194_58_,
  etablissem60_.LIM1_ETB                AS LIM15_194_58_,
  etablissem60_.LIM2_ETB                AS LIM16_194_58_,
  etablissem60_.LIM3_ETB                AS LIM17_194_58_,
  etablissem60_.NUM_ORD_ETB             AS NUM_ORD_ETB18_194_58_,
  etablissem60_.COD_PAY_ADR_ETB         AS COD_PAY_ADR_ETB28_194_58_,
  etablissem60_.COD_PRU_CHG             AS COD_PRU_CHG29_194_58_,
  etablissem60_.COD_PRU_PRL             AS COD_PRU_PRL30_194_58_,
  etablissem60_.COD_STE                 AS COD_STE31_194_58_,
  etablissem60_.TEM_AUT_SIS_ETB         AS TEM_AUT_SIS_ETB19_194_58_,
  etablissem60_.TEM_CNV_ETB             AS TEM_CNV_ETB20_194_58_,
  etablissem60_.TEM_EN_SVE_ETB          AS TEM_EN_SVE_ETB21_194_58_,
  etablissem60_.TEM_MIN_ETB             AS TEM_MIN_ETB22_194_58_,
  etablissem60_.TEM_PRE_SIS_ETB         AS TEM_PRE_SIS_ETB23_194_58_,
  etablissem60_.TEM_PUB_ETB             AS TEM_PUB_ETB24_194_58_,
  etablissem60_.COD_TPE                 AS COD_TPE32_194_58_,
  individuvo61_.COD_IND                 AS COD_IND1_233_59_,
  individuvo61_.COD_ETU                 AS COD_ETU8_233_59_,
  individuvo61_.DATE_NAI_IND            AS DATE_NAI_IND27_233_59_,
  individuvo61_.LIB_NOM_PAT_IND         AS LIB_NOM_PAT_IND33_233_59_,
  individuvo61_.LIB_PR1_IND             AS LIB_PR37_233_59_,
  mtfaflssov62_.COD_MFS                 AS COD_MFS1_278_60_,
  mtfaflssov62_.LIB_MFS                 AS LIB_MFS2_278_60_,
  mtfaflssov62_.LIB_WEB_MFS             AS LIB_WEB_MFS3_278_60_,
  mtfaflssov62_.LIC_MFS                 AS LIC_MFS4_278_60_,
  mtfaflssov62_.LIM1_MFS                AS LIM5_278_60_,
  mtfaflssov62_.LIM2_MFS                AS LIM6_278_60_,
  mtfaflssov62_.LIM3_MFS                AS LIM7_278_60_,
  mtfaflssov62_.NUM_ORD_MFS             AS NUM_ORD_MFS8_278_60_,
  mtfaflssov62_.TEM_DEL                 AS TEM_DEL9_278_60_,
  mtfaflssov62_.TEM_EN_SVE_MFS          AS TEM_EN_SVE_MFS10_278_60_,
  mtfaflssov62_.TEM_MIN_MFS             AS TEM_MIN_MFS11_278_60_,
  mtfaflssov62_.TEM_PRL_MFS             AS TEM_PRL_MFS12_278_60_,
  mtfnonafls63_.COD_MNS                 AS COD_MNS1_280_61_,
  mtfnonafls63_.LIB_MNS                 AS LIB_MNS2_280_61_,
  mtfnonafls63_.LIB_WEB_MNS             AS LIB_WEB_MNS3_280_61_,
  mtfnonafls63_.LIC_MNS                 AS LIC_MNS4_280_61_,
  mtfnonafls63_.LIM1_MNS                AS LIM5_280_61_,
  mtfnonafls63_.LIM2_MNS                AS LIM6_280_61_,
  mtfnonafls63_.LIM3_MNS                AS LIM7_280_61_,
  mtfnonafls63_.NUM_ORD_MNS             AS NUM_ORD_MNS8_280_61_,
  mtfnonafls63_.TEM_DEL                 AS TEM_DEL9_280_61_,
  mtfnonafls63_.TEM_EN_SVE_MNS          AS TEM_EN_SVE_MNS10_280_61_,
  mtfnonafls63_.TEM_MIN_MNS             AS TEM_MIN_MNS11_280_61_,
  mtfnonafls63_.TEM_NON_CALC_MUT        AS TEM_NON_CALC_MUT12_280_61_,
  prgechange64_.COD_PRG                 AS COD_PRG1_321_62_,
  prgechange64_.TEM_SNS_PRG             AS TEM_SNS_PRG2_321_62_,
  prgechange64_.COD_SIS_PRG             AS COD_SIS_PRG3_321_62_,
  prgechange64_.LIB_PRG                 AS LIB_PRG4_321_62_,
  prgechange64_.LIB_WEB_PRG             AS LIB_WEB_PRG5_321_62_,
  prgechange64_.LIC_PRG                 AS LIC_PRG6_321_62_,
  prgechange64_.LIM1_PRG                AS LIM7_321_62_,
  prgechange64_.LIM2_PRG                AS LIM8_321_62_,
  prgechange64_.LIM3_PRG                AS LIM9_321_62_,
  prgechange64_.LIX_1_PRG               AS LIX_10_321_62_,
  prgechange64_.LIX_2_PRG               AS LIX_11_321_62_,
  prgechange64_.LIX_3_PRG               AS LIX_12_321_62_,
  prgechange64_.LIX_4_PRG               AS LIX_13_321_62_,
  prgechange64_.NUM_ORD_PRG             AS NUM_ORD_PRG14_321_62_,
  prgechange64_.COD_PRU                 AS COD_PRU17_321_62_,
  prgechange64_.TEM_EN_SVE_PRG          AS TEM_EN_SVE_PRG15_321_62_,
  prgechange64_.TEM_MIN_PRG             AS TEM_MIN_PRG16_321_62_,
  profiletuv65_.COD_PRU                 AS COD_PRU1_323_63_,
  profiletuv65_.LIB_PRU                 AS LIB_PRU2_323_63_,
  profiletuv65_.LIB_WEB_PRU             AS LIB_WEB_PRU3_323_63_,
  profiletuv65_.LIC_PRU                 AS LIC_PRU4_323_63_,
  profiletuv65_.LIM1_PRU                AS LIM5_323_63_,
  profiletuv65_.LIM2_PRU                AS LIM6_323_63_,
  profiletuv65_.LIM3_PRU                AS LIM7_323_63_,
  profiletuv65_.LIX_1_PRU               AS LIX_8_323_63_,
  profiletuv65_.LIX_2_PRU               AS LIX_9_323_63_,
  profiletuv65_.LIX_3_PRU               AS LIX_10_323_63_,
  profiletuv65_.LIX_4_PRU               AS LIX_11_323_63_,
  profiletuv65_.NUM_ORD_PRU             AS NUM_ORD_PRU12_323_63_,
  profiletuv65_.TEM_DEL                 AS TEM_DEL13_323_63_,
  profiletuv65_.TEM_EN_SVE_PRU          AS TEM_EN_SVE_PRU14_323_63_,
  profiletuv65_.TEM_MIN_PRU             AS TEM_MIN_PRU15_323_63_,
  profiletuv65_.TEM_PAI_WEB             AS TEM_PAI_WEB16_323_63_,
  profiletuv65_.TEM_PEC_MIN_PRU         AS TEM_PEC_MIN_PRU17_323_63_,
  profiletuv65_.TEM_SPE_PRU             AS TEM_SPE_PRU18_323_63_,
  profiletuv65_.TEM_TYP_ETP_PRU         AS TEM_TYP_ETP_PRU19_323_63_,
  profiletuv66_.COD_PRU                 AS COD_PRU1_323_64_,
  profiletuv66_.LIB_PRU                 AS LIB_PRU2_323_64_,
  profiletuv66_.LIB_WEB_PRU             AS LIB_WEB_PRU3_323_64_,
  profiletuv66_.LIC_PRU                 AS LIC_PRU4_323_64_,
  profiletuv66_.LIM1_PRU                AS LIM5_323_64_,
  profiletuv66_.LIM2_PRU                AS LIM6_323_64_,
  profiletuv66_.LIM3_PRU                AS LIM7_323_64_,
  profiletuv66_.LIX_1_PRU               AS LIX_8_323_64_,
  profiletuv66_.LIX_2_PRU               AS LIX_9_323_64_,
  profiletuv66_.LIX_3_PRU               AS LIX_10_323_64_,
  profiletuv66_.LIX_4_PRU               AS LIX_11_323_64_,
  profiletuv66_.NUM_ORD_PRU             AS NUM_ORD_PRU12_323_64_,
  profiletuv66_.TEM_DEL                 AS TEM_DEL13_323_64_,
  profiletuv66_.TEM_EN_SVE_PRU          AS TEM_EN_SVE_PRU14_323_64_,
  profiletuv66_.TEM_MIN_PRU             AS TEM_MIN_PRU15_323_64_,
  profiletuv66_.TEM_PAI_WEB             AS TEM_PAI_WEB16_323_64_,
  profiletuv66_.TEM_PEC_MIN_PRU         AS TEM_PEC_MIN_PRU17_323_64_,
  profiletuv66_.TEM_SPE_PRU             AS TEM_SPE_PRU18_323_64_,
  profiletuv66_.TEM_TYP_ETP_PRU         AS TEM_TYP_ETP_PRU19_323_64_,
  quotitetra67_.COD_QTR                 AS COD_QTR1_326_65_,
  quotitetra67_.COD_SIS_QTR             AS COD_SIS_QTR2_326_65_,
  quotitetra67_.LIB_QTR                 AS LIB_QTR3_326_65_,
  quotitetra67_.LIB_WEB_QTR             AS LIB_WEB_QTR4_326_65_,
  quotitetra67_.LIC_QTR                 AS LIC_QTR5_326_65_,
  quotitetra67_.LIM1_QTR                AS LIM6_326_65_,
  quotitetra67_.LIM2_QTR                AS LIM7_326_65_,
  quotitetra67_.LIM3_QTR                AS LIM8_326_65_,
  quotitetra67_.NUM_ORD_QTR             AS NUM_ORD_QTR9_326_65_,
  quotitetra67_.TEM_COU_AUT_REG_QTR     AS TEM_COU_AUT_REG_Q10_326_65_,
  quotitetra67_.TEM_EN_SVE_QTR          AS TEM_EN_SVE_QTR11_326_65_,
  quotitetra67_.TEM_MIN_QTR             AS TEM_MIN_QTR12_326_65_,
  quotitetra67_.TEM_PAI_WEB             AS TEM_PAI_WEB13_326_65_,
  regimeinsv68_.COD_RGI                 AS COD_RGI1_327_66_,
  regimeinsv68_.COD_SIS_RGI             AS COD_SIS_RGI2_327_66_,
  regimeinsv68_.ETA_SIS_RGI             AS ETA_SIS_RGI3_327_66_,
  regimeinsv68_.LIB_RGI                 AS LIB_RGI4_327_66_,
  regimeinsv68_.LIC_RGI                 AS LIC_RGI5_327_66_,
  regimeinsv68_.TEM_EN_SVE_RGI          AS TEM_EN_SVE_RGI6_327_66_,
  regimeinsv68_.TEM_PAI_WEB             AS TEM_PAI_WEB7_327_66_,
  regimeinsv68_.TEM_PDF_RGI             AS TEM_PDF_RGI8_327_66_,
  regimeinsv68_.TEM_PEC_MIN_RGI         AS TEM_PEC_MIN_RGI9_327_66_,
  regimessov69_.COD_RSS                 AS COD_RSS1_329_67_,
  regimessov69_.LIB_RSS                 AS LIB_RSS2_329_67_,
  regimessov69_.LIC_RSS                 AS LIC_RSS3_329_67_,
  regimessov69_.TEM_EN_SVE_RSS          AS TEM_EN_SVE_RSS4_329_67_,
  sitsociale70_.COD_SOC                 AS COD_SOC1_376_68_,
  sitsociale70_.LIB_SOC                 AS LIB_SOC2_376_68_,
  sitsociale70_.LIB_WEB_SOC             AS LIB_WEB_SOC3_376_68_,
  sitsociale70_.LIC_SOC                 AS LIC_SOC4_376_68_,
  sitsociale70_.LIM1_SOC                AS LIM5_376_68_,
  sitsociale70_.LIM2_SOC                AS LIM6_376_68_,
  sitsociale70_.LIM3_SOC                AS LIM7_376_68_,
  sitsociale70_.LIX_1_SOC               AS LIX_8_376_68_,
  sitsociale70_.LIX_2_SOC               AS LIX_9_376_68_,
  sitsociale70_.LIX_3_SOC               AS LIX_10_376_68_,
  sitsociale70_.LIX_4_SOC               AS LIX_11_376_68_,
  sitsociale70_.NUM_ORD_SOC             AS NUM_ORD_SOC12_376_68_,
  sitsociale70_.TEM_DEL                 AS TEM_DEL13_376_68_,
  sitsociale70_.TEM_EN_SVE_SOC          AS TEM_EN_SVE_SOC14_376_68_,
  sitsociale70_.TEM_MIN_SOC             AS TEM_MIN_SOC15_376_68_,
  sitsociale70_.TEM_PAI_WEB             AS TEM_PAI_WEB16_376_68_,
  sitsociale70_.TEM_PEC_MIN_SOC         AS TEM_PEC_MIN_SOC17_376_68_,
  situations71_.COD_SIS                 AS COD_SIS1_372_69_,
  situations71_.LIB_SIS                 AS LIB_SIS2_372_69_,
  situations71_.LIB_WEB_SIS             AS LIB_WEB_SIS3_372_69_,
  situations71_.LIC_SIS                 AS LIC_SIS4_372_69_,
  situations71_.LIM1_SIS                AS LIM5_372_69_,
  situations71_.LIM2_SIS                AS LIM6_372_69_,
  situations71_.LIM3_SIS                AS LIM7_372_69_,
  situations71_.NUM_ORD_SIS             AS NUM_ORD_SIS8_372_69_,
  situations71_.TEM_ACC_ETA_SIS         AS TEM_ACC_ETA_SIS9_372_69_,
  situations71_.TEM_ACC_LIE_SIS         AS TEM_ACC_LIE_SIS10_372_69_,
  situations71_.TEM_ANN_PRM_INS_SIS     AS TEM_ANN_PRM_INS_S11_372_69_,
  situations71_.TEM_EN_SVE_SIS          AS TEM_EN_SVE_SIS12_372_69_,
  situations71_.TEM_MIN_SIS             AS TEM_MIN_SIS13_372_69_,
  spohaunivv72_.COD_SPO                 AS COD_SPO1_383_70_,
  spohaunivv72_.LIB_SPO                 AS LIB_SPO2_383_70_,
  spohaunivv72_.LIB_WEB_SPO             AS LIB_WEB_SPO3_383_70_,
  spohaunivv72_.LIC_SPO                 AS LIC_SPO4_383_70_,
  spohaunivv72_.LIM1_SPO                AS LIM5_383_70_,
  spohaunivv72_.LIM2_SPO                AS LIM6_383_70_,
  spohaunivv72_.LIM3_SPO                AS LIM7_383_70_,
  spohaunivv72_.NUM_ORD_SPO             AS NUM_ORD_SPO8_383_70_,
  spohaunivv72_.TEM_EN_SVE_SPO          AS TEM_EN_SVE_SPO9_383_70_,
  spohaunivv72_.TEM_MIN_SPO             AS TEM_MIN_SPO10_383_70_,
  statutetuv73_.COD_STU                 AS COD_STU1_386_71_,
  statutetuv73_.COD_TYP_EDT_CRT_STU     AS COD_TYP_EDT_CRT_ST2_386_71_,
  statutetuv73_.LIB_STU                 AS LIB_STU3_386_71_,
  statutetuv73_.LIB_WEB_STU             AS LIB_WEB_STU4_386_71_,
  statutetuv73_.LIC_STU                 AS LIC_STU5_386_71_,
  statutetuv73_.LIM1_STU                AS LIM6_386_71_,
  statutetuv73_.LIM2_STU                AS LIM7_386_71_,
  statutetuv73_.LIM3_STU                AS LIM8_386_71_,
  statutetuv73_.LIX_1_STU               AS LIX_9_386_71_,
  statutetuv73_.LIX_2_STU               AS LIX_10_386_71_,
  statutetuv73_.LIX_3_STU               AS LIX_11_386_71_,
  statutetuv73_.LIX_4_STU               AS LIX_12_386_71_,
  statutetuv73_.NUM_ORD_STU             AS NUM_ORD_STU13_386_71_,
  statutetuv73_.COD_PRU                 AS COD_PRU23_386_71_,
  statutetuv73_.TEM_BU_STU              AS TEM_BU_STU14_386_71_,
  statutetuv73_.TEM_EN_SVE_STU          AS TEM_EN_SVE_STU15_386_71_,
  statutetuv73_.TEM_EXA_STU             AS TEM_EXA_STU16_386_71_,
  statutetuv73_.TEM_HEB_STU             AS TEM_HEB_STU17_386_71_,
  statutetuv73_.TEM_MIN_STU             AS TEM_MIN_STU18_386_71_,
  statutetuv73_.TEM_OUV_DRT_SSO_STU     AS TEM_OUV_DRT_SSO_S19_386_71_,
  statutetuv73_.TEM_PAI_WEB             AS TEM_PAI_WEB20_386_71_,
  statutetuv73_.TEM_PEC_MIN_STU         AS TEM_PEC_MIN_STU21_386_71_,
  statutetuv73_.TEM_USA_ETU_STU         AS TEM_USA_ETU_STU22_386_71_,
  profiletuv74_.COD_PRU                 AS COD_PRU1_323_72_,
  profiletuv74_.LIB_PRU                 AS LIB_PRU2_323_72_,
  profiletuv74_.LIB_WEB_PRU             AS LIB_WEB_PRU3_323_72_,
  profiletuv74_.LIC_PRU                 AS LIC_PRU4_323_72_,
  profiletuv74_.LIM1_PRU                AS LIM5_323_72_,
  profiletuv74_.LIM2_PRU                AS LIM6_323_72_,
  profiletuv74_.LIM3_PRU                AS LIM7_323_72_,
  profiletuv74_.LIX_1_PRU               AS LIX_8_323_72_,
  profiletuv74_.LIX_2_PRU               AS LIX_9_323_72_,
  profiletuv74_.LIX_3_PRU               AS LIX_10_323_72_,
  profiletuv74_.LIX_4_PRU               AS LIX_11_323_72_,
  profiletuv74_.NUM_ORD_PRU             AS NUM_ORD_PRU12_323_72_,
  profiletuv74_.TEM_DEL                 AS TEM_DEL13_323_72_,
  profiletuv74_.TEM_EN_SVE_PRU          AS TEM_EN_SVE_PRU14_323_72_,
  profiletuv74_.TEM_MIN_PRU             AS TEM_MIN_PRU15_323_72_,
  profiletuv74_.TEM_PAI_WEB             AS TEM_PAI_WEB16_323_72_,
  profiletuv74_.TEM_PEC_MIN_PRU         AS TEM_PEC_MIN_PRU17_323_72_,
  profiletuv74_.TEM_SPE_PRU             AS TEM_SPE_PRU18_323_72_,
  profiletuv74_.TEM_TYP_ETP_PRU         AS TEM_TYP_ETP_PRU19_323_72_,
  typdiplome75_.COD_TDE                 AS COD_TDE1_493_73_,
  typdiplome75_.LIB_TDE                 AS LIB_TDE2_493_73_,
  typdiplome75_.LIB_WEB_TDE             AS LIB_WEB_TDE3_493_73_,
  typdiplome75_.NUM_ORD_TDE             AS NUM_ORD_TDE4_493_73_,
  typdiplome75_.TEM_EN_SVE_TDE          AS TEM_EN_SVE_TDE5_493_73_,
  typdiplome75_.TEM_MIN_TDE             AS TEM_MIN_TDE6_493_73_,
  typdiplome75_.COD_TDS                 AS COD_TDS7_493_73_,
  typdiplome75_.COD_TPD_ETB             AS COD_TPD_ETB8_493_73_,
  typdiplome76_.COD_TDS                 AS COD_TDS1_494_74_,
  typdiplome76_.LIB_TDS                 AS LIB_TDS2_494_74_,
  typdiplome76_.LIB_WEB_TDS             AS LIB_WEB_TDS3_494_74_,
  typdiplome76_.LIC_TDS                 AS LIC_TDS4_494_74_,
  typdiplome76_.LIM1_TDS                AS LIM5_494_74_,
  typdiplome76_.LIM2_TDS                AS LIM6_494_74_,
  typdiplome76_.LIM3_TDS                AS LIM7_494_74_,
  typdiplome76_.NUM_ORD_TDS             AS NUM_ORD_TDS8_494_74_,
  typdiplome76_.TEM_ANN_PRM_INS_DIS     AS TEM_ANN_PRM_INS_DI9_494_74_,
  typdiplome76_.TEM_ANN_PRM_INS_ENSUP   AS TEM_ANN_PRM_INS_E10_494_74_,
  typdiplome76_.TEM_EN_SVE_TDS          AS TEM_EN_SVE_TDS11_494_74_,
  typdiplome76_.TEM_MIN_TDS             AS TEM_MIN_TDS12_494_74_,
  typdiplome77_.COD_TPD_ETB             AS COD_TPD_ETB1_492_75_,
  typdiplome77_.AGL_CUR                 AS AGL_CUR2_492_75_,
  typdiplome77_.AGL_FORM                AS AGL_FORM3_492_75_,
  typdiplome77_.AGL_TEM_MAST            AS AGL_TEM_MAST4_492_75_,
  typdiplome77_.COD_ECH                 AS COD_ECH5_492_75_,
  typdiplome77_.COD_TPD_SIS             AS COD_TPD_SIS6_492_75_,
  typdiplome77_.ETA_IFM                 AS ETA_IFM7_492_75_,
  typdiplome77_.ETA_ING                 AS ETA_ING8_492_75_,
  typdiplome77_.ETA_THS_HDR_DRT         AS ETA_THS_HDR_DRT9_492_75_,
  typdiplome77_.LIB_TPD                 AS LIB_TPD10_492_75_,
  typdiplome77_.LIC_TPD                 AS LIC_TPD11_492_75_,
  typdiplome77_.COD_NIF                 AS COD_NIF19_492_75_,
  typdiplome77_.TEM_CRD_SIS             AS TEM_CRD_SIS12_492_75_,
  typdiplome77_.TEM_EN_SVE_TPD          AS TEM_EN_SVE_TPD13_492_75_,
  typdiplome77_.TEM_ENQ_SIS_TPD         AS TEM_ENQ_SIS_TPD14_492_75_,
  typdiplome77_.TEM_NAT_EUR             AS TEM_NAT_EUR15_492_75_,
  typdiplome77_.TEM_PREXAM              AS TEM_PREXAM16_492_75_,
  typdiplome77_.TEM_PRIOR               AS TEM_PRIOR17_492_75_,
  typdiplome77_.TEM_SANTE               AS TEM_SANTE18_492_75_,
  typdiplome77_.COD_TDS                 AS COD_TDS20_492_75_,
  typdiplome77_.COD_TDS_INT             AS COD_TDS_INT21_492_75_,
  niveauform78_.COD_NIF                 AS COD_NIF1_288_76_,
  niveauform78_.LIB_NIF                 AS LIB_NIF2_288_76_,
  niveauform78_.TEM_EN_SVE_NIF          AS TEM_EN_SVE_NIF3_288_76_,
  typdiplome79_.COD_TDS                 AS COD_TDS1_494_77_,
  typdiplome79_.LIB_TDS                 AS LIB_TDS2_494_77_,
  typdiplome79_.LIB_WEB_TDS             AS LIB_WEB_TDS3_494_77_,
  typdiplome79_.LIC_TDS                 AS LIC_TDS4_494_77_,
  typdiplome79_.LIM1_TDS                AS LIM5_494_77_,
  typdiplome79_.LIM2_TDS                AS LIM6_494_77_,
  typdiplome79_.LIM3_TDS                AS LIM7_494_77_,
  typdiplome79_.NUM_ORD_TDS             AS NUM_ORD_TDS8_494_77_,
  typdiplome79_.TEM_ANN_PRM_INS_DIS     AS TEM_ANN_PRM_INS_DI9_494_77_,
  typdiplome79_.TEM_ANN_PRM_INS_ENSUP   AS TEM_ANN_PRM_INS_E10_494_77_,
  typdiplome79_.TEM_EN_SVE_TDS          AS TEM_EN_SVE_TDS11_494_77_,
  typdiplome79_.TEM_MIN_TDS             AS TEM_MIN_TDS12_494_77_,
  typdiplome80_.COD_TDS                 AS COD_TDS1_494_78_,
  typdiplome80_.LIB_TDS                 AS LIB_TDS2_494_78_,
  typdiplome80_.LIB_WEB_TDS             AS LIB_WEB_TDS3_494_78_,
  typdiplome80_.LIC_TDS                 AS LIC_TDS4_494_78_,
  typdiplome80_.LIM1_TDS                AS LIM5_494_78_,
  typdiplome80_.LIM2_TDS                AS LIM6_494_78_,
  typdiplome80_.LIM3_TDS                AS LIM7_494_78_,
  typdiplome80_.NUM_ORD_TDS             AS NUM_ORD_TDS8_494_78_,
  typdiplome80_.TEM_ANN_PRM_INS_DIS     AS TEM_ANN_PRM_INS_DI9_494_78_,
  typdiplome80_.TEM_ANN_PRM_INS_ENSUP   AS TEM_ANN_PRM_INS_E10_494_78_,
  typdiplome80_.TEM_EN_SVE_TDS          AS TEM_EN_SVE_TDS11_494_78_,
  typdiplome80_.TEM_MIN_TDS             AS TEM_MIN_TDS12_494_78_,
  typdiplome81_.COD_TDS                 AS COD_TDS1_494_79_,
  typdiplome81_.LIB_TDS                 AS LIB_TDS2_494_79_,
  typdiplome81_.LIB_WEB_TDS             AS LIB_WEB_TDS3_494_79_,
  typdiplome81_.LIC_TDS                 AS LIC_TDS4_494_79_,
  typdiplome81_.LIM1_TDS                AS LIM5_494_79_,
  typdiplome81_.LIM2_TDS                AS LIM6_494_79_,
  typdiplome81_.LIM3_TDS                AS LIM7_494_79_,
  typdiplome81_.NUM_ORD_TDS             AS NUM_ORD_TDS8_494_79_,
  typdiplome81_.TEM_ANN_PRM_INS_DIS     AS TEM_ANN_PRM_INS_DI9_494_79_,
  typdiplome81_.TEM_ANN_PRM_INS_ENSUP   AS TEM_ANN_PRM_INS_E10_494_79_,
  typdiplome81_.TEM_EN_SVE_TDS          AS TEM_EN_SVE_TDS11_494_79_,
  typdiplome81_.TEM_MIN_TDS             AS TEM_MIN_TDS12_494_79_,
  typetbvo82_.COD_TPE                   AS COD_TPE1_498_80_,
  typetbvo82_.COD_SIS_TPE               AS COD_SIS_TPE2_498_80_,
  typetbvo82_.LIB_TPE                   AS LIB_TPE3_498_80_,
  typetbvo82_.LIB_WEB_TPE               AS LIB_WEB_TPE4_498_80_,
  typetbvo82_.LIC_TPE                   AS LIC_TPE5_498_80_,
  typetbvo82_.LIM1_TPE                  AS LIM6_498_80_,
  typetbvo82_.LIM2_TPE                  AS LIM7_498_80_,
  typetbvo82_.LIM3_TPE                  AS LIM8_498_80_,
  typetbvo82_.NUM_ORD_TPE               AS NUM_ORD_TPE9_498_80_,
  typetbvo82_.COD_PRU_CHG               AS COD_PRU_CHG15_498_80_,
  typetbvo82_.COD_PRU_PRL               AS COD_PRU_PRL16_498_80_,
  typetbvo82_.TEM_DET_TPE               AS TEM_DET_TPE10_498_80_,
  typetbvo82_.TEM_EN_SVE_TPE            AS TEM_EN_SVE_TPE11_498_80_,
  typetbvo82_.TEM_GES_TRF_TPE           AS TEM_GES_TRF_TPE12_498_80_,
  typetbvo82_.TEM_MIN_TPE               AS TEM_MIN_TPE13_498_80_,
  typetbvo82_.TEM_PROP_AUTRE_ETB        AS TEM_PROP_AUTRE_ET14_498_80_,
  typetbvo83_.COD_TPE                   AS COD_TPE1_498_81_,
  typetbvo83_.COD_SIS_TPE               AS COD_SIS_TPE2_498_81_,
  typetbvo83_.LIB_TPE                   AS LIB_TPE3_498_81_,
  typetbvo83_.LIB_WEB_TPE               AS LIB_WEB_TPE4_498_81_,
  typetbvo83_.LIC_TPE                   AS LIC_TPE5_498_81_,
  typetbvo83_.LIM1_TPE                  AS LIM6_498_81_,
  typetbvo83_.LIM2_TPE                  AS LIM7_498_81_,
  typetbvo83_.LIM3_TPE                  AS LIM8_498_81_,
  typetbvo83_.NUM_ORD_TPE               AS NUM_ORD_TPE9_498_81_,
  typetbvo83_.COD_PRU_CHG               AS COD_PRU_CHG15_498_81_,
  typetbvo83_.COD_PRU_PRL               AS COD_PRU_PRL16_498_81_,
  typetbvo83_.TEM_DET_TPE               AS TEM_DET_TPE10_498_81_,
  typetbvo83_.TEM_EN_SVE_TPE            AS TEM_EN_SVE_TPE11_498_81_,
  typetbvo83_.TEM_GES_TRF_TPE           AS TEM_GES_TRF_TPE12_498_81_,
  typetbvo83_.TEM_MIN_TPE               AS TEM_MIN_TPE13_498_81_,
  typetbvo83_.TEM_PROP_AUTRE_ETB        AS TEM_PROP_AUTRE_ET14_498_81_,
  utilisateu84_.COD_UTI                 AS COD_UTI1_506_82_,
  utilisateu84_.ADR_MAIL_UTI            AS ADR_MAIL_UTI2_506_82_,
  utilisateu84_.COD_CGE                 AS COD_CGE13_506_82_,
  utilisateu84_.COD_CIN                 AS COD_CIN14_506_82_,
  utilisateu84_.COD_CIP                 AS COD_CIP15_506_82_,
  utilisateu84_.COD_IMP_WIN_A3          AS COD_IMP_WIN_A3_506_82_,
  utilisateu84_.COD_NUM_UTI             AS COD_NUM_UTI4_506_82_,
  utilisateu84_.COD_IMP                 AS COD_IMP16_506_82_,
  utilisateu84_.LIB_CMT_UTI             AS LIB_CMT_UTI5_506_82_,
  utilisateu84_.REP_EXP_UTI             AS REP_EXP_UTI6_506_82_,
  utilisateu84_.TEM_AUT_MEMENTO         AS TEM_AUT_MEMENTO7_506_82_,
  utilisateu84_.TEM_AUT_SPE_MCC         AS TEM_AUT_SPE_MCC8_506_82_,
  utilisateu84_.TEM_AUT_WEB             AS TEM_AUT_WEB9_506_82_,
  utilisateu84_.TEM_EN_SVE_UTI          AS TEM_EN_SVE_UTI10_506_82_,
  utilisateu84_.TEM_PIL_UTI             AS TEM_PIL_UTI11_506_82_,
  utilisateu84_.TEM_PMT_3F_AUT_RMB      AS TEM_PMT_12_506_82_,
  utilisateu84_.COD_TUT                 AS COD_TUT17_506_82_,
  centregest85_.COD_CGE                 AS COD_CGE1_84_83_,
  centregest85_.COD_MOD_PAI_MIN_CGE     AS COD_MOD_PAI_MIN_CG2_84_83_,
  centregest85_.COD_MOD_PAI_MINP_CGE    AS COD_MOD_PAI_MINP_C3_84_83_,
  centregest85_.COD_POS_ADR_CGE         AS COD_POS_ADR_CGE33_84_83_,
  centregest85_.COD_COM_ADR_CGE         AS COD_COM_ADR_CGE34_84_83_,
  centregest85_.COD_CPA                 AS COD_CPA35_84_83_,
  centregest85_.DAT_DEB_INS_CGE         AS DAT_DEB_INS_CGE4_84_83_,
  centregest85_.DAT_FIN_INS_CGE         AS DAT_FIN_INS_CGE5_84_83_,
  centregest85_.ETA_TYP_EDT_CRT_CGE     AS ETA_TYP_EDT_CRT_CG6_84_83_,
  centregest85_.LIB_AD1_CGE             AS LIB_AD7_84_83_,
  centregest85_.LIB_AD2_CGE             AS LIB_AD8_84_83_,
  centregest85_.LIB_AD3_CGE             AS LIB_AD9_84_83_,
  centregest85_.LIB_CGE                 AS LIB_CGE10_84_83_,
  centregest85_.LIB_CMT_CGE             AS LIB_CMT_CGE11_84_83_,
  centregest85_.LIB_CMT_PCJ_MIN_CGE     AS LIB_CMT_PCJ_MIN_C12_84_83_,
  centregest85_.LIB_CMT_PCJ_MINP_CGE    AS LIB_CMT_PCJ_MINP_13_84_83_,
  centregest85_.LIB_NOM_RESP_CGE        AS LIB_NOM_RESP_CGE14_84_83_,
  centregest85_.LIC_CGE                 AS LIC_CGE15_84_83_,
  centregest85_.MOD_EDT_CRT             AS MOD_EDT_CRT16_84_83_,
  centregest85_.NBR_ETU_CPT             AS NBR_ETU_CPT17_84_83_,
  centregest85_.NBR_MAX_INS_AUT         AS NBR_MAX_INS_AUT18_84_83_,
  centregest85_.NUM_CHR_QUT_CGE         AS NUM_CHR_QUT_CGE19_84_83_,
  centregest85_.NUM_OCC_PRM_QUT_VAL     AS NUM_OCC_PRM_QUT_V20_84_83_,
  centregest85_.NUM_OCC_QUT_EDT         AS NUM_OCC_QUT_EDT21_84_83_,
  centregest85_.NUM_OCC_QUT_EDT_LCH     AS NUM_OCC_QUT_EDT_L22_84_83_,
  centregest85_.NUM_OCC_QUT_EDT_VDR     AS NUM_OCC_QUT_EDT_V23_84_83_,
  centregest85_.NUM_OCC_QUT_VAL         AS NUM_OCC_QUT_VAL24_84_83_,
  centregest85_.TEM_CTRL_PAI            AS TEM_CTRL_PAI25_84_83_,
  centregest85_.TEM_CTRL_RMB            AS TEM_CTRL_RMB26_84_83_,
  centregest85_.TEM_EN_SVE_CGE          AS TEM_EN_SVE_CGE27_84_83_,
  centregest85_.TEM_MIN_CGE             AS TEM_MIN_CGE28_84_83_,
  centregest85_.TEM_MIN_DEMAT_CGE       AS TEM_MIN_DEMAT_CGE29_84_83_,
  centregest85_.TEM_MINP_DEMAT_CGE      AS TEM_MINP_DEMAT_CG30_84_83_,
  centregest85_.TEM_PAI_MEME_POS        AS TEM_PAI_MEME_POS31_84_83_,
  centregest85_.TEM_PMT_3F_CGE_WEB      AS TEM_PMT_32_84_83_,
  centreinco86_.COD_CIN                 AS COD_CIN1_86_84_,
  centreinco86_.COD_TRI_ETU_CIN         AS COD_TRI_ETU_CIN2_86_84_,
  centreinco86_.HH_CIN                  AS HH_CIN3_86_84_,
  centreinco86_.LIB_CIN                 AS LIB_CIN4_86_84_,
  centreinco86_.MM_CIN                  AS MM_CIN5_86_84_,
  centreinco86_.TEM_EN_SVE_CIN          AS TEM_EN_SVE_CIN6_86_84_,
  centreinsp87_.COD_CIP                 AS COD_CIP1_87_85_,
  centreinsp87_.LIB_CIP                 AS LIB_CIP2_87_85_,
  centreinsp87_.LIC_CIP                 AS LIC_CIP3_87_85_,
  centreinsp87_.TEM_ADIP_CIP            AS TEM_ADIP_CIP4_87_85_,
  centreinsp87_.TEM_EN_SVE_CIP          AS TEM_EN_SVE_CIP5_87_85_,
  imprimante88_.COD_IMP                 AS COD_IMP1_231_86_,
  imprimante88_.FMT_RPT_IMP             AS FMT_RPT_IMP2_231_86_,
  imprimante88_.IMP_RES_PS              AS IMP_RES_PS3_231_86_,
  imprimante88_.LIB_IMP                 AS LIB_IMP4_231_86_,
  imprimante88_.NOM_RPT_IMP             AS NOM_RPT_IMP5_231_86_,
  imprimante88_.TEM_IMP_PS_PDF          AS TEM_IMP_PS_PDF6_231_86_,
  typutilisa89_.COD_TUT                 AS COD_TUT1_505_87_,
  typutilisa89_.LIB_CMT_TUT             AS LIB_CMT_TUT2_505_87_,
  typutilisa89_.LIB_TUT                 AS LIB_TUT3_505_87_,
  typutilisa89_.TEM_COF_NOT             AS TEM_COF_NOT4_505_87_,
  loginbatch90_.COD_UTI                 AS COD_UTI1_260_88_,
  loginbatch90_.MDP_UTI                 AS MDP_UTI2_260_88_,
  utilisateu91_.COD_UTI                 AS COD_UTI1_506_89_,
  utilisateu91_.ADR_MAIL_UTI            AS ADR_MAIL_UTI2_506_89_,
  utilisateu91_.COD_CGE                 AS COD_CGE13_506_89_,
  utilisateu91_.COD_CIN                 AS COD_CIN14_506_89_,
  utilisateu91_.COD_CIP                 AS COD_CIP15_506_89_,
  utilisateu91_.COD_IMP_WIN_A3          AS COD_IMP_WIN_A3_506_89_,
  utilisateu91_.COD_NUM_UTI             AS COD_NUM_UTI4_506_89_,
  utilisateu91_.COD_IMP                 AS COD_IMP16_506_89_,
  utilisateu91_.LIB_CMT_UTI             AS LIB_CMT_UTI5_506_89_,
  utilisateu91_.REP_EXP_UTI             AS REP_EXP_UTI6_506_89_,
  utilisateu91_.TEM_AUT_MEMENTO         AS TEM_AUT_MEMENTO7_506_89_,
  utilisateu91_.TEM_AUT_SPE_MCC         AS TEM_AUT_SPE_MCC8_506_89_,
  utilisateu91_.TEM_AUT_WEB             AS TEM_AUT_WEB9_506_89_,
  utilisateu91_.TEM_EN_SVE_UTI          AS TEM_EN_SVE_UTI10_506_89_,
  utilisateu91_.TEM_PIL_UTI             AS TEM_PIL_UTI11_506_89_,
  utilisateu91_.TEM_PMT_3F_AUT_RMB      AS TEM_PMT_12_506_89_,
  utilisateu91_.COD_TUT                 AS COD_TUT17_506_89_,
  utilisateu92_.COD_UTI                 AS COD_UTI1_506_90_,
  utilisateu92_.ADR_MAIL_UTI            AS ADR_MAIL_UTI2_506_90_,
  utilisateu92_.COD_CGE                 AS COD_CGE13_506_90_,
  utilisateu92_.COD_CIN                 AS COD_CIN14_506_90_,
  utilisateu92_.COD_CIP                 AS COD_CIP15_506_90_,
  utilisateu92_.COD_IMP_WIN_A3          AS COD_IMP_WIN_A3_506_90_,
  utilisateu92_.COD_NUM_UTI             AS COD_NUM_UTI4_506_90_,
  utilisateu92_.COD_IMP                 AS COD_IMP16_506_90_,
  utilisateu92_.LIB_CMT_UTI             AS LIB_CMT_UTI5_506_90_,
  utilisateu92_.REP_EXP_UTI             AS REP_EXP_UTI6_506_90_,
  utilisateu92_.TEM_AUT_MEMENTO         AS TEM_AUT_MEMENTO7_506_90_,
  utilisateu92_.TEM_AUT_SPE_MCC         AS TEM_AUT_SPE_MCC8_506_90_,
  utilisateu92_.TEM_AUT_WEB             AS TEM_AUT_WEB9_506_90_,
  utilisateu92_.TEM_EN_SVE_UTI          AS TEM_EN_SVE_UTI10_506_90_,
  utilisateu92_.TEM_PIL_UTI             AS TEM_PIL_UTI11_506_90_,
  utilisateu92_.TEM_PMT_3F_AUT_RMB      AS TEM_PMT_12_506_90_,
  utilisateu92_.COD_TUT                 AS COD_TUT17_506_90_,
  inspedagog93_.COD_ANU                 AS COD_ANU1_256_91_,
  inspedagog93_.COD_ETP                 AS COD_ETP2_256_91_,
  inspedagog93_.COD_IND                 AS COD_IND3_256_91_,
  inspedagog93_.COD_VRS_VET             AS COD_VRS_VET4_256_91_,
  inspedagog93_.COD_TYP_IPE             AS COD_TYP_IPE5_256_91_,
  inspedagog93_.DAT_ACC_IPE             AS DAT_ACC_IPE6_256_91_,
  inspedagog93_.DAT_CRE_IPE             AS DAT_CRE_IPE7_256_91_,
  inspedagog93_.DAT_MOD_IPE             AS DAT_MOD_IPE8_256_91_,
  inspedagog93_.COD_FEX                 AS COD_FEX12_256_91_,
  inspedagog93_.LIB_REF_ACC             AS LIB_REF_ACC9_256_91_,
  inspedagog93_.NBR_CRD_VET_INS         AS NBR_CRD_VET_INS10_256_91_,
  inspedagog93_.TEM_INS_ELP_ATMQ_IPE    AS TEM_INS_ELP_ATMQ_11_256_91_,
  inspedagog93_.COD_UTI                 AS COD_UTI13_256_91_,
  inspedagog93_.COD_UTI_ACC             AS COD_UTI_ACC14_256_91_,
  inspedagog93_.COD_UTI_MOD             AS COD_UTI_MOD15_256_91_,
  formuleexa94_.COD_FEX                 AS COD_FEX1_209_92_,
  formuleexa94_.LIB_FEX                 AS LIB_FEX2_209_92_,
  formuleexa94_.LIC_FEX                 AS LIC_FEX3_209_92_,
  formuleexa94_.TEM_DEL                 AS TEM_DEL4_209_92_,
  formuleexa94_.TEM_EN_SVE_FEX          AS TEM_EN_SVE_FEX5_209_92_,
  inspedagog95_.COD_ANU                 AS COD_ANU1_255_93_,
  inspedagog95_.COD_IND                 AS COD_IND2_255_93_,
  anneeunivo96_.COD_ANU                 AS COD_ANU1_18_94_,
  anneeunivo96_.DAT_FRM_OPI             AS DAT_FRM_OPI2_18_94_,
  anneeunivo96_.DAT_OUV_OPI             AS DAT_OUV_OPI3_18_94_,
  anneeunivo96_.ETA_ANU_AGL             AS ETA_ANU_AGL4_18_94_,
  anneeunivo96_.ETA_ANU_APB             AS ETA_ANU_APB5_18_94_,
  anneeunivo96_.ETA_ANU_IAE             AS ETA_ANU_IAE6_18_94_,
  anneeunivo96_.ETA_ANU_IPE             AS ETA_ANU_IPE7_18_94_,
  anneeunivo96_.ETA_ANU_RES             AS ETA_ANU_RES8_18_94_,
  anneeunivo96_.LIB_ANU                 AS LIB_ANU9_18_94_,
  anneeunivo96_.LIC_ANU                 AS LIC_ANU10_18_94_,
  anneeunivo96_.NUM_OCC_OBT_ADD         AS NUM_OCC_OBT_ADD11_18_94_,
  anneeunivo96_.NUM_OCC_OBT_CER         AS NUM_OCC_OBT_CER12_18_94_,
  anneeunivo96_.NUM_OCC_OBT_VDI         AS NUM_OCC_OBT_VDI13_18_94_,
  anneeunivo96_.NUM_OCC_OBT_VDI_UNI     AS NUM_OCC_OBT_VDI_U14_18_94_,
  individuvo97_.COD_IND                 AS COD_IND1_233_95_,
  individuvo97_.COD_ETU                 AS COD_ETU8_233_95_,
  individuvo97_.DATE_NAI_IND            AS DATE_NAI_IND27_233_95_,
  individuvo97_.LIB_NOM_PAT_IND         AS LIB_NOM_PAT_IND33_233_95_,
  individuvo97_.LIB_PR1_IND             AS LIB_PR37_233_95_,
  utilisateu98_.COD_UTI                 AS COD_UTI1_506_96_,
  utilisateu98_.ADR_MAIL_UTI            AS ADR_MAIL_UTI2_506_96_,
  utilisateu98_.COD_CGE                 AS COD_CGE13_506_96_,
  utilisateu98_.COD_CIN                 AS COD_CIN14_506_96_,
  utilisateu98_.COD_CIP                 AS COD_CIP15_506_96_,
  utilisateu98_.COD_IMP_WIN_A3          AS COD_IMP_WIN_A3_506_96_,
  utilisateu98_.COD_NUM_UTI             AS COD_NUM_UTI4_506_96_,
  utilisateu98_.COD_IMP                 AS COD_IMP16_506_96_,
  utilisateu98_.LIB_CMT_UTI             AS LIB_CMT_UTI5_506_96_,
  utilisateu98_.REP_EXP_UTI             AS REP_EXP_UTI6_506_96_,
  utilisateu98_.TEM_AUT_MEMENTO         AS TEM_AUT_MEMENTO7_506_96_,
  utilisateu98_.TEM_AUT_SPE_MCC         AS TEM_AUT_SPE_MCC8_506_96_,
  utilisateu98_.TEM_AUT_WEB             AS TEM_AUT_WEB9_506_96_,
  utilisateu98_.TEM_EN_SVE_UTI          AS TEM_EN_SVE_UTI10_506_96_,
  utilisateu98_.TEM_PIL_UTI             AS TEM_PIL_UTI11_506_96_,
  utilisateu98_.TEM_PMT_3F_AUT_RMB      AS TEM_PMT_12_506_96_,
  utilisateu98_.COD_TUT                 AS COD_TUT17_506_96_,
  utilisateu99_.COD_UTI                 AS COD_UTI1_506_97_,
  utilisateu99_.ADR_MAIL_UTI            AS ADR_MAIL_UTI2_506_97_,
  utilisateu99_.COD_CGE                 AS COD_CGE13_506_97_,
  utilisateu99_.COD_CIN                 AS COD_CIN14_506_97_,
  utilisateu99_.COD_CIP                 AS COD_CIP15_506_97_,
  utilisateu99_.COD_IMP_WIN_A3          AS COD_IMP_WIN_A3_506_97_,
  utilisateu99_.COD_NUM_UTI             AS COD_NUM_UTI4_506_97_,
  utilisateu99_.COD_IMP                 AS COD_IMP16_506_97_,
  utilisateu99_.LIB_CMT_UTI             AS LIB_CMT_UTI5_506_97_,
  utilisateu99_.REP_EXP_UTI             AS REP_EXP_UTI6_506_97_,
  utilisateu99_.TEM_AUT_MEMENTO         AS TEM_AUT_MEMENTO7_506_97_,
  utilisateu99_.TEM_AUT_SPE_MCC         AS TEM_AUT_SPE_MCC8_506_97_,
  utilisateu99_.TEM_AUT_WEB             AS TEM_AUT_WEB9_506_97_,
  utilisateu99_.TEM_EN_SVE_UTI          AS TEM_EN_SVE_UTI10_506_97_,
  utilisateu99_.TEM_PIL_UTI             AS TEM_PIL_UTI11_506_97_,
  utilisateu99_.TEM_PMT_3F_AUT_RMB      AS TEM_PMT_12_506_97_,
  utilisateu99_.COD_TUT                 AS COD_TUT17_506_97_,
  utilisateu100_.COD_UTI                AS COD_UTI1_506_98_,
  utilisateu100_.ADR_MAIL_UTI           AS ADR_MAIL_UTI2_506_98_,
  utilisateu100_.COD_CGE                AS COD_CGE13_506_98_,
  utilisateu100_.COD_CIN                AS COD_CIN14_506_98_,
  utilisateu100_.COD_CIP                AS COD_CIP15_506_98_,
  utilisateu100_.COD_IMP_WIN_A3         AS COD_IMP_WIN_A3_506_98_,
  utilisateu100_.COD_NUM_UTI            AS COD_NUM_UTI4_506_98_,
  utilisateu100_.COD_IMP                AS COD_IMP16_506_98_,
  utilisateu100_.LIB_CMT_UTI            AS LIB_CMT_UTI5_506_98_,
  utilisateu100_.REP_EXP_UTI            AS REP_EXP_UTI6_506_98_,
  utilisateu100_.TEM_AUT_MEMENTO        AS TEM_AUT_MEMENTO7_506_98_,
  utilisateu100_.TEM_AUT_SPE_MCC        AS TEM_AUT_SPE_MCC8_506_98_,
  utilisateu100_.TEM_AUT_WEB            AS TEM_AUT_WEB9_506_98_,
  utilisateu100_.TEM_EN_SVE_UTI         AS TEM_EN_SVE_UTI10_506_98_,
  utilisateu100_.TEM_PIL_UTI            AS TEM_PIL_UTI11_506_98_,
  utilisateu100_.TEM_PMT_3F_AUT_RMB     AS TEM_PMT_12_506_98_,
  utilisateu100_.COD_TUT                AS COD_TUT17_506_98_,
  versioneta101_.COD_ETP                AS COD_ETP1_528_99_,
  versioneta101_.COD_VRS_VET            AS COD_VRS_VET2_528_99_,
  versioneta101_.COD_CPG                AS COD_CPG43_528_99_,
  versioneta101_.BAR_SAI_VET            AS BAR_SAI_VET3_528_99_,
  versioneta101_.COD_CGE_MIN_VET        AS COD_CGE_MIN_VET44_528_99_,
  versioneta101_.COD_CGE_MINP_VET       AS COD_CGE_MINP_VET4_528_99_,
  versioneta101_.COD_CIP_ADIP_VET       AS COD_CIP_ADIP_VET5_528_99_,
  versioneta101_.COD_CMP                AS COD_CMP45_528_99_,
  versioneta101_.COD_CFM                AS COD_CFM46_528_99_,
  versioneta101_.COD_CNV                AS COD_CNV47_528_99_,
  versioneta101_.DAT_DEB_DEF_PACES_REE  AS DAT_DEB_DEF_PACES_6_528_99_,
  versioneta101_.DAT_DEB_MIN_VET        AS DAT_DEB_MIN_VET7_528_99_,
  versioneta101_.DAT_DEB_MINP_VET       AS DAT_DEB_MINP_VET8_528_99_,
  versioneta101_.DAT_DEB_PACES_REE      AS DAT_DEB_PACES_REE9_528_99_,
  versioneta101_.DAT_DEB_PACES_SIM      AS DAT_DEB_PACES_SIM10_528_99_,
  versioneta101_.DAT_DEB_PROV_PACES_REE AS DAT_DEB_PROV_PACE11_528_99_,
  versioneta101_.DAT_DEB_PROV_PACES_SIM AS DAT_DEB_PROV_PACE12_528_99_,
  versioneta101_.DAT_FIN_DEF_PACES_REE  AS DAT_FIN_DEF_PACES13_528_99_,
  versioneta101_.DAT_FIN_MIN_VET        AS DAT_FIN_MIN_VET14_528_99_,
  versioneta101_.DAT_FIN_MINP_VET       AS DAT_FIN_MINP_VET15_528_99_,
  versioneta101_.DAT_FIN_PACES_REE      AS DAT_FIN_PACES_REE16_528_99_,
  versioneta101_.DAT_FIN_PACES_SIM      AS DAT_FIN_PACES_SIM17_528_99_,
  versioneta101_.DAT_FIN_PROV_PACES_REE AS DAT_FIN_PROV_PACE18_528_99_,
  versioneta101_.DAT_FIN_PROV_PACES_SIM AS DAT_FIN_PROV_PACE19_528_99_,
  versioneta101_.COD_DUE                AS COD_DUE48_528_99_,
  versioneta101_.COD_ESI                AS COD_ESI49_528_99_,
  versioneta101_.GRP_PACES_VET          AS GRP_PACES_VET20_528_99_,
  versioneta101_.LIB_CMT_VET            AS LIB_CMT_VET21_528_99_,
  versioneta101_.LIB_WEB_VET            AS LIB_WEB_VET22_528_99_,
  versioneta101_.LIM1_VET               AS LIM23_528_99_,
  versioneta101_.LIM2_VET               AS LIM24_528_99_,
  versioneta101_.LIM3_VET               AS LIM25_528_99_,
  versioneta101_.NBR_ADM_VET            AS NBR_ADM_VET26_528_99_,
  versioneta101_.NBR_CRD_VET            AS NBR_CRD_VET27_528_99_,
  versioneta101_.NBR_VOL_HOR_VET        AS NBR_VOL_HOR_VET28_528_99_,
  versioneta101_.COD_PTY                AS COD_PTY50_528_99_,
  versioneta101_.COD_PAN_1              AS COD_PAN_51_528_99_,
  versioneta101_.COD_PAN_2              AS COD_PAN_52_528_99_,
  versioneta101_.COD_PAN_3              AS COD_PAN_53_528_99_,
  versioneta101_.COD_PAN_4              AS COD_PAN_54_528_99_,
  versioneta101_.TEM_ADI                AS TEM_ADI29_528_99_,
  versioneta101_.TEM_ADO                AS TEM_ADO30_528_99_,
  versioneta101_.TEM_DIP_VET            AS TEM_DIP_VET31_528_99_,
  versioneta101_.TEM_HEB_VET            AS TEM_HEB_VET32_528_99_,
  versioneta101_.TEM_JUR_VET            AS TEM_JUR_VET33_528_99_,
  versioneta101_.TEM_MND_VET            AS TEM_MND_VET34_528_99_,
  versioneta101_.TEM_NOT_VET            AS TEM_NOT_VET35_528_99_,
  versioneta101_.TEM_OPI_MIN_VET        AS TEM_OPI_MIN_VET36_528_99_,
  versioneta101_.TEM_PMT_3F_VET_WEB     AS TEM_PMT_37_528_99_,
  versioneta101_.TEM_PNT_JUR_VET        AS TEM_PNT_JUR_VET38_528_99_,
  versioneta101_.TEM_REINS_SANS_DELIB   AS TEM_REINS_SANS_DE39_528_99_,
  versioneta101_.TEM_RES_VET            AS TEM_RES_VET40_528_99_,
  versioneta101_.TEM_SES_UNI            AS TEM_SES_UNI41_528_99_,
  versioneta101_.TEM_TLS_VET            AS TEM_TLS_VET42_528_99_,
  versioneta101_.COD_TRE_NEG            AS COD_TRE_NEG55_528_99_,
  versioneta101_.COD_TRE_POS            AS COD_TRE_POS56_528_99_,
  adipcampag102_.COD_CPG                AS COD_CPG1_2_100_,
  adipcampag102_.DATE_FERM_CPG          AS DATE_FERM_CPG2_2_100_,
  adipcampag102_.DATE_OUV_CPG           AS DATE_OUV_CPG3_2_100_,
  adipcampag102_.LIB_CPG                AS LIB_CPG4_2_100_,
  adipcampag102_.TEM_EN_SVE_CPG         AS TEM_EN_SVE_CPG5_2_100_,
  centregest103_.COD_CGE                AS COD_CGE1_84_101_,
  centregest103_.COD_MOD_PAI_MIN_CGE    AS COD_MOD_PAI_MIN_CG2_84_101_,
  centregest103_.COD_MOD_PAI_MINP_CGE   AS COD_MOD_PAI_MINP_C3_84_101_,
  centregest103_.COD_POS_ADR_CGE        AS COD_POS_ADR_CGE33_84_101_,
  centregest103_.COD_COM_ADR_CGE        AS COD_COM_ADR_CGE34_84_101_,
  centregest103_.COD_CPA                AS COD_CPA35_84_101_,
  centregest103_.DAT_DEB_INS_CGE        AS DAT_DEB_INS_CGE4_84_101_,
  centregest103_.DAT_FIN_INS_CGE        AS DAT_FIN_INS_CGE5_84_101_,
  centregest103_.ETA_TYP_EDT_CRT_CGE    AS ETA_TYP_EDT_CRT_CG6_84_101_,
  centregest103_.LIB_AD1_CGE            AS LIB_AD7_84_101_,
  centregest103_.LIB_AD2_CGE            AS LIB_AD8_84_101_,
  centregest103_.LIB_AD3_CGE            AS LIB_AD9_84_101_,
  centregest103_.LIB_CGE                AS LIB_CGE10_84_101_,
  centregest103_.LIB_CMT_CGE            AS LIB_CMT_CGE11_84_101_,
  centregest103_.LIB_CMT_PCJ_MIN_CGE    AS LIB_CMT_PCJ_MIN_C12_84_101_,
  centregest103_.LIB_CMT_PCJ_MINP_CGE   AS LIB_CMT_PCJ_MINP_13_84_101_,
  centregest103_.LIB_NOM_RESP_CGE       AS LIB_NOM_RESP_CGE14_84_101_,
  centregest103_.LIC_CGE                AS LIC_CGE15_84_101_,
  centregest103_.MOD_EDT_CRT            AS MOD_EDT_CRT16_84_101_,
  centregest103_.NBR_ETU_CPT            AS NBR_ETU_CPT17_84_101_,
  centregest103_.NBR_MAX_INS_AUT        AS NBR_MAX_INS_AUT18_84_101_,
  centregest103_.NUM_CHR_QUT_CGE        AS NUM_CHR_QUT_CGE19_84_101_,
  centregest103_.NUM_OCC_PRM_QUT_VAL    AS NUM_OCC_PRM_QUT_V20_84_101_,
  centregest103_.NUM_OCC_QUT_EDT        AS NUM_OCC_QUT_EDT21_84_101_,
  centregest103_.NUM_OCC_QUT_EDT_LCH    AS NUM_OCC_QUT_EDT_L22_84_101_,
  centregest103_.NUM_OCC_QUT_EDT_VDR    AS NUM_OCC_QUT_EDT_V23_84_101_,
  centregest103_.NUM_OCC_QUT_VAL        AS NUM_OCC_QUT_VAL24_84_101_,
  centregest103_.TEM_CTRL_PAI           AS TEM_CTRL_PAI25_84_101_,
  centregest103_.TEM_CTRL_RMB           AS TEM_CTRL_RMB26_84_101_,
  centregest103_.TEM_EN_SVE_CGE         AS TEM_EN_SVE_CGE27_84_101_,
  centregest103_.TEM_MIN_CGE            AS TEM_MIN_CGE28_84_101_,
  centregest103_.TEM_MIN_DEMAT_CGE      AS TEM_MIN_DEMAT_CGE29_84_101_,
  centregest103_.TEM_MINP_DEMAT_CGE     AS TEM_MINP_DEMAT_CG30_84_101_,
  centregest103_.TEM_PAI_MEME_POS       AS TEM_PAI_MEME_POS31_84_101_,
  centregest103_.TEM_PMT_3F_CGE_WEB     AS TEM_PMT_32_84_101_,
  composante104_.COD_CMP                AS COD_CMP1_107_102_,
  composante104_.COD_NAT_CMP            AS COD_NAT_CMP2_107_102_,
  composante104_.COD_RNE_CMP            AS COD_RNE_CMP3_107_102_,
  composante104_.COD_POS_ADR_CMP        AS COD_POS_ADR_CMP21_107_102_,
  composante104_.COD_COM_ADR_CMP        AS COD_COM_ADR_CMP22_107_102_,
  composante104_.INT_1_EDI_DIP_CMP      AS INT_4_107_102_,
  composante104_.INT_2_EDI_DIP_CMP      AS INT_5_107_102_,
  composante104_.LIB_AD1_CMP            AS LIB_AD6_107_102_,
  composante104_.LIB_AD2_CMP            AS LIB_AD7_107_102_,
  composante104_.LIB_AD3_CMP            AS LIB_AD8_107_102_,
  composante104_.LIB_WEB_CMP            AS LIB_WEB_CMP9_107_102_,
  composante104_.LIB_CMP                AS LIB_CMP10_107_102_,
  composante104_.LIB_CMT_CMP            AS LIB_CMT_CMP11_107_102_,
  composante104_.LIC_CMP                AS LIC_CMP12_107_102_,
  composante104_.LIM1_CMP               AS LIM13_107_102_,
  composante104_.LIM2_CMP               AS LIM14_107_102_,
  composante104_.LIM3_CMP               AS LIM15_107_102_,
  composante104_.NUM_ORD_CMP            AS NUM_ORD_CMP16_107_102_,
  composante104_.COD_SIG                AS COD_SIG23_107_102_,
  composante104_.TEM_COU_ACC_TRV_CMP    AS TEM_COU_ACC_TRV_C17_107_102_,
  composante104_.TEM_ELC_CMP            AS TEM_ELC_CMP18_107_102_,
  composante104_.TEM_EN_SVE_CMP         AS TEM_EN_SVE_CMP19_107_102_,
  composante104_.TEM_MIN_CMP            AS TEM_MIN_CMP20_107_102_,
  composante104_.COD_TPC                AS COD_TPC24_107_102_,
  configment105_.COD_CFM                AS COD_CFM1_113_103_,
  configment105_.LIB_CFM                AS LIB_CFM2_113_103_,
  configment105_.LIC_CFM                AS LIC_CFM3_113_103_,
  configment105_.TEM_DEL                AS TEM_DEL4_113_103_,
  configment105_.TEM_EN_SVE_CFM         AS TEM_EN_SVE_CFM5_113_103_,
  configment105_.TEM_THS_CFM            AS TEM_THS_CFM6_113_103_,
  convention106_.COD_CNV                AS COD_CNV1_116_104_,
  convention106_.COD_SIS_CNV            AS COD_SIS_CNV2_116_104_,
  convention106_.LIB_CNV                AS LIB_CNV3_116_104_,
  convention106_.TEM_EN_SVE_CNV         AS TEM_EN_SVE_CNV4_116_104_,
  dureeetape107_.COD_DUE                AS COD_DUE1_155_105_,
  dureeetape107_.LIB_DUE                AS LIB_DUE2_155_105_,
  dureeetape107_.TEM_EN_SVE_DUE         AS TEM_EN_SVE_DUE3_155_105_,
  etapesisvo108_.COD_ESI                AS COD_ESI1_196_106_,
  etapesisvo108_.LIB_ESI                AS LIB_ESI2_196_106_,
  etapesisvo108_.TEM_EN_SVE_ESI         AS TEM_EN_SVE_ESI3_196_106_,
  etapevo109_.COD_ETP                   AS COD_ETP1_195_107_,
  etapevo109_.COD_ACT                   AS COD_ACT10_195_107_,
  etapevo109_.COD_CUR                   AS COD_CUR11_195_107_,
  etapevo109_.COD_CYC                   AS COD_CYC12_195_107_,
  etapevo109_.LIB_ETP                   AS LIB_ETP2_195_107_,
  etapevo109_.LIC_ETP                   AS LIC_ETP3_195_107_,
  etapevo109_.NBR_MAX_IAE_AUT           AS NBR_MAX_IAE_AUT4_195_107_,
  etapevo109_.NBR_MAX_INSC_DEUG         AS NBR_MAX_INSC_DEUG5_195_107_,
  etapevo109_.TEM_COU_ACC_TRV_ETP       AS TEM_COU_ACC_TRV_ET6_195_107_,
  etapevo109_.TEM_OUV_DRT_BRS           AS TEM_OUV_DRT_BRS7_195_107_,
  etapevo109_.TEM_OUV_DRT_SSO_ETP       AS TEM_OUV_DRT_SSO_ET8_195_107_,
  etapevo109_.TEM_TYP_OPI               AS TEM_TYP_OPI9_195_107_,
  actionlolf110_.COD_ACT                AS COD_ACT1_1_108_,
  actionlolf110_.COD_DESTINATION        AS COD_DESTINATION2_1_108_,
  actionlolf110_.LIB_ACT                AS LIB_ACT3_1_108_,
  actionlolf110_.LIC_ACT                AS LIC_ACT4_1_108_,
  actionlolf110_.NUM_ORD_ACT            AS NUM_ORD_ACT5_1_108_,
  actionlolf110_.TEM_EN_SVE_ACT         AS TEM_EN_SVE_ACT6_1_108_,
  cursuslmdv111_.COD_CUR                AS COD_CUR1_125_109_,
  cursuslmdv111_.LIB_CUR                AS LIB_CUR2_125_109_,
  cursuslmdv111_.NUM_ORD_CUR            AS NUM_ORD_CUR3_125_109_,
  cursuslmdv111_.TEM_EN_SVE_CUR         AS TEM_EN_SVE_CUR4_125_109_,
  cyclevo112_.COD_CYC                   AS COD_CYC1_126_110_,
  cyclevo112_.LIB_CYC                   AS LIB_CYC2_126_110_,
  cyclevo112_.TEM_DEL                   AS TEM_DEL3_126_110_,
  cyclevo112_.TEM_EN_SVE_CYC            AS TEM_EN_SVE_CYC4_126_110_,
  parcoursty113_.COD_PTY                AS COD_PTY1_303_111_,
  parcoursty113_.COD_SIS_PTY            AS COD_SIS_PTY2_303_111_,
  parcoursty113_.LIB_PTY                AS LIB_PTY3_303_111_,
  parcoursty113_.TEM_EN_SVE_PTY         AS TEM_EN_SVE_PTY4_303_111_,
  periodeano114_.COD_PAN                AS COD_PAN1_307_112_,
  periodeano114_.LIB_PAN                AS LIB_PAN2_307_112_,
  periodeano114_.COD_RNA                AS COD_RNA4_307_112_,
  periodeano114_.TEM_EN_SVE_PAN         AS TEM_EN_SVE_PAN3_307_112_,
  reglenuman115_.COD_RNA                AS COD_RNA1_334_113_,
  reglenuman115_.COD_RNA_EXT            AS COD_RNA_EXT2_334_113_,
  reglenuman115_.LIB_RNA                AS LIB_RNA3_334_113_,
  reglenuman115_.MOD_RNA                AS MOD_RNA4_334_113_,
  reglenuman115_.NUM_DEB                AS NUM_DEB5_334_113_,
  reglenuman115_.TEM_EN_SVE_RNA         AS TEM_EN_SVE_RNA6_334_113_,
  reglenuman115_.TEM_NUM_DEB            AS TEM_NUM_DEB7_334_113_,
  reglenuman115_.TEM_PREF_RE            AS TEM_PREF_RE8_334_113_,
  periodeano116_.COD_PAN                AS COD_PAN1_307_114_,
  periodeano116_.LIB_PAN                AS LIB_PAN2_307_114_,
  periodeano116_.COD_RNA                AS COD_RNA4_307_114_,
  periodeano116_.TEM_EN_SVE_PAN         AS TEM_EN_SVE_PAN3_307_114_,
  periodeano117_.COD_PAN                AS COD_PAN1_307_115_,
  periodeano117_.LIB_PAN                AS LIB_PAN2_307_115_,
  periodeano117_.COD_RNA                AS COD_RNA4_307_115_,
  periodeano117_.TEM_EN_SVE_PAN         AS TEM_EN_SVE_PAN3_307_115_,
  periodeano118_.COD_PAN                AS COD_PAN1_307_116_,
  periodeano118_.LIB_PAN                AS LIB_PAN2_307_116_,
  periodeano118_.COD_RNA                AS COD_RNA4_307_116_,
  periodeano118_.TEM_EN_SVE_PAN         AS TEM_EN_SVE_PAN3_307_116_,
  typresulta119_.COD_TRE                AS COD_TRE1_503_117_,
  typresulta119_.COD_NEG_TRE            AS COD_NEG_TRE2_503_117_,
  typresulta119_.COD_SIS_DIP_TRE        AS COD_SIS_DIP_TRE3_503_117_,
  typresulta119_.LIB_TRE                AS LIB_TRE4_503_117_,
  typresulta119_.LIC_TRE                AS LIC_TRE5_503_117_,
  typresulta119_.TEM_ADI_TRE            AS TEM_ADI_TRE6_503_117_,
  typresulta119_.TEM_ADO_TRE            AS TEM_ADO_TRE7_503_117_,
  typresulta119_.TEM_DEL                AS TEM_DEL8_503_117_,
  typresulta119_.TEM_ELP_TRE            AS TEM_ELP_TRE9_503_117_,
  typresulta119_.TEM_EN_SVE_TRE         AS TEM_EN_SVE_TRE10_503_117_,
  typresulta119_.TEM_EPR_TRE            AS TEM_EPR_TRE11_503_117_,
  typresulta119_.TEM_VDI_TRE            AS TEM_VDI_TRE12_503_117_,
  typresulta119_.TEM_VET_TRE            AS TEM_VET_TRE13_503_117_,
  typresulta120_.COD_TRE                AS COD_TRE1_503_118_,
  typresulta120_.COD_NEG_TRE            AS COD_NEG_TRE2_503_118_,
  typresulta120_.COD_SIS_DIP_TRE        AS COD_SIS_DIP_TRE3_503_118_,
  typresulta120_.LIB_TRE                AS LIB_TRE4_503_118_,
  typresulta120_.LIC_TRE                AS LIC_TRE5_503_118_,
  typresulta120_.TEM_ADI_TRE            AS TEM_ADI_TRE6_503_118_,
  typresulta120_.TEM_ADO_TRE            AS TEM_ADO_TRE7_503_118_,
  typresulta120_.TEM_DEL                AS TEM_DEL8_503_118_,
  typresulta120_.TEM_ELP_TRE            AS TEM_ELP_TRE9_503_118_,
  typresulta120_.TEM_EN_SVE_TRE         AS TEM_EN_SVE_TRE10_503_118_,
  typresulta120_.TEM_EPR_TRE            AS TEM_EPR_TRE11_503_118_,
  typresulta120_.TEM_VDI_TRE            AS TEM_VDI_TRE12_503_118_,
  typresulta120_.TEM_VET_TRE            AS TEM_VET_TRE13_503_118_,
  profiletuv121_.COD_PRU                AS COD_PRU1_323_119_,
  profiletuv121_.LIB_PRU                AS LIB_PRU2_323_119_,
  profiletuv121_.LIB_WEB_PRU            AS LIB_WEB_PRU3_323_119_,
  profiletuv121_.LIC_PRU                AS LIC_PRU4_323_119_,
  profiletuv121_.LIM1_PRU               AS LIM5_323_119_,
  profiletuv121_.LIM2_PRU               AS LIM6_323_119_,
  profiletuv121_.LIM3_PRU               AS LIM7_323_119_,
  profiletuv121_.LIX_1_PRU              AS LIX_8_323_119_,
  profiletuv121_.LIX_2_PRU              AS LIX_9_323_119_,
  profiletuv121_.LIX_3_PRU              AS LIX_10_323_119_,
  profiletuv121_.LIX_4_PRU              AS LIX_11_323_119_,
  profiletuv121_.NUM_ORD_PRU            AS NUM_ORD_PRU12_323_119_,
  profiletuv121_.TEM_DEL                AS TEM_DEL13_323_119_,
  profiletuv121_.TEM_EN_SVE_PRU         AS TEM_EN_SVE_PRU14_323_119_,
  profiletuv121_.TEM_MIN_PRU            AS TEM_MIN_PRU15_323_119_,
  profiletuv121_.TEM_PAI_WEB            AS TEM_PAI_WEB16_323_119_,
  profiletuv121_.TEM_PEC_MIN_PRU        AS TEM_PEC_MIN_PRU17_323_119_,
  profiletuv121_.TEM_SPE_PRU            AS TEM_SPE_PRU18_323_119_,
  profiletuv121_.TEM_TYP_ETP_PRU        AS TEM_TYP_ETP_PRU19_323_119_,
  regimeinsv122_.COD_RGI                AS COD_RGI1_327_120_,
  regimeinsv122_.COD_SIS_RGI            AS COD_SIS_RGI2_327_120_,
  regimeinsv122_.ETA_SIS_RGI            AS ETA_SIS_RGI3_327_120_,
  regimeinsv122_.LIB_RGI                AS LIB_RGI4_327_120_,
  regimeinsv122_.LIC_RGI                AS LIC_RGI5_327_120_,
  regimeinsv122_.TEM_EN_SVE_RGI         AS TEM_EN_SVE_RGI6_327_120_,
  regimeinsv122_.TEM_PAI_WEB            AS TEM_PAI_WEB7_327_120_,
  regimeinsv122_.TEM_PDF_RGI            AS TEM_PDF_RGI8_327_120_,
  regimeinsv122_.TEM_PEC_MIN_RGI        AS TEM_PEC_MIN_RGI9_327_120_,
  teleenseig123_.COD_TLS                AS COD_TLS1_395_121_,
  teleenseig123_.COD_SIS_TLS            AS COD_SIS_TLS2_395_121_,
  teleenseig123_.LIB_TLS                AS LIB_TLS3_395_121_,
  teleenseig123_.LIB_WEB_TLS            AS LIB_WEB_TLS4_395_121_,
  teleenseig123_.LIC_TLS                AS LIC_TLS5_395_121_,
  teleenseig123_.NUM_ORD_TLS            AS NUM_ORD_TLS6_395_121_,
  teleenseig123_.TEM_EN_SVE_TLS         AS TEM_EN_SVE_TLS7_395_121_,
  teleenseig123_.TEM_MIN_TLS            AS TEM_MIN_TLS8_395_121_,
  typcpgevo124_.COD_TYP_CPG             AS COD_TYP_CPG1_490_122_,
  typcpgevo124_.COD_ANU_TYP_CPG         AS COD_ANU_TYP_CPG2_490_122_,
  typcpgevo124_.COD_DOM_TYP_CPG         AS COD_DOM_TYP_CPG3_490_122_,
  typcpgevo124_.COD_SIS_TYP_CPG         AS COD_SIS_TYP_CPG4_490_122_,
  typcpgevo124_.LIB_TYP_CPG             AS LIB_TYP_CPG5_490_122_,
  typcpgevo124_.LIC_TYP_CPG             AS LIC_TYP_CPG6_490_122_,
  typcpgevo124_.TEM_EN_SVE_TYP_CPG      AS TEM_EN_SVE_TYP_CPG7_490_122_,
  utilisateu125_.COD_UTI                AS COD_UTI1_506_123_,
  utilisateu125_.ADR_MAIL_UTI           AS ADR_MAIL_UTI2_506_123_,
  utilisateu125_.COD_CGE                AS COD_CGE13_506_123_,
  utilisateu125_.COD_CIN                AS COD_CIN14_506_123_,
  utilisateu125_.COD_CIP                AS COD_CIP15_506_123_,
  utilisateu125_.COD_IMP_WIN_A3         AS COD_IMP_WIN_A3_506_123_,
  utilisateu125_.COD_NUM_UTI            AS COD_NUM_UTI4_506_123_,
  utilisateu125_.COD_IMP                AS COD_IMP16_506_123_,
  utilisateu125_.LIB_CMT_UTI            AS LIB_CMT_UTI5_506_123_,
  utilisateu125_.REP_EXP_UTI            AS REP_EXP_UTI6_506_123_,
  utilisateu125_.TEM_AUT_MEMENTO        AS TEM_AUT_MEMENTO7_506_123_,
  utilisateu125_.TEM_AUT_SPE_MCC        AS TEM_AUT_SPE_MCC8_506_123_,
  utilisateu125_.TEM_AUT_WEB            AS TEM_AUT_WEB9_506_123_,
  utilisateu125_.TEM_EN_SVE_UTI         AS TEM_EN_SVE_UTI10_506_123_,
  utilisateu125_.TEM_PIL_UTI            AS TEM_PIL_UTI11_506_123_,
  utilisateu125_.TEM_PMT_3F_AUT_RMB     AS TEM_PMT_12_506_123_,
  utilisateu125_.COD_TUT                AS COD_TUT17_506_123_,
  utilisateu126_.COD_UTI                AS COD_UTI1_506_124_,
  utilisateu126_.ADR_MAIL_UTI           AS ADR_MAIL_UTI2_506_124_,
  utilisateu126_.COD_CGE                AS COD_CGE13_506_124_,
  utilisateu126_.COD_CIN                AS COD_CIN14_506_124_,
  utilisateu126_.COD_CIP                AS COD_CIP15_506_124_,
  utilisateu126_.COD_IMP_WIN_A3         AS COD_IMP_WIN_A3_506_124_,
  utilisateu126_.COD_NUM_UTI            AS COD_NUM_UTI4_506_124_,
  utilisateu126_.COD_IMP                AS COD_IMP16_506_124_,
  utilisateu126_.LIB_CMT_UTI            AS LIB_CMT_UTI5_506_124_,
  utilisateu126_.REP_EXP_UTI            AS REP_EXP_UTI6_506_124_,
  utilisateu126_.TEM_AUT_MEMENTO        AS TEM_AUT_MEMENTO7_506_124_,
  utilisateu126_.TEM_AUT_SPE_MCC        AS TEM_AUT_SPE_MCC8_506_124_,
  utilisateu126_.TEM_AUT_WEB            AS TEM_AUT_WEB9_506_124_,
  utilisateu126_.TEM_EN_SVE_UTI         AS TEM_EN_SVE_UTI10_506_124_,
  utilisateu126_.TEM_PIL_UTI            AS TEM_PIL_UTI11_506_124_,
  utilisateu126_.TEM_PMT_3F_AUT_RMB     AS TEM_PMT_12_506_124_,
  utilisateu126_.COD_TUT                AS COD_TUT17_506_124_,
  utilisateu127_.COD_UTI                AS COD_UTI1_506_125_,
  utilisateu127_.ADR_MAIL_UTI           AS ADR_MAIL_UTI2_506_125_,
  utilisateu127_.COD_CGE                AS COD_CGE13_506_125_,
  utilisateu127_.COD_CIN                AS COD_CIN14_506_125_,
  utilisateu127_.COD_CIP                AS COD_CIP15_506_125_,
  utilisateu127_.COD_IMP_WIN_A3         AS COD_IMP_WIN_A3_506_125_,
  utilisateu127_.COD_NUM_UTI            AS COD_NUM_UTI4_506_125_,
  utilisateu127_.COD_IMP                AS COD_IMP16_506_125_,
  utilisateu127_.LIB_CMT_UTI            AS LIB_CMT_UTI5_506_125_,
  utilisateu127_.REP_EXP_UTI            AS REP_EXP_UTI6_506_125_,
  utilisateu127_.TEM_AUT_MEMENTO        AS TEM_AUT_MEMENTO7_506_125_,
  utilisateu127_.TEM_AUT_SPE_MCC        AS TEM_AUT_SPE_MCC8_506_125_,
  utilisateu127_.TEM_AUT_WEB            AS TEM_AUT_WEB9_506_125_,
  utilisateu127_.TEM_EN_SVE_UTI         AS TEM_EN_SVE_UTI10_506_125_,
  utilisateu127_.TEM_PIL_UTI            AS TEM_PIL_UTI11_506_125_,
  utilisateu127_.TEM_PMT_3F_AUT_RMB     AS TEM_PMT_12_506_125_,
  utilisateu127_.COD_TUT                AS COD_TUT17_506_125_,
  versiondip128_.COD_DIP                AS COD_DIP1_527_126_,
  versiondip128_.COD_VRS_VDI            AS COD_VRS_VDI2_527_126_,
  versiondip128_.BAR_SAI_VDI            AS BAR_SAI_VDI3_527_126_,
  versiondip128_.COD_CAR_VDI            AS COD_CAR_VDI4_527_126_,
  versiondip128_.COD_DOS_HAB_VDI        AS COD_DOS_HAB_VDI5_527_126_,
  versiondip128_.COD_ROF_VDI            AS COD_ROF_VDI6_527_126_,
  versiondip128_.COD_CFM                AS COD_CFM32_527_126_,
  versiondip128_.COD_CUR                AS COD_CUR33_527_126_,
  versiondip128_.DAA_DEB_HAB_VDI        AS DAA_DEB_HAB_VDI7_527_126_,
  versiondip128_.DAA_DEB_RCT_VDI        AS DAA_DEB_RCT_VDI8_527_126_,
  versiondip128_.DAA_DEB_VAL_VDI        AS DAA_DEB_VAL_VDI9_527_126_,
  versiondip128_.DAA_FIN_HAB_VDI        AS DAA_FIN_HAB_VDI10_527_126_,
  versiondip128_.DAA_FIN_RCT_VDI        AS DAA_FIN_RCT_VDI11_527_126_,
  versiondip128_.DAA_FIN_VAL_VDI        AS DAA_FIN_VAL_VDI12_527_126_,
  versiondip128_.COD_SIS_VDI            AS COD_SIS_VDI34_527_126_,
  versiondip128_.COD_SIS_VDI_INT        AS COD_SIS_VDI_INT35_527_126_,
  versiondip128_.DUR_ANN_VDI            AS DUR_ANN_VDI13_527_126_,
  versiondip128_.COD_EDO_VDI            AS COD_EDO_VDI36_527_126_,
  versiondip128_.COD_FIV                AS COD_FIV37_527_126_,
  versiondip128_.LIB_WEB_VDI            AS LIB_WEB_VDI14_527_126_,
  versiondip128_.LIC_VDI                AS LIC_VDI15_527_126_,
  versiondip128_.LIM1_VDI               AS LIM16_527_126_,
  versiondip128_.LIM2_VDI               AS LIM17_527_126_,
  versiondip128_.LIM3_VDI               AS LIM18_527_126_,
  versiondip128_.COD_MEV                AS COD_MEV38_527_126_,
  versiondip128_.NBR_ADM_VDI            AS NBR_ADM_VDI19_527_126_,
  versiondip128_.NBR_CRD_VDI            AS NBR_CRD_VDI20_527_126_,
  versiondip128_.NBR_MAX_SPE_VDI        AS NBR_MAX_SPE_VDI21_527_126_,
  versiondip128_.NBR_MIN_SPE_VDI        AS NBR_MIN_SPE_VDI22_527_126_,
  versiondip128_.COD_PTY                AS COD_PTY39_527_126_,
  versiondip128_.COD_PAN_1              AS COD_PAN_40_527_126_,
  versiondip128_.COD_PAN_2              AS COD_PAN_41_527_126_,
  versiondip128_.COD_PAN_3              AS COD_PAN_42_527_126_,
  versiondip128_.COD_PAN_4              AS COD_PAN_43_527_126_,
  versiondip128_.COD_SVD                AS COD_SVD44_527_126_,
  versiondip128_.TEM_ADI                AS TEM_ADI23_527_126_,
  versiondip128_.TEM_ADO                AS TEM_ADO24_527_126_,
  versiondip128_.TEM_JUR_VDI            AS TEM_JUR_VDI25_527_126_,
  versiondip128_.TEM_MND_VDI            AS TEM_MND_VDI26_527_126_,
  versiondip128_.TEM_NOT_VDI            AS TEM_NOT_VDI27_527_126_,
  versiondip128_.TEM_PNT_JUR_VDI        AS TEM_PNT_JUR_VDI28_527_126_,
  versiondip128_.TEM_RES_THS_VDI        AS TEM_RES_THS_VDI29_527_126_,
  versiondip128_.TEM_RES_VDI            AS TEM_RES_VDI30_527_126_,
  versiondip128_.TEM_SES_UNI            AS TEM_SES_UNI31_527_126_,
  versiondip128_.COD_TRE_NEG            AS COD_TRE_NEG45_527_126_,
  versiondip128_.COD_TRE_POS            AS COD_TRE_POS46_527_126_,
  (
    SELECT
      typ.ETA_THS_HDR_DRT
    FROM
      DIPLOME dip,
      TYP_DIPLOME typ
    WHERE
      dip.COD_DIP      =versiondip128_.COD_DIP
    AND dip.COD_TPD_ETB=typ.COD_TPD_ETB
  )                                 AS formula14_126_,
  configment129_.COD_CFM            AS COD_CFM1_113_127_,
  configment129_.LIB_CFM            AS LIB_CFM2_113_127_,
  configment129_.LIC_CFM            AS LIC_CFM3_113_127_,
  configment129_.TEM_DEL            AS TEM_DEL4_113_127_,
  configment129_.TEM_EN_SVE_CFM     AS TEM_EN_SVE_CFM5_113_127_,
  configment129_.TEM_THS_CFM        AS TEM_THS_CFM6_113_127_,
  cursuslmdv130_.COD_CUR            AS COD_CUR1_125_128_,
  cursuslmdv130_.LIB_CUR            AS LIB_CUR2_125_128_,
  cursuslmdv130_.NUM_ORD_CUR        AS NUM_ORD_CUR3_125_128_,
  cursuslmdv130_.TEM_EN_SVE_CUR     AS TEM_EN_SVE_CUR4_125_128_,
  diplomesis131_.COD_DIS            AS COD_DIS1_137_129_,
  diplomesis131_.ETA_DIS            AS ETA_DIS2_137_129_,
  diplomesis131_.LIB_INT1_DIS       AS LIB_INT3_137_129_,
  diplomesis131_.LIB_INT2_DIS       AS LIB_INT4_137_129_,
  diplomesis131_.LIC_TYP_DIS        AS LIC_TYP_DIS5_137_129_,
  diplomesis131_.TEM_EN_SVE_DIS     AS TEM_EN_SVE_DIS6_137_129_,
  diplomesis131_.TEM_INT_DIS        AS TEM_INT_DIS7_137_129_,
  diplomesis132_.COD_DIS            AS COD_DIS1_137_130_,
  diplomesis132_.ETA_DIS            AS ETA_DIS2_137_130_,
  diplomesis132_.LIB_INT1_DIS       AS LIB_INT3_137_130_,
  diplomesis132_.LIB_INT2_DIS       AS LIB_INT4_137_130_,
  diplomesis132_.LIC_TYP_DIS        AS LIC_TYP_DIS5_137_130_,
  diplomesis132_.TEM_EN_SVE_DIS     AS TEM_EN_SVE_DIS6_137_130_,
  diplomesis132_.TEM_INT_DIS        AS TEM_INT_DIS7_137_130_,
  diplomevo133_.COD_DIP             AS COD_DIP1_136_131_,
  diplomevo133_.COD_CYC             AS COD_CYC7_136_131_,
  diplomevo133_.COD_DFD             AS COD_DFD8_136_131_,
  diplomevo133_.COD_ETB             AS COD_ETB9_136_131_,
  diplomevo133_.LIB_DIP             AS LIB_DIP2_136_131_,
  diplomevo133_.LIC_DIP             AS LIC_DIP3_136_131_,
  diplomevo133_.COD_NDI             AS COD_NDI10_136_131_,
  diplomevo133_.NBR_MAX_INSC_DEUG   AS NBR_MAX_INSC_DEUG4_136_131_,
  diplomevo133_.COD_NIM             AS COD_NIM11_136_131_,
  diplomevo133_.COD_SDS             AS COD_SDS12_136_131_,
  diplomevo133_.TEM_COU_ACC_TRV_DIP AS TEM_COU_ACC_TRV_DI5_136_131_,
  diplomevo133_.TEM_OUV_DRT_SSO_DIP AS TEM_OUV_DRT_SSO_DI6_136_131_,
  diplomevo133_.COD_TPD_ETB         AS COD_TPD_ETB13_136_131_,
  cyclevo134_.COD_CYC               AS COD_CYC1_126_132_,
  cyclevo134_.LIB_CYC               AS LIB_CYC2_126_132_,
  cyclevo134_.TEM_DEL               AS TEM_DEL3_126_132_,
  cyclevo134_.TEM_EN_SVE_CYC        AS TEM_EN_SVE_CYC4_126_132_,
  domainefor135_.COD_DFD            AS COD_DFD1_146_133_,
  domainefor135_.LIB_DFD            AS LIB_DFD2_146_133_,
  domainefor135_.TEM_EN_SVE_DFD     AS TEM_EN_SVE_DFD3_146_133_,
  etablissem136_.COD_ETB            AS COD_ETB1_194_134_,
  etablissem136_.COD_AFF_DEP_ETB    AS COD_AFF_DEP_ETB2_194_134_,
  etablissem136_.COD_AFF_ETB        AS COD_AFF_ETB3_194_134_,
  etablissem136_.COD_ESU_ESE        AS COD_ESU_ESE4_194_134_,
  etablissem136_.COD_POS_ADR_ETB    AS COD_POS_ADR_ETB25_194_134_,
  etablissem136_.COD_COM_ADR_ETB    AS COD_COM_ADR_ETB26_194_134_,
  etablissem136_.COD_DEP            AS COD_DEP27_194_134_,
  etablissem136_.LIB_AD1_ETB        AS LIB_AD5_194_134_,
  etablissem136_.LIB_AD2_ETB        AS LIB_AD6_194_134_,
  etablissem136_.LIB_AD3_ETB        AS LIB_AD7_194_134_,
  etablissem136_.LIB_ADE_ETB        AS LIB_ADE_ETB8_194_134_,
  etablissem136_.LIB_ART_OFF_ETB    AS LIB_ART_OFF_ETB9_194_134_,
  etablissem136_.LIB_CMT_ETB        AS LIB_CMT_ETB10_194_134_,
  etablissem136_.LIB_ETB            AS LIB_ETB11_194_134_,
  etablissem136_.LIB_OFF_ETB        AS LIB_OFF_ETB12_194_134_,
  etablissem136_.LIB_WEB_ETB        AS LIB_WEB_ETB13_194_134_,
  etablissem136_.LIC_ETB            AS LIC_ETB14_194_134_,
  etablissem136_.LIM1_ETB           AS LIM15_194_134_,
  etablissem136_.LIM2_ETB           AS LIM16_194_134_,
  etablissem136_.LIM3_ETB           AS LIM17_194_134_,
  etablissem136_.NUM_ORD_ETB        AS NUM_ORD_ETB18_194_134_,
  etablissem136_.COD_PAY_ADR_ETB    AS COD_PAY_ADR_ETB28_194_134_,
  etablissem136_.COD_PRU_CHG        AS COD_PRU_CHG29_194_134_,
  etablissem136_.COD_PRU_PRL        AS COD_PRU_PRL30_194_134_,
  etablissem136_.COD_STE            AS COD_STE31_194_134_,
  etablissem136_.TEM_AUT_SIS_ETB    AS TEM_AUT_SIS_ETB19_194_134_,
  etablissem136_.TEM_CNV_ETB        AS TEM_CNV_ETB20_194_134_,
  etablissem136_.TEM_EN_SVE_ETB     AS TEM_EN_SVE_ETB21_194_134_,
  etablissem136_.TEM_MIN_ETB        AS TEM_MIN_ETB22_194_134_,
  etablissem136_.TEM_PRE_SIS_ETB    AS TEM_PRE_SIS_ETB23_194_134_,
  etablissem136_.TEM_PUB_ETB        AS TEM_PUB_ETB24_194_134_,
  etablissem136_.COD_TPE            AS COD_TPE32_194_134_,
  naturedipl137_.COD_NDI            AS COD_NDI1_285_135_,
  naturedipl137_.COD_PRI_NDI        AS COD_PRI_NDI2_285_135_,
  naturedipl137_.LIB_NDI            AS LIB_NDI3_285_135_,
  naturedipl137_.LIC_NDI            AS LIC_NDI4_285_135_,
  naturedipl137_.TEM_DEL            AS TEM_DEL5_285_135_,
  naturedipl137_.TEM_EN_SVE_NDI     AS TEM_EN_SVE_NDI6_285_135_,
  niveauinte138_.COD_NIM            AS COD_NIM1_289_136_,
  niveauinte138_.LIB_NIM            AS LIB_NIM2_289_136_,
  niveauinte138_.TEM_EN_SVE_NIM     AS TEM_EN_SVE_NIM3_289_136_,
  secdissisv139_.COD_SDS            AS COD_SDS1_363_137_,
  secdissisv139_.COD_DSI            AS COD_DSI5_363_137_,
  secdissisv139_.LIB_SDS            AS LIB_SDS2_363_137_,
  secdissisv139_.LIC_SDS            AS LIC_SDS3_363_137_,
  secdissisv139_.TEM_EN_SVE_SDS     AS TEM_EN_SVE_SDS4_363_137_,
  discipline140_.COD_DSI            AS COD_DSI1_142_138_,
  discipline140_.LIB_DSI            AS LIB_DSI2_142_138_,
  discipline140_.LIC_DSI            AS LIC_DSI3_142_138_,
  discipline140_.TEM_EN_SVE_DSI     AS TEM_EN_SVE_DSI4_142_138_,
  typdiplome141_.COD_TPD_ETB        AS COD_TPD_ETB1_492_139_,
  typdiplome141_.AGL_CUR            AS AGL_CUR2_492_139_,
  typdiplome141_.AGL_FORM           AS AGL_FORM3_492_139_,
  typdiplome141_.AGL_TEM_MAST       AS AGL_TEM_MAST4_492_139_,
  typdiplome141_.COD_ECH            AS COD_ECH5_492_139_,
  typdiplome141_.COD_TPD_SIS        AS COD_TPD_SIS6_492_139_,
  typdiplome141_.ETA_IFM            AS ETA_IFM7_492_139_,
  typdiplome141_.ETA_ING            AS ETA_ING8_492_139_,
  typdiplome141_.ETA_THS_HDR_DRT    AS ETA_THS_HDR_DRT9_492_139_,
  typdiplome141_.LIB_TPD            AS LIB_TPD10_492_139_,
  typdiplome141_.LIC_TPD            AS LIC_TPD11_492_139_,
  typdiplome141_.COD_NIF            AS COD_NIF19_492_139_,
  typdiplome141_.TEM_CRD_SIS        AS TEM_CRD_SIS12_492_139_,
  typdiplome141_.TEM_EN_SVE_TPD     AS TEM_EN_SVE_TPD13_492_139_,
  typdiplome141_.TEM_ENQ_SIS_TPD    AS TEM_ENQ_SIS_TPD14_492_139_,
  typdiplome141_.TEM_NAT_EUR        AS TEM_NAT_EUR15_492_139_,
  typdiplome141_.TEM_PREXAM         AS TEM_PREXAM16_492_139_,
  typdiplome141_.TEM_PRIOR          AS TEM_PRIOR17_492_139_,
  typdiplome141_.TEM_SANTE          AS TEM_SANTE18_492_139_,
  typdiplome141_.COD_TDS            AS COD_TDS20_492_139_,
  typdiplome141_.COD_TDS_INT        AS COD_TDS_INT21_492_139_,
  ecoledocto142_.COD_EDO            AS COD_EDO1_156_140_,
  ecoledocto142_.COD_NAT_EDO        AS COD_NAT_EDO2_156_140_,
  ecoledocto142_.LIB_EDO            AS LIB_EDO3_156_140_,
  ecoledocto142_.LIB_WEB_EDO        AS LIB_WEB_EDO4_156_140_,
  ecoledocto142_.LIC_EDO            AS LIC_EDO5_156_140_,
  ecoledocto142_.NUM_ORD_EDO        AS NUM_ORD_EDO6_156_140_,
  ecoledocto142_.TEM_EN_SVE_EDO     AS TEM_EN_SVE_EDO7_156_140_,
  ecoledocto142_.TEM_MIN_EDO        AS TEM_MIN_EDO8_156_140_,
  ecoledocto142_.TEM_PAI_WEB        AS TEM_PAI_WEB9_156_140_,
  finalitevd143_.COD_FIV            AS COD_FIV1_205_141_,
  finalitevd143_.AGL_COD_FIV        AS AGL_COD_FIV2_205_141_,
  finalitevd143_.LIB_FIV            AS LIB_FIV3_205_141_,
  finalitevd143_.TEM_EN_SVE_FIV     AS TEM_EN_SVE_FIV4_205_141_,
  mentionvdi144_.COD_MEV            AS COD_MEV1_270_142_,
  mentionvdi144_.LIB_MEV            AS LIB_MEV2_270_142_,
  mentionvdi144_.TEM_EN_SVE_MEV     AS TEM_EN_SVE_MEV3_270_142_,
  parcoursty145_.COD_PTY            AS COD_PTY1_303_143_,
  parcoursty145_.COD_SIS_PTY        AS COD_SIS_PTY2_303_143_,
  parcoursty145_.LIB_PTY            AS LIB_PTY3_303_143_,
  parcoursty145_.TEM_EN_SVE_PTY     AS TEM_EN_SVE_PTY4_303_143_,
  periodeano146_.COD_PAN            AS COD_PAN1_307_144_,
  periodeano146_.LIB_PAN            AS LIB_PAN2_307_144_,
  periodeano146_.COD_RNA            AS COD_RNA4_307_144_,
  periodeano146_.TEM_EN_SVE_PAN     AS TEM_EN_SVE_PAN3_307_144_,
  periodeano147_.COD_PAN            AS COD_PAN1_307_145_,
  periodeano147_.LIB_PAN            AS LIB_PAN2_307_145_,
  periodeano147_.COD_RNA            AS COD_RNA4_307_145_,
  periodeano147_.TEM_EN_SVE_PAN     AS TEM_EN_SVE_PAN3_307_145_,
  periodeano148_.COD_PAN            AS COD_PAN1_307_146_,
  periodeano148_.LIB_PAN            AS LIB_PAN2_307_146_,
  periodeano148_.COD_RNA            AS COD_RNA4_307_146_,
  periodeano148_.TEM_EN_SVE_PAN     AS TEM_EN_SVE_PAN3_307_146_,
  periodeano149_.COD_PAN            AS COD_PAN1_307_147_,
  periodeano149_.LIB_PAN            AS LIB_PAN2_307_147_,
  periodeano149_.COD_RNA            AS COD_RNA4_307_147_,
  periodeano149_.TEM_EN_SVE_PAN     AS TEM_EN_SVE_PAN3_307_147_,
  specialite150_.COD_SVD            AS COD_SVD1_381_148_,
  specialite150_.LIB_SVD            AS LIB_SVD2_381_148_,
  specialite150_.TEM_EN_SVE_SVD     AS TEM_EN_SVE_SVD3_381_148_,
  typresulta151_.COD_TRE            AS COD_TRE1_503_149_,
  typresulta151_.COD_NEG_TRE        AS COD_NEG_TRE2_503_149_,
  typresulta151_.COD_SIS_DIP_TRE    AS COD_SIS_DIP_TRE3_503_149_,
  typresulta151_.LIB_TRE            AS LIB_TRE4_503_149_,
  typresulta151_.LIC_TRE            AS LIC_TRE5_503_149_,
  typresulta151_.TEM_ADI_TRE        AS TEM_ADI_TRE6_503_149_,
  typresulta151_.TEM_ADO_TRE        AS TEM_ADO_TRE7_503_149_,
  typresulta151_.TEM_DEL            AS TEM_DEL8_503_149_,
  typresulta151_.TEM_ELP_TRE        AS TEM_ELP_TRE9_503_149_,
  typresulta151_.TEM_EN_SVE_TRE     AS TEM_EN_SVE_TRE10_503_149_,
  typresulta151_.TEM_EPR_TRE        AS TEM_EPR_TRE11_503_149_,
  typresulta151_.TEM_VDI_TRE        AS TEM_VDI_TRE12_503_149_,
  typresulta151_.TEM_VET_TRE        AS TEM_VET_TRE13_503_149_,
  typresulta152_.COD_TRE            AS COD_TRE1_503_150_,
  typresulta152_.COD_NEG_TRE        AS COD_NEG_TRE2_503_150_,
  typresulta152_.COD_SIS_DIP_TRE    AS COD_SIS_DIP_TRE3_503_150_,
  typresulta152_.LIB_TRE            AS LIB_TRE4_503_150_,
  typresulta152_.LIC_TRE            AS LIC_TRE5_503_150_,
  typresulta152_.TEM_ADI_TRE        AS TEM_ADI_TRE6_503_150_,
  typresulta152_.TEM_ADO_TRE        AS TEM_ADO_TRE7_503_150_,
  typresulta152_.TEM_DEL            AS TEM_DEL8_503_150_,
  typresulta152_.TEM_ELP_TRE        AS TEM_ELP_TRE9_503_150_,
  typresulta152_.TEM_EN_SVE_TRE     AS TEM_EN_SVE_TRE10_503_150_,
  typresulta152_.TEM_EPR_TRE        AS TEM_EPR_TRE11_503_150_,
  typresulta152_.TEM_VDI_TRE        AS TEM_VDI_TRE12_503_150_,
  typresulta152_.TEM_VET_TRE        AS TEM_VET_TRE13_503_150_,
  versiondip153_.COD_DIP            AS COD_DIP1_527_151_,
  versiondip153_.COD_VRS_VDI        AS COD_VRS_VDI2_527_151_,
  versiondip153_.BAR_SAI_VDI        AS BAR_SAI_VDI3_527_151_,
  versiondip153_.COD_CAR_VDI        AS COD_CAR_VDI4_527_151_,
  versiondip153_.COD_DOS_HAB_VDI    AS COD_DOS_HAB_VDI5_527_151_,
  versiondip153_.COD_ROF_VDI        AS COD_ROF_VDI6_527_151_,
  versiondip153_.COD_CFM            AS COD_CFM32_527_151_,
  versiondip153_.COD_CUR            AS COD_CUR33_527_151_,
  versiondip153_.DAA_DEB_HAB_VDI    AS DAA_DEB_HAB_VDI7_527_151_,
  versiondip153_.DAA_DEB_RCT_VDI    AS DAA_DEB_RCT_VDI8_527_151_,
  versiondip153_.DAA_DEB_VAL_VDI    AS DAA_DEB_VAL_VDI9_527_151_,
  versiondip153_.DAA_FIN_HAB_VDI    AS DAA_FIN_HAB_VDI10_527_151_,
  versiondip153_.DAA_FIN_RCT_VDI    AS DAA_FIN_RCT_VDI11_527_151_,
  versiondip153_.DAA_FIN_VAL_VDI    AS DAA_FIN_VAL_VDI12_527_151_,
  versiondip153_.COD_SIS_VDI        AS COD_SIS_VDI34_527_151_,
  versiondip153_.COD_SIS_VDI_INT    AS COD_SIS_VDI_INT35_527_151_,
  versiondip153_.DUR_ANN_VDI        AS DUR_ANN_VDI13_527_151_,
  versiondip153_.COD_EDO_VDI        AS COD_EDO_VDI36_527_151_,
  versiondip153_.COD_FIV            AS COD_FIV37_527_151_,
  versiondip153_.LIB_WEB_VDI        AS LIB_WEB_VDI14_527_151_,
  versiondip153_.LIC_VDI            AS LIC_VDI15_527_151_,
  versiondip153_.LIM1_VDI           AS LIM16_527_151_,
  versiondip153_.LIM2_VDI           AS LIM17_527_151_,
  versiondip153_.LIM3_VDI           AS LIM18_527_151_,
  versiondip153_.COD_MEV            AS COD_MEV38_527_151_,
  versiondip153_.NBR_ADM_VDI        AS NBR_ADM_VDI19_527_151_,
  versiondip153_.NBR_CRD_VDI        AS NBR_CRD_VDI20_527_151_,
  versiondip153_.NBR_MAX_SPE_VDI    AS NBR_MAX_SPE_VDI21_527_151_,
  versiondip153_.NBR_MIN_SPE_VDI    AS NBR_MIN_SPE_VDI22_527_151_,
  versiondip153_.COD_PTY            AS COD_PTY39_527_151_,
  versiondip153_.COD_PAN_1          AS COD_PAN_40_527_151_,
  versiondip153_.COD_PAN_2          AS COD_PAN_41_527_151_,
  versiondip153_.COD_PAN_3          AS COD_PAN_42_527_151_,
  versiondip153_.COD_PAN_4          AS COD_PAN_43_527_151_,
  versiondip153_.COD_SVD            AS COD_SVD44_527_151_,
  versiondip153_.TEM_ADI            AS TEM_ADI23_527_151_,
  versiondip153_.TEM_ADO            AS TEM_ADO24_527_151_,
  versiondip153_.TEM_JUR_VDI        AS TEM_JUR_VDI25_527_151_,
  versiondip153_.TEM_MND_VDI        AS TEM_MND_VDI26_527_151_,
  versiondip153_.TEM_NOT_VDI        AS TEM_NOT_VDI27_527_151_,
  versiondip153_.TEM_PNT_JUR_VDI    AS TEM_PNT_JUR_VDI28_527_151_,
  versiondip153_.TEM_RES_THS_VDI    AS TEM_RES_THS_VDI29_527_151_,
  versiondip153_.TEM_RES_VDI        AS TEM_RES_VDI30_527_151_,
  versiondip153_.TEM_SES_UNI        AS TEM_SES_UNI31_527_151_,
  versiondip153_.COD_TRE_NEG        AS COD_TRE_NEG45_527_151_,
  versiondip153_.COD_TRE_POS        AS COD_TRE_POS46_527_151_,
  (
    SELECT
      typ.ETA_THS_HDR_DRT
    FROM
      DIPLOME dip,
      TYP_DIPLOME typ
    WHERE
      dip.COD_DIP      =versiondip153_.COD_DIP
    AND dip.COD_TPD_ETB=typ.COD_TPD_ETB
  )                                     AS formula14_151_,
  versioneta154_.COD_ETP                AS COD_ETP1_528_152_,
  versioneta154_.COD_VRS_VET            AS COD_VRS_VET2_528_152_,
  versioneta154_.COD_CPG                AS COD_CPG43_528_152_,
  versioneta154_.BAR_SAI_VET            AS BAR_SAI_VET3_528_152_,
  versioneta154_.COD_CGE_MIN_VET        AS COD_CGE_MIN_VET44_528_152_,
  versioneta154_.COD_CGE_MINP_VET       AS COD_CGE_MINP_VET4_528_152_,
  versioneta154_.COD_CIP_ADIP_VET       AS COD_CIP_ADIP_VET5_528_152_,
  versioneta154_.COD_CMP                AS COD_CMP45_528_152_,
  versioneta154_.COD_CFM                AS COD_CFM46_528_152_,
  versioneta154_.COD_CNV                AS COD_CNV47_528_152_,
  versioneta154_.DAT_DEB_DEF_PACES_REE  AS DAT_DEB_DEF_PACES_6_528_152_,
  versioneta154_.DAT_DEB_MIN_VET        AS DAT_DEB_MIN_VET7_528_152_,
  versioneta154_.DAT_DEB_MINP_VET       AS DAT_DEB_MINP_VET8_528_152_,
  versioneta154_.DAT_DEB_PACES_REE      AS DAT_DEB_PACES_REE9_528_152_,
  versioneta154_.DAT_DEB_PACES_SIM      AS DAT_DEB_PACES_SIM10_528_152_,
  versioneta154_.DAT_DEB_PROV_PACES_REE AS DAT_DEB_PROV_PACE11_528_152_,
  versioneta154_.DAT_DEB_PROV_PACES_SIM AS DAT_DEB_PROV_PACE12_528_152_,
  versioneta154_.DAT_FIN_DEF_PACES_REE  AS DAT_FIN_DEF_PACES13_528_152_,
  versioneta154_.DAT_FIN_MIN_VET        AS DAT_FIN_MIN_VET14_528_152_,
  versioneta154_.DAT_FIN_MINP_VET       AS DAT_FIN_MINP_VET15_528_152_,
  versioneta154_.DAT_FIN_PACES_REE      AS DAT_FIN_PACES_REE16_528_152_,
  versioneta154_.DAT_FIN_PACES_SIM      AS DAT_FIN_PACES_SIM17_528_152_,
  versioneta154_.DAT_FIN_PROV_PACES_REE AS DAT_FIN_PROV_PACE18_528_152_,
  versioneta154_.DAT_FIN_PROV_PACES_SIM AS DAT_FIN_PROV_PACE19_528_152_,
  versioneta154_.COD_DUE                AS COD_DUE48_528_152_,
  versioneta154_.COD_ESI                AS COD_ESI49_528_152_,
  versioneta154_.GRP_PACES_VET          AS GRP_PACES_VET20_528_152_,
  versioneta154_.LIB_CMT_VET            AS LIB_CMT_VET21_528_152_,
  versioneta154_.LIB_WEB_VET            AS LIB_WEB_VET22_528_152_,
  versioneta154_.LIM1_VET               AS LIM23_528_152_,
  versioneta154_.LIM2_VET               AS LIM24_528_152_,
  versioneta154_.LIM3_VET               AS LIM25_528_152_,
  versioneta154_.NBR_ADM_VET            AS NBR_ADM_VET26_528_152_,
  versioneta154_.NBR_CRD_VET            AS NBR_CRD_VET27_528_152_,
  versioneta154_.NBR_VOL_HOR_VET        AS NBR_VOL_HOR_VET28_528_152_,
  versioneta154_.COD_PTY                AS COD_PTY50_528_152_,
  versioneta154_.COD_PAN_1              AS COD_PAN_51_528_152_,
  versioneta154_.COD_PAN_2              AS COD_PAN_52_528_152_,
  versioneta154_.COD_PAN_3              AS COD_PAN_53_528_152_,
  versioneta154_.COD_PAN_4              AS COD_PAN_54_528_152_,
  versioneta154_.TEM_ADI                AS TEM_ADI29_528_152_,
  versioneta154_.TEM_ADO                AS TEM_ADO30_528_152_,
  versioneta154_.TEM_DIP_VET            AS TEM_DIP_VET31_528_152_,
  versioneta154_.TEM_HEB_VET            AS TEM_HEB_VET32_528_152_,
  versioneta154_.TEM_JUR_VET            AS TEM_JUR_VET33_528_152_,
  versioneta154_.TEM_MND_VET            AS TEM_MND_VET34_528_152_,
  versioneta154_.TEM_NOT_VET            AS TEM_NOT_VET35_528_152_,
  versioneta154_.TEM_OPI_MIN_VET        AS TEM_OPI_MIN_VET36_528_152_,
  versioneta154_.TEM_PMT_3F_VET_WEB     AS TEM_PMT_37_528_152_,
  versioneta154_.TEM_PNT_JUR_VET        AS TEM_PNT_JUR_VET38_528_152_,
  versioneta154_.TEM_REINS_SANS_DELIB   AS TEM_REINS_SANS_DE39_528_152_,
  versioneta154_.TEM_RES_VET            AS TEM_RES_VET40_528_152_,
  versioneta154_.TEM_SES_UNI            AS TEM_SES_UNI41_528_152_,
  versioneta154_.TEM_TLS_VET            AS TEM_TLS_VET42_528_152_,
  versioneta154_.COD_TRE_NEG            AS COD_TRE_NEG55_528_152_,
  versioneta154_.COD_TRE_POS            AS COD_TRE_POS56_528_152_
FROM
  CARACT_IAE_IND this_
LEFT OUTER JOIN ETABLISSEMENT etablissem2_
ON
  this_.COD_ETB_PI_1=etablissem2_.COD_ETB
LEFT OUTER JOIN COM_BDI combdivo3_
ON
  etablissem2_.COD_POS_ADR_ETB  =combdivo3_.COD_BDI
AND etablissem2_.COD_COM_ADR_ETB=combdivo3_.COD_COM
LEFT OUTER JOIN BUREAU_DIS bureaudisv4_
ON
  combdivo3_.COD_BDI=bureaudisv4_.COD_BDI
LEFT OUTER JOIN COMMUNE communevo5_
ON
  combdivo3_.COD_COM=communevo5_.COD_COM
LEFT OUTER JOIN DEPARTEMENT departemen6_
ON
  communevo5_.COD_DEP=departemen6_.COD_DEP
LEFT OUTER JOIN ACADEMIE academievo7_
ON
  departemen6_.COD_ACD=academievo7_.COD_ACD
LEFT OUTER JOIN COMMUNE communevo8_
ON
  etablissem2_.COD_COM_ADR_ETB=communevo8_.COD_COM
LEFT OUTER JOIN DEPARTEMENT departemen9_
ON
  etablissem2_.COD_DEP=departemen9_.COD_DEP
LEFT OUTER JOIN PAYS paysvo10_
ON
  etablissem2_.COD_PAY_ADR_ETB=paysvo10_.COD_PAY
LEFT OUTER JOIN PROFIL_ETU profiletuv11_
ON
  etablissem2_.COD_PRU_CHG=profiletuv11_.COD_PRU
LEFT OUTER JOIN PROFIL_ETU profiletuv12_
ON
  etablissem2_.COD_PRU_PRL=profiletuv12_.COD_PRU
LEFT OUTER JOIN STATUT_ETB statutetbv13_
ON
  etablissem2_.COD_STE=statutetbv13_.COD_STE
LEFT OUTER JOIN TYP_ETB typetbvo14_
ON
  etablissem2_.COD_TPE=typetbvo14_.COD_TPE
LEFT OUTER JOIN PROFIL_ETU profiletuv15_
ON
  typetbvo14_.COD_PRU_CHG=profiletuv15_.COD_PRU
LEFT OUTER JOIN PROFIL_ETU profiletuv16_
ON
  typetbvo14_.COD_PRU_PRL=profiletuv16_.COD_PRU
LEFT OUTER JOIN ETABLISSEMENT etablissem17_
ON
  this_.COD_ETB_PI_2=etablissem17_.COD_ETB
LEFT OUTER JOIN ETABLISSEMENT etablissem18_
ON
  this_.COD_ETB_PI_3=etablissem18_.COD_ETB
LEFT OUTER JOIN ETABLISSEMENT etablissem19_
ON
  this_.COD_ETB_PI_4=etablissem19_.COD_ETB
LEFT OUTER JOIN INS_ADM_ETP insadmetpv20_
ON
  this_.COD_ANU      =insadmetpv20_.COD_ANU
AND this_.COD_ETP    =insadmetpv20_.COD_ETP
AND this_.COD_IND    =insadmetpv20_.COD_IND
AND this_.COD_VRS_VET=insadmetpv20_.COD_VRS_VET
AND this_.NUM_OCC_IAE=insadmetpv20_.NUM_OCC_IAE
LEFT OUTER JOIN BOURSE boursevo21_
ON
  insadmetpv20_.COD_BRS=boursevo21_.COD_BRS
LEFT OUTER JOIN SIT_SOCIALE sitsociale22_
ON
  boursevo21_.COD_SOC=sitsociale22_.COD_SOC
LEFT OUTER JOIN CENTRE_GESTION centregest23_
ON
  insadmetpv20_.COD_CGE=centregest23_.COD_CGE
LEFT OUTER JOIN COM_BDI combdivo24_
ON
  centregest23_.COD_POS_ADR_CGE  =combdivo24_.COD_BDI
AND centregest23_.COD_COM_ADR_CGE=combdivo24_.COD_COM
LEFT OUTER JOIN CPAM cpamvo25_
ON
  centregest23_.COD_CPA=cpamvo25_.COD_CPA
LEFT OUTER JOIN COM_BDI combdivo26_
ON
  cpamvo25_.COD_POS_ADR_CPA  =combdivo26_.COD_BDI
AND cpamvo25_.COD_COM_ADR_CPA=combdivo26_.COD_COM
LEFT OUTER JOIN COMPOSANTE composante27_
ON
  insadmetpv20_.COD_CMP=composante27_.COD_CMP
LEFT OUTER JOIN COM_BDI combdivo28_
ON
  composante27_.COD_POS_ADR_CMP  =combdivo28_.COD_BDI
AND composante27_.COD_COM_ADR_CMP=combdivo28_.COD_COM
LEFT OUTER JOIN SIGNATAIRE signataire29_
ON
  composante27_.COD_SIG=signataire29_.COD_SIG
LEFT OUTER JOIN TYP_COMPOSANTE typcomposa30_
ON
  composante27_.COD_TPC=typcomposa30_.COD_TPC
LEFT OUTER JOIN SITUATION_SISE situations31_
ON
  typcomposa30_.COD_SIS=situations31_.COD_SIS
LEFT OUTER JOIN DIP_AUT_CUR dipautcurv32_
ON
  insadmetpv20_.COD_DAC_ACC=dipautcurv32_.COD_DAC
LEFT OUTER JOIN ECOLE_DOCTORALE ecoledocto33_
ON
  insadmetpv20_.COD_EDO_IAE=ecoledocto33_.COD_EDO
LEFT OUTER JOIN ETABLISSEMENT etablissem34_
ON
  insadmetpv20_.COD_ETB_IFM_1=etablissem34_.COD_ETB
LEFT OUTER JOIN ETABLISSEMENT etablissem35_
ON
  insadmetpv20_.COD_ETB_IFM_2=etablissem35_.COD_ETB
LEFT OUTER JOIN INS_ADM_ANU insadmanuv36_
ON
  insadmetpv20_.COD_ANU  =insadmanuv36_.COD_ANU
AND insadmetpv20_.COD_IND=insadmanuv36_.COD_IND
LEFT OUTER JOIN AIDE_FINANCIERE aidefinanc37_
ON
  insadmanuv36_.COD_AFI=aidefinanc37_.COD_AFI
LEFT OUTER JOIN ANNEE_UNI anneeunivo38_
ON
  insadmanuv36_.COD_ANU=anneeunivo38_.COD_ANU
LEFT OUTER JOIN ASS_RSP_CIV assrspcivv39_
ON
  insadmanuv36_.COD_ASR=assrspcivv39_.COD_ASR
LEFT OUTER JOIN CAT_SOC_PFL catsocpflv40_
ON
  insadmanuv36_.COD_PCS_ETUDIANT=catsocpflv40_.COD_PCS
LEFT OUTER JOIN CAT_SOC_PFL catsocpflv41_
ON
  insadmanuv36_.COD_PCS_PARENT=catsocpflv41_.COD_PCS
LEFT OUTER JOIN CAT_SOC_PFL catsocpflv42_
ON
  insadmanuv36_.COD_PCS_PARENT_AUTRE=catsocpflv42_.COD_PCS
LEFT OUTER JOIN CENTRE_PAYEUR centrepaye43_
ON
  insadmanuv36_.COD_CTP=centrepaye43_.COD_CTP
LEFT OUTER JOIN COM_BDI combdivo44_
ON
  centrepaye43_.COD_POS_ADR_CTP  =combdivo44_.COD_BDI
AND centrepaye43_.COD_COM_ADR_CTP=combdivo44_.COD_COM
LEFT OUTER JOIN MUTUELLE mutuellevo45_
ON
  centrepaye43_.COD_MUT=mutuellevo45_.COD_MUT
LEFT OUTER JOIN COM_BDI combdivo46_
ON
  mutuellevo45_.COD_POS_ADR_MUT  =combdivo46_.COD_BDI
AND mutuellevo45_.COD_COM_ADR_MUT=combdivo46_.COD_COM
LEFT OUTER JOIN CPAM cpamvo47_
ON
  insadmanuv36_.COD_CPA=cpamvo47_.COD_CPA
LEFT OUTER JOIN DEPARTEMENT departemen48_
ON
  insadmanuv36_.COD_DEP_ANN_PRE=departemen48_.COD_DEP
LEFT OUTER JOIN DEPARTEMENT departemen49_
ON
  insadmanuv36_.COD_DEP_ANT=departemen49_.COD_DEP
LEFT OUTER JOIN DOMAINE_ACT_PFL domaineact50_
ON
  insadmanuv36_.COD_DAP=domaineact50_.COD_DAP
LEFT OUTER JOIN DROIT droitvo51_
ON
  insadmanuv36_.COD_DRT_MUT=droitvo51_.COD_DRT
LEFT OUTER JOIN MUTUELLE mutuellevo52_
ON
  droitvo51_.COD_MUT=mutuellevo52_.COD_MUT
LEFT OUTER JOIN NIV_REGROUP nivregroup53_
ON
  droitvo51_.COD_NRG=nivregroup53_.COD_NRG
LEFT OUTER JOIN TYP_DROIT typdroitvo54_
ON
  droitvo51_.COD_TDR=typdroitvo54_.COD_TDR
LEFT OUTER JOIN ETABLISSEMENT etablissem55_
ON
  insadmanuv36_.COD_ETB_ANN_PRE=etablissem55_.COD_ETB
LEFT OUTER JOIN ETABLISSEMENT etablissem56_
ON
  insadmanuv36_.COD_ETB_ANT=etablissem56_.COD_ETB
LEFT OUTER JOIN ETABLISSEMENT etablissem57_
ON
  insadmanuv36_.COD_ETB_DER_DPL=etablissem57_.COD_ETB
LEFT OUTER JOIN ETABLISSEMENT etablissem58_
ON
  insadmanuv36_.COD_ETB_PRL_CHG=etablissem58_.COD_ETB
LEFT OUTER JOIN ETABLISSEMENT etablissem59_
ON
  insadmanuv36_.COD_ETB_TPT=etablissem59_.COD_ETB
LEFT OUTER JOIN ETABLISSEMENT etablissem60_
ON
  insadmanuv36_.COD_ETR=etablissem60_.COD_ETB
LEFT OUTER JOIN INDIVIDU individuvo61_
ON
  insadmanuv36_.COD_IND=individuvo61_.COD_IND
LEFT OUTER JOIN MTF_AFL_SSO mtfaflssov62_
ON
  insadmanuv36_.COD_MFS=mtfaflssov62_.COD_MFS
LEFT OUTER JOIN MTF_NON_AFL_SSO mtfnonafls63_
ON
  insadmanuv36_.COD_MNS=mtfnonafls63_.COD_MNS
LEFT OUTER JOIN PRG_ECHANGE prgechange64_
ON
  insadmanuv36_.COD_PRG      =prgechange64_.COD_PRG
AND insadmanuv36_.TEM_SNS_PRG=prgechange64_.TEM_SNS_PRG
LEFT OUTER JOIN PROFIL_ETU profiletuv65_
ON
  prgechange64_.COD_PRU=profiletuv65_.COD_PRU
LEFT OUTER JOIN PROFIL_ETU profiletuv66_
ON
  insadmanuv36_.COD_PRU=profiletuv66_.COD_PRU
LEFT OUTER JOIN QUOTITE_TRA quotitetra67_
ON
  insadmanuv36_.COD_QTR=quotitetra67_.COD_QTR
LEFT OUTER JOIN REGIME_INS regimeinsv68_
ON
  insadmanuv36_.COD_RGI=regimeinsv68_.COD_RGI
LEFT OUTER JOIN REGIME_SSO regimessov69_
ON
  insadmanuv36_.COD_RSS=regimessov69_.COD_RSS
LEFT OUTER JOIN SIT_SOCIALE sitsociale70_
ON
  insadmanuv36_.COD_SOC=sitsociale70_.COD_SOC
LEFT OUTER JOIN SITUATION_SISE situations71_
ON
  insadmanuv36_.COD_SIS_ANN_PRE=situations71_.COD_SIS
LEFT OUTER JOIN SPO_HAU_NIV spohaunivv72_
ON
  insadmanuv36_.COD_SPO=spohaunivv72_.COD_SPO
LEFT OUTER JOIN STATUT_ETU statutetuv73_
ON
  insadmanuv36_.COD_STU=statutetuv73_.COD_STU
LEFT OUTER JOIN PROFIL_ETU profiletuv74_
ON
  statutetuv73_.COD_PRU=profiletuv74_.COD_PRU
LEFT OUTER JOIN TYP_DIPLOME_EXT typdiplome75_
ON
  insadmanuv36_.COD_TDE_DER_DPL=typdiplome75_.COD_TDE
LEFT OUTER JOIN TYP_DIPLOME_SISE typdiplome76_
ON
  typdiplome75_.COD_TDS=typdiplome76_.COD_TDS
LEFT OUTER JOIN TYP_DIPLOME typdiplome77_
ON
  typdiplome75_.COD_TPD_ETB=typdiplome77_.COD_TPD_ETB
LEFT OUTER JOIN NIVEAU_FORMATION niveauform78_
ON
  typdiplome77_.COD_NIF=niveauform78_.COD_NIF
LEFT OUTER JOIN TYP_DIPLOME_SISE typdiplome79_
ON
  typdiplome77_.COD_TDS=typdiplome79_.COD_TDS
LEFT OUTER JOIN TYP_DIPLOME_SISE typdiplome80_
ON
  typdiplome77_.COD_TDS_INT=typdiplome80_.COD_TDS
LEFT OUTER JOIN TYP_DIPLOME_SISE typdiplome81_
ON
  insadmanuv36_.COD_TDS_ANN_PRE=typdiplome81_.COD_TDS
LEFT OUTER JOIN TYP_ETB typetbvo82_
ON
  insadmanuv36_.COD_TPE_ANT=typetbvo82_.COD_TPE
LEFT OUTER JOIN TYP_ETB typetbvo83_
ON
  insadmanuv36_.COD_TPE_PRL_CHG=typetbvo83_.COD_TPE
LEFT OUTER JOIN UTILISATEUR utilisateu84_
ON
  insadmanuv36_.COD_UTI=utilisateu84_.COD_UTI
LEFT OUTER JOIN CENTRE_GESTION centregest85_
ON
  utilisateu84_.COD_CGE=centregest85_.COD_CGE
LEFT OUTER JOIN CENTRE_INCOMP centreinco86_
ON
  utilisateu84_.COD_CIN=centreinco86_.COD_CIN
LEFT OUTER JOIN CENTRE_INS_PED centreinsp87_
ON
  utilisateu84_.COD_CIP=centreinsp87_.COD_CIP
LEFT OUTER JOIN IMPRIMANTE imprimante88_
ON
  utilisateu84_.COD_IMP=imprimante88_.COD_IMP
LEFT OUTER JOIN TYP_UTILISATEUR typutilisa89_
ON
  utilisateu84_.COD_TUT=typutilisa89_.COD_TUT
LEFT OUTER JOIN LOGIN_BATCH loginbatch90_
ON
  utilisateu84_.COD_UTI=loginbatch90_.COD_UTI
LEFT OUTER JOIN UTILISATEUR utilisateu91_
ON
  loginbatch90_.COD_UTI=utilisateu91_.COD_UTI
LEFT OUTER JOIN UTILISATEUR utilisateu92_
ON
  insadmanuv36_.COD_UTI_MOD=utilisateu92_.COD_UTI
LEFT OUTER JOIN INS_PEDAGOGI_ETP inspedagog93_
ON
  insadmetpv20_.COD_ANU      =inspedagog93_.COD_ANU
AND insadmetpv20_.COD_ETP    =inspedagog93_.COD_ETP
AND insadmetpv20_.COD_IND    =inspedagog93_.COD_IND
AND insadmetpv20_.COD_VRS_VET=inspedagog93_.COD_VRS_VET
LEFT OUTER JOIN FORMULE_EXAMEN formuleexa94_
ON
  inspedagog93_.COD_FEX=formuleexa94_.COD_FEX
LEFT OUTER JOIN INS_PEDAGOGI_ANU inspedagog95_
ON
  inspedagog93_.COD_ANU  =inspedagog95_.COD_ANU
AND inspedagog93_.COD_IND=inspedagog95_.COD_IND
LEFT OUTER JOIN ANNEE_UNI anneeunivo96_
ON
  inspedagog95_.COD_ANU=anneeunivo96_.COD_ANU
LEFT OUTER JOIN INDIVIDU individuvo97_
ON
  inspedagog95_.COD_IND=individuvo97_.COD_IND
LEFT OUTER JOIN UTILISATEUR utilisateu98_
ON
  inspedagog93_.COD_UTI=utilisateu98_.COD_UTI
LEFT OUTER JOIN UTILISATEUR utilisateu99_
ON
  inspedagog93_.COD_UTI_ACC=utilisateu99_.COD_UTI
LEFT OUTER JOIN UTILISATEUR utilisateu100_
ON
  inspedagog93_.COD_UTI_MOD=utilisateu100_.COD_UTI
LEFT OUTER JOIN VERSION_ETAPE versioneta101_
ON
  inspedagog93_.COD_ETP      =versioneta101_.COD_ETP
AND inspedagog93_.COD_VRS_VET=versioneta101_.COD_VRS_VET
LEFT OUTER JOIN ADIP_CAMPAGNE adipcampag102_
ON
  versioneta101_.COD_CPG=adipcampag102_.COD_CPG
LEFT OUTER JOIN CENTRE_GESTION centregest103_
ON
  versioneta101_.COD_CGE_MIN_VET=centregest103_.COD_CGE
LEFT OUTER JOIN COMPOSANTE composante104_
ON
  versioneta101_.COD_CMP=composante104_.COD_CMP
LEFT OUTER JOIN CONFIG_MENTION configment105_
ON
  versioneta101_.COD_CFM=configment105_.COD_CFM
LEFT OUTER JOIN CONVENTION convention106_
ON
  versioneta101_.COD_CNV=convention106_.COD_CNV
LEFT OUTER JOIN DUREE_ETAPE dureeetape107_
ON
  versioneta101_.COD_DUE=dureeetape107_.COD_DUE
LEFT OUTER JOIN ETAPE_SIS etapesisvo108_
ON
  versioneta101_.COD_ESI=etapesisvo108_.COD_ESI
LEFT OUTER JOIN ETAPE etapevo109_
ON
  versioneta101_.COD_ETP=etapevo109_.COD_ETP
LEFT OUTER JOIN ACTION_LOLF actionlolf110_
ON
  etapevo109_.COD_ACT=actionlolf110_.COD_ACT
LEFT OUTER JOIN CURSUS_LMD cursuslmdv111_
ON
  etapevo109_.COD_CUR=cursuslmdv111_.COD_CUR
LEFT OUTER JOIN CYCLE cyclevo112_
ON
  etapevo109_.COD_CYC=cyclevo112_.COD_CYC
LEFT OUTER JOIN PARCOURS_TYPE parcoursty113_
ON
  versioneta101_.COD_PTY=parcoursty113_.COD_PTY
LEFT OUTER JOIN PERIODE_ANO periodeano114_
ON
  versioneta101_.COD_PAN_1=periodeano114_.COD_PAN
LEFT OUTER JOIN REGLE_NUM_ANO reglenuman115_
ON
  periodeano114_.COD_RNA=reglenuman115_.COD_RNA
LEFT OUTER JOIN PERIODE_ANO periodeano116_
ON
  versioneta101_.COD_PAN_2=periodeano116_.COD_PAN
LEFT OUTER JOIN PERIODE_ANO periodeano117_
ON
  versioneta101_.COD_PAN_3=periodeano117_.COD_PAN
LEFT OUTER JOIN PERIODE_ANO periodeano118_
ON
  versioneta101_.COD_PAN_4=periodeano118_.COD_PAN
LEFT OUTER JOIN TYP_RESULTAT typresulta119_
ON
  versioneta101_.COD_TRE_NEG=typresulta119_.COD_TRE
LEFT OUTER JOIN TYP_RESULTAT typresulta120_
ON
  versioneta101_.COD_TRE_POS=typresulta120_.COD_TRE
LEFT OUTER JOIN PROFIL_ETU profiletuv121_
ON
  insadmetpv20_.COD_PRU=profiletuv121_.COD_PRU
LEFT OUTER JOIN REGIME_INS regimeinsv122_
ON
  insadmetpv20_.COD_RGE=regimeinsv122_.COD_RGI
LEFT OUTER JOIN TELE_ENSEIGNEMENT_MODE teleenseig123_
ON
  insadmetpv20_.COD_TLS=teleenseig123_.COD_TLS
LEFT OUTER JOIN TYP_CPGE typcpgevo124_
ON
  insadmetpv20_.COD_TYP_CPG=typcpgevo124_.COD_TYP_CPG
LEFT OUTER JOIN UTILISATEUR utilisateu125_
ON
  insadmetpv20_.COD_UTI=utilisateu125_.COD_UTI
LEFT OUTER JOIN UTILISATEUR utilisateu126_
ON
  insadmetpv20_.COD_UTI_ACC=utilisateu126_.COD_UTI
LEFT OUTER JOIN UTILISATEUR utilisateu127_
ON
  insadmetpv20_.COD_UTI_MOD=utilisateu127_.COD_UTI
LEFT OUTER JOIN VERSION_DIPLOME versiondip128_
ON
  insadmetpv20_.COD_DIP      =versiondip128_.COD_DIP
AND insadmetpv20_.COD_VRS_VDI=versiondip128_.COD_VRS_VDI
LEFT OUTER JOIN CONFIG_MENTION configment129_
ON
  versiondip128_.COD_CFM=configment129_.COD_CFM
LEFT OUTER JOIN CURSUS_LMD cursuslmdv130_
ON
  versiondip128_.COD_CUR=cursuslmdv130_.COD_CUR
LEFT OUTER JOIN DIPLOME_SISE diplomesis131_
ON
  versiondip128_.COD_SIS_VDI=diplomesis131_.COD_DIS
LEFT OUTER JOIN DIPLOME_SISE diplomesis132_
ON
  versiondip128_.COD_SIS_VDI_INT=diplomesis132_.COD_DIS
LEFT OUTER JOIN DIPLOME diplomevo133_
ON
  versiondip128_.COD_DIP=diplomevo133_.COD_DIP
LEFT OUTER JOIN CYCLE cyclevo134_
ON
  diplomevo133_.COD_CYC=cyclevo134_.COD_CYC
LEFT OUTER JOIN DOMAINE_FORMATION_DIP domainefor135_
ON
  diplomevo133_.COD_DFD=domainefor135_.COD_DFD
LEFT OUTER JOIN ETABLISSEMENT etablissem136_
ON
  diplomevo133_.COD_ETB=etablissem136_.COD_ETB
LEFT OUTER JOIN NATURE_DIPLOME naturedipl137_
ON
  diplomevo133_.COD_NDI=naturedipl137_.COD_NDI
LEFT OUTER JOIN NIVEAU_INTERMINI niveauinte138_
ON
  diplomevo133_.COD_NIM=niveauinte138_.COD_NIM
LEFT OUTER JOIN SEC_DIS_SIS secdissisv139_
ON
  diplomevo133_.COD_SDS=secdissisv139_.COD_SDS
LEFT OUTER JOIN DISCIPLINE_SIS discipline140_
ON
  secdissisv139_.COD_DSI=discipline140_.COD_DSI
LEFT OUTER JOIN TYP_DIPLOME typdiplome141_
ON
  diplomevo133_.COD_TPD_ETB=typdiplome141_.COD_TPD_ETB
LEFT OUTER JOIN ECOLE_DOCTORALE ecoledocto142_
ON
  versiondip128_.COD_EDO_VDI=ecoledocto142_.COD_EDO
LEFT OUTER JOIN FINALITE_VDI finalitevd143_
ON
  versiondip128_.COD_FIV=finalitevd143_.COD_FIV
LEFT OUTER JOIN MENTION_VDI mentionvdi144_
ON
  versiondip128_.COD_MEV=mentionvdi144_.COD_MEV
LEFT OUTER JOIN PARCOURS_TYPE parcoursty145_
ON
  versiondip128_.COD_PTY=parcoursty145_.COD_PTY
LEFT OUTER JOIN PERIODE_ANO periodeano146_
ON
  versiondip128_.COD_PAN_1=periodeano146_.COD_PAN
LEFT OUTER JOIN PERIODE_ANO periodeano147_
ON
  versiondip128_.COD_PAN_2=periodeano147_.COD_PAN
LEFT OUTER JOIN PERIODE_ANO periodeano148_
ON
  versiondip128_.COD_PAN_3=periodeano148_.COD_PAN
LEFT OUTER JOIN PERIODE_ANO periodeano149_
ON
  versiondip128_.COD_PAN_4=periodeano149_.COD_PAN
LEFT OUTER JOIN SPECIALITE_VDI specialite150_
ON
  versiondip128_.COD_SVD=specialite150_.COD_SVD
LEFT OUTER JOIN TYP_RESULTAT typresulta151_
ON
  versiondip128_.COD_TRE_NEG=typresulta151_.COD_TRE
LEFT OUTER JOIN TYP_RESULTAT typresulta152_
ON
  versiondip128_.COD_TRE_POS=typresulta152_.COD_TRE
LEFT OUTER JOIN VERSION_DIPLOME versiondip153_
ON
  insadmetpv20_.COD_DIP_ACC      =versiondip153_.COD_DIP
AND insadmetpv20_.COD_VRS_VDI_ACC=versiondip153_.COD_VRS_VDI
LEFT OUTER JOIN VERSION_ETAPE versioneta154_
ON
  insadmetpv20_.COD_ETP      =versioneta154_.COD_ETP
AND insadmetpv20_.COD_VRS_VET=versioneta154_.COD_VRS_VET
WHERE
  this_.COD_ANU      ='2015'
AND this_.COD_IND    ='121151'
AND this_.COD_ETP    ='TLMH10'
AND this_.COD_VRS_VET='300'
AND this_.NUM_OCC_IAE='E'