hdh-spark-job - Details for Query 662

Submitted Time: 2026/10/21 21:34:20
Duration: 1 s
Succeeded Jobs: 620 621

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: 770 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 770 ms number of output rows: 1"]; } 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 34,041"]; 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=13329]

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

WholeStageCodegen (1)

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_437435#140201)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_437435#140201)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_437436#140198)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_437436#140198)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMED_437437#140044)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMED_437437#140044)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATRV_437438#140098)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATRV_437438#140098)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCOM_437439#140107)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCOM_437439#140107)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URGEN_437440#140273)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_URGEN_437440#140273)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ASTREI_437441#140028)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ASTREI_437441#140028)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUIT_437442#140187)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUIT_437442#140187)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FERIE_437443#140122)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FERIE_437443#140122)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORFAI_437444#140158)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FORFAI_437444#140158)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IRM_437445#140172)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_IRM_437445#140172)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_LO_437446#140117)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_LO_437446#140117)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ECHO_437447#140112)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ECHO_437447#140112)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANGIO_437448#140026)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ANGIO_437448#140026)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_AUTR_437449#140031)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_AUTR_437449#140031)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSER_437450#140052)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSER_437450#140052)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODC_A_437451#140037)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODC_A_437451#140037)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SIGMA_437452#140252)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SIGMA_437452#140252)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LIBEL_437453#140173)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_LIBEL_437453#140173)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VALID_437454#140275)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_VALID_437454#140275)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATURE_437455#140184)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NATURE_437455#140184)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ETAPE_437456#140116)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ETAPE_437456#140116)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATCR_437457#140261)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_STATCR_437457#140261)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CR_437458#140248)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CR_437458#140248)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_F_437459#140249)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_R_F_437459#140249)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CR_437460#140110)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CR_437460#140110)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_F_437461#140111)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_F_437461#140111)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCLO_437462#140106)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCLO_437462#140106)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMM_1_437463#140068)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_COMM_1_437463#140068)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GROUPE_437464#140160)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_GROUPE_437464#140160)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANNVAL_437465#140027)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ANNVAL_437465#140027)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MONNAIE_437466#140177)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MONNAIE_437466#140177)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_437467#140120)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_437467#140120)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACCON_437468#140119)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FACCON_437468#140119)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_M_FORF_437469#140182)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_M_FORF_437469#140182)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_437470#140225)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_437470#140225)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARCAI_437471#140220)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARCAI_437471#140220)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUCAI_437472#140266)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUCAI_437472#140266)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_437473#140222)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_437473#140222)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUMUT_437474#140267)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUMUT_437474#140267)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARFOR_437475#140221)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARFOR_437475#140221)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_437476#140237)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_437476#140237)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGCAI_437477#140234)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGCAI_437477#140234)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGMUT_437478#140236)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGMUT_437478#140236)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGFOR_437479#140235)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGFOR_437479#140235)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_A_R_437480#140246)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_R_A_R_437480#140246)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_437481#140189)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_437481#140189)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_437482#140192)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_437482#140192)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOF_437483#140191)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOF_437483#140191)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_437484#140196)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_437484#140196)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMMUT_437485#140207)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMMUT_437485#140207)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFOR_437486#140205)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFOR_437486#140205)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATF_D_437487#140092)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATF_D_437487#140092)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCSS_437488#140086)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCSS_437488#140086)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DAT100_437489#140080)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DAT100_437489#140080)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATARR_437490#140083)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATARR_437490#140083)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUARR_437491#140161)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUARR_437491#140161)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCOT_437492#140084)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCOT_437492#140084)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUCOT_437493#140162)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUCOT_437493#140162)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAL_437494#140217)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAL_437494#140217)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN1_437495#140250)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN1_437495#140250)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN2_437496#140251)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN2_437496#140251)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSEC_437497#140051)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSEC_437497#140051)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSRV_437498#140062)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSRV_437498#140062)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENC_437499#140039)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENC_437499#140039)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODTIT_437500#140064)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODTIT_437500#140064)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODDIC_437501#140038)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODDIC_437501#140038)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOI_437502#140115)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOI_437502#140115)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENV_437503#140091)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENV_437503#140091)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIP_437504#140114)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIP_437504#140114)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVP_437505#140090)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVP_437505#140090)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAF_437506#140216)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAF_437506#140216)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_437507#140194)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_437507#140194)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ORIDEM_437508#140219)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ORIDEM_437508#140219)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MODTRT_437509#140176)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MODTRT_437509#140176)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATASS_437510#140183)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NATASS_437510#140183)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMACC_437511#140188)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMACC_437511#140188)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC_437512#140082)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC_437512#140082)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFAC_437513#140204)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFAC_437513#140204)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_437514#140243)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_437514#140243)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TARIF_437515#140265)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TARIF_437515#140265)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_SECU_437516#140118)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_SECU_437516#140118)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_COT_437517#140185)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_COT_437517#140185)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_FAC_437518#140186)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_FAC_437518#140186)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VERSION_437519#140276)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_VERSION_437519#140276)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_437520#140053)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_437520#140053)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATMAJ_437521#140093)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATMAJ_437521#140093)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUTI_437522#140066)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUTI_437522#140066)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRE_437523#140097)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRE_437523#140097)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCMU_437524#140131)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCMU_437524#140131)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCRE_437525#140085)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCRE_437525#140085)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUFL_437526#140065)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUFL_437526#140065)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMLOC_437527#140206)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMLOC_437527#140206)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLACCID_437528#140126)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLACCID_437528#140126)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPEXO_437529#140270)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPEXO_437529#140270)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RNGNAI_437530#140245)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_RNGNAI_437530#140245)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPEC_437531#140147)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPEC_437531#140147)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGAT_437532#140048)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGAT_437532#140048)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIAT_437533#140034)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIAT_437533#140034)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLREFER_437534#140150)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLREFER_437534#140150)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODPJ_437535#140047)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODPJ_437535#140047)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGPJ_437536#140049)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGPJ_437536#140049)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#140035)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#140035)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCARNET_437538#140130)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCARNET_437538#140130)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_QUALDP_437539#140232)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_QUALDP_437539#140232)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TIERSP_437540#140268)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TIERSP_437540#140268)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC2_437541#140081)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC2_437541#140081)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPJ_437542#140095)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPJ_437542#140095)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDOMIC_437543#140135)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDOMIC_437543#140135)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DROITS_437544#140108)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DROITS_437544#140108)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPM_437545#140154)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPM_437545#140154)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPR_437546#140155)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPR_437546#140155)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENT_437547#140088)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENT_437547#140088)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENT_437548#140040)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENT_437548#140040)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CONMUT_437549#140069)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CONMUT_437549#140069)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ADHMUT_437550#140024)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ADHMUT_437550#140024)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GARMUT_437551#140159)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_GARMUT_437551#140159)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTITMED_437552#140153)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTITMED_437552#140153)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#140127)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#140127)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#140223)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#140223)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#140224)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#140224)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#140226)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#140226)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#140227)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#140227)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNUM_437558#140145)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNUM_437558#140145)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFACT_437559#140137)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFACT_437559#140137)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLGRATUI_437560#140139)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLGRATUI_437560#140139)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_437561#140210)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_437561#140210)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_437562#140212)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_437562#140212)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_437563#140214)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_437563#140214)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MDTMUT_437564#140175)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MDTMUT_437564#140175)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIC_437565#140113)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIC_437565#140113)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVC_437566#140089)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVC_437566#140089)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODM_H_437567#140046)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODM_H_437567#140046)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODATS_437568#140033)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODATS_437568#140033)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STAOPI_437569#140260)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_STAOPI_437569#140260)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPRES_437570#140272)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPRES_437570#140272)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMMENT_437571#140067)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_COMMENT_437571#140067)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODROUT_437572#140050)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODROUT_437572#140050)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOMAINE_437573#140105)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DOMAINE_437573#140105)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INDTRAI_437574#140167)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INDTRAI_437574#140167)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDHOTE_437575#140166)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_IDHOTE_437575#140166)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSTS_437576#140063)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSTS_437576#140063)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRCHAMC_437577#140230)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PRCHAMC_437577#140230)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TPAMC_437578#140269)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TPAMC_437578#140269)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PJAMC_437579#140229)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PJAMC_437579#140229)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPFAC_437580#140271)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPFAC_437580#140271)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCENAT_437581#140036)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCENAT_437581#140036)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLARMAT_437582#140129)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLARMAT_437582#140129)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORC_437583#140157)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FORC_437583#140157)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#140140)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#140140)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#140099)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#140099)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#140125)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#140125)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOTDB_437587#140169)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOTDB_437587#140169)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCVIM_437588#140132)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCVIM_437588#140132)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOAMC_437589#140168)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOAMC_437589#140168)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODIPS_437590#140042)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODIPS_437590#140042)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMTR_437591#140045)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMTR_437591#140045)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_437592#140179)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_437592#140179)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#140238)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#140238)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_437594#140257)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_437594#140257)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#140258)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#140258)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_437596#140255)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_437596#140255)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#140256)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#140256)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_437598#140253)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_437598#140253)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#140254)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#140254)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTELE_437600#140152)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTELE_437600#140152)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#140195)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#140195)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#140244)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#140244)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#140149)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#140149)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAME_437604#140128)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAME_437604#140128)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#140133)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#140133)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMOP_437606#140208)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMOP_437606#140208)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#140190)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#140190)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#140193)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#140193)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_437609#140239)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_437609#140239)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#140240)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#140240)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_437611#140241)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_437611#140241)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#140242)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#140242)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CH_437613#140073)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CH_437613#140073)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CF_437614#140072)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CF_437614#140072)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MH_437615#140075)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MH_437615#140075)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MF_437616#140074)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MF_437616#140074)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AH_437617#140071)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AH_437617#140071)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AF_437618#140070)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AF_437618#140070)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PAVMUT_437619#140228)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PAVMUT_437619#140228)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#140058)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#140058)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#140057)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#140057)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#140060)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#140060)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#140059)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#140059)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#140056)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#140056)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#140055)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#140055)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#140215)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#140215)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#140211)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#140211)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#140213)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#140213)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSCAI_437629#140142)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSCAI_437629#140142)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSMUT_437630#140143)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSMUT_437630#140143)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSPAT_437631#140144)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSPAT_437631#140144)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CD_437632#140247)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CD_437632#140247)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CD_437633#140109)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CD_437633#140109)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LOCK_437634#140174)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_LOCK_437634#140174)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRC_437635#140096)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRC_437635#140096)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUPRC_437636#140164)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUPRC_437636#140164)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODACC_437637#140032)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODACC_437637#140032)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MOTPAS_437638#140178)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MOTPAS_437638#140178)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTBDI_437639#140151)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTBDI_437639#140151)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTENTE_437640#140029)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTENTE_437640#140029)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#140030)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#140030)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEST_437642#140100)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DEST_437642#140100)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#140263)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#140263)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#140200)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#140200)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#140041)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#140041)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#140054)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#140054)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#140203)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#140203)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URG_437648#140274)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_URG_437648#140274)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_STD_437649#140171)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_STD_437649#140171)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_SPE_437650#140170)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_SPE_437650#140170)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#140259)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#140259)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RCP_437652#140233)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_RCP_437652#140233)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#140076)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#140076)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#140262)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#140262)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFTIMP_437655#140138)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFTIMP_437655#140138)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#140264)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#140264)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#140197)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#140197)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PAT_437658#140102)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PAT_437658#140102)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#140103)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#140103)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#140181)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#140181)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMPRG_437661#140209)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMPRG_437661#140209)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_437662#140123)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_437662#140123)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPARTI_437663#140146)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPARTI_437663#140146)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPARTI_437664#140094)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPARTI_437664#140094)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDFACSIT_437665#140165)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_IDFACSIT_437665#140165)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#140199)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#140199)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ALARMES_437667#140025)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ALARMES_437667#140025)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#140101)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#140101)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLVIP_437669#140156)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLVIP_437669#140156)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#140148)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#140148)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#140124)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#140124)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#140121)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#140121)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#140180)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#140180)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#140134)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#140134)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DMPAUT_437675#140104)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DMPAUT_437675#140104)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLLIBERE_437676#140141)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLLIBERE_437676#140141)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACCNUM_437677#140022)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ACCNUM_437677#140022)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CR_437678#140078)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CR_437678#140078)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CD_437679#140077)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CD_437679#140077)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_F_437680#140079)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_F_437680#140079)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLENTREE_437681#140136)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLENTREE_437681#140136)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENTREE_437682#140087)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENTREE_437682#140087)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUENTREE_437683#140163)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUENTREE_437683#140163)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRESCS_437684#140231)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PRESCS_437684#140231)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#140023)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#140023)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#140202)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#140202)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSPE_437687#140061)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSPE_437687#140061)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMTRT_437688#140218)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMTRT_437688#140218)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#140043)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#140043)), ) END)

FileScan parquet [EM_ACCNUM_437677#140022,EM_ACTES_ESTIM_437685#140023,EM_ADHMUT_437550#140024,EM_ALARMES_437667#140025,EM_ANGIO_437448#140026,EM_ANNVAL_437465#140027,EM_ASTREI_437441#140028,EM_ATTENTE_437640#140029,EM_ATTMOTIF_437641#140030,EM_AUTR_437449#140031,EM_CODACC_437637#140032,EM_CODATS_437568#140033,EM_CODCAIAT_437533#140034,EM_CODCAIPJ_437537#140035,EM_CODCENAT_437581#140036,EM_CODC_A_437451#140037,EM_CODDIC_437501#140038,EM_CODENC_437499#140039,EM_CODENT_437548#140040,EM_CODETAB_PROD_437645#140041,EM_CODIPS_437590#140042,EM_CODMEDPAT_437689#140043,EM_CODMED_437437#140044,EM_CODMTR_437591#140045,... 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#140022, EM_ACTES_ESTIM_437685#140023, EM_ADHMUT_437550#140024, EM_ALARMES_437667#140025, EM_ANGIO_437448#140026, EM_ANNVAL_437465#140027, EM_ASTREI_437441#140028, EM_ATTENTE_437640#140029, EM_ATTMOTIF_437641#140030, EM_AUTR_437449#140031, EM_CODACC_437637#140032, EM_CODATS_437568#140033, EM_CODCAIAT_437533#140034, EM_CODCAIPJ_437537#140035, EM_CODCENAT_437581#140036, EM_CODC_A_437451#140037, EM_CODDIC_437501#140038, EM_CODENC_437499#140039, EM_CODENT_437548#140040, EM_CODETAB_PROD_437645#140041, EM_CODIPS_437590#140042, EM_CODMEDPAT_437689#140043, EM_CODMED_437437#140044, EM_CODMTR_437591#140045, EM_CODM_H_437567#140046, EM_CODPJ_437535#140047, EM_CODREGAT_437532#140048, EM_CODREGPJ_437536#140049, EM_CODROUT_437572#140050, EM_CODSEC_437497#140051, EM_CODSER_437450#140052, EM_CODSIT_437520#140053, EM_CODSIT_PROD_437646#140054, EM_CODSOC_AF_437625#140055, EM_CODSOC_AH_437624#140056, EM_CODSOC_CF_437621#140057, EM_CODSOC_CH_437620#140058, EM_CODSOC_MF_437623#140059, EM_CODSOC_MH_437622#140060, EM_CODSPE_437687#140061, EM_CODSRV_437498#140062, EM_CODSTS_437576#140063, EM_CODTIT_437500#140064, EM_CODUFL_437526#140065, EM_CODUTI_437522#140066, EM_COMMENT_437571#140067, EM_COMM_1_437463#140068, EM_CONMUT_437549#140069, EM_CRL_AF_437618#140070, EM_CRL_AH_437617#140071, EM_CRL_CF_437614#140072, EM_CRL_CH_437613#140073, EM_CRL_MF_437616#140074, EM_CRL_MH_437615#140075, EM_CR_ATTENDU_437653#140076, EM_C_R_CD_437679#140077, EM_C_R_CR_437678#140078, EM_C_R_F_437680#140079, EM_DAT100_437489#140080, EM_DATACC2_437541#140081, EM_DATACC_437512#140082, EM_DATARR_437490#140083, EM_DATCOT_437492#140084, EM_DATCRE_437525#140085, EM_DATCSS_437488#140086, EM_DATENTREE_437682#140087, EM_DATENT_437547#140088, EM_DATENVC_437566#140089, EM_DATENVP_437505#140090, EM_DATENV_437503#140091, EM_DATF_D_437487#140092, EM_DATMAJ_437521#140093, EM_DATPARTI_437664#140094, EM_DATPJ_437542#140095, EM_DATPRC_437635#140096, EM_DATPRE_437523#140097, EM_DATRV_437438#140098, EM_DEBEXOMAT_437585#140099, EM_DEST_437642#140100, EM_DIF_DEFER_437668#140101, EM_DIF_PAT_437658#140102, EM_DIF_PRESC_437659#140103, EM_DMPAUT_437675#140104, EM_DOMAINE_437573#140105, EM_DOSCLO_437462#140106, EM_DOSCOM_437439#140107, EM_DROITS_437544#140108, EM_D_R_CD_437633#140109, EM_D_R_CR_437460#140110, EM_D_R_F_437461#140111, EM_ECHO_437447#140112, EM_ENVOIC_437565#140113, EM_ENVOIP_437504#140114, EM_ENVOI_437502#140115, EM_ETAPE_437456#140116, EM_EXA_LO_437446#140117, EM_EXA_SECU_437516#140118, EM_FACCON_437468#140119, EM_FACTUR_437467#140120, EM_FACTUR_ESTIM_437672#140121, EM_FERIE_437443#140122, EM_FINESS_437662#140123, EM_FINESS_HONO_437671#140124, EM_FINEXOMAT_437586#140125, EM_FLACCID_437528#140126, EM_FLAMCFSE_437553#140127, EM_FLAME_437604#140128, EM_FLARMAT_437582#140129, EM_FLCARNET_437538#140130, EM_FLCMU_437524#140131, EM_FLCVIM_437588#140132, EM_FLDECLMTR_437605#140133, EM_FLDMP_SECRET_437674#140134, EM_FLDOMIC_437543#140135, EM_FLENTREE_437681#140136, EM_FLFACT_437559#140137, EM_FLFTIMP_437655#140138, EM_FLGRATUI_437560#140139, EM_FLHOSPIT_437584#140140, EM_FLLIBERE_437676#140141, EM_FLNSCAI_437629#140142, EM_FLNSMUT_437630#140143, EM_FLNSPAT_437631#140144, EM_FLNUM_437558#140145, EM_FLPARTI_437663#140146, EM_FLPEC_437531#140147, EM_FLPORTAIL_437670#140148, EM_FLPRESCINF_437603#140149, EM_FLREFER_437534#140150, EM_FLTBDI_437639#140151, EM_FLTELE_437600#140152, EM_FLTITMED_437552#140153, EM_FLTOPM_437545#140154, EM_FLTOPR_437546#140155, EM_FLVIP_437669#140156, EM_FORC_437583#140157, EM_FORFAI_437444#140158, EM_GARMUT_437551#140159, EM_GROUPE_437464#140160, EM_HEUARR_437491#140161, EM_HEUCOT_437493#140162, EM_HEUENTREE_437683#140163, EM_HEUPRC_437636#140164, EM_IDFACSIT_437665#140165, EM_IDHOTE_437575#140166, EM_INDTRAI_437574#140167, EM_INFOAMC_437589#140168, EM_INFOTDB_437587#140169, EM_INT_SPE_437650#140170, EM_INT_STD_437649#140171, EM_IRM_437445#140172, EM_LIBEL_437453#140173, EM_LOCK_437634#140174, EM_MDTMUT_437564#140175, EM_MODTRT_437509#140176, EM_MONNAIE_437466#140177, EM_MOTPAS_437638#140178, EM_MTDEP_437592#140179, EM_MTDEP_ESTIM_437673#140180, EM_MT_PEC_SMG_437660#140181, EM_M_FORF_437469#140182, EM_NATASS_437510#140183, EM_NATURE_437455#140184, EM_NB_COT_437517#140185, EM_NB_FAC_437518#140186, EM_NUIT_437442#140187, EM_NUMACC_437511#140188, EM_NUMBOC_437481#140189, EM_NUMBOC_FT_437607#140190, EM_NUMBOF_437483#140191, EM_NUMBOM_437482#140192, EM_NUMBOM_FT_437608#140193, EM_NUMBOT_437507#140194, EM_NUMBOT_FT_437601#140195, EM_NUMCAI_437484#140196, EM_NUMCAI_FT_437657#140197, EM_NUMDEM_437436#140198, EM_NUMDEM_ORI_437666#140199, EM_NUMDEM_PROD_437644#140200, EM_NUMDOS_437435#140201, EM_NUMDOS_ORI_437686#140202, EM_NUMDOS_PROD_437647#140203, EM_NUMFAC_437513#140204, EM_NUMFOR_437486#140205, EM_NUMLOC_437527#140206, EM_NUMMUT_437485#140207, EM_NUMOP_437606#140208, EM_NUMPRG_437661#140209, EM_NUMREL_C_437561#140210, EM_NUMREL_C_F_437627#140211, EM_NUMREL_M_437562#140212, EM_NUMREL_M_F_437628#140213, EM_NUMREL_P_437563#140214, EM_NUMREL_P_F_437626#140215, EM_NUMSAF_437506#140216, EM_NUMSAL_437494#140217, EM_NUMTRT_437688#140218, EM_ORIDEM_437508#140219, EM_PARCAI_437471#140220, EM_PARFOR_437475#140221, EM_PARMUT_437473#140222, EM_PARMUT_FT_437554#140223, EM_PARMUT_HON_437555#140224, EM_PARPAT_437470#140225, EM_PARPAT_FT_437556#140226, EM_PARPAT_HON_437557#140227, EM_PAVMUT_437619#140228, EM_PJAMC_437579#140229, EM_PRCHAMC_437577#140230, EM_PRESCS_437684#140231, EM_QUALDP_437539#140232, EM_RCP_437652#140233, EM_REGCAI_437477#140234, EM_REGFOR_437479#140235, EM_REGMUT_437478#140236, EM_REGPAT_437476#140237, EM_REGPAT_HON_437593#140238, EM_REJBOC_437609#140239, EM_REJBOC_FT_437610#140240, EM_REJBOM_437611#140241, EM_REJBOM_FT_437612#140242, EM_REJBOT_437514#140243, EM_REJBOT_FT_437602#140244, EM_RNGNAI_437530#140245, EM_R_A_R_437480#140246, EM_R_CD_437632#140247, EM_R_CR_437458#140248, EM_R_F_437459#140249, EM_SCAN1_437495#140250, EM_SCAN2_437496#140251, EM_SIGMA_437452#140252, EM_SLDCAI_437598#140253, EM_SLDCAI_FT_437599#140254, EM_SLDMUT_437596#140255, EM_SLDMUT_FT_437597#140256, EM_SLDPAT_437594#140257, EM_SLDPAT_FT_437595#140258, EM_SPL_TRANS_437651#140259, EM_STAOPI_437569#140260, EM_STATCR_437457#140261, EM_STATUT_ENVOI_437654#140262, EM_STATUT_SMS_437643#140263, EM_SUPMOTIF_437656#140264, EM_TARIF_437515#140265, EM_TAUCAI_437472#140266, EM_TAUMUT_437474#140267, EM_TIERSP_437540#140268, EM_TPAMC_437578#140269, EM_TYPEXO_437529#140270, EM_TYPFAC_437580#140271, EM_TYPRES_437570#140272, EM_URGEN_437440#140273, EM_URG_437648#140274, EM_VALID_437454#140275, EM_VERSION_437519#140276]
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#140022, EM_ACTES_ESTIM_437685#140023, EM_ADHMUT_437550#140024, EM_ALARMES_437667#140025, EM_ANGIO_437448#140026, EM_ANNVAL_437465#140027, EM_ASTREI_437441#140028, EM_ATTENTE_437640#140029, EM_ATTMOTIF_437641#140030, EM_AUTR_437449#140031, EM_CODACC_437637#140032, EM_CODATS_437568#140033, EM_CODCAIAT_437533#140034, EM_CODCAIPJ_437537#140035, EM_CODCENAT_437581#140036, EM_CODC_A_437451#140037, EM_CODDIC_437501#140038, EM_CODENC_437499#140039, EM_CODENT_437548#140040, EM_CODETAB_PROD_437645#140041, EM_CODIPS_437590#140042, EM_CODMEDPAT_437689#140043, EM_CODMED_437437#140044, EM_CODMTR_437591#140045, EM_CODM_H_437567#140046, EM_CODPJ_437535#140047, EM_CODREGAT_437532#140048, EM_CODREGPJ_437536#140049, EM_CODROUT_437572#140050, EM_CODSEC_437497#140051, EM_CODSER_437450#140052, EM_CODSIT_437520#140053, EM_CODSIT_PROD_437646#140054, EM_CODSOC_AF_437625#140055, EM_CODSOC_AH_437624#140056, EM_CODSOC_CF_437621#140057, EM_CODSOC_CH_437620#140058, EM_CODSOC_MF_437623#140059, EM_CODSOC_MH_437622#140060, EM_CODSPE_437687#140061, EM_CODSRV_437498#140062, EM_CODSTS_437576#140063, EM_CODTIT_437500#140064, EM_CODUFL_437526#140065, EM_CODUTI_437522#140066, EM_COMMENT_437571#140067, EM_COMM_1_437463#140068, EM_CONMUT_437549#140069, EM_CRL_AF_437618#140070, EM_CRL_AH_437617#140071, EM_CRL_CF_437614#140072, EM_CRL_CH_437613#140073, EM_CRL_MF_437616#140074, EM_CRL_MH_437615#140075, EM_CR_ATTENDU_437653#140076, EM_C_R_CD_437679#140077, EM_C_R_CR_437678#140078, EM_C_R_F_437680#140079, EM_DAT100_437489#140080, EM_DATACC2_437541#140081, EM_DATACC_437512#140082, EM_DATARR_437490#140083, EM_DATCOT_437492#140084, EM_DATCRE_437525#140085, EM_DATCSS_437488#140086, EM_DATENTREE_437682#140087, EM_DATENT_437547#140088, EM_DATENVC_437566#140089, EM_DATENVP_437505#140090, EM_DATENV_437503#140091, EM_DATF_D_437487#140092, EM_DATMAJ_437521#140093, EM_DATPARTI_437664#140094, EM_DATPJ_437542#140095, EM_DATPRC_437635#140096, EM_DATPRE_437523#140097, EM_DATRV_437438#140098, EM_DEBEXOMAT_437585#140099, EM_DEST_437642#140100, EM_DIF_DEFER_437668#140101, EM_DIF_PAT_437658#140102, EM_DIF_PRESC_437659#140103, EM_DMPAUT_437675#140104, EM_DOMAINE_437573#140105, EM_DOSCLO_437462#140106, EM_DOSCOM_437439#140107, EM_DROITS_437544#140108, EM_D_R_CD_437633#140109, EM_D_R_CR_437460#140110, EM_D_R_F_437461#140111, EM_ECHO_437447#140112, EM_ENVOIC_437565#140113, EM_ENVOIP_437504#140114, EM_ENVOI_437502#140115, EM_ETAPE_437456#140116, EM_EXA_LO_437446#140117, EM_EXA_SECU_437516#140118, EM_FACCON_437468#140119, EM_FACTUR_437467#140120, EM_FACTUR_ESTIM_437672#140121, EM_FERIE_437443#140122, EM_FINESS_437662#140123, EM_FINESS_HONO_437671#140124, EM_FINEXOMAT_437586#140125, EM_FLACCID_437528#140126, EM_FLAMCFSE_437553#140127, EM_FLAME_437604#140128, EM_FLARMAT_437582#140129, EM_FLCARNET_437538#140130, EM_FLCMU_437524#140131, EM_FLCVIM_437588#140132, EM_FLDECLMTR_437605#140133, EM_FLDMP_SECRET_437674#140134, EM_FLDOMIC_437543#140135, EM_FLENTREE_437681#140136, EM_FLFACT_437559#140137, EM_FLFTIMP_437655#140138, EM_FLGRATUI_437560#140139, EM_FLHOSPIT_437584#140140, EM_FLLIBERE_437676#140141, EM_FLNSCAI_437629#140142, EM_FLNSMUT_437630#140143, EM_FLNSPAT_437631#140144, EM_FLNUM_437558#140145, EM_FLPARTI_437663#140146, EM_FLPEC_437531#140147, EM_FLPORTAIL_437670#140148, EM_FLPRESCINF_437603#140149, EM_FLREFER_437534#140150, EM_FLTBDI_437639#140151, EM_FLTELE_437600#140152, EM_FLTITMED_437552#140153, EM_FLTOPM_437545#140154, EM_FLTOPR_437546#140155, EM_FLVIP_437669#140156, EM_FORC_437583#140157, EM_FORFAI_437444#140158, EM_GARMUT_437551#140159, EM_GROUPE_437464#140160, EM_HEUARR_437491#140161, EM_HEUCOT_437493#140162, EM_HEUENTREE_437683#140163, EM_HEUPRC_437636#140164, EM_IDFACSIT_437665#140165, EM_IDHOTE_437575#140166, EM_INDTRAI_437574#140167, EM_INFOAMC_437589#140168, EM_INFOTDB_437587#140169, EM_INT_SPE_437650#140170, EM_INT_STD_437649#140171, EM_IRM_437445#140172, EM_LIBEL_437453#140173, EM_LOCK_437634#140174, EM_MDTMUT_437564#140175, EM_MODTRT_437509#140176, EM_MONNAIE_437466#140177, EM_MOTPAS_437638#140178, EM_MTDEP_437592#140179, EM_MTDEP_ESTIM_437673#140180, EM_MT_PEC_SMG_437660#140181, EM_M_FORF_437469#140182, EM_NATASS_437510#140183, EM_NATURE_437455#140184, EM_NB_COT_437517#140185, EM_NB_FAC_437518#140186, EM_NUIT_437442#140187, EM_NUMACC_437511#140188, EM_NUMBOC_437481#140189, EM_NUMBOC_FT_437607#140190, EM_NUMBOF_437483#140191, EM_NUMBOM_437482#140192, EM_NUMBOM_FT_437608#140193, EM_NUMBOT_437507#140194, EM_NUMBOT_FT_437601#140195, EM_NUMCAI_437484#140196, EM_NUMCAI_FT_437657#140197, EM_NUMDEM_437436#140198, EM_NUMDEM_ORI_437666#140199, EM_NUMDEM_PROD_437644#140200, EM_NUMDOS_437435#140201, EM_NUMDOS_ORI_437686#140202, EM_NUMDOS_PROD_437647#140203, EM_NUMFAC_437513#140204, EM_NUMFOR_437486#140205, EM_NUMLOC_437527#140206, EM_NUMMUT_437485#140207, EM_NUMOP_437606#140208, EM_NUMPRG_437661#140209, EM_NUMREL_C_437561#140210, EM_NUMREL_C_F_437627#140211, EM_NUMREL_M_437562#140212, EM_NUMREL_M_F_437628#140213, EM_NUMREL_P_437563#140214, EM_NUMREL_P_F_437626#140215, EM_NUMSAF_437506#140216, EM_NUMSAL_437494#140217, EM_NUMTRT_437688#140218, EM_ORIDEM_437508#140219, EM_PARCAI_437471#140220, EM_PARFOR_437475#140221, EM_PARMUT_437473#140222, EM_PARMUT_FT_437554#140223, EM_PARMUT_HON_437555#140224, EM_PARPAT_437470#140225, EM_PARPAT_FT_437556#140226, EM_PARPAT_HON_437557#140227, EM_PAVMUT_437619#140228, EM_PJAMC_437579#140229, EM_PRCHAMC_437577#140230, EM_PRESCS_437684#140231, EM_QUALDP_437539#140232, EM_RCP_437652#140233, EM_REGCAI_437477#140234, EM_REGFOR_437479#140235, EM_REGMUT_437478#140236, EM_REGPAT_437476#140237, EM_REGPAT_HON_437593#140238, EM_REJBOC_437609#140239, EM_REJBOC_FT_437610#140240, EM_REJBOM_437611#140241, EM_REJBOM_FT_437612#140242, EM_REJBOT_437514#140243, EM_REJBOT_FT_437602#140244, EM_RNGNAI_437530#140245, EM_R_A_R_437480#140246, EM_R_CD_437632#140247, EM_R_CR_437458#140248, EM_R_F_437459#140249, EM_SCAN1_437495#140250, EM_SCAN2_437496#140251, EM_SIGMA_437452#140252, EM_SLDCAI_437598#140253, EM_SLDCAI_FT_437599#140254, EM_SLDMUT_437596#140255, EM_SLDMUT_FT_437597#140256, EM_SLDPAT_437594#140257, EM_SLDPAT_FT_437595#140258, EM_SPL_TRANS_437651#140259, EM_STAOPI_437569#140260, EM_STATCR_437457#140261, EM_STATUT_ENVOI_437654#140262, EM_STATUT_SMS_437643#140263, EM_SUPMOTIF_437656#140264, EM_TARIF_437515#140265, EM_TAUCAI_437472#140266, EM_TAUMUT_437474#140267, EM_TIERSP_437540#140268, EM_TPAMC_437578#140269, EM_TYPEXO_437529#140270, EM_TYPFAC_437580#140271, EM_TYPRES_437570#140272, EM_URGEN_437440#140273, EM_URG_437648#140274, EM_VALID_437454#140275, EM_VERSION_437519#140276]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_437435#140201)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_437435#140201)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_437436#140198)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_437436#140198)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMED_437437#140044)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMED_437437#140044)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATRV_437438#140098)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATRV_437438#140098)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCOM_437439#140107)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCOM_437439#140107)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URGEN_437440#140273)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_URGEN_437440#140273)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ASTREI_437441#140028)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ASTREI_437441#140028)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUIT_437442#140187)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUIT_437442#140187)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FERIE_437443#140122)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FERIE_437443#140122)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORFAI_437444#140158)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FORFAI_437444#140158)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IRM_437445#140172)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_IRM_437445#140172)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_LO_437446#140117)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_LO_437446#140117)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ECHO_437447#140112)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ECHO_437447#140112)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANGIO_437448#140026)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ANGIO_437448#140026)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_AUTR_437449#140031)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_AUTR_437449#140031)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSER_437450#140052)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSER_437450#140052)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODC_A_437451#140037)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODC_A_437451#140037)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SIGMA_437452#140252)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SIGMA_437452#140252)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LIBEL_437453#140173)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_LIBEL_437453#140173)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VALID_437454#140275)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_VALID_437454#140275)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATURE_437455#140184)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NATURE_437455#140184)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ETAPE_437456#140116)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ETAPE_437456#140116)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATCR_437457#140261)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_STATCR_437457#140261)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CR_437458#140248)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CR_437458#140248)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_F_437459#140249)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_R_F_437459#140249)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CR_437460#140110)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CR_437460#140110)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_F_437461#140111)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_F_437461#140111)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCLO_437462#140106)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCLO_437462#140106)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMM_1_437463#140068)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_COMM_1_437463#140068)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GROUPE_437464#140160)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_GROUPE_437464#140160)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANNVAL_437465#140027)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ANNVAL_437465#140027)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MONNAIE_437466#140177)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MONNAIE_437466#140177)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_437467#140120)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_437467#140120)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACCON_437468#140119)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FACCON_437468#140119)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_M_FORF_437469#140182)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_M_FORF_437469#140182)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_437470#140225)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_437470#140225)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARCAI_437471#140220)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARCAI_437471#140220)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUCAI_437472#140266)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUCAI_437472#140266)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_437473#140222)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_437473#140222)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUMUT_437474#140267)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUMUT_437474#140267)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARFOR_437475#140221)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARFOR_437475#140221)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_437476#140237)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_437476#140237)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGCAI_437477#140234)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGCAI_437477#140234)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGMUT_437478#140236)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGMUT_437478#140236)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGFOR_437479#140235)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGFOR_437479#140235)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_A_R_437480#140246)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_R_A_R_437480#140246)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_437481#140189)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_437481#140189)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_437482#140192)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_437482#140192)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOF_437483#140191)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOF_437483#140191)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_437484#140196)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_437484#140196)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMMUT_437485#140207)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMMUT_437485#140207)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFOR_437486#140205)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFOR_437486#140205)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATF_D_437487#140092)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATF_D_437487#140092)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCSS_437488#140086)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCSS_437488#140086)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DAT100_437489#140080)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DAT100_437489#140080)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATARR_437490#140083)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATARR_437490#140083)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUARR_437491#140161)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUARR_437491#140161)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCOT_437492#140084)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCOT_437492#140084)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUCOT_437493#140162)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUCOT_437493#140162)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAL_437494#140217)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAL_437494#140217)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN1_437495#140250)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN1_437495#140250)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN2_437496#140251)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN2_437496#140251)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSEC_437497#140051)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSEC_437497#140051)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSRV_437498#140062)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSRV_437498#140062)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENC_437499#140039)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENC_437499#140039)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODTIT_437500#140064)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODTIT_437500#140064)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODDIC_437501#140038)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODDIC_437501#140038)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOI_437502#140115)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOI_437502#140115)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENV_437503#140091)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENV_437503#140091)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIP_437504#140114)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIP_437504#140114)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVP_437505#140090)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVP_437505#140090)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAF_437506#140216)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAF_437506#140216)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_437507#140194)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_437507#140194)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ORIDEM_437508#140219)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ORIDEM_437508#140219)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MODTRT_437509#140176)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MODTRT_437509#140176)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATASS_437510#140183)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NATASS_437510#140183)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMACC_437511#140188)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMACC_437511#140188)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC_437512#140082)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC_437512#140082)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFAC_437513#140204)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFAC_437513#140204)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_437514#140243)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_437514#140243)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TARIF_437515#140265)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TARIF_437515#140265)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_SECU_437516#140118)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_SECU_437516#140118)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_COT_437517#140185)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_COT_437517#140185)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_FAC_437518#140186)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_FAC_437518#140186)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VERSION_437519#140276)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_VERSION_437519#140276)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_437520#140053)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_437520#140053)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATMAJ_437521#140093)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATMAJ_437521#140093)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUTI_437522#140066)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUTI_437522#140066)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRE_437523#140097)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRE_437523#140097)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCMU_437524#140131)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCMU_437524#140131)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCRE_437525#140085)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCRE_437525#140085)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUFL_437526#140065)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUFL_437526#140065)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMLOC_437527#140206)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMLOC_437527#140206)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLACCID_437528#140126)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLACCID_437528#140126)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPEXO_437529#140270)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPEXO_437529#140270)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RNGNAI_437530#140245)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_RNGNAI_437530#140245)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPEC_437531#140147)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPEC_437531#140147)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGAT_437532#140048)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGAT_437532#140048)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIAT_437533#140034)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIAT_437533#140034)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLREFER_437534#140150)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLREFER_437534#140150)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODPJ_437535#140047)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODPJ_437535#140047)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGPJ_437536#140049)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGPJ_437536#140049)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#140035)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#140035)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCARNET_437538#140130)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCARNET_437538#140130)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_QUALDP_437539#140232)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_QUALDP_437539#140232)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TIERSP_437540#140268)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TIERSP_437540#140268)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC2_437541#140081)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC2_437541#140081)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPJ_437542#140095)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPJ_437542#140095)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDOMIC_437543#140135)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDOMIC_437543#140135)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DROITS_437544#140108)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DROITS_437544#140108)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPM_437545#140154)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPM_437545#140154)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPR_437546#140155)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPR_437546#140155)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENT_437547#140088)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENT_437547#140088)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENT_437548#140040)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENT_437548#140040)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CONMUT_437549#140069)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CONMUT_437549#140069)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ADHMUT_437550#140024)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ADHMUT_437550#140024)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GARMUT_437551#140159)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_GARMUT_437551#140159)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTITMED_437552#140153)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTITMED_437552#140153)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#140127)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#140127)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#140223)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#140223)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#140224)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#140224)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#140226)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#140226)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#140227)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#140227)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNUM_437558#140145)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNUM_437558#140145)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFACT_437559#140137)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFACT_437559#140137)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLGRATUI_437560#140139)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLGRATUI_437560#140139)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_437561#140210)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_437561#140210)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_437562#140212)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_437562#140212)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_437563#140214)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_437563#140214)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MDTMUT_437564#140175)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MDTMUT_437564#140175)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIC_437565#140113)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIC_437565#140113)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVC_437566#140089)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVC_437566#140089)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODM_H_437567#140046)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODM_H_437567#140046)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODATS_437568#140033)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODATS_437568#140033)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STAOPI_437569#140260)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_STAOPI_437569#140260)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPRES_437570#140272)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPRES_437570#140272)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMMENT_437571#140067)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_COMMENT_437571#140067)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODROUT_437572#140050)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODROUT_437572#140050)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOMAINE_437573#140105)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DOMAINE_437573#140105)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INDTRAI_437574#140167)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INDTRAI_437574#140167)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDHOTE_437575#140166)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_IDHOTE_437575#140166)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSTS_437576#140063)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSTS_437576#140063)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRCHAMC_437577#140230)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PRCHAMC_437577#140230)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TPAMC_437578#140269)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TPAMC_437578#140269)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PJAMC_437579#140229)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PJAMC_437579#140229)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPFAC_437580#140271)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPFAC_437580#140271)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCENAT_437581#140036)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCENAT_437581#140036)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLARMAT_437582#140129)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLARMAT_437582#140129)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORC_437583#140157)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FORC_437583#140157)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#140140)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#140140)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#140099)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#140099)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#140125)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#140125)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOTDB_437587#140169)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOTDB_437587#140169)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCVIM_437588#140132)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCVIM_437588#140132)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOAMC_437589#140168)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOAMC_437589#140168)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODIPS_437590#140042)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODIPS_437590#140042)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMTR_437591#140045)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMTR_437591#140045)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_437592#140179)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_437592#140179)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#140238)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#140238)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_437594#140257)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_437594#140257)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#140258)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#140258)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_437596#140255)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_437596#140255)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#140256)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#140256)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_437598#140253)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_437598#140253)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#140254)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#140254)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTELE_437600#140152)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTELE_437600#140152)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#140195)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#140195)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#140244)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#140244)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#140149)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#140149)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAME_437604#140128)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAME_437604#140128)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#140133)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#140133)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMOP_437606#140208)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMOP_437606#140208)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#140190)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#140190)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#140193)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#140193)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_437609#140239)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_437609#140239)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#140240)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#140240)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_437611#140241)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_437611#140241)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#140242)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#140242)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CH_437613#140073)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CH_437613#140073)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CF_437614#140072)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CF_437614#140072)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MH_437615#140075)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MH_437615#140075)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MF_437616#140074)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MF_437616#140074)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AH_437617#140071)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AH_437617#140071)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AF_437618#140070)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AF_437618#140070)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PAVMUT_437619#140228)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PAVMUT_437619#140228)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#140058)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#140058)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#140057)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#140057)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#140060)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#140060)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#140059)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#140059)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#140056)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#140056)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#140055)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#140055)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#140215)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#140215)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#140211)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#140211)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#140213)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#140213)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSCAI_437629#140142)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSCAI_437629#140142)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSMUT_437630#140143)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSMUT_437630#140143)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSPAT_437631#140144)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSPAT_437631#140144)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CD_437632#140247)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CD_437632#140247)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CD_437633#140109)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CD_437633#140109)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LOCK_437634#140174)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_LOCK_437634#140174)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRC_437635#140096)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRC_437635#140096)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUPRC_437636#140164)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUPRC_437636#140164)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODACC_437637#140032)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODACC_437637#140032)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MOTPAS_437638#140178)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MOTPAS_437638#140178)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTBDI_437639#140151)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTBDI_437639#140151)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTENTE_437640#140029)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTENTE_437640#140029)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#140030)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#140030)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEST_437642#140100)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DEST_437642#140100)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#140263)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#140263)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#140200)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#140200)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#140041)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#140041)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#140054)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#140054)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#140203)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#140203)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URG_437648#140274)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_URG_437648#140274)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_STD_437649#140171)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_STD_437649#140171)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_SPE_437650#140170)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_SPE_437650#140170)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#140259)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#140259)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RCP_437652#140233)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_RCP_437652#140233)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#140076)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#140076)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#140262)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#140262)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFTIMP_437655#140138)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFTIMP_437655#140138)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#140264)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#140264)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#140197)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#140197)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PAT_437658#140102)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PAT_437658#140102)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#140103)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#140103)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#140181)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#140181)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMPRG_437661#140209)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMPRG_437661#140209)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_437662#140123)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_437662#140123)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPARTI_437663#140146)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPARTI_437663#140146)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPARTI_437664#140094)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPARTI_437664#140094)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDFACSIT_437665#140165)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_IDFACSIT_437665#140165)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#140199)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#140199)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ALARMES_437667#140025)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ALARMES_437667#140025)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#140101)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#140101)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLVIP_437669#140156)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLVIP_437669#140156)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#140148)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#140148)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#140124)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#140124)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#140121)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#140121)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#140180)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#140180)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#140134)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#140134)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DMPAUT_437675#140104)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DMPAUT_437675#140104)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLLIBERE_437676#140141)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLLIBERE_437676#140141)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACCNUM_437677#140022)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ACCNUM_437677#140022)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CR_437678#140078)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CR_437678#140078)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CD_437679#140077)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CD_437679#140077)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_F_437680#140079)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_F_437680#140079)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLENTREE_437681#140136)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_FLENTREE_437681#140136)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENTREE_437682#140087)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENTREE_437682#140087)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUENTREE_437683#140163)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUENTREE_437683#140163)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRESCS_437684#140231)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_PRESCS_437684#140231)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#140023)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#140023)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#140202)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#140202)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSPE_437687#140061)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSPE_437687#140061)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMTRT_437688#140218)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMTRT_437688#140218)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#140043)), )) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#140043)), ) END)

(3) Project
Output: []
Input [255]: [EM_ACCNUM_437677#140022, EM_ACTES_ESTIM_437685#140023, EM_ADHMUT_437550#140024, EM_ALARMES_437667#140025, EM_ANGIO_437448#140026, EM_ANNVAL_437465#140027, EM_ASTREI_437441#140028, EM_ATTENTE_437640#140029, EM_ATTMOTIF_437641#140030, EM_AUTR_437449#140031, EM_CODACC_437637#140032, EM_CODATS_437568#140033, EM_CODCAIAT_437533#140034, EM_CODCAIPJ_437537#140035, EM_CODCENAT_437581#140036, EM_CODC_A_437451#140037, EM_CODDIC_437501#140038, EM_CODENC_437499#140039, EM_CODENT_437548#140040, EM_CODETAB_PROD_437645#140041, EM_CODIPS_437590#140042, EM_CODMEDPAT_437689#140043, EM_CODMED_437437#140044, EM_CODMTR_437591#140045, EM_CODM_H_437567#140046, EM_CODPJ_437535#140047, EM_CODREGAT_437532#140048, EM_CODREGPJ_437536#140049, EM_CODROUT_437572#140050, EM_CODSEC_437497#140051, EM_CODSER_437450#140052, EM_CODSIT_437520#140053, EM_CODSIT_PROD_437646#140054, EM_CODSOC_AF_437625#140055, EM_CODSOC_AH_437624#140056, EM_CODSOC_CF_437621#140057, EM_CODSOC_CH_437620#140058, EM_CODSOC_MF_437623#140059, EM_CODSOC_MH_437622#140060, EM_CODSPE_437687#140061, EM_CODSRV_437498#140062, EM_CODSTS_437576#140063, EM_CODTIT_437500#140064, EM_CODUFL_437526#140065, EM_CODUTI_437522#140066, EM_COMMENT_437571#140067, EM_COMM_1_437463#140068, EM_CONMUT_437549#140069, EM_CRL_AF_437618#140070, EM_CRL_AH_437617#140071, EM_CRL_CF_437614#140072, EM_CRL_CH_437613#140073, EM_CRL_MF_437616#140074, EM_CRL_MH_437615#140075, EM_CR_ATTENDU_437653#140076, EM_C_R_CD_437679#140077, EM_C_R_CR_437678#140078, EM_C_R_F_437680#140079, EM_DAT100_437489#140080, EM_DATACC2_437541#140081, EM_DATACC_437512#140082, EM_DATARR_437490#140083, EM_DATCOT_437492#140084, EM_DATCRE_437525#140085, EM_DATCSS_437488#140086, EM_DATENTREE_437682#140087, EM_DATENT_437547#140088, EM_DATENVC_437566#140089, EM_DATENVP_437505#140090, EM_DATENV_437503#140091, EM_DATF_D_437487#140092, EM_DATMAJ_437521#140093, EM_DATPARTI_437664#140094, EM_DATPJ_437542#140095, EM_DATPRC_437635#140096, EM_DATPRE_437523#140097, EM_DATRV_437438#140098, EM_DEBEXOMAT_437585#140099, EM_DEST_437642#140100, EM_DIF_DEFER_437668#140101, EM_DIF_PAT_437658#140102, EM_DIF_PRESC_437659#140103, EM_DMPAUT_437675#140104, EM_DOMAINE_437573#140105, EM_DOSCLO_437462#140106, EM_DOSCOM_437439#140107, EM_DROITS_437544#140108, EM_D_R_CD_437633#140109, EM_D_R_CR_437460#140110, EM_D_R_F_437461#140111, EM_ECHO_437447#140112, EM_ENVOIC_437565#140113, EM_ENVOIP_437504#140114, EM_ENVOI_437502#140115, EM_ETAPE_437456#140116, EM_EXA_LO_437446#140117, EM_EXA_SECU_437516#140118, EM_FACCON_437468#140119, EM_FACTUR_437467#140120, EM_FACTUR_ESTIM_437672#140121, EM_FERIE_437443#140122, EM_FINESS_437662#140123, EM_FINESS_HONO_437671#140124, EM_FINEXOMAT_437586#140125, EM_FLACCID_437528#140126, EM_FLAMCFSE_437553#140127, EM_FLAME_437604#140128, EM_FLARMAT_437582#140129, EM_FLCARNET_437538#140130, EM_FLCMU_437524#140131, EM_FLCVIM_437588#140132, EM_FLDECLMTR_437605#140133, EM_FLDMP_SECRET_437674#140134, EM_FLDOMIC_437543#140135, EM_FLENTREE_437681#140136, EM_FLFACT_437559#140137, EM_FLFTIMP_437655#140138, EM_FLGRATUI_437560#140139, EM_FLHOSPIT_437584#140140, EM_FLLIBERE_437676#140141, EM_FLNSCAI_437629#140142, EM_FLNSMUT_437630#140143, EM_FLNSPAT_437631#140144, EM_FLNUM_437558#140145, EM_FLPARTI_437663#140146, EM_FLPEC_437531#140147, EM_FLPORTAIL_437670#140148, EM_FLPRESCINF_437603#140149, EM_FLREFER_437534#140150, EM_FLTBDI_437639#140151, EM_FLTELE_437600#140152, EM_FLTITMED_437552#140153, EM_FLTOPM_437545#140154, EM_FLTOPR_437546#140155, EM_FLVIP_437669#140156, EM_FORC_437583#140157, EM_FORFAI_437444#140158, EM_GARMUT_437551#140159, EM_GROUPE_437464#140160, EM_HEUARR_437491#140161, EM_HEUCOT_437493#140162, EM_HEUENTREE_437683#140163, EM_HEUPRC_437636#140164, EM_IDFACSIT_437665#140165, EM_IDHOTE_437575#140166, EM_INDTRAI_437574#140167, EM_INFOAMC_437589#140168, EM_INFOTDB_437587#140169, EM_INT_SPE_437650#140170, EM_INT_STD_437649#140171, EM_IRM_437445#140172, EM_LIBEL_437453#140173, EM_LOCK_437634#140174, EM_MDTMUT_437564#140175, EM_MODTRT_437509#140176, EM_MONNAIE_437466#140177, EM_MOTPAS_437638#140178, EM_MTDEP_437592#140179, EM_MTDEP_ESTIM_437673#140180, EM_MT_PEC_SMG_437660#140181, EM_M_FORF_437469#140182, EM_NATASS_437510#140183, EM_NATURE_437455#140184, EM_NB_COT_437517#140185, EM_NB_FAC_437518#140186, EM_NUIT_437442#140187, EM_NUMACC_437511#140188, EM_NUMBOC_437481#140189, EM_NUMBOC_FT_437607#140190, EM_NUMBOF_437483#140191, EM_NUMBOM_437482#140192, EM_NUMBOM_FT_437608#140193, EM_NUMBOT_437507#140194, EM_NUMBOT_FT_437601#140195, EM_NUMCAI_437484#140196, EM_NUMCAI_FT_437657#140197, EM_NUMDEM_437436#140198, EM_NUMDEM_ORI_437666#140199, EM_NUMDEM_PROD_437644#140200, EM_NUMDOS_437435#140201, EM_NUMDOS_ORI_437686#140202, EM_NUMDOS_PROD_437647#140203, EM_NUMFAC_437513#140204, EM_NUMFOR_437486#140205, EM_NUMLOC_437527#140206, EM_NUMMUT_437485#140207, EM_NUMOP_437606#140208, EM_NUMPRG_437661#140209, EM_NUMREL_C_437561#140210, EM_NUMREL_C_F_437627#140211, EM_NUMREL_M_437562#140212, EM_NUMREL_M_F_437628#140213, EM_NUMREL_P_437563#140214, EM_NUMREL_P_F_437626#140215, EM_NUMSAF_437506#140216, EM_NUMSAL_437494#140217, EM_NUMTRT_437688#140218, EM_ORIDEM_437508#140219, EM_PARCAI_437471#140220, EM_PARFOR_437475#140221, EM_PARMUT_437473#140222, EM_PARMUT_FT_437554#140223, EM_PARMUT_HON_437555#140224, EM_PARPAT_437470#140225, EM_PARPAT_FT_437556#140226, EM_PARPAT_HON_437557#140227, EM_PAVMUT_437619#140228, EM_PJAMC_437579#140229, EM_PRCHAMC_437577#140230, EM_PRESCS_437684#140231, EM_QUALDP_437539#140232, EM_RCP_437652#140233, EM_REGCAI_437477#140234, EM_REGFOR_437479#140235, EM_REGMUT_437478#140236, EM_REGPAT_437476#140237, EM_REGPAT_HON_437593#140238, EM_REJBOC_437609#140239, EM_REJBOC_FT_437610#140240, EM_REJBOM_437611#140241, EM_REJBOM_FT_437612#140242, EM_REJBOT_437514#140243, EM_REJBOT_FT_437602#140244, EM_RNGNAI_437530#140245, EM_R_A_R_437480#140246, EM_R_CD_437632#140247, EM_R_CR_437458#140248, EM_R_F_437459#140249, EM_SCAN1_437495#140250, EM_SCAN2_437496#140251, EM_SIGMA_437452#140252, EM_SLDCAI_437598#140253, EM_SLDCAI_FT_437599#140254, EM_SLDMUT_437596#140255, EM_SLDMUT_FT_437597#140256, EM_SLDPAT_437594#140257, EM_SLDPAT_FT_437595#140258, EM_SPL_TRANS_437651#140259, EM_STAOPI_437569#140260, EM_STATCR_437457#140261, EM_STATUT_ENVOI_437654#140262, EM_STATUT_SMS_437643#140263, EM_SUPMOTIF_437656#140264, EM_TARIF_437515#140265, EM_TAUCAI_437472#140266, EM_TAUMUT_437474#140267, EM_TIERSP_437540#140268, EM_TPAMC_437578#140269, EM_TYPEXO_437529#140270, EM_TYPFAC_437580#140271, EM_TYPRES_437570#140272, EM_URGEN_437440#140273, EM_URG_437648#140274, EM_VALID_437454#140275, EM_VERSION_437519#140276]

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

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

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

(7) HashAggregate [codegen id : 2]
Input [1]: [count#142794L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#142531L]
Results [1]: [count(1)#142531L AS COL_c6df0007-3c9f-488f-ae80-3f34359ea8b7#142533L]

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

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

(10) HashAggregate
Input [1]: [count#142794L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#142531L]
Results [1]: [count(1)#142531L AS COL_c6df0007-3c9f-488f-ae80-3f34359ea8b7#142533L]

(11) AdaptiveSparkPlan
Output [1]: [COL_c6df0007-3c9f-488f-ae80-3f34359ea8b7#142533L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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