hdh-spark-job - Details for Query 605

Submitted Time: 2026/10/21 21:31:50
Duration: 8 s
Succeeded Jobs: 537 542

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: 56.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: 56.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 7.2 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 7.2 s number of output rows: 1"]; } 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 0"]; 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=11949]

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

WholeStageCodegen (1)

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_437435#123883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_437435#123883)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_437436#123880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_437436#123880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMED_437437#123726)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMED_437437#123726)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATRV_437438#123780)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATRV_437438#123780)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCOM_437439#123789)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCOM_437439#123789)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URGEN_437440#123955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_URGEN_437440#123955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ASTREI_437441#123710)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ASTREI_437441#123710)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUIT_437442#123869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUIT_437442#123869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FERIE_437443#123804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FERIE_437443#123804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORFAI_437444#123840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORFAI_437444#123840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IRM_437445#123854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IRM_437445#123854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_LO_437446#123799)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_LO_437446#123799)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ECHO_437447#123794)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ECHO_437447#123794)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANGIO_437448#123708)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANGIO_437448#123708)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_AUTR_437449#123713)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_AUTR_437449#123713)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSER_437450#123734)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSER_437450#123734)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODC_A_437451#123719)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODC_A_437451#123719)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SIGMA_437452#123934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SIGMA_437452#123934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LIBEL_437453#123855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_LIBEL_437453#123855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VALID_437454#123957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_VALID_437454#123957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATURE_437455#123866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATURE_437455#123866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ETAPE_437456#123798)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ETAPE_437456#123798)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATCR_437457#123943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATCR_437457#123943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CR_437458#123930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CR_437458#123930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_F_437459#123931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_F_437459#123931)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CR_437460#123792)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CR_437460#123792)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_F_437461#123793)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_F_437461#123793)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCLO_437462#123788)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCLO_437462#123788)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMM_1_437463#123750)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMM_1_437463#123750)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GROUPE_437464#123842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_GROUPE_437464#123842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANNVAL_437465#123709)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANNVAL_437465#123709)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MONNAIE_437466#123859)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MONNAIE_437466#123859)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_437467#123802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_437467#123802)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACCON_437468#123801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACCON_437468#123801)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_M_FORF_437469#123864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_M_FORF_437469#123864)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_437470#123907)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_437470#123907)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARCAI_437471#123902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARCAI_437471#123902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUCAI_437472#123948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUCAI_437472#123948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_437473#123904)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_437473#123904)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUMUT_437474#123949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUMUT_437474#123949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARFOR_437475#123903)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARFOR_437475#123903)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_437476#123919)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_437476#123919)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGCAI_437477#123916)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGCAI_437477#123916)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGMUT_437478#123918)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGMUT_437478#123918)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGFOR_437479#123917)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGFOR_437479#123917)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_A_R_437480#123928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_A_R_437480#123928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_437481#123871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_437481#123871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_437482#123874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_437482#123874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOF_437483#123873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOF_437483#123873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_437484#123878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_437484#123878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMMUT_437485#123889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMMUT_437485#123889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFOR_437486#123887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFOR_437486#123887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATF_D_437487#123774)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATF_D_437487#123774)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCSS_437488#123768)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCSS_437488#123768)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DAT100_437489#123762)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DAT100_437489#123762)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATARR_437490#123765)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATARR_437490#123765)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUARR_437491#123843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUARR_437491#123843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCOT_437492#123766)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCOT_437492#123766)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUCOT_437493#123844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUCOT_437493#123844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAL_437494#123899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAL_437494#123899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN1_437495#123932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN1_437495#123932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN2_437496#123933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN2_437496#123933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSEC_437497#123733)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSEC_437497#123733)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSRV_437498#123744)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSRV_437498#123744)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENC_437499#123721)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENC_437499#123721)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODTIT_437500#123746)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODTIT_437500#123746)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODDIC_437501#123720)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODDIC_437501#123720)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOI_437502#123797)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOI_437502#123797)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENV_437503#123773)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENV_437503#123773)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIP_437504#123796)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIP_437504#123796)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVP_437505#123772)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVP_437505#123772)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAF_437506#123898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAF_437506#123898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_437507#123876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_437507#123876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ORIDEM_437508#123901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ORIDEM_437508#123901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MODTRT_437509#123858)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MODTRT_437509#123858)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATASS_437510#123865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATASS_437510#123865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMACC_437511#123870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMACC_437511#123870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC_437512#123764)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC_437512#123764)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFAC_437513#123886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFAC_437513#123886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_437514#123925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_437514#123925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TARIF_437515#123947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TARIF_437515#123947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_SECU_437516#123800)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_SECU_437516#123800)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_COT_437517#123867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_COT_437517#123867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_FAC_437518#123868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_FAC_437518#123868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VERSION_437519#123958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_VERSION_437519#123958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_437520#123735)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_437520#123735)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATMAJ_437521#123775)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATMAJ_437521#123775)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUTI_437522#123748)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUTI_437522#123748)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRE_437523#123779)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRE_437523#123779)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCMU_437524#123813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCMU_437524#123813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCRE_437525#123767)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCRE_437525#123767)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUFL_437526#123747)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUFL_437526#123747)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMLOC_437527#123888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMLOC_437527#123888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLACCID_437528#123808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLACCID_437528#123808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPEXO_437529#123952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPEXO_437529#123952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RNGNAI_437530#123927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_RNGNAI_437530#123927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPEC_437531#123829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPEC_437531#123829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGAT_437532#123730)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGAT_437532#123730)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIAT_437533#123716)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIAT_437533#123716)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLREFER_437534#123832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLREFER_437534#123832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODPJ_437535#123729)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODPJ_437535#123729)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGPJ_437536#123731)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGPJ_437536#123731)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#123717)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#123717)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCARNET_437538#123812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCARNET_437538#123812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_QUALDP_437539#123914)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_QUALDP_437539#123914)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TIERSP_437540#123950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TIERSP_437540#123950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC2_437541#123763)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC2_437541#123763)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPJ_437542#123777)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPJ_437542#123777)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDOMIC_437543#123817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDOMIC_437543#123817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DROITS_437544#123790)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DROITS_437544#123790)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPM_437545#123836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPM_437545#123836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPR_437546#123837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPR_437546#123837)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENT_437547#123770)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENT_437547#123770)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENT_437548#123722)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENT_437548#123722)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CONMUT_437549#123751)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CONMUT_437549#123751)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ADHMUT_437550#123706)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ADHMUT_437550#123706)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GARMUT_437551#123841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_GARMUT_437551#123841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTITMED_437552#123835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTITMED_437552#123835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#123809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#123809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#123905)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#123905)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#123906)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#123906)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#123908)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#123908)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#123909)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#123909)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNUM_437558#123827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNUM_437558#123827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFACT_437559#123819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFACT_437559#123819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLGRATUI_437560#123821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLGRATUI_437560#123821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_437561#123892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_437561#123892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_437562#123894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_437562#123894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_437563#123896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_437563#123896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MDTMUT_437564#123857)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MDTMUT_437564#123857)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIC_437565#123795)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIC_437565#123795)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVC_437566#123771)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVC_437566#123771)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODM_H_437567#123728)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODM_H_437567#123728)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODATS_437568#123715)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODATS_437568#123715)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STAOPI_437569#123942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STAOPI_437569#123942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPRES_437570#123954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPRES_437570#123954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMMENT_437571#123749)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMMENT_437571#123749)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODROUT_437572#123732)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODROUT_437572#123732)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOMAINE_437573#123787)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOMAINE_437573#123787)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INDTRAI_437574#123849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INDTRAI_437574#123849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDHOTE_437575#123848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDHOTE_437575#123848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSTS_437576#123745)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSTS_437576#123745)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRCHAMC_437577#123912)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRCHAMC_437577#123912)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TPAMC_437578#123951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TPAMC_437578#123951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PJAMC_437579#123911)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PJAMC_437579#123911)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPFAC_437580#123953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPFAC_437580#123953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCENAT_437581#123718)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCENAT_437581#123718)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLARMAT_437582#123811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLARMAT_437582#123811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORC_437583#123839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORC_437583#123839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#123822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#123822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#123781)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#123781)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#123807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#123807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOTDB_437587#123851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOTDB_437587#123851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCVIM_437588#123814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCVIM_437588#123814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOAMC_437589#123850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOAMC_437589#123850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODIPS_437590#123724)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODIPS_437590#123724)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMTR_437591#123727)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMTR_437591#123727)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_437592#123861)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_437592#123861)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#123920)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#123920)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_437594#123939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_437594#123939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#123940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#123940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_437596#123937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_437596#123937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#123938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#123938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_437598#123935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_437598#123935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#123936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#123936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTELE_437600#123834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTELE_437600#123834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#123877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#123877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#123926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#123926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#123831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#123831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAME_437604#123810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAME_437604#123810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#123815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#123815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMOP_437606#123890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMOP_437606#123890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#123872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#123872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#123875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#123875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_437609#123921)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_437609#123921)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#123922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#123922)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_437611#123923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_437611#123923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#123924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#123924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CH_437613#123755)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CH_437613#123755)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CF_437614#123754)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CF_437614#123754)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MH_437615#123757)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MH_437615#123757)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MF_437616#123756)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MF_437616#123756)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AH_437617#123753)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AH_437617#123753)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AF_437618#123752)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AF_437618#123752)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PAVMUT_437619#123910)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PAVMUT_437619#123910)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#123740)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#123740)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#123739)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#123739)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#123742)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#123742)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#123741)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#123741)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#123738)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#123738)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#123737)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#123737)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#123897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#123897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#123893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#123893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#123895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#123895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSCAI_437629#123824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSCAI_437629#123824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSMUT_437630#123825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSMUT_437630#123825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSPAT_437631#123826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSPAT_437631#123826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CD_437632#123929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CD_437632#123929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CD_437633#123791)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CD_437633#123791)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LOCK_437634#123856)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_LOCK_437634#123856)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRC_437635#123778)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRC_437635#123778)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUPRC_437636#123846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUPRC_437636#123846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODACC_437637#123714)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODACC_437637#123714)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MOTPAS_437638#123860)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MOTPAS_437638#123860)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTBDI_437639#123833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTBDI_437639#123833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTENTE_437640#123711)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTENTE_437640#123711)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#123712)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#123712)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEST_437642#123782)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEST_437642#123782)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#123945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#123945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#123882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#123882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#123723)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#123723)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#123736)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#123736)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#123885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#123885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URG_437648#123956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_URG_437648#123956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_STD_437649#123853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_STD_437649#123853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_SPE_437650#123852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_SPE_437650#123852)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#123941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#123941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RCP_437652#123915)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_RCP_437652#123915)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#123758)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#123758)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#123944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#123944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFTIMP_437655#123820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFTIMP_437655#123820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#123946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#123946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#123879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#123879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PAT_437658#123784)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PAT_437658#123784)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#123785)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#123785)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#123863)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#123863)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMPRG_437661#123891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMPRG_437661#123891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_437662#123805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_437662#123805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPARTI_437663#123828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPARTI_437663#123828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPARTI_437664#123776)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPARTI_437664#123776)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDFACSIT_437665#123847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDFACSIT_437665#123847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#123881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#123881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ALARMES_437667#123707)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ALARMES_437667#123707)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#123783)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#123783)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLVIP_437669#123838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLVIP_437669#123838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#123830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#123830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#123806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#123806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#123803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#123803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#123862)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#123862)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#123816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#123816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DMPAUT_437675#123786)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DMPAUT_437675#123786)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLLIBERE_437676#123823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLLIBERE_437676#123823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACCNUM_437677#123704)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACCNUM_437677#123704)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CR_437678#123760)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CR_437678#123760)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CD_437679#123759)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CD_437679#123759)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_F_437680#123761)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_F_437680#123761)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLENTREE_437681#123818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLENTREE_437681#123818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENTREE_437682#123769)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENTREE_437682#123769)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUENTREE_437683#123845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUENTREE_437683#123845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRESCS_437684#123913)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRESCS_437684#123913)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#123705)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#123705)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#123884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#123884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSPE_437687#123743)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSPE_437687#123743)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMTRT_437688#123900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMTRT_437688#123900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#123725)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#123725)), MARX) END)

FileScan parquet [EM_ACCNUM_437677#123704,EM_ACTES_ESTIM_437685#123705,EM_ADHMUT_437550#123706,EM_ALARMES_437667#123707,EM_ANGIO_437448#123708,EM_ANNVAL_437465#123709,EM_ASTREI_437441#123710,EM_ATTENTE_437640#123711,EM_ATTMOTIF_437641#123712,EM_AUTR_437449#123713,EM_CODACC_437637#123714,EM_CODATS_437568#123715,EM_CODCAIAT_437533#123716,EM_CODCAIPJ_437537#123717,EM_CODCENAT_437581#123718,EM_CODC_A_437451#123719,EM_CODDIC_437501#123720,EM_CODENC_437499#123721,EM_CODENT_437548#123722,EM_CODETAB_PROD_437645#123723,EM_CODIPS_437590#123724,EM_CODMEDPAT_437689#123725,EM_CODMED_437437#123726,EM_CODMTR_437591#123727,... 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#123704, EM_ACTES_ESTIM_437685#123705, EM_ADHMUT_437550#123706, EM_ALARMES_437667#123707, EM_ANGIO_437448#123708, EM_ANNVAL_437465#123709, EM_ASTREI_437441#123710, EM_ATTENTE_437640#123711, EM_ATTMOTIF_437641#123712, EM_AUTR_437449#123713, EM_CODACC_437637#123714, EM_CODATS_437568#123715, EM_CODCAIAT_437533#123716, EM_CODCAIPJ_437537#123717, EM_CODCENAT_437581#123718, EM_CODC_A_437451#123719, EM_CODDIC_437501#123720, EM_CODENC_437499#123721, EM_CODENT_437548#123722, EM_CODETAB_PROD_437645#123723, EM_CODIPS_437590#123724, EM_CODMEDPAT_437689#123725, EM_CODMED_437437#123726, EM_CODMTR_437591#123727, EM_CODM_H_437567#123728, EM_CODPJ_437535#123729, EM_CODREGAT_437532#123730, EM_CODREGPJ_437536#123731, EM_CODROUT_437572#123732, EM_CODSEC_437497#123733, EM_CODSER_437450#123734, EM_CODSIT_437520#123735, EM_CODSIT_PROD_437646#123736, EM_CODSOC_AF_437625#123737, EM_CODSOC_AH_437624#123738, EM_CODSOC_CF_437621#123739, EM_CODSOC_CH_437620#123740, EM_CODSOC_MF_437623#123741, EM_CODSOC_MH_437622#123742, EM_CODSPE_437687#123743, EM_CODSRV_437498#123744, EM_CODSTS_437576#123745, EM_CODTIT_437500#123746, EM_CODUFL_437526#123747, EM_CODUTI_437522#123748, EM_COMMENT_437571#123749, EM_COMM_1_437463#123750, EM_CONMUT_437549#123751, EM_CRL_AF_437618#123752, EM_CRL_AH_437617#123753, EM_CRL_CF_437614#123754, EM_CRL_CH_437613#123755, EM_CRL_MF_437616#123756, EM_CRL_MH_437615#123757, EM_CR_ATTENDU_437653#123758, EM_C_R_CD_437679#123759, EM_C_R_CR_437678#123760, EM_C_R_F_437680#123761, EM_DAT100_437489#123762, EM_DATACC2_437541#123763, EM_DATACC_437512#123764, EM_DATARR_437490#123765, EM_DATCOT_437492#123766, EM_DATCRE_437525#123767, EM_DATCSS_437488#123768, EM_DATENTREE_437682#123769, EM_DATENT_437547#123770, EM_DATENVC_437566#123771, EM_DATENVP_437505#123772, EM_DATENV_437503#123773, EM_DATF_D_437487#123774, EM_DATMAJ_437521#123775, EM_DATPARTI_437664#123776, EM_DATPJ_437542#123777, EM_DATPRC_437635#123778, EM_DATPRE_437523#123779, EM_DATRV_437438#123780, EM_DEBEXOMAT_437585#123781, EM_DEST_437642#123782, EM_DIF_DEFER_437668#123783, EM_DIF_PAT_437658#123784, EM_DIF_PRESC_437659#123785, EM_DMPAUT_437675#123786, EM_DOMAINE_437573#123787, EM_DOSCLO_437462#123788, EM_DOSCOM_437439#123789, EM_DROITS_437544#123790, EM_D_R_CD_437633#123791, EM_D_R_CR_437460#123792, EM_D_R_F_437461#123793, EM_ECHO_437447#123794, EM_ENVOIC_437565#123795, EM_ENVOIP_437504#123796, EM_ENVOI_437502#123797, EM_ETAPE_437456#123798, EM_EXA_LO_437446#123799, EM_EXA_SECU_437516#123800, EM_FACCON_437468#123801, EM_FACTUR_437467#123802, EM_FACTUR_ESTIM_437672#123803, EM_FERIE_437443#123804, EM_FINESS_437662#123805, EM_FINESS_HONO_437671#123806, EM_FINEXOMAT_437586#123807, EM_FLACCID_437528#123808, EM_FLAMCFSE_437553#123809, EM_FLAME_437604#123810, EM_FLARMAT_437582#123811, EM_FLCARNET_437538#123812, EM_FLCMU_437524#123813, EM_FLCVIM_437588#123814, EM_FLDECLMTR_437605#123815, EM_FLDMP_SECRET_437674#123816, EM_FLDOMIC_437543#123817, EM_FLENTREE_437681#123818, EM_FLFACT_437559#123819, EM_FLFTIMP_437655#123820, EM_FLGRATUI_437560#123821, EM_FLHOSPIT_437584#123822, EM_FLLIBERE_437676#123823, EM_FLNSCAI_437629#123824, EM_FLNSMUT_437630#123825, EM_FLNSPAT_437631#123826, EM_FLNUM_437558#123827, EM_FLPARTI_437663#123828, EM_FLPEC_437531#123829, EM_FLPORTAIL_437670#123830, EM_FLPRESCINF_437603#123831, EM_FLREFER_437534#123832, EM_FLTBDI_437639#123833, EM_FLTELE_437600#123834, EM_FLTITMED_437552#123835, EM_FLTOPM_437545#123836, EM_FLTOPR_437546#123837, EM_FLVIP_437669#123838, EM_FORC_437583#123839, EM_FORFAI_437444#123840, EM_GARMUT_437551#123841, EM_GROUPE_437464#123842, EM_HEUARR_437491#123843, EM_HEUCOT_437493#123844, EM_HEUENTREE_437683#123845, EM_HEUPRC_437636#123846, EM_IDFACSIT_437665#123847, EM_IDHOTE_437575#123848, EM_INDTRAI_437574#123849, EM_INFOAMC_437589#123850, EM_INFOTDB_437587#123851, EM_INT_SPE_437650#123852, EM_INT_STD_437649#123853, EM_IRM_437445#123854, EM_LIBEL_437453#123855, EM_LOCK_437634#123856, EM_MDTMUT_437564#123857, EM_MODTRT_437509#123858, EM_MONNAIE_437466#123859, EM_MOTPAS_437638#123860, EM_MTDEP_437592#123861, EM_MTDEP_ESTIM_437673#123862, EM_MT_PEC_SMG_437660#123863, EM_M_FORF_437469#123864, EM_NATASS_437510#123865, EM_NATURE_437455#123866, EM_NB_COT_437517#123867, EM_NB_FAC_437518#123868, EM_NUIT_437442#123869, EM_NUMACC_437511#123870, EM_NUMBOC_437481#123871, EM_NUMBOC_FT_437607#123872, EM_NUMBOF_437483#123873, EM_NUMBOM_437482#123874, EM_NUMBOM_FT_437608#123875, EM_NUMBOT_437507#123876, EM_NUMBOT_FT_437601#123877, EM_NUMCAI_437484#123878, EM_NUMCAI_FT_437657#123879, EM_NUMDEM_437436#123880, EM_NUMDEM_ORI_437666#123881, EM_NUMDEM_PROD_437644#123882, EM_NUMDOS_437435#123883, EM_NUMDOS_ORI_437686#123884, EM_NUMDOS_PROD_437647#123885, EM_NUMFAC_437513#123886, EM_NUMFOR_437486#123887, EM_NUMLOC_437527#123888, EM_NUMMUT_437485#123889, EM_NUMOP_437606#123890, EM_NUMPRG_437661#123891, EM_NUMREL_C_437561#123892, EM_NUMREL_C_F_437627#123893, EM_NUMREL_M_437562#123894, EM_NUMREL_M_F_437628#123895, EM_NUMREL_P_437563#123896, EM_NUMREL_P_F_437626#123897, EM_NUMSAF_437506#123898, EM_NUMSAL_437494#123899, EM_NUMTRT_437688#123900, EM_ORIDEM_437508#123901, EM_PARCAI_437471#123902, EM_PARFOR_437475#123903, EM_PARMUT_437473#123904, EM_PARMUT_FT_437554#123905, EM_PARMUT_HON_437555#123906, EM_PARPAT_437470#123907, EM_PARPAT_FT_437556#123908, EM_PARPAT_HON_437557#123909, EM_PAVMUT_437619#123910, EM_PJAMC_437579#123911, EM_PRCHAMC_437577#123912, EM_PRESCS_437684#123913, EM_QUALDP_437539#123914, EM_RCP_437652#123915, EM_REGCAI_437477#123916, EM_REGFOR_437479#123917, EM_REGMUT_437478#123918, EM_REGPAT_437476#123919, EM_REGPAT_HON_437593#123920, EM_REJBOC_437609#123921, EM_REJBOC_FT_437610#123922, EM_REJBOM_437611#123923, EM_REJBOM_FT_437612#123924, EM_REJBOT_437514#123925, EM_REJBOT_FT_437602#123926, EM_RNGNAI_437530#123927, EM_R_A_R_437480#123928, EM_R_CD_437632#123929, EM_R_CR_437458#123930, EM_R_F_437459#123931, EM_SCAN1_437495#123932, EM_SCAN2_437496#123933, EM_SIGMA_437452#123934, EM_SLDCAI_437598#123935, EM_SLDCAI_FT_437599#123936, EM_SLDMUT_437596#123937, EM_SLDMUT_FT_437597#123938, EM_SLDPAT_437594#123939, EM_SLDPAT_FT_437595#123940, EM_SPL_TRANS_437651#123941, EM_STAOPI_437569#123942, EM_STATCR_437457#123943, EM_STATUT_ENVOI_437654#123944, EM_STATUT_SMS_437643#123945, EM_SUPMOTIF_437656#123946, EM_TARIF_437515#123947, EM_TAUCAI_437472#123948, EM_TAUMUT_437474#123949, EM_TIERSP_437540#123950, EM_TPAMC_437578#123951, EM_TYPEXO_437529#123952, EM_TYPFAC_437580#123953, EM_TYPRES_437570#123954, EM_URGEN_437440#123955, EM_URG_437648#123956, EM_VALID_437454#123957, EM_VERSION_437519#123958]
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#123704, EM_ACTES_ESTIM_437685#123705, EM_ADHMUT_437550#123706, EM_ALARMES_437667#123707, EM_ANGIO_437448#123708, EM_ANNVAL_437465#123709, EM_ASTREI_437441#123710, EM_ATTENTE_437640#123711, EM_ATTMOTIF_437641#123712, EM_AUTR_437449#123713, EM_CODACC_437637#123714, EM_CODATS_437568#123715, EM_CODCAIAT_437533#123716, EM_CODCAIPJ_437537#123717, EM_CODCENAT_437581#123718, EM_CODC_A_437451#123719, EM_CODDIC_437501#123720, EM_CODENC_437499#123721, EM_CODENT_437548#123722, EM_CODETAB_PROD_437645#123723, EM_CODIPS_437590#123724, EM_CODMEDPAT_437689#123725, EM_CODMED_437437#123726, EM_CODMTR_437591#123727, EM_CODM_H_437567#123728, EM_CODPJ_437535#123729, EM_CODREGAT_437532#123730, EM_CODREGPJ_437536#123731, EM_CODROUT_437572#123732, EM_CODSEC_437497#123733, EM_CODSER_437450#123734, EM_CODSIT_437520#123735, EM_CODSIT_PROD_437646#123736, EM_CODSOC_AF_437625#123737, EM_CODSOC_AH_437624#123738, EM_CODSOC_CF_437621#123739, EM_CODSOC_CH_437620#123740, EM_CODSOC_MF_437623#123741, EM_CODSOC_MH_437622#123742, EM_CODSPE_437687#123743, EM_CODSRV_437498#123744, EM_CODSTS_437576#123745, EM_CODTIT_437500#123746, EM_CODUFL_437526#123747, EM_CODUTI_437522#123748, EM_COMMENT_437571#123749, EM_COMM_1_437463#123750, EM_CONMUT_437549#123751, EM_CRL_AF_437618#123752, EM_CRL_AH_437617#123753, EM_CRL_CF_437614#123754, EM_CRL_CH_437613#123755, EM_CRL_MF_437616#123756, EM_CRL_MH_437615#123757, EM_CR_ATTENDU_437653#123758, EM_C_R_CD_437679#123759, EM_C_R_CR_437678#123760, EM_C_R_F_437680#123761, EM_DAT100_437489#123762, EM_DATACC2_437541#123763, EM_DATACC_437512#123764, EM_DATARR_437490#123765, EM_DATCOT_437492#123766, EM_DATCRE_437525#123767, EM_DATCSS_437488#123768, EM_DATENTREE_437682#123769, EM_DATENT_437547#123770, EM_DATENVC_437566#123771, EM_DATENVP_437505#123772, EM_DATENV_437503#123773, EM_DATF_D_437487#123774, EM_DATMAJ_437521#123775, EM_DATPARTI_437664#123776, EM_DATPJ_437542#123777, EM_DATPRC_437635#123778, EM_DATPRE_437523#123779, EM_DATRV_437438#123780, EM_DEBEXOMAT_437585#123781, EM_DEST_437642#123782, EM_DIF_DEFER_437668#123783, EM_DIF_PAT_437658#123784, EM_DIF_PRESC_437659#123785, EM_DMPAUT_437675#123786, EM_DOMAINE_437573#123787, EM_DOSCLO_437462#123788, EM_DOSCOM_437439#123789, EM_DROITS_437544#123790, EM_D_R_CD_437633#123791, EM_D_R_CR_437460#123792, EM_D_R_F_437461#123793, EM_ECHO_437447#123794, EM_ENVOIC_437565#123795, EM_ENVOIP_437504#123796, EM_ENVOI_437502#123797, EM_ETAPE_437456#123798, EM_EXA_LO_437446#123799, EM_EXA_SECU_437516#123800, EM_FACCON_437468#123801, EM_FACTUR_437467#123802, EM_FACTUR_ESTIM_437672#123803, EM_FERIE_437443#123804, EM_FINESS_437662#123805, EM_FINESS_HONO_437671#123806, EM_FINEXOMAT_437586#123807, EM_FLACCID_437528#123808, EM_FLAMCFSE_437553#123809, EM_FLAME_437604#123810, EM_FLARMAT_437582#123811, EM_FLCARNET_437538#123812, EM_FLCMU_437524#123813, EM_FLCVIM_437588#123814, EM_FLDECLMTR_437605#123815, EM_FLDMP_SECRET_437674#123816, EM_FLDOMIC_437543#123817, EM_FLENTREE_437681#123818, EM_FLFACT_437559#123819, EM_FLFTIMP_437655#123820, EM_FLGRATUI_437560#123821, EM_FLHOSPIT_437584#123822, EM_FLLIBERE_437676#123823, EM_FLNSCAI_437629#123824, EM_FLNSMUT_437630#123825, EM_FLNSPAT_437631#123826, EM_FLNUM_437558#123827, EM_FLPARTI_437663#123828, EM_FLPEC_437531#123829, EM_FLPORTAIL_437670#123830, EM_FLPRESCINF_437603#123831, EM_FLREFER_437534#123832, EM_FLTBDI_437639#123833, EM_FLTELE_437600#123834, EM_FLTITMED_437552#123835, EM_FLTOPM_437545#123836, EM_FLTOPR_437546#123837, EM_FLVIP_437669#123838, EM_FORC_437583#123839, EM_FORFAI_437444#123840, EM_GARMUT_437551#123841, EM_GROUPE_437464#123842, EM_HEUARR_437491#123843, EM_HEUCOT_437493#123844, EM_HEUENTREE_437683#123845, EM_HEUPRC_437636#123846, EM_IDFACSIT_437665#123847, EM_IDHOTE_437575#123848, EM_INDTRAI_437574#123849, EM_INFOAMC_437589#123850, EM_INFOTDB_437587#123851, EM_INT_SPE_437650#123852, EM_INT_STD_437649#123853, EM_IRM_437445#123854, EM_LIBEL_437453#123855, EM_LOCK_437634#123856, EM_MDTMUT_437564#123857, EM_MODTRT_437509#123858, EM_MONNAIE_437466#123859, EM_MOTPAS_437638#123860, EM_MTDEP_437592#123861, EM_MTDEP_ESTIM_437673#123862, EM_MT_PEC_SMG_437660#123863, EM_M_FORF_437469#123864, EM_NATASS_437510#123865, EM_NATURE_437455#123866, EM_NB_COT_437517#123867, EM_NB_FAC_437518#123868, EM_NUIT_437442#123869, EM_NUMACC_437511#123870, EM_NUMBOC_437481#123871, EM_NUMBOC_FT_437607#123872, EM_NUMBOF_437483#123873, EM_NUMBOM_437482#123874, EM_NUMBOM_FT_437608#123875, EM_NUMBOT_437507#123876, EM_NUMBOT_FT_437601#123877, EM_NUMCAI_437484#123878, EM_NUMCAI_FT_437657#123879, EM_NUMDEM_437436#123880, EM_NUMDEM_ORI_437666#123881, EM_NUMDEM_PROD_437644#123882, EM_NUMDOS_437435#123883, EM_NUMDOS_ORI_437686#123884, EM_NUMDOS_PROD_437647#123885, EM_NUMFAC_437513#123886, EM_NUMFOR_437486#123887, EM_NUMLOC_437527#123888, EM_NUMMUT_437485#123889, EM_NUMOP_437606#123890, EM_NUMPRG_437661#123891, EM_NUMREL_C_437561#123892, EM_NUMREL_C_F_437627#123893, EM_NUMREL_M_437562#123894, EM_NUMREL_M_F_437628#123895, EM_NUMREL_P_437563#123896, EM_NUMREL_P_F_437626#123897, EM_NUMSAF_437506#123898, EM_NUMSAL_437494#123899, EM_NUMTRT_437688#123900, EM_ORIDEM_437508#123901, EM_PARCAI_437471#123902, EM_PARFOR_437475#123903, EM_PARMUT_437473#123904, EM_PARMUT_FT_437554#123905, EM_PARMUT_HON_437555#123906, EM_PARPAT_437470#123907, EM_PARPAT_FT_437556#123908, EM_PARPAT_HON_437557#123909, EM_PAVMUT_437619#123910, EM_PJAMC_437579#123911, EM_PRCHAMC_437577#123912, EM_PRESCS_437684#123913, EM_QUALDP_437539#123914, EM_RCP_437652#123915, EM_REGCAI_437477#123916, EM_REGFOR_437479#123917, EM_REGMUT_437478#123918, EM_REGPAT_437476#123919, EM_REGPAT_HON_437593#123920, EM_REJBOC_437609#123921, EM_REJBOC_FT_437610#123922, EM_REJBOM_437611#123923, EM_REJBOM_FT_437612#123924, EM_REJBOT_437514#123925, EM_REJBOT_FT_437602#123926, EM_RNGNAI_437530#123927, EM_R_A_R_437480#123928, EM_R_CD_437632#123929, EM_R_CR_437458#123930, EM_R_F_437459#123931, EM_SCAN1_437495#123932, EM_SCAN2_437496#123933, EM_SIGMA_437452#123934, EM_SLDCAI_437598#123935, EM_SLDCAI_FT_437599#123936, EM_SLDMUT_437596#123937, EM_SLDMUT_FT_437597#123938, EM_SLDPAT_437594#123939, EM_SLDPAT_FT_437595#123940, EM_SPL_TRANS_437651#123941, EM_STAOPI_437569#123942, EM_STATCR_437457#123943, EM_STATUT_ENVOI_437654#123944, EM_STATUT_SMS_437643#123945, EM_SUPMOTIF_437656#123946, EM_TARIF_437515#123947, EM_TAUCAI_437472#123948, EM_TAUMUT_437474#123949, EM_TIERSP_437540#123950, EM_TPAMC_437578#123951, EM_TYPEXO_437529#123952, EM_TYPFAC_437580#123953, EM_TYPRES_437570#123954, EM_URGEN_437440#123955, EM_URG_437648#123956, EM_VALID_437454#123957, EM_VERSION_437519#123958]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_437435#123883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_437435#123883)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_437436#123880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_437436#123880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMED_437437#123726)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMED_437437#123726)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATRV_437438#123780)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATRV_437438#123780)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCOM_437439#123789)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCOM_437439#123789)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URGEN_437440#123955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_URGEN_437440#123955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ASTREI_437441#123710)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ASTREI_437441#123710)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUIT_437442#123869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUIT_437442#123869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FERIE_437443#123804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FERIE_437443#123804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORFAI_437444#123840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORFAI_437444#123840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IRM_437445#123854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IRM_437445#123854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_LO_437446#123799)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_LO_437446#123799)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ECHO_437447#123794)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ECHO_437447#123794)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANGIO_437448#123708)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANGIO_437448#123708)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_AUTR_437449#123713)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_AUTR_437449#123713)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSER_437450#123734)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSER_437450#123734)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODC_A_437451#123719)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODC_A_437451#123719)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SIGMA_437452#123934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SIGMA_437452#123934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LIBEL_437453#123855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_LIBEL_437453#123855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VALID_437454#123957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_VALID_437454#123957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATURE_437455#123866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATURE_437455#123866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ETAPE_437456#123798)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ETAPE_437456#123798)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATCR_437457#123943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATCR_437457#123943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CR_437458#123930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CR_437458#123930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_F_437459#123931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_F_437459#123931)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CR_437460#123792)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CR_437460#123792)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_F_437461#123793)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_F_437461#123793)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCLO_437462#123788)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCLO_437462#123788)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMM_1_437463#123750)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMM_1_437463#123750)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GROUPE_437464#123842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_GROUPE_437464#123842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANNVAL_437465#123709)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANNVAL_437465#123709)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MONNAIE_437466#123859)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MONNAIE_437466#123859)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_437467#123802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_437467#123802)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACCON_437468#123801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACCON_437468#123801)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_M_FORF_437469#123864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_M_FORF_437469#123864)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_437470#123907)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_437470#123907)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARCAI_437471#123902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARCAI_437471#123902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUCAI_437472#123948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUCAI_437472#123948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_437473#123904)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_437473#123904)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUMUT_437474#123949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUMUT_437474#123949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARFOR_437475#123903)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARFOR_437475#123903)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_437476#123919)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_437476#123919)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGCAI_437477#123916)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGCAI_437477#123916)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGMUT_437478#123918)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGMUT_437478#123918)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGFOR_437479#123917)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGFOR_437479#123917)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_A_R_437480#123928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_A_R_437480#123928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_437481#123871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_437481#123871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_437482#123874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_437482#123874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOF_437483#123873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOF_437483#123873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_437484#123878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_437484#123878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMMUT_437485#123889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMMUT_437485#123889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFOR_437486#123887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFOR_437486#123887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATF_D_437487#123774)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATF_D_437487#123774)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCSS_437488#123768)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCSS_437488#123768)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DAT100_437489#123762)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DAT100_437489#123762)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATARR_437490#123765)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATARR_437490#123765)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUARR_437491#123843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUARR_437491#123843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCOT_437492#123766)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCOT_437492#123766)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUCOT_437493#123844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUCOT_437493#123844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAL_437494#123899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAL_437494#123899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN1_437495#123932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN1_437495#123932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN2_437496#123933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN2_437496#123933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSEC_437497#123733)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSEC_437497#123733)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSRV_437498#123744)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSRV_437498#123744)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENC_437499#123721)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENC_437499#123721)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODTIT_437500#123746)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODTIT_437500#123746)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODDIC_437501#123720)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODDIC_437501#123720)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOI_437502#123797)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOI_437502#123797)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENV_437503#123773)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENV_437503#123773)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIP_437504#123796)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIP_437504#123796)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVP_437505#123772)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVP_437505#123772)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAF_437506#123898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAF_437506#123898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_437507#123876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_437507#123876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ORIDEM_437508#123901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ORIDEM_437508#123901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MODTRT_437509#123858)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MODTRT_437509#123858)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATASS_437510#123865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATASS_437510#123865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMACC_437511#123870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMACC_437511#123870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC_437512#123764)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC_437512#123764)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFAC_437513#123886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFAC_437513#123886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_437514#123925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_437514#123925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TARIF_437515#123947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TARIF_437515#123947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_SECU_437516#123800)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_SECU_437516#123800)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_COT_437517#123867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_COT_437517#123867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_FAC_437518#123868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_FAC_437518#123868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VERSION_437519#123958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_VERSION_437519#123958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_437520#123735)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_437520#123735)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATMAJ_437521#123775)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATMAJ_437521#123775)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUTI_437522#123748)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUTI_437522#123748)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRE_437523#123779)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRE_437523#123779)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCMU_437524#123813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCMU_437524#123813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCRE_437525#123767)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCRE_437525#123767)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUFL_437526#123747)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUFL_437526#123747)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMLOC_437527#123888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMLOC_437527#123888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLACCID_437528#123808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLACCID_437528#123808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPEXO_437529#123952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPEXO_437529#123952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RNGNAI_437530#123927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_RNGNAI_437530#123927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPEC_437531#123829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPEC_437531#123829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGAT_437532#123730)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGAT_437532#123730)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIAT_437533#123716)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIAT_437533#123716)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLREFER_437534#123832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLREFER_437534#123832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODPJ_437535#123729)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODPJ_437535#123729)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGPJ_437536#123731)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGPJ_437536#123731)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#123717)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#123717)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCARNET_437538#123812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCARNET_437538#123812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_QUALDP_437539#123914)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_QUALDP_437539#123914)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TIERSP_437540#123950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TIERSP_437540#123950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC2_437541#123763)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC2_437541#123763)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPJ_437542#123777)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPJ_437542#123777)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDOMIC_437543#123817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDOMIC_437543#123817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DROITS_437544#123790)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DROITS_437544#123790)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPM_437545#123836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPM_437545#123836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPR_437546#123837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPR_437546#123837)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENT_437547#123770)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENT_437547#123770)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENT_437548#123722)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENT_437548#123722)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CONMUT_437549#123751)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CONMUT_437549#123751)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ADHMUT_437550#123706)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ADHMUT_437550#123706)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GARMUT_437551#123841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_GARMUT_437551#123841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTITMED_437552#123835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTITMED_437552#123835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#123809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#123809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#123905)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#123905)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#123906)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#123906)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#123908)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#123908)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#123909)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#123909)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNUM_437558#123827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNUM_437558#123827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFACT_437559#123819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFACT_437559#123819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLGRATUI_437560#123821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLGRATUI_437560#123821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_437561#123892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_437561#123892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_437562#123894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_437562#123894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_437563#123896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_437563#123896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MDTMUT_437564#123857)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MDTMUT_437564#123857)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIC_437565#123795)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIC_437565#123795)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVC_437566#123771)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVC_437566#123771)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODM_H_437567#123728)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODM_H_437567#123728)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODATS_437568#123715)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODATS_437568#123715)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STAOPI_437569#123942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STAOPI_437569#123942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPRES_437570#123954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPRES_437570#123954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMMENT_437571#123749)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMMENT_437571#123749)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODROUT_437572#123732)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODROUT_437572#123732)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOMAINE_437573#123787)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOMAINE_437573#123787)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INDTRAI_437574#123849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INDTRAI_437574#123849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDHOTE_437575#123848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDHOTE_437575#123848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSTS_437576#123745)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSTS_437576#123745)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRCHAMC_437577#123912)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRCHAMC_437577#123912)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TPAMC_437578#123951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TPAMC_437578#123951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PJAMC_437579#123911)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PJAMC_437579#123911)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPFAC_437580#123953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPFAC_437580#123953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCENAT_437581#123718)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCENAT_437581#123718)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLARMAT_437582#123811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLARMAT_437582#123811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORC_437583#123839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORC_437583#123839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#123822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#123822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#123781)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#123781)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#123807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#123807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOTDB_437587#123851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOTDB_437587#123851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCVIM_437588#123814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCVIM_437588#123814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOAMC_437589#123850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOAMC_437589#123850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODIPS_437590#123724)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODIPS_437590#123724)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMTR_437591#123727)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMTR_437591#123727)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_437592#123861)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_437592#123861)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#123920)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#123920)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_437594#123939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_437594#123939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#123940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#123940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_437596#123937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_437596#123937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#123938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#123938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_437598#123935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_437598#123935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#123936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#123936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTELE_437600#123834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTELE_437600#123834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#123877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#123877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#123926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#123926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#123831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#123831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAME_437604#123810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAME_437604#123810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#123815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#123815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMOP_437606#123890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMOP_437606#123890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#123872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#123872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#123875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#123875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_437609#123921)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_437609#123921)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#123922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#123922)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_437611#123923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_437611#123923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#123924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#123924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CH_437613#123755)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CH_437613#123755)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CF_437614#123754)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CF_437614#123754)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MH_437615#123757)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MH_437615#123757)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MF_437616#123756)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MF_437616#123756)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AH_437617#123753)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AH_437617#123753)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AF_437618#123752)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AF_437618#123752)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PAVMUT_437619#123910)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PAVMUT_437619#123910)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#123740)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#123740)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#123739)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#123739)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#123742)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#123742)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#123741)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#123741)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#123738)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#123738)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#123737)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#123737)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#123897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#123897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#123893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#123893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#123895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#123895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSCAI_437629#123824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSCAI_437629#123824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSMUT_437630#123825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSMUT_437630#123825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSPAT_437631#123826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSPAT_437631#123826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CD_437632#123929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CD_437632#123929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CD_437633#123791)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CD_437633#123791)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LOCK_437634#123856)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_LOCK_437634#123856)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRC_437635#123778)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRC_437635#123778)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUPRC_437636#123846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUPRC_437636#123846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODACC_437637#123714)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODACC_437637#123714)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MOTPAS_437638#123860)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MOTPAS_437638#123860)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTBDI_437639#123833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTBDI_437639#123833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTENTE_437640#123711)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTENTE_437640#123711)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#123712)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#123712)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEST_437642#123782)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEST_437642#123782)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#123945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#123945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#123882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#123882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#123723)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#123723)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#123736)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#123736)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#123885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#123885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URG_437648#123956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_URG_437648#123956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_STD_437649#123853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_STD_437649#123853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_SPE_437650#123852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_SPE_437650#123852)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#123941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#123941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RCP_437652#123915)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_RCP_437652#123915)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#123758)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#123758)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#123944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#123944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFTIMP_437655#123820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFTIMP_437655#123820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#123946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#123946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#123879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#123879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PAT_437658#123784)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PAT_437658#123784)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#123785)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#123785)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#123863)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#123863)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMPRG_437661#123891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMPRG_437661#123891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_437662#123805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_437662#123805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPARTI_437663#123828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPARTI_437663#123828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPARTI_437664#123776)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPARTI_437664#123776)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDFACSIT_437665#123847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDFACSIT_437665#123847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#123881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#123881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ALARMES_437667#123707)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ALARMES_437667#123707)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#123783)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#123783)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLVIP_437669#123838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLVIP_437669#123838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#123830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#123830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#123806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#123806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#123803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#123803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#123862)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#123862)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#123816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#123816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DMPAUT_437675#123786)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DMPAUT_437675#123786)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLLIBERE_437676#123823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLLIBERE_437676#123823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACCNUM_437677#123704)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACCNUM_437677#123704)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CR_437678#123760)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CR_437678#123760)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CD_437679#123759)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CD_437679#123759)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_F_437680#123761)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_F_437680#123761)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLENTREE_437681#123818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLENTREE_437681#123818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENTREE_437682#123769)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENTREE_437682#123769)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUENTREE_437683#123845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUENTREE_437683#123845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRESCS_437684#123913)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRESCS_437684#123913)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#123705)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#123705)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#123884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#123884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSPE_437687#123743)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSPE_437687#123743)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMTRT_437688#123900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMTRT_437688#123900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#123725)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#123725)), MARX) END)

(3) Project
Output: []
Input [255]: [EM_ACCNUM_437677#123704, EM_ACTES_ESTIM_437685#123705, EM_ADHMUT_437550#123706, EM_ALARMES_437667#123707, EM_ANGIO_437448#123708, EM_ANNVAL_437465#123709, EM_ASTREI_437441#123710, EM_ATTENTE_437640#123711, EM_ATTMOTIF_437641#123712, EM_AUTR_437449#123713, EM_CODACC_437637#123714, EM_CODATS_437568#123715, EM_CODCAIAT_437533#123716, EM_CODCAIPJ_437537#123717, EM_CODCENAT_437581#123718, EM_CODC_A_437451#123719, EM_CODDIC_437501#123720, EM_CODENC_437499#123721, EM_CODENT_437548#123722, EM_CODETAB_PROD_437645#123723, EM_CODIPS_437590#123724, EM_CODMEDPAT_437689#123725, EM_CODMED_437437#123726, EM_CODMTR_437591#123727, EM_CODM_H_437567#123728, EM_CODPJ_437535#123729, EM_CODREGAT_437532#123730, EM_CODREGPJ_437536#123731, EM_CODROUT_437572#123732, EM_CODSEC_437497#123733, EM_CODSER_437450#123734, EM_CODSIT_437520#123735, EM_CODSIT_PROD_437646#123736, EM_CODSOC_AF_437625#123737, EM_CODSOC_AH_437624#123738, EM_CODSOC_CF_437621#123739, EM_CODSOC_CH_437620#123740, EM_CODSOC_MF_437623#123741, EM_CODSOC_MH_437622#123742, EM_CODSPE_437687#123743, EM_CODSRV_437498#123744, EM_CODSTS_437576#123745, EM_CODTIT_437500#123746, EM_CODUFL_437526#123747, EM_CODUTI_437522#123748, EM_COMMENT_437571#123749, EM_COMM_1_437463#123750, EM_CONMUT_437549#123751, EM_CRL_AF_437618#123752, EM_CRL_AH_437617#123753, EM_CRL_CF_437614#123754, EM_CRL_CH_437613#123755, EM_CRL_MF_437616#123756, EM_CRL_MH_437615#123757, EM_CR_ATTENDU_437653#123758, EM_C_R_CD_437679#123759, EM_C_R_CR_437678#123760, EM_C_R_F_437680#123761, EM_DAT100_437489#123762, EM_DATACC2_437541#123763, EM_DATACC_437512#123764, EM_DATARR_437490#123765, EM_DATCOT_437492#123766, EM_DATCRE_437525#123767, EM_DATCSS_437488#123768, EM_DATENTREE_437682#123769, EM_DATENT_437547#123770, EM_DATENVC_437566#123771, EM_DATENVP_437505#123772, EM_DATENV_437503#123773, EM_DATF_D_437487#123774, EM_DATMAJ_437521#123775, EM_DATPARTI_437664#123776, EM_DATPJ_437542#123777, EM_DATPRC_437635#123778, EM_DATPRE_437523#123779, EM_DATRV_437438#123780, EM_DEBEXOMAT_437585#123781, EM_DEST_437642#123782, EM_DIF_DEFER_437668#123783, EM_DIF_PAT_437658#123784, EM_DIF_PRESC_437659#123785, EM_DMPAUT_437675#123786, EM_DOMAINE_437573#123787, EM_DOSCLO_437462#123788, EM_DOSCOM_437439#123789, EM_DROITS_437544#123790, EM_D_R_CD_437633#123791, EM_D_R_CR_437460#123792, EM_D_R_F_437461#123793, EM_ECHO_437447#123794, EM_ENVOIC_437565#123795, EM_ENVOIP_437504#123796, EM_ENVOI_437502#123797, EM_ETAPE_437456#123798, EM_EXA_LO_437446#123799, EM_EXA_SECU_437516#123800, EM_FACCON_437468#123801, EM_FACTUR_437467#123802, EM_FACTUR_ESTIM_437672#123803, EM_FERIE_437443#123804, EM_FINESS_437662#123805, EM_FINESS_HONO_437671#123806, EM_FINEXOMAT_437586#123807, EM_FLACCID_437528#123808, EM_FLAMCFSE_437553#123809, EM_FLAME_437604#123810, EM_FLARMAT_437582#123811, EM_FLCARNET_437538#123812, EM_FLCMU_437524#123813, EM_FLCVIM_437588#123814, EM_FLDECLMTR_437605#123815, EM_FLDMP_SECRET_437674#123816, EM_FLDOMIC_437543#123817, EM_FLENTREE_437681#123818, EM_FLFACT_437559#123819, EM_FLFTIMP_437655#123820, EM_FLGRATUI_437560#123821, EM_FLHOSPIT_437584#123822, EM_FLLIBERE_437676#123823, EM_FLNSCAI_437629#123824, EM_FLNSMUT_437630#123825, EM_FLNSPAT_437631#123826, EM_FLNUM_437558#123827, EM_FLPARTI_437663#123828, EM_FLPEC_437531#123829, EM_FLPORTAIL_437670#123830, EM_FLPRESCINF_437603#123831, EM_FLREFER_437534#123832, EM_FLTBDI_437639#123833, EM_FLTELE_437600#123834, EM_FLTITMED_437552#123835, EM_FLTOPM_437545#123836, EM_FLTOPR_437546#123837, EM_FLVIP_437669#123838, EM_FORC_437583#123839, EM_FORFAI_437444#123840, EM_GARMUT_437551#123841, EM_GROUPE_437464#123842, EM_HEUARR_437491#123843, EM_HEUCOT_437493#123844, EM_HEUENTREE_437683#123845, EM_HEUPRC_437636#123846, EM_IDFACSIT_437665#123847, EM_IDHOTE_437575#123848, EM_INDTRAI_437574#123849, EM_INFOAMC_437589#123850, EM_INFOTDB_437587#123851, EM_INT_SPE_437650#123852, EM_INT_STD_437649#123853, EM_IRM_437445#123854, EM_LIBEL_437453#123855, EM_LOCK_437634#123856, EM_MDTMUT_437564#123857, EM_MODTRT_437509#123858, EM_MONNAIE_437466#123859, EM_MOTPAS_437638#123860, EM_MTDEP_437592#123861, EM_MTDEP_ESTIM_437673#123862, EM_MT_PEC_SMG_437660#123863, EM_M_FORF_437469#123864, EM_NATASS_437510#123865, EM_NATURE_437455#123866, EM_NB_COT_437517#123867, EM_NB_FAC_437518#123868, EM_NUIT_437442#123869, EM_NUMACC_437511#123870, EM_NUMBOC_437481#123871, EM_NUMBOC_FT_437607#123872, EM_NUMBOF_437483#123873, EM_NUMBOM_437482#123874, EM_NUMBOM_FT_437608#123875, EM_NUMBOT_437507#123876, EM_NUMBOT_FT_437601#123877, EM_NUMCAI_437484#123878, EM_NUMCAI_FT_437657#123879, EM_NUMDEM_437436#123880, EM_NUMDEM_ORI_437666#123881, EM_NUMDEM_PROD_437644#123882, EM_NUMDOS_437435#123883, EM_NUMDOS_ORI_437686#123884, EM_NUMDOS_PROD_437647#123885, EM_NUMFAC_437513#123886, EM_NUMFOR_437486#123887, EM_NUMLOC_437527#123888, EM_NUMMUT_437485#123889, EM_NUMOP_437606#123890, EM_NUMPRG_437661#123891, EM_NUMREL_C_437561#123892, EM_NUMREL_C_F_437627#123893, EM_NUMREL_M_437562#123894, EM_NUMREL_M_F_437628#123895, EM_NUMREL_P_437563#123896, EM_NUMREL_P_F_437626#123897, EM_NUMSAF_437506#123898, EM_NUMSAL_437494#123899, EM_NUMTRT_437688#123900, EM_ORIDEM_437508#123901, EM_PARCAI_437471#123902, EM_PARFOR_437475#123903, EM_PARMUT_437473#123904, EM_PARMUT_FT_437554#123905, EM_PARMUT_HON_437555#123906, EM_PARPAT_437470#123907, EM_PARPAT_FT_437556#123908, EM_PARPAT_HON_437557#123909, EM_PAVMUT_437619#123910, EM_PJAMC_437579#123911, EM_PRCHAMC_437577#123912, EM_PRESCS_437684#123913, EM_QUALDP_437539#123914, EM_RCP_437652#123915, EM_REGCAI_437477#123916, EM_REGFOR_437479#123917, EM_REGMUT_437478#123918, EM_REGPAT_437476#123919, EM_REGPAT_HON_437593#123920, EM_REJBOC_437609#123921, EM_REJBOC_FT_437610#123922, EM_REJBOM_437611#123923, EM_REJBOM_FT_437612#123924, EM_REJBOT_437514#123925, EM_REJBOT_FT_437602#123926, EM_RNGNAI_437530#123927, EM_R_A_R_437480#123928, EM_R_CD_437632#123929, EM_R_CR_437458#123930, EM_R_F_437459#123931, EM_SCAN1_437495#123932, EM_SCAN2_437496#123933, EM_SIGMA_437452#123934, EM_SLDCAI_437598#123935, EM_SLDCAI_FT_437599#123936, EM_SLDMUT_437596#123937, EM_SLDMUT_FT_437597#123938, EM_SLDPAT_437594#123939, EM_SLDPAT_FT_437595#123940, EM_SPL_TRANS_437651#123941, EM_STAOPI_437569#123942, EM_STATCR_437457#123943, EM_STATUT_ENVOI_437654#123944, EM_STATUT_SMS_437643#123945, EM_SUPMOTIF_437656#123946, EM_TARIF_437515#123947, EM_TAUCAI_437472#123948, EM_TAUMUT_437474#123949, EM_TIERSP_437540#123950, EM_TPAMC_437578#123951, EM_TYPEXO_437529#123952, EM_TYPFAC_437580#123953, EM_TYPRES_437570#123954, EM_URGEN_437440#123955, EM_URG_437648#123956, EM_VALID_437454#123957, EM_VERSION_437519#123958]

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

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

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

(7) HashAggregate [codegen id : 2]
Input [1]: [count#126100L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#125837L]
Results [1]: [count(1)#125837L AS COL_94cdedae-76dc-4053-bb13-14a940c24fd1#125839L]

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

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

(10) HashAggregate
Input [1]: [count#126100L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#125837L]
Results [1]: [count(1)#125837L AS COL_94cdedae-76dc-4053-bb13-14a940c24fd1#125839L]

(11) AdaptiveSparkPlan
Output [1]: [COL_94cdedae-76dc-4053-bb13-14a940c24fd1#125839L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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