hdh-spark-job - Details for Query 756

Submitted Time: 2026/10/21 21:36:52
Duration: 6 s
Succeeded Jobs: 753 757

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 4.7 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 4.7 s number of output rows: 1"]; } 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; 8 [labelType="html" label="Scan parquet number of output rows: 34,041 number of files read: 1 metadata time: 0 ms size of files read: 1490.8 KiB"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=15692]

HashAggregate(keys=[], functions=[partial_count(1)])

WholeStageCodegen (1)

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_437435#165398)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_437435#165398)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_437436#165395)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_437436#165395)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMED_437437#165241)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMED_437437#165241)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATRV_437438#165295)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATRV_437438#165295)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCOM_437439#165304)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCOM_437439#165304)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URGEN_437440#165470)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_URGEN_437440#165470)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ASTREI_437441#165225)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ASTREI_437441#165225)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUIT_437442#165384)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUIT_437442#165384)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FERIE_437443#165319)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FERIE_437443#165319)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORFAI_437444#165355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORFAI_437444#165355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IRM_437445#165369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_IRM_437445#165369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_LO_437446#165314)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_LO_437446#165314)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ECHO_437447#165309)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ECHO_437447#165309)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANGIO_437448#165223)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANGIO_437448#165223)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_AUTR_437449#165228)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_AUTR_437449#165228)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSER_437450#165249)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSER_437450#165249)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODC_A_437451#165234)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODC_A_437451#165234)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SIGMA_437452#165449)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SIGMA_437452#165449)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LIBEL_437453#165370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_LIBEL_437453#165370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VALID_437454#165472)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_VALID_437454#165472)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATURE_437455#165381)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATURE_437455#165381)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ETAPE_437456#165313)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ETAPE_437456#165313)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATCR_437457#165458)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATCR_437457#165458)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CR_437458#165445)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CR_437458#165445)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_F_437459#165446)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_F_437459#165446)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CR_437460#165307)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CR_437460#165307)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_F_437461#165308)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_F_437461#165308)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCLO_437462#165303)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCLO_437462#165303)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMM_1_437463#165265)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMM_1_437463#165265)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GROUPE_437464#165357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_GROUPE_437464#165357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANNVAL_437465#165224)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANNVAL_437465#165224)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MONNAIE_437466#165374)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MONNAIE_437466#165374)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_437467#165317)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_437467#165317)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACCON_437468#165316)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACCON_437468#165316)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_M_FORF_437469#165379)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_M_FORF_437469#165379)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_437470#165422)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_437470#165422)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARCAI_437471#165417)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARCAI_437471#165417)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUCAI_437472#165463)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUCAI_437472#165463)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_437473#165419)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_437473#165419)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUMUT_437474#165464)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUMUT_437474#165464)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARFOR_437475#165418)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARFOR_437475#165418)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_437476#165434)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_437476#165434)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGCAI_437477#165431)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGCAI_437477#165431)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGMUT_437478#165433)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGMUT_437478#165433)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGFOR_437479#165432)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGFOR_437479#165432)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_A_R_437480#165443)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_A_R_437480#165443)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_437481#165386)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_437481#165386)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_437482#165389)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_437482#165389)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOF_437483#165388)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOF_437483#165388)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_437484#165393)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_437484#165393)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMMUT_437485#165404)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMMUT_437485#165404)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFOR_437486#165402)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFOR_437486#165402)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATF_D_437487#165289)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATF_D_437487#165289)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCSS_437488#165283)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCSS_437488#165283)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DAT100_437489#165277)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DAT100_437489#165277)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATARR_437490#165280)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATARR_437490#165280)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUARR_437491#165358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUARR_437491#165358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCOT_437492#165281)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCOT_437492#165281)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUCOT_437493#165359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUCOT_437493#165359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAL_437494#165414)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAL_437494#165414)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN1_437495#165447)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN1_437495#165447)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN2_437496#165448)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN2_437496#165448)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSEC_437497#165248)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSEC_437497#165248)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSRV_437498#165259)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSRV_437498#165259)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENC_437499#165236)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENC_437499#165236)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODTIT_437500#165261)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODTIT_437500#165261)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODDIC_437501#165235)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODDIC_437501#165235)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOI_437502#165312)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOI_437502#165312)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENV_437503#165288)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENV_437503#165288)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIP_437504#165311)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIP_437504#165311)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVP_437505#165287)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVP_437505#165287)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAF_437506#165413)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAF_437506#165413)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_437507#165391)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_437507#165391)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ORIDEM_437508#165416)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ORIDEM_437508#165416)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MODTRT_437509#165373)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MODTRT_437509#165373)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATASS_437510#165380)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATASS_437510#165380)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMACC_437511#165385)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMACC_437511#165385)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC_437512#165279)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC_437512#165279)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFAC_437513#165401)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFAC_437513#165401)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_437514#165440)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_437514#165440)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TARIF_437515#165462)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TARIF_437515#165462)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_SECU_437516#165315)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_SECU_437516#165315)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_COT_437517#165382)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_COT_437517#165382)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_FAC_437518#165383)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_FAC_437518#165383)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VERSION_437519#165473)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_VERSION_437519#165473)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_437520#165250)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_437520#165250)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATMAJ_437521#165290)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATMAJ_437521#165290)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUTI_437522#165263)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUTI_437522#165263)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRE_437523#165294)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRE_437523#165294)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCMU_437524#165328)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCMU_437524#165328)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCRE_437525#165282)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCRE_437525#165282)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUFL_437526#165262)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUFL_437526#165262)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMLOC_437527#165403)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMLOC_437527#165403)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLACCID_437528#165323)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLACCID_437528#165323)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPEXO_437529#165467)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPEXO_437529#165467)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RNGNAI_437530#165442)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_RNGNAI_437530#165442)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPEC_437531#165344)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPEC_437531#165344)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGAT_437532#165245)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGAT_437532#165245)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIAT_437533#165231)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIAT_437533#165231)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLREFER_437534#165347)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLREFER_437534#165347)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODPJ_437535#165244)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODPJ_437535#165244)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGPJ_437536#165246)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGPJ_437536#165246)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#165232)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#165232)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCARNET_437538#165327)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCARNET_437538#165327)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_QUALDP_437539#165429)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_QUALDP_437539#165429)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TIERSP_437540#165465)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TIERSP_437540#165465)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC2_437541#165278)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC2_437541#165278)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPJ_437542#165292)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPJ_437542#165292)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDOMIC_437543#165332)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDOMIC_437543#165332)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DROITS_437544#165305)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DROITS_437544#165305)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPM_437545#165351)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPM_437545#165351)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPR_437546#165352)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPR_437546#165352)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENT_437547#165285)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENT_437547#165285)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENT_437548#165237)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENT_437548#165237)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CONMUT_437549#165266)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CONMUT_437549#165266)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ADHMUT_437550#165221)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ADHMUT_437550#165221)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GARMUT_437551#165356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_GARMUT_437551#165356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTITMED_437552#165350)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTITMED_437552#165350)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#165324)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#165324)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#165420)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#165420)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#165421)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#165421)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#165423)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#165423)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#165424)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#165424)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNUM_437558#165342)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNUM_437558#165342)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFACT_437559#165334)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFACT_437559#165334)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLGRATUI_437560#165336)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLGRATUI_437560#165336)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_437561#165407)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_437561#165407)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_437562#165409)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_437562#165409)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_437563#165411)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_437563#165411)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MDTMUT_437564#165372)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MDTMUT_437564#165372)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIC_437565#165310)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIC_437565#165310)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVC_437566#165286)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVC_437566#165286)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODM_H_437567#165243)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODM_H_437567#165243)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODATS_437568#165230)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODATS_437568#165230)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STAOPI_437569#165457)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_STAOPI_437569#165457)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPRES_437570#165469)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPRES_437570#165469)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMMENT_437571#165264)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMMENT_437571#165264)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODROUT_437572#165247)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODROUT_437572#165247)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOMAINE_437573#165302)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOMAINE_437573#165302)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INDTRAI_437574#165364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INDTRAI_437574#165364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDHOTE_437575#165363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDHOTE_437575#165363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSTS_437576#165260)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSTS_437576#165260)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRCHAMC_437577#165427)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRCHAMC_437577#165427)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TPAMC_437578#165466)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TPAMC_437578#165466)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PJAMC_437579#165426)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PJAMC_437579#165426)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPFAC_437580#165468)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPFAC_437580#165468)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCENAT_437581#165233)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCENAT_437581#165233)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLARMAT_437582#165326)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLARMAT_437582#165326)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORC_437583#165354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORC_437583#165354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#165337)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#165337)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#165296)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#165296)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#165322)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#165322)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOTDB_437587#165366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOTDB_437587#165366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCVIM_437588#165329)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCVIM_437588#165329)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOAMC_437589#165365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOAMC_437589#165365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODIPS_437590#165239)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODIPS_437590#165239)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMTR_437591#165242)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMTR_437591#165242)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_437592#165376)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_437592#165376)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#165435)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#165435)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_437594#165454)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_437594#165454)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#165455)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#165455)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_437596#165452)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_437596#165452)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#165453)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#165453)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_437598#165450)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_437598#165450)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#165451)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#165451)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTELE_437600#165349)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTELE_437600#165349)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#165392)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#165392)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#165441)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#165441)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#165346)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#165346)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAME_437604#165325)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAME_437604#165325)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#165330)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#165330)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMOP_437606#165405)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMOP_437606#165405)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#165387)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#165387)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#165390)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#165390)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_437609#165436)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_437609#165436)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#165437)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#165437)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_437611#165438)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_437611#165438)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#165439)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#165439)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CH_437613#165270)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CH_437613#165270)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CF_437614#165269)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CF_437614#165269)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MH_437615#165272)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MH_437615#165272)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MF_437616#165271)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MF_437616#165271)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AH_437617#165268)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AH_437617#165268)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AF_437618#165267)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AF_437618#165267)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PAVMUT_437619#165425)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PAVMUT_437619#165425)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#165255)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#165255)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#165254)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#165254)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#165257)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#165257)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#165256)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#165256)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#165253)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#165253)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#165252)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#165252)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#165412)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#165412)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#165408)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#165408)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#165410)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#165410)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSCAI_437629#165339)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSCAI_437629#165339)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSMUT_437630#165340)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSMUT_437630#165340)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSPAT_437631#165341)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSPAT_437631#165341)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CD_437632#165444)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CD_437632#165444)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CD_437633#165306)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CD_437633#165306)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LOCK_437634#165371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_LOCK_437634#165371)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRC_437635#165293)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRC_437635#165293)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUPRC_437636#165361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUPRC_437636#165361)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODACC_437637#165229)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODACC_437637#165229)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MOTPAS_437638#165375)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MOTPAS_437638#165375)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTBDI_437639#165348)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTBDI_437639#165348)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTENTE_437640#165226)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTENTE_437640#165226)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#165227)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#165227)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEST_437642#165297)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEST_437642#165297)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#165460)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#165460)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#165397)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#165397)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#165238)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#165238)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#165251)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#165251)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#165400)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#165400)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URG_437648#165471)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_URG_437648#165471)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_STD_437649#165368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_STD_437649#165368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_SPE_437650#165367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_SPE_437650#165367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#165456)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#165456)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RCP_437652#165430)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_RCP_437652#165430)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#165273)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#165273)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#165459)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#165459)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFTIMP_437655#165335)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFTIMP_437655#165335)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#165461)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#165461)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#165394)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#165394)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PAT_437658#165299)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PAT_437658#165299)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#165300)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#165300)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#165378)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#165378)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMPRG_437661#165406)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMPRG_437661#165406)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_437662#165320)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_437662#165320)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPARTI_437663#165343)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPARTI_437663#165343)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPARTI_437664#165291)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPARTI_437664#165291)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDFACSIT_437665#165362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDFACSIT_437665#165362)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#165396)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#165396)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ALARMES_437667#165222)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ALARMES_437667#165222)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#165298)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#165298)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLVIP_437669#165353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLVIP_437669#165353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#165345)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#165345)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#165321)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#165321)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#165318)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#165318)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#165377)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#165377)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#165331)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#165331)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DMPAUT_437675#165301)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DMPAUT_437675#165301)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLLIBERE_437676#165338)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLLIBERE_437676#165338)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACCNUM_437677#165219)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACCNUM_437677#165219)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CR_437678#165275)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CR_437678#165275)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CD_437679#165274)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CD_437679#165274)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_F_437680#165276)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_F_437680#165276)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLENTREE_437681#165333)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLENTREE_437681#165333)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENTREE_437682#165284)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENTREE_437682#165284)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUENTREE_437683#165360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUENTREE_437683#165360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRESCS_437684#165428)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRESCS_437684#165428)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#165220)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#165220)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#165399)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#165399)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSPE_437687#165258)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSPE_437687#165258)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMTRT_437688#165415)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMTRT_437688#165415)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#165240)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#165240)), A63000893163) END)

FileScan parquet [EM_ACCNUM_437677#165219,EM_ACTES_ESTIM_437685#165220,EM_ADHMUT_437550#165221,EM_ALARMES_437667#165222,EM_ANGIO_437448#165223,EM_ANNVAL_437465#165224,EM_ASTREI_437441#165225,EM_ATTENTE_437640#165226,EM_ATTMOTIF_437641#165227,EM_AUTR_437449#165228,EM_CODACC_437637#165229,EM_CODATS_437568#165230,EM_CODCAIAT_437533#165231,EM_CODCAIPJ_437537#165232,EM_CODCENAT_437581#165233,EM_CODC_A_437451#165234,EM_CODDIC_437501#165235,EM_CODENC_437499#165236,EM_CODENT_437548#165237,EM_CODETAB_PROD_437645#165238,EM_CODIPS_437590#165239,EM_CODMEDPAT_437689#165240,EM_CODMED_437437#165241,EM_CODMTR_437591#165242,... 231 more fields] Batched: false, DataFilters: [((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_DEMAND_437434], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<EM_ACCNUM_437677:string,EM_ACTES_ESTIM_437685:string,EM_ADHMUT_437550:string,EM_ALARMES_43...

Details

== Physical Plan ==
AdaptiveSparkPlan (11)
+- == Final Plan ==
   * HashAggregate (7)
   +- ShuffleQueryStage (6), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (5)
         +- * HashAggregate (4)
            +- Project (3)
               +- Filter (2)
                  +- Scan parquet  (1)
+- == Initial Plan ==
   HashAggregate (10)
   +- Exchange (9)
      +- HashAggregate (8)
         +- Project (3)
            +- Filter (2)
               +- Scan parquet  (1)


(1) Scan parquet 
Output [255]: [EM_ACCNUM_437677#165219, EM_ACTES_ESTIM_437685#165220, EM_ADHMUT_437550#165221, EM_ALARMES_437667#165222, EM_ANGIO_437448#165223, EM_ANNVAL_437465#165224, EM_ASTREI_437441#165225, EM_ATTENTE_437640#165226, EM_ATTMOTIF_437641#165227, EM_AUTR_437449#165228, EM_CODACC_437637#165229, EM_CODATS_437568#165230, EM_CODCAIAT_437533#165231, EM_CODCAIPJ_437537#165232, EM_CODCENAT_437581#165233, EM_CODC_A_437451#165234, EM_CODDIC_437501#165235, EM_CODENC_437499#165236, EM_CODENT_437548#165237, EM_CODETAB_PROD_437645#165238, EM_CODIPS_437590#165239, EM_CODMEDPAT_437689#165240, EM_CODMED_437437#165241, EM_CODMTR_437591#165242, EM_CODM_H_437567#165243, EM_CODPJ_437535#165244, EM_CODREGAT_437532#165245, EM_CODREGPJ_437536#165246, EM_CODROUT_437572#165247, EM_CODSEC_437497#165248, EM_CODSER_437450#165249, EM_CODSIT_437520#165250, EM_CODSIT_PROD_437646#165251, EM_CODSOC_AF_437625#165252, EM_CODSOC_AH_437624#165253, EM_CODSOC_CF_437621#165254, EM_CODSOC_CH_437620#165255, EM_CODSOC_MF_437623#165256, EM_CODSOC_MH_437622#165257, EM_CODSPE_437687#165258, EM_CODSRV_437498#165259, EM_CODSTS_437576#165260, EM_CODTIT_437500#165261, EM_CODUFL_437526#165262, EM_CODUTI_437522#165263, EM_COMMENT_437571#165264, EM_COMM_1_437463#165265, EM_CONMUT_437549#165266, EM_CRL_AF_437618#165267, EM_CRL_AH_437617#165268, EM_CRL_CF_437614#165269, EM_CRL_CH_437613#165270, EM_CRL_MF_437616#165271, EM_CRL_MH_437615#165272, EM_CR_ATTENDU_437653#165273, EM_C_R_CD_437679#165274, EM_C_R_CR_437678#165275, EM_C_R_F_437680#165276, EM_DAT100_437489#165277, EM_DATACC2_437541#165278, EM_DATACC_437512#165279, EM_DATARR_437490#165280, EM_DATCOT_437492#165281, EM_DATCRE_437525#165282, EM_DATCSS_437488#165283, EM_DATENTREE_437682#165284, EM_DATENT_437547#165285, EM_DATENVC_437566#165286, EM_DATENVP_437505#165287, EM_DATENV_437503#165288, EM_DATF_D_437487#165289, EM_DATMAJ_437521#165290, EM_DATPARTI_437664#165291, EM_DATPJ_437542#165292, EM_DATPRC_437635#165293, EM_DATPRE_437523#165294, EM_DATRV_437438#165295, EM_DEBEXOMAT_437585#165296, EM_DEST_437642#165297, EM_DIF_DEFER_437668#165298, EM_DIF_PAT_437658#165299, EM_DIF_PRESC_437659#165300, EM_DMPAUT_437675#165301, EM_DOMAINE_437573#165302, EM_DOSCLO_437462#165303, EM_DOSCOM_437439#165304, EM_DROITS_437544#165305, EM_D_R_CD_437633#165306, EM_D_R_CR_437460#165307, EM_D_R_F_437461#165308, EM_ECHO_437447#165309, EM_ENVOIC_437565#165310, EM_ENVOIP_437504#165311, EM_ENVOI_437502#165312, EM_ETAPE_437456#165313, EM_EXA_LO_437446#165314, EM_EXA_SECU_437516#165315, EM_FACCON_437468#165316, EM_FACTUR_437467#165317, EM_FACTUR_ESTIM_437672#165318, EM_FERIE_437443#165319, EM_FINESS_437662#165320, EM_FINESS_HONO_437671#165321, EM_FINEXOMAT_437586#165322, EM_FLACCID_437528#165323, EM_FLAMCFSE_437553#165324, EM_FLAME_437604#165325, EM_FLARMAT_437582#165326, EM_FLCARNET_437538#165327, EM_FLCMU_437524#165328, EM_FLCVIM_437588#165329, EM_FLDECLMTR_437605#165330, EM_FLDMP_SECRET_437674#165331, EM_FLDOMIC_437543#165332, EM_FLENTREE_437681#165333, EM_FLFACT_437559#165334, EM_FLFTIMP_437655#165335, EM_FLGRATUI_437560#165336, EM_FLHOSPIT_437584#165337, EM_FLLIBERE_437676#165338, EM_FLNSCAI_437629#165339, EM_FLNSMUT_437630#165340, EM_FLNSPAT_437631#165341, EM_FLNUM_437558#165342, EM_FLPARTI_437663#165343, EM_FLPEC_437531#165344, EM_FLPORTAIL_437670#165345, EM_FLPRESCINF_437603#165346, EM_FLREFER_437534#165347, EM_FLTBDI_437639#165348, EM_FLTELE_437600#165349, EM_FLTITMED_437552#165350, EM_FLTOPM_437545#165351, EM_FLTOPR_437546#165352, EM_FLVIP_437669#165353, EM_FORC_437583#165354, EM_FORFAI_437444#165355, EM_GARMUT_437551#165356, EM_GROUPE_437464#165357, EM_HEUARR_437491#165358, EM_HEUCOT_437493#165359, EM_HEUENTREE_437683#165360, EM_HEUPRC_437636#165361, EM_IDFACSIT_437665#165362, EM_IDHOTE_437575#165363, EM_INDTRAI_437574#165364, EM_INFOAMC_437589#165365, EM_INFOTDB_437587#165366, EM_INT_SPE_437650#165367, EM_INT_STD_437649#165368, EM_IRM_437445#165369, EM_LIBEL_437453#165370, EM_LOCK_437634#165371, EM_MDTMUT_437564#165372, EM_MODTRT_437509#165373, EM_MONNAIE_437466#165374, EM_MOTPAS_437638#165375, EM_MTDEP_437592#165376, EM_MTDEP_ESTIM_437673#165377, EM_MT_PEC_SMG_437660#165378, EM_M_FORF_437469#165379, EM_NATASS_437510#165380, EM_NATURE_437455#165381, EM_NB_COT_437517#165382, EM_NB_FAC_437518#165383, EM_NUIT_437442#165384, EM_NUMACC_437511#165385, EM_NUMBOC_437481#165386, EM_NUMBOC_FT_437607#165387, EM_NUMBOF_437483#165388, EM_NUMBOM_437482#165389, EM_NUMBOM_FT_437608#165390, EM_NUMBOT_437507#165391, EM_NUMBOT_FT_437601#165392, EM_NUMCAI_437484#165393, EM_NUMCAI_FT_437657#165394, EM_NUMDEM_437436#165395, EM_NUMDEM_ORI_437666#165396, EM_NUMDEM_PROD_437644#165397, EM_NUMDOS_437435#165398, EM_NUMDOS_ORI_437686#165399, EM_NUMDOS_PROD_437647#165400, EM_NUMFAC_437513#165401, EM_NUMFOR_437486#165402, EM_NUMLOC_437527#165403, EM_NUMMUT_437485#165404, EM_NUMOP_437606#165405, EM_NUMPRG_437661#165406, EM_NUMREL_C_437561#165407, EM_NUMREL_C_F_437627#165408, EM_NUMREL_M_437562#165409, EM_NUMREL_M_F_437628#165410, EM_NUMREL_P_437563#165411, EM_NUMREL_P_F_437626#165412, EM_NUMSAF_437506#165413, EM_NUMSAL_437494#165414, EM_NUMTRT_437688#165415, EM_ORIDEM_437508#165416, EM_PARCAI_437471#165417, EM_PARFOR_437475#165418, EM_PARMUT_437473#165419, EM_PARMUT_FT_437554#165420, EM_PARMUT_HON_437555#165421, EM_PARPAT_437470#165422, EM_PARPAT_FT_437556#165423, EM_PARPAT_HON_437557#165424, EM_PAVMUT_437619#165425, EM_PJAMC_437579#165426, EM_PRCHAMC_437577#165427, EM_PRESCS_437684#165428, EM_QUALDP_437539#165429, EM_RCP_437652#165430, EM_REGCAI_437477#165431, EM_REGFOR_437479#165432, EM_REGMUT_437478#165433, EM_REGPAT_437476#165434, EM_REGPAT_HON_437593#165435, EM_REJBOC_437609#165436, EM_REJBOC_FT_437610#165437, EM_REJBOM_437611#165438, EM_REJBOM_FT_437612#165439, EM_REJBOT_437514#165440, EM_REJBOT_FT_437602#165441, EM_RNGNAI_437530#165442, EM_R_A_R_437480#165443, EM_R_CD_437632#165444, EM_R_CR_437458#165445, EM_R_F_437459#165446, EM_SCAN1_437495#165447, EM_SCAN2_437496#165448, EM_SIGMA_437452#165449, EM_SLDCAI_437598#165450, EM_SLDCAI_FT_437599#165451, EM_SLDMUT_437596#165452, EM_SLDMUT_FT_437597#165453, EM_SLDPAT_437594#165454, EM_SLDPAT_FT_437595#165455, EM_SPL_TRANS_437651#165456, EM_STAOPI_437569#165457, EM_STATCR_437457#165458, EM_STATUT_ENVOI_437654#165459, EM_STATUT_SMS_437643#165460, EM_SUPMOTIF_437656#165461, EM_TARIF_437515#165462, EM_TAUCAI_437472#165463, EM_TAUMUT_437474#165464, EM_TIERSP_437540#165465, EM_TPAMC_437578#165466, EM_TYPEXO_437529#165467, EM_TYPFAC_437580#165468, EM_TYPRES_437570#165469, EM_URGEN_437440#165470, EM_URG_437648#165471, EM_VALID_437454#165472, EM_VERSION_437519#165473]
Batched: false
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_DEMAND_437434]
ReadSchema: struct<EM_ACCNUM_437677:string,EM_ACTES_ESTIM_437685:string,EM_ADHMUT_437550:string,EM_ALARMES_437667:string,EM_ANGIO_437448:string,EM_ANNVAL_437465:string,EM_ASTREI_437441:string,EM_ATTENTE_437640:string,EM_ATTMOTIF_437641:string,EM_AUTR_437449:string,EM_CODACC_437637:string,EM_CODATS_437568:string,EM_CODCAIAT_437533:string,EM_CODCAIPJ_437537:string,EM_CODCENAT_437581:string,EM_CODC_A_437451:string,EM_CODDIC_437501:string,EM_CODENC_437499:string,EM_CODENT_437548:string,EM_CODETAB_PROD_437645:string,EM_CODIPS_437590:string,EM_CODMEDPAT_437689:string,EM_CODMED_437437:string,EM_CODMTR_437591:string,EM_CODM_H_437567:string,EM_CODPJ_437535:string,EM_CODREGAT_437532:string,EM_CODREGPJ_437536:string,EM_CODROUT_437572:string,EM_CODSEC_437497:string,EM_CODSER_437450:string,EM_CODSIT_437520:string,EM_CODSIT_PROD_437646:string,EM_CODSOC_AF_437625:string,EM_CODSOC_AH_437624:string,EM_CODSOC_CF_437621:string,EM_CODSOC_CH_437620:string,EM_CODSOC_MF_437623:string,EM_CODSOC_MH_437622:string,EM_CODSPE_437687:string,EM_CODSRV_437498:string,EM_CODSTS_437576:string,EM_CODTIT_437500:string,EM_CODUFL_437526:string,EM_CODUTI_437522:string,EM_COMMENT_437571:string,EM_COMM_1_437463:string,EM_CONMUT_437549:string,EM_CRL_AF_437618:string,EM_CRL_AH_437617:string,EM_CRL_CF_437614:string,EM_CRL_CH_437613:string,EM_CRL_MF_437616:string,EM_CRL_MH_437615:string,EM_CR_ATTENDU_437653:string,EM_C_R_CD_437679:string,EM_C_R_CR_437678:string,EM_C_R_F_437680:string,EM_DAT100_437489:string,EM_DATACC2_437541:string,EM_DATACC_437512:string,EM_DATARR_437490:string,EM_DATCOT_437492:string,EM_DATCRE_437525:string,EM_DATCSS_437488:string,EM_DATENTREE_437682:string,EM_DATENT_437547:string,EM_DATENVC_437566:string,EM_DATENVP_437505:string,EM_DATENV_437503:string,EM_DATF_D_437487:string,EM_DATMAJ_437521:string,EM_DATPARTI_437664:string,EM_DATPJ_437542:string,EM_DATPRC_437635:string,EM_DATPRE_437523:string,EM_DATRV_437438:string,EM_DEBEXOMAT_437585:string,EM_DEST_437642:string,EM_DIF_DEFER_437668:string,EM_DIF_PAT_437658:string,EM_DIF_PRESC_437659:string,EM_DMPAUT_437675:string,EM_DOMAINE_437573:string,EM_DOSCLO_437462:string,EM_DOSCOM_437439:string,EM_DROITS_437544:string,EM_D_R_CD_437633:string,EM_D_R_CR_437460:string,EM_D_R_F_437461:string,EM_ECHO_437447:string,EM_ENVOIC_437565:string,EM_ENVOIP_437504:string,EM_ENVOI_437502:string,EM_ETAPE_437456:string,EM_EXA_LO_437446:string,EM_EXA_SECU_437516:string,EM_FACCON_437468:string,EM_FACTUR_437467:string,EM_FACTUR_ESTIM_437672:string,EM_FERIE_437443:string,EM_FINESS_437662:string,EM_FINESS_HONO_437671:string,EM_FINEXOMAT_437586:string,EM_FLACCID_437528:string,EM_FLAMCFSE_437553:string,EM_FLAME_437604:string,EM_FLARMAT_437582:string,EM_FLCARNET_437538:string,EM_FLCMU_437524:string,EM_FLCVIM_437588:string,EM_FLDECLMTR_437605:string,EM_FLDMP_SECRET_437674:string,EM_FLDOMIC_437543:string,EM_FLENTREE_437681:string,EM_FLFACT_437559:string,EM_FLFTIMP_437655:string,EM_FLGRATUI_437560:string,EM_FLHOSPIT_437584:string,EM_FLLIBERE_437676:string,EM_FLNSCAI_437629:string,EM_FLNSMUT_437630:string,EM_FLNSPAT_437631:string,EM_FLNUM_437558:string,EM_FLPARTI_437663:string,EM_FLPEC_437531:string,EM_FLPORTAIL_437670:string,EM_FLPRESCINF_437603:string,EM_FLREFER_437534:string,EM_FLTBDI_437639:string,EM_FLTELE_437600:string,EM_FLTITMED_437552:string,EM_FLTOPM_437545:string,EM_FLTOPR_437546:string,EM_FLVIP_437669:string,EM_FORC_437583:string,EM_FORFAI_437444:string,EM_GARMUT_437551:string,EM_GROUPE_437464:string,EM_HEUARR_437491:string,EM_HEUCOT_437493:string,EM_HEUENTREE_437683:string,EM_HEUPRC_437636:string,EM_IDFACSIT_437665:string,EM_IDHOTE_437575:string,EM_INDTRAI_437574:string,EM_INFOAMC_437589:string,EM_INFOTDB_437587:string,EM_INT_SPE_437650:string,EM_INT_STD_437649:string,EM_IRM_437445:string,EM_LIBEL_437453:string,EM_LOCK_437634:string,EM_MDTMUT_437564:string,EM_MODTRT_437509:string,EM_MONNAIE_437466:string,EM_MOTPAS_437638:string,EM_MTDEP_437592:string,EM_MTDEP_ESTIM_437673:string,EM_MT_PEC_SMG_437660:string,EM_M_FORF_437469:string,EM_NATASS_437510:string,EM_NATURE_437455:string,EM_NB_COT_437517:string,EM_NB_FAC_437518:string,EM_NUIT_437442:string,EM_NUMACC_437511:string,EM_NUMBOC_437481:string,EM_NUMBOC_FT_437607:string,EM_NUMBOF_437483:string,EM_NUMBOM_437482:string,EM_NUMBOM_FT_437608:string,EM_NUMBOT_437507:string,EM_NUMBOT_FT_437601:string,EM_NUMCAI_437484:string,EM_NUMCAI_FT_437657:string,EM_NUMDEM_437436:string,EM_NUMDEM_ORI_437666:string,EM_NUMDEM_PROD_437644:string,EM_NUMDOS_437435:string,EM_NUMDOS_ORI_437686:string,EM_NUMDOS_PROD_437647:string,EM_NUMFAC_437513:string,EM_NUMFOR_437486:string,EM_NUMLOC_437527:string,EM_NUMMUT_437485:string,EM_NUMOP_437606:string,EM_NUMPRG_437661:string,EM_NUMREL_C_437561:string,EM_NUMREL_C_F_437627:string,EM_NUMREL_M_437562:string,EM_NUMREL_M_F_437628:string,EM_NUMREL_P_437563:string,EM_NUMREL_P_F_437626:string,EM_NUMSAF_437506:string,EM_NUMSAL_437494:string,EM_NUMTRT_437688:string,EM_ORIDEM_437508:string,EM_PARCAI_437471:string,EM_PARFOR_437475:string,EM_PARMUT_437473:string,EM_PARMUT_FT_437554:string,EM_PARMUT_HON_437555:string,EM_PARPAT_437470:string,EM_PARPAT_FT_437556:string,EM_PARPAT_HON_437557:string,EM_PAVMUT_437619:string,EM_PJAMC_437579:string,EM_PRCHAMC_437577:string,EM_PRESCS_437684:string,EM_QUALDP_437539:string,EM_RCP_437652:string,EM_REGCAI_437477:string,EM_REGFOR_437479:string,EM_REGMUT_437478:string,EM_REGPAT_437476:string,EM_REGPAT_HON_437593:string,EM_REJBOC_437609:string,EM_REJBOC_FT_437610:string,EM_REJBOM_437611:string,EM_REJBOM_FT_437612:string,EM_REJBOT_437514:string,EM_REJBOT_FT_437602:string,EM_RNGNAI_437530:string,EM_R_A_R_437480:string,EM_R_CD_437632:string,EM_R_CR_437458:string,EM_R_F_437459:string,EM_SCAN1_437495:string,EM_SCAN2_437496:string,EM_SIGMA_437452:string,EM_SLDCAI_437598:string,EM_SLDCAI_FT_437599:string,EM_SLDMUT_437596:string,EM_SLDMUT_FT_437597:string,EM_SLDPAT_437594:string,EM_SLDPAT_FT_437595:string,EM_SPL_TRANS_437651:string,EM_STAOPI_437569:string,EM_STATCR_437457:string,EM_STATUT_ENVOI_437654:string,EM_STATUT_SMS_437643:string,EM_SUPMOTIF_437656:string,EM_TARIF_437515:string,EM_TAUCAI_437472:string,EM_TAUMUT_437474:string,EM_TIERSP_437540:string,EM_TPAMC_437578:string,EM_TYPEXO_437529:string,EM_TYPFAC_437580:string,EM_TYPRES_437570:string,EM_URGEN_437440:string,EM_URG_437648:string,EM_VALID_437454:string,EM_VERSION_437519:string>

(2) Filter
Input [255]: [EM_ACCNUM_437677#165219, EM_ACTES_ESTIM_437685#165220, EM_ADHMUT_437550#165221, EM_ALARMES_437667#165222, EM_ANGIO_437448#165223, EM_ANNVAL_437465#165224, EM_ASTREI_437441#165225, EM_ATTENTE_437640#165226, EM_ATTMOTIF_437641#165227, EM_AUTR_437449#165228, EM_CODACC_437637#165229, EM_CODATS_437568#165230, EM_CODCAIAT_437533#165231, EM_CODCAIPJ_437537#165232, EM_CODCENAT_437581#165233, EM_CODC_A_437451#165234, EM_CODDIC_437501#165235, EM_CODENC_437499#165236, EM_CODENT_437548#165237, EM_CODETAB_PROD_437645#165238, EM_CODIPS_437590#165239, EM_CODMEDPAT_437689#165240, EM_CODMED_437437#165241, EM_CODMTR_437591#165242, EM_CODM_H_437567#165243, EM_CODPJ_437535#165244, EM_CODREGAT_437532#165245, EM_CODREGPJ_437536#165246, EM_CODROUT_437572#165247, EM_CODSEC_437497#165248, EM_CODSER_437450#165249, EM_CODSIT_437520#165250, EM_CODSIT_PROD_437646#165251, EM_CODSOC_AF_437625#165252, EM_CODSOC_AH_437624#165253, EM_CODSOC_CF_437621#165254, EM_CODSOC_CH_437620#165255, EM_CODSOC_MF_437623#165256, EM_CODSOC_MH_437622#165257, EM_CODSPE_437687#165258, EM_CODSRV_437498#165259, EM_CODSTS_437576#165260, EM_CODTIT_437500#165261, EM_CODUFL_437526#165262, EM_CODUTI_437522#165263, EM_COMMENT_437571#165264, EM_COMM_1_437463#165265, EM_CONMUT_437549#165266, EM_CRL_AF_437618#165267, EM_CRL_AH_437617#165268, EM_CRL_CF_437614#165269, EM_CRL_CH_437613#165270, EM_CRL_MF_437616#165271, EM_CRL_MH_437615#165272, EM_CR_ATTENDU_437653#165273, EM_C_R_CD_437679#165274, EM_C_R_CR_437678#165275, EM_C_R_F_437680#165276, EM_DAT100_437489#165277, EM_DATACC2_437541#165278, EM_DATACC_437512#165279, EM_DATARR_437490#165280, EM_DATCOT_437492#165281, EM_DATCRE_437525#165282, EM_DATCSS_437488#165283, EM_DATENTREE_437682#165284, EM_DATENT_437547#165285, EM_DATENVC_437566#165286, EM_DATENVP_437505#165287, EM_DATENV_437503#165288, EM_DATF_D_437487#165289, EM_DATMAJ_437521#165290, EM_DATPARTI_437664#165291, EM_DATPJ_437542#165292, EM_DATPRC_437635#165293, EM_DATPRE_437523#165294, EM_DATRV_437438#165295, EM_DEBEXOMAT_437585#165296, EM_DEST_437642#165297, EM_DIF_DEFER_437668#165298, EM_DIF_PAT_437658#165299, EM_DIF_PRESC_437659#165300, EM_DMPAUT_437675#165301, EM_DOMAINE_437573#165302, EM_DOSCLO_437462#165303, EM_DOSCOM_437439#165304, EM_DROITS_437544#165305, EM_D_R_CD_437633#165306, EM_D_R_CR_437460#165307, EM_D_R_F_437461#165308, EM_ECHO_437447#165309, EM_ENVOIC_437565#165310, EM_ENVOIP_437504#165311, EM_ENVOI_437502#165312, EM_ETAPE_437456#165313, EM_EXA_LO_437446#165314, EM_EXA_SECU_437516#165315, EM_FACCON_437468#165316, EM_FACTUR_437467#165317, EM_FACTUR_ESTIM_437672#165318, EM_FERIE_437443#165319, EM_FINESS_437662#165320, EM_FINESS_HONO_437671#165321, EM_FINEXOMAT_437586#165322, EM_FLACCID_437528#165323, EM_FLAMCFSE_437553#165324, EM_FLAME_437604#165325, EM_FLARMAT_437582#165326, EM_FLCARNET_437538#165327, EM_FLCMU_437524#165328, EM_FLCVIM_437588#165329, EM_FLDECLMTR_437605#165330, EM_FLDMP_SECRET_437674#165331, EM_FLDOMIC_437543#165332, EM_FLENTREE_437681#165333, EM_FLFACT_437559#165334, EM_FLFTIMP_437655#165335, EM_FLGRATUI_437560#165336, EM_FLHOSPIT_437584#165337, EM_FLLIBERE_437676#165338, EM_FLNSCAI_437629#165339, EM_FLNSMUT_437630#165340, EM_FLNSPAT_437631#165341, EM_FLNUM_437558#165342, EM_FLPARTI_437663#165343, EM_FLPEC_437531#165344, EM_FLPORTAIL_437670#165345, EM_FLPRESCINF_437603#165346, EM_FLREFER_437534#165347, EM_FLTBDI_437639#165348, EM_FLTELE_437600#165349, EM_FLTITMED_437552#165350, EM_FLTOPM_437545#165351, EM_FLTOPR_437546#165352, EM_FLVIP_437669#165353, EM_FORC_437583#165354, EM_FORFAI_437444#165355, EM_GARMUT_437551#165356, EM_GROUPE_437464#165357, EM_HEUARR_437491#165358, EM_HEUCOT_437493#165359, EM_HEUENTREE_437683#165360, EM_HEUPRC_437636#165361, EM_IDFACSIT_437665#165362, EM_IDHOTE_437575#165363, EM_INDTRAI_437574#165364, EM_INFOAMC_437589#165365, EM_INFOTDB_437587#165366, EM_INT_SPE_437650#165367, EM_INT_STD_437649#165368, EM_IRM_437445#165369, EM_LIBEL_437453#165370, EM_LOCK_437634#165371, EM_MDTMUT_437564#165372, EM_MODTRT_437509#165373, EM_MONNAIE_437466#165374, EM_MOTPAS_437638#165375, EM_MTDEP_437592#165376, EM_MTDEP_ESTIM_437673#165377, EM_MT_PEC_SMG_437660#165378, EM_M_FORF_437469#165379, EM_NATASS_437510#165380, EM_NATURE_437455#165381, EM_NB_COT_437517#165382, EM_NB_FAC_437518#165383, EM_NUIT_437442#165384, EM_NUMACC_437511#165385, EM_NUMBOC_437481#165386, EM_NUMBOC_FT_437607#165387, EM_NUMBOF_437483#165388, EM_NUMBOM_437482#165389, EM_NUMBOM_FT_437608#165390, EM_NUMBOT_437507#165391, EM_NUMBOT_FT_437601#165392, EM_NUMCAI_437484#165393, EM_NUMCAI_FT_437657#165394, EM_NUMDEM_437436#165395, EM_NUMDEM_ORI_437666#165396, EM_NUMDEM_PROD_437644#165397, EM_NUMDOS_437435#165398, EM_NUMDOS_ORI_437686#165399, EM_NUMDOS_PROD_437647#165400, EM_NUMFAC_437513#165401, EM_NUMFOR_437486#165402, EM_NUMLOC_437527#165403, EM_NUMMUT_437485#165404, EM_NUMOP_437606#165405, EM_NUMPRG_437661#165406, EM_NUMREL_C_437561#165407, EM_NUMREL_C_F_437627#165408, EM_NUMREL_M_437562#165409, EM_NUMREL_M_F_437628#165410, EM_NUMREL_P_437563#165411, EM_NUMREL_P_F_437626#165412, EM_NUMSAF_437506#165413, EM_NUMSAL_437494#165414, EM_NUMTRT_437688#165415, EM_ORIDEM_437508#165416, EM_PARCAI_437471#165417, EM_PARFOR_437475#165418, EM_PARMUT_437473#165419, EM_PARMUT_FT_437554#165420, EM_PARMUT_HON_437555#165421, EM_PARPAT_437470#165422, EM_PARPAT_FT_437556#165423, EM_PARPAT_HON_437557#165424, EM_PAVMUT_437619#165425, EM_PJAMC_437579#165426, EM_PRCHAMC_437577#165427, EM_PRESCS_437684#165428, EM_QUALDP_437539#165429, EM_RCP_437652#165430, EM_REGCAI_437477#165431, EM_REGFOR_437479#165432, EM_REGMUT_437478#165433, EM_REGPAT_437476#165434, EM_REGPAT_HON_437593#165435, EM_REJBOC_437609#165436, EM_REJBOC_FT_437610#165437, EM_REJBOM_437611#165438, EM_REJBOM_FT_437612#165439, EM_REJBOT_437514#165440, EM_REJBOT_FT_437602#165441, EM_RNGNAI_437530#165442, EM_R_A_R_437480#165443, EM_R_CD_437632#165444, EM_R_CR_437458#165445, EM_R_F_437459#165446, EM_SCAN1_437495#165447, EM_SCAN2_437496#165448, EM_SIGMA_437452#165449, EM_SLDCAI_437598#165450, EM_SLDCAI_FT_437599#165451, EM_SLDMUT_437596#165452, EM_SLDMUT_FT_437597#165453, EM_SLDPAT_437594#165454, EM_SLDPAT_FT_437595#165455, EM_SPL_TRANS_437651#165456, EM_STAOPI_437569#165457, EM_STATCR_437457#165458, EM_STATUT_ENVOI_437654#165459, EM_STATUT_SMS_437643#165460, EM_SUPMOTIF_437656#165461, EM_TARIF_437515#165462, EM_TAUCAI_437472#165463, EM_TAUMUT_437474#165464, EM_TIERSP_437540#165465, EM_TPAMC_437578#165466, EM_TYPEXO_437529#165467, EM_TYPFAC_437580#165468, EM_TYPRES_437570#165469, EM_URGEN_437440#165470, EM_URG_437648#165471, EM_VALID_437454#165472, EM_VERSION_437519#165473]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_437435#165398)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_437435#165398)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_437436#165395)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_437436#165395)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMED_437437#165241)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMED_437437#165241)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATRV_437438#165295)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATRV_437438#165295)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCOM_437439#165304)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCOM_437439#165304)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URGEN_437440#165470)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_URGEN_437440#165470)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ASTREI_437441#165225)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ASTREI_437441#165225)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUIT_437442#165384)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUIT_437442#165384)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FERIE_437443#165319)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FERIE_437443#165319)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORFAI_437444#165355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORFAI_437444#165355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IRM_437445#165369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_IRM_437445#165369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_LO_437446#165314)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_LO_437446#165314)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ECHO_437447#165309)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ECHO_437447#165309)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANGIO_437448#165223)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANGIO_437448#165223)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_AUTR_437449#165228)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_AUTR_437449#165228)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSER_437450#165249)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSER_437450#165249)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODC_A_437451#165234)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODC_A_437451#165234)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SIGMA_437452#165449)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SIGMA_437452#165449)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LIBEL_437453#165370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_LIBEL_437453#165370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VALID_437454#165472)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_VALID_437454#165472)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATURE_437455#165381)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATURE_437455#165381)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ETAPE_437456#165313)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ETAPE_437456#165313)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATCR_437457#165458)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATCR_437457#165458)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CR_437458#165445)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CR_437458#165445)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_F_437459#165446)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_F_437459#165446)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CR_437460#165307)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CR_437460#165307)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_F_437461#165308)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_F_437461#165308)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCLO_437462#165303)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCLO_437462#165303)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMM_1_437463#165265)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMM_1_437463#165265)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GROUPE_437464#165357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_GROUPE_437464#165357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANNVAL_437465#165224)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANNVAL_437465#165224)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MONNAIE_437466#165374)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MONNAIE_437466#165374)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_437467#165317)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_437467#165317)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACCON_437468#165316)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACCON_437468#165316)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_M_FORF_437469#165379)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_M_FORF_437469#165379)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_437470#165422)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_437470#165422)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARCAI_437471#165417)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARCAI_437471#165417)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUCAI_437472#165463)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUCAI_437472#165463)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_437473#165419)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_437473#165419)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUMUT_437474#165464)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUMUT_437474#165464)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARFOR_437475#165418)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARFOR_437475#165418)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_437476#165434)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_437476#165434)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGCAI_437477#165431)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGCAI_437477#165431)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGMUT_437478#165433)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGMUT_437478#165433)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGFOR_437479#165432)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGFOR_437479#165432)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_A_R_437480#165443)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_A_R_437480#165443)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_437481#165386)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_437481#165386)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_437482#165389)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_437482#165389)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOF_437483#165388)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOF_437483#165388)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_437484#165393)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_437484#165393)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMMUT_437485#165404)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMMUT_437485#165404)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFOR_437486#165402)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFOR_437486#165402)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATF_D_437487#165289)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATF_D_437487#165289)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCSS_437488#165283)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCSS_437488#165283)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DAT100_437489#165277)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DAT100_437489#165277)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATARR_437490#165280)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATARR_437490#165280)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUARR_437491#165358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUARR_437491#165358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCOT_437492#165281)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCOT_437492#165281)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUCOT_437493#165359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUCOT_437493#165359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAL_437494#165414)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAL_437494#165414)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN1_437495#165447)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN1_437495#165447)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN2_437496#165448)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN2_437496#165448)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSEC_437497#165248)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSEC_437497#165248)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSRV_437498#165259)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSRV_437498#165259)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENC_437499#165236)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENC_437499#165236)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODTIT_437500#165261)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODTIT_437500#165261)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODDIC_437501#165235)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODDIC_437501#165235)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOI_437502#165312)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOI_437502#165312)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENV_437503#165288)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENV_437503#165288)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIP_437504#165311)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIP_437504#165311)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVP_437505#165287)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVP_437505#165287)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAF_437506#165413)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAF_437506#165413)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_437507#165391)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_437507#165391)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ORIDEM_437508#165416)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ORIDEM_437508#165416)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MODTRT_437509#165373)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MODTRT_437509#165373)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATASS_437510#165380)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATASS_437510#165380)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMACC_437511#165385)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMACC_437511#165385)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC_437512#165279)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC_437512#165279)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFAC_437513#165401)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFAC_437513#165401)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_437514#165440)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_437514#165440)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TARIF_437515#165462)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TARIF_437515#165462)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_SECU_437516#165315)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_SECU_437516#165315)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_COT_437517#165382)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_COT_437517#165382)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_FAC_437518#165383)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_FAC_437518#165383)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VERSION_437519#165473)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_VERSION_437519#165473)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_437520#165250)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_437520#165250)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATMAJ_437521#165290)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATMAJ_437521#165290)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUTI_437522#165263)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUTI_437522#165263)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRE_437523#165294)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRE_437523#165294)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCMU_437524#165328)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCMU_437524#165328)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCRE_437525#165282)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCRE_437525#165282)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUFL_437526#165262)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUFL_437526#165262)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMLOC_437527#165403)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMLOC_437527#165403)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLACCID_437528#165323)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLACCID_437528#165323)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPEXO_437529#165467)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPEXO_437529#165467)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RNGNAI_437530#165442)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_RNGNAI_437530#165442)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPEC_437531#165344)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPEC_437531#165344)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGAT_437532#165245)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGAT_437532#165245)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIAT_437533#165231)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIAT_437533#165231)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLREFER_437534#165347)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLREFER_437534#165347)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODPJ_437535#165244)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODPJ_437535#165244)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGPJ_437536#165246)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGPJ_437536#165246)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#165232)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#165232)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCARNET_437538#165327)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCARNET_437538#165327)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_QUALDP_437539#165429)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_QUALDP_437539#165429)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TIERSP_437540#165465)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TIERSP_437540#165465)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC2_437541#165278)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC2_437541#165278)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPJ_437542#165292)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPJ_437542#165292)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDOMIC_437543#165332)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDOMIC_437543#165332)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DROITS_437544#165305)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DROITS_437544#165305)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPM_437545#165351)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPM_437545#165351)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPR_437546#165352)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPR_437546#165352)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENT_437547#165285)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENT_437547#165285)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENT_437548#165237)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENT_437548#165237)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CONMUT_437549#165266)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CONMUT_437549#165266)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ADHMUT_437550#165221)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ADHMUT_437550#165221)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GARMUT_437551#165356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_GARMUT_437551#165356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTITMED_437552#165350)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTITMED_437552#165350)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#165324)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#165324)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#165420)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#165420)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#165421)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#165421)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#165423)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#165423)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#165424)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#165424)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNUM_437558#165342)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNUM_437558#165342)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFACT_437559#165334)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFACT_437559#165334)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLGRATUI_437560#165336)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLGRATUI_437560#165336)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_437561#165407)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_437561#165407)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_437562#165409)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_437562#165409)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_437563#165411)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_437563#165411)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MDTMUT_437564#165372)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MDTMUT_437564#165372)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIC_437565#165310)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIC_437565#165310)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVC_437566#165286)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVC_437566#165286)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODM_H_437567#165243)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODM_H_437567#165243)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODATS_437568#165230)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODATS_437568#165230)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STAOPI_437569#165457)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_STAOPI_437569#165457)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPRES_437570#165469)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPRES_437570#165469)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMMENT_437571#165264)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMMENT_437571#165264)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODROUT_437572#165247)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODROUT_437572#165247)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOMAINE_437573#165302)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOMAINE_437573#165302)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INDTRAI_437574#165364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INDTRAI_437574#165364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDHOTE_437575#165363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDHOTE_437575#165363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSTS_437576#165260)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSTS_437576#165260)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRCHAMC_437577#165427)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRCHAMC_437577#165427)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TPAMC_437578#165466)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TPAMC_437578#165466)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PJAMC_437579#165426)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PJAMC_437579#165426)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPFAC_437580#165468)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPFAC_437580#165468)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCENAT_437581#165233)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCENAT_437581#165233)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLARMAT_437582#165326)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLARMAT_437582#165326)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORC_437583#165354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORC_437583#165354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#165337)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#165337)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#165296)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#165296)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#165322)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#165322)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOTDB_437587#165366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOTDB_437587#165366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCVIM_437588#165329)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCVIM_437588#165329)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOAMC_437589#165365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOAMC_437589#165365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODIPS_437590#165239)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODIPS_437590#165239)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMTR_437591#165242)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMTR_437591#165242)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_437592#165376)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_437592#165376)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#165435)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#165435)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_437594#165454)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_437594#165454)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#165455)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#165455)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_437596#165452)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_437596#165452)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#165453)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#165453)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_437598#165450)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_437598#165450)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#165451)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#165451)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTELE_437600#165349)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTELE_437600#165349)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#165392)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#165392)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#165441)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#165441)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#165346)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#165346)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAME_437604#165325)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAME_437604#165325)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#165330)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#165330)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMOP_437606#165405)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMOP_437606#165405)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#165387)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#165387)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#165390)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#165390)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_437609#165436)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_437609#165436)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#165437)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#165437)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_437611#165438)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_437611#165438)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#165439)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#165439)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CH_437613#165270)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CH_437613#165270)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CF_437614#165269)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CF_437614#165269)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MH_437615#165272)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MH_437615#165272)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MF_437616#165271)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MF_437616#165271)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AH_437617#165268)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AH_437617#165268)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AF_437618#165267)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AF_437618#165267)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PAVMUT_437619#165425)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PAVMUT_437619#165425)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#165255)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#165255)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#165254)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#165254)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#165257)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#165257)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#165256)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#165256)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#165253)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#165253)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#165252)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#165252)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#165412)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#165412)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#165408)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#165408)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#165410)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#165410)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSCAI_437629#165339)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSCAI_437629#165339)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSMUT_437630#165340)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSMUT_437630#165340)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSPAT_437631#165341)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSPAT_437631#165341)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CD_437632#165444)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CD_437632#165444)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CD_437633#165306)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CD_437633#165306)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LOCK_437634#165371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_LOCK_437634#165371)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRC_437635#165293)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRC_437635#165293)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUPRC_437636#165361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUPRC_437636#165361)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODACC_437637#165229)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODACC_437637#165229)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MOTPAS_437638#165375)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MOTPAS_437638#165375)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTBDI_437639#165348)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTBDI_437639#165348)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTENTE_437640#165226)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTENTE_437640#165226)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#165227)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#165227)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEST_437642#165297)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEST_437642#165297)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#165460)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#165460)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#165397)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#165397)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#165238)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#165238)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#165251)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#165251)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#165400)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#165400)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URG_437648#165471)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_URG_437648#165471)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_STD_437649#165368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_STD_437649#165368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_SPE_437650#165367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_SPE_437650#165367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#165456)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#165456)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RCP_437652#165430)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_RCP_437652#165430)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#165273)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#165273)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#165459)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#165459)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFTIMP_437655#165335)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFTIMP_437655#165335)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#165461)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#165461)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#165394)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#165394)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PAT_437658#165299)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PAT_437658#165299)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#165300)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#165300)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#165378)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#165378)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMPRG_437661#165406)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMPRG_437661#165406)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_437662#165320)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_437662#165320)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPARTI_437663#165343)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPARTI_437663#165343)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPARTI_437664#165291)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPARTI_437664#165291)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDFACSIT_437665#165362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDFACSIT_437665#165362)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#165396)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#165396)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ALARMES_437667#165222)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ALARMES_437667#165222)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#165298)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#165298)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLVIP_437669#165353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLVIP_437669#165353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#165345)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#165345)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#165321)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#165321)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#165318)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#165318)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#165377)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#165377)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#165331)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#165331)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DMPAUT_437675#165301)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DMPAUT_437675#165301)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLLIBERE_437676#165338)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLLIBERE_437676#165338)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACCNUM_437677#165219)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACCNUM_437677#165219)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CR_437678#165275)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CR_437678#165275)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CD_437679#165274)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CD_437679#165274)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_F_437680#165276)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_F_437680#165276)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLENTREE_437681#165333)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLENTREE_437681#165333)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENTREE_437682#165284)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENTREE_437682#165284)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUENTREE_437683#165360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUENTREE_437683#165360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRESCS_437684#165428)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRESCS_437684#165428)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#165220)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#165220)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#165399)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#165399)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSPE_437687#165258)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSPE_437687#165258)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMTRT_437688#165415)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMTRT_437688#165415)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#165240)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#165240)), A63000893163) END)

(3) Project
Output: []
Input [255]: [EM_ACCNUM_437677#165219, EM_ACTES_ESTIM_437685#165220, EM_ADHMUT_437550#165221, EM_ALARMES_437667#165222, EM_ANGIO_437448#165223, EM_ANNVAL_437465#165224, EM_ASTREI_437441#165225, EM_ATTENTE_437640#165226, EM_ATTMOTIF_437641#165227, EM_AUTR_437449#165228, EM_CODACC_437637#165229, EM_CODATS_437568#165230, EM_CODCAIAT_437533#165231, EM_CODCAIPJ_437537#165232, EM_CODCENAT_437581#165233, EM_CODC_A_437451#165234, EM_CODDIC_437501#165235, EM_CODENC_437499#165236, EM_CODENT_437548#165237, EM_CODETAB_PROD_437645#165238, EM_CODIPS_437590#165239, EM_CODMEDPAT_437689#165240, EM_CODMED_437437#165241, EM_CODMTR_437591#165242, EM_CODM_H_437567#165243, EM_CODPJ_437535#165244, EM_CODREGAT_437532#165245, EM_CODREGPJ_437536#165246, EM_CODROUT_437572#165247, EM_CODSEC_437497#165248, EM_CODSER_437450#165249, EM_CODSIT_437520#165250, EM_CODSIT_PROD_437646#165251, EM_CODSOC_AF_437625#165252, EM_CODSOC_AH_437624#165253, EM_CODSOC_CF_437621#165254, EM_CODSOC_CH_437620#165255, EM_CODSOC_MF_437623#165256, EM_CODSOC_MH_437622#165257, EM_CODSPE_437687#165258, EM_CODSRV_437498#165259, EM_CODSTS_437576#165260, EM_CODTIT_437500#165261, EM_CODUFL_437526#165262, EM_CODUTI_437522#165263, EM_COMMENT_437571#165264, EM_COMM_1_437463#165265, EM_CONMUT_437549#165266, EM_CRL_AF_437618#165267, EM_CRL_AH_437617#165268, EM_CRL_CF_437614#165269, EM_CRL_CH_437613#165270, EM_CRL_MF_437616#165271, EM_CRL_MH_437615#165272, EM_CR_ATTENDU_437653#165273, EM_C_R_CD_437679#165274, EM_C_R_CR_437678#165275, EM_C_R_F_437680#165276, EM_DAT100_437489#165277, EM_DATACC2_437541#165278, EM_DATACC_437512#165279, EM_DATARR_437490#165280, EM_DATCOT_437492#165281, EM_DATCRE_437525#165282, EM_DATCSS_437488#165283, EM_DATENTREE_437682#165284, EM_DATENT_437547#165285, EM_DATENVC_437566#165286, EM_DATENVP_437505#165287, EM_DATENV_437503#165288, EM_DATF_D_437487#165289, EM_DATMAJ_437521#165290, EM_DATPARTI_437664#165291, EM_DATPJ_437542#165292, EM_DATPRC_437635#165293, EM_DATPRE_437523#165294, EM_DATRV_437438#165295, EM_DEBEXOMAT_437585#165296, EM_DEST_437642#165297, EM_DIF_DEFER_437668#165298, EM_DIF_PAT_437658#165299, EM_DIF_PRESC_437659#165300, EM_DMPAUT_437675#165301, EM_DOMAINE_437573#165302, EM_DOSCLO_437462#165303, EM_DOSCOM_437439#165304, EM_DROITS_437544#165305, EM_D_R_CD_437633#165306, EM_D_R_CR_437460#165307, EM_D_R_F_437461#165308, EM_ECHO_437447#165309, EM_ENVOIC_437565#165310, EM_ENVOIP_437504#165311, EM_ENVOI_437502#165312, EM_ETAPE_437456#165313, EM_EXA_LO_437446#165314, EM_EXA_SECU_437516#165315, EM_FACCON_437468#165316, EM_FACTUR_437467#165317, EM_FACTUR_ESTIM_437672#165318, EM_FERIE_437443#165319, EM_FINESS_437662#165320, EM_FINESS_HONO_437671#165321, EM_FINEXOMAT_437586#165322, EM_FLACCID_437528#165323, EM_FLAMCFSE_437553#165324, EM_FLAME_437604#165325, EM_FLARMAT_437582#165326, EM_FLCARNET_437538#165327, EM_FLCMU_437524#165328, EM_FLCVIM_437588#165329, EM_FLDECLMTR_437605#165330, EM_FLDMP_SECRET_437674#165331, EM_FLDOMIC_437543#165332, EM_FLENTREE_437681#165333, EM_FLFACT_437559#165334, EM_FLFTIMP_437655#165335, EM_FLGRATUI_437560#165336, EM_FLHOSPIT_437584#165337, EM_FLLIBERE_437676#165338, EM_FLNSCAI_437629#165339, EM_FLNSMUT_437630#165340, EM_FLNSPAT_437631#165341, EM_FLNUM_437558#165342, EM_FLPARTI_437663#165343, EM_FLPEC_437531#165344, EM_FLPORTAIL_437670#165345, EM_FLPRESCINF_437603#165346, EM_FLREFER_437534#165347, EM_FLTBDI_437639#165348, EM_FLTELE_437600#165349, EM_FLTITMED_437552#165350, EM_FLTOPM_437545#165351, EM_FLTOPR_437546#165352, EM_FLVIP_437669#165353, EM_FORC_437583#165354, EM_FORFAI_437444#165355, EM_GARMUT_437551#165356, EM_GROUPE_437464#165357, EM_HEUARR_437491#165358, EM_HEUCOT_437493#165359, EM_HEUENTREE_437683#165360, EM_HEUPRC_437636#165361, EM_IDFACSIT_437665#165362, EM_IDHOTE_437575#165363, EM_INDTRAI_437574#165364, EM_INFOAMC_437589#165365, EM_INFOTDB_437587#165366, EM_INT_SPE_437650#165367, EM_INT_STD_437649#165368, EM_IRM_437445#165369, EM_LIBEL_437453#165370, EM_LOCK_437634#165371, EM_MDTMUT_437564#165372, EM_MODTRT_437509#165373, EM_MONNAIE_437466#165374, EM_MOTPAS_437638#165375, EM_MTDEP_437592#165376, EM_MTDEP_ESTIM_437673#165377, EM_MT_PEC_SMG_437660#165378, EM_M_FORF_437469#165379, EM_NATASS_437510#165380, EM_NATURE_437455#165381, EM_NB_COT_437517#165382, EM_NB_FAC_437518#165383, EM_NUIT_437442#165384, EM_NUMACC_437511#165385, EM_NUMBOC_437481#165386, EM_NUMBOC_FT_437607#165387, EM_NUMBOF_437483#165388, EM_NUMBOM_437482#165389, EM_NUMBOM_FT_437608#165390, EM_NUMBOT_437507#165391, EM_NUMBOT_FT_437601#165392, EM_NUMCAI_437484#165393, EM_NUMCAI_FT_437657#165394, EM_NUMDEM_437436#165395, EM_NUMDEM_ORI_437666#165396, EM_NUMDEM_PROD_437644#165397, EM_NUMDOS_437435#165398, EM_NUMDOS_ORI_437686#165399, EM_NUMDOS_PROD_437647#165400, EM_NUMFAC_437513#165401, EM_NUMFOR_437486#165402, EM_NUMLOC_437527#165403, EM_NUMMUT_437485#165404, EM_NUMOP_437606#165405, EM_NUMPRG_437661#165406, EM_NUMREL_C_437561#165407, EM_NUMREL_C_F_437627#165408, EM_NUMREL_M_437562#165409, EM_NUMREL_M_F_437628#165410, EM_NUMREL_P_437563#165411, EM_NUMREL_P_F_437626#165412, EM_NUMSAF_437506#165413, EM_NUMSAL_437494#165414, EM_NUMTRT_437688#165415, EM_ORIDEM_437508#165416, EM_PARCAI_437471#165417, EM_PARFOR_437475#165418, EM_PARMUT_437473#165419, EM_PARMUT_FT_437554#165420, EM_PARMUT_HON_437555#165421, EM_PARPAT_437470#165422, EM_PARPAT_FT_437556#165423, EM_PARPAT_HON_437557#165424, EM_PAVMUT_437619#165425, EM_PJAMC_437579#165426, EM_PRCHAMC_437577#165427, EM_PRESCS_437684#165428, EM_QUALDP_437539#165429, EM_RCP_437652#165430, EM_REGCAI_437477#165431, EM_REGFOR_437479#165432, EM_REGMUT_437478#165433, EM_REGPAT_437476#165434, EM_REGPAT_HON_437593#165435, EM_REJBOC_437609#165436, EM_REJBOC_FT_437610#165437, EM_REJBOM_437611#165438, EM_REJBOM_FT_437612#165439, EM_REJBOT_437514#165440, EM_REJBOT_FT_437602#165441, EM_RNGNAI_437530#165442, EM_R_A_R_437480#165443, EM_R_CD_437632#165444, EM_R_CR_437458#165445, EM_R_F_437459#165446, EM_SCAN1_437495#165447, EM_SCAN2_437496#165448, EM_SIGMA_437452#165449, EM_SLDCAI_437598#165450, EM_SLDCAI_FT_437599#165451, EM_SLDMUT_437596#165452, EM_SLDMUT_FT_437597#165453, EM_SLDPAT_437594#165454, EM_SLDPAT_FT_437595#165455, EM_SPL_TRANS_437651#165456, EM_STAOPI_437569#165457, EM_STATCR_437457#165458, EM_STATUT_ENVOI_437654#165459, EM_STATUT_SMS_437643#165460, EM_SUPMOTIF_437656#165461, EM_TARIF_437515#165462, EM_TAUCAI_437472#165463, EM_TAUMUT_437474#165464, EM_TIERSP_437540#165465, EM_TPAMC_437578#165466, EM_TYPEXO_437529#165467, EM_TYPFAC_437580#165468, EM_TYPRES_437570#165469, EM_URGEN_437440#165470, EM_URG_437648#165471, EM_VALID_437454#165472, EM_VERSION_437519#165473]

(4) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#170083L]
Results [1]: [count#170084L]

(5) Exchange
Input [1]: [count#170084L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=15692]

(6) ShuffleQueryStage
Output [1]: [count#170084L]
Arguments: 0

(7) HashAggregate [codegen id : 2]
Input [1]: [count#170084L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#169817L]
Results [1]: [count(1)#169817L AS COL_9170ed74-d7c7-4d58-8db2-b54469cdf560#169819L]

(8) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#170083L]
Results [1]: [count#170084L]

(9) Exchange
Input [1]: [count#170084L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=15680]

(10) HashAggregate
Input [1]: [count#170084L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#169817L]
Results [1]: [count(1)#169817L AS COL_9170ed74-d7c7-4d58-8db2-b54469cdf560#169819L]

(11) AdaptiveSparkPlan
Output [1]: [COL_9170ed74-d7c7-4d58-8db2-b54469cdf560#169819L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet