hdh-spark-job - Details for Query 703

Submitted Time: 2026/10/21 21:34:36
Duration: 8 s
Succeeded Jobs: 678 681

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: 6.5 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 6.5 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=14380]

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

WholeStageCodegen (1)

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_437435#152554)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_437435#152554)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_437436#152551)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_437436#152551)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMED_437437#152397)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMED_437437#152397)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATRV_437438#152451)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATRV_437438#152451)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCOM_437439#152460)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCOM_437439#152460)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URGEN_437440#152626)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_URGEN_437440#152626)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ASTREI_437441#152381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ASTREI_437441#152381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUIT_437442#152540)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUIT_437442#152540)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FERIE_437443#152475)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FERIE_437443#152475)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORFAI_437444#152511)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORFAI_437444#152511)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IRM_437445#152525)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IRM_437445#152525)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_LO_437446#152470)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_LO_437446#152470)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ECHO_437447#152465)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ECHO_437447#152465)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANGIO_437448#152379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANGIO_437448#152379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_AUTR_437449#152384)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_AUTR_437449#152384)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSER_437450#152405)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSER_437450#152405)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODC_A_437451#152390)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODC_A_437451#152390)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SIGMA_437452#152605)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SIGMA_437452#152605)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LIBEL_437453#152526)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_LIBEL_437453#152526)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VALID_437454#152628)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_VALID_437454#152628)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATURE_437455#152537)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATURE_437455#152537)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ETAPE_437456#152469)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ETAPE_437456#152469)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATCR_437457#152614)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATCR_437457#152614)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CR_437458#152601)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CR_437458#152601)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_F_437459#152602)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_F_437459#152602)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CR_437460#152463)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CR_437460#152463)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_F_437461#152464)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_F_437461#152464)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCLO_437462#152459)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCLO_437462#152459)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMM_1_437463#152421)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMM_1_437463#152421)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GROUPE_437464#152513)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_GROUPE_437464#152513)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANNVAL_437465#152380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANNVAL_437465#152380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MONNAIE_437466#152530)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MONNAIE_437466#152530)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_437467#152473)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_437467#152473)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACCON_437468#152472)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACCON_437468#152472)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_M_FORF_437469#152535)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_M_FORF_437469#152535)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_437470#152578)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_437470#152578)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARCAI_437471#152573)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARCAI_437471#152573)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUCAI_437472#152619)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUCAI_437472#152619)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_437473#152575)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_437473#152575)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUMUT_437474#152620)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUMUT_437474#152620)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARFOR_437475#152574)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARFOR_437475#152574)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_437476#152590)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_437476#152590)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGCAI_437477#152587)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGCAI_437477#152587)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGMUT_437478#152589)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGMUT_437478#152589)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGFOR_437479#152588)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGFOR_437479#152588)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_A_R_437480#152599)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_A_R_437480#152599)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_437481#152542)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_437481#152542)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_437482#152545)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_437482#152545)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOF_437483#152544)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOF_437483#152544)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_437484#152549)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_437484#152549)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMMUT_437485#152560)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMMUT_437485#152560)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFOR_437486#152558)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFOR_437486#152558)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATF_D_437487#152445)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATF_D_437487#152445)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCSS_437488#152439)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCSS_437488#152439)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DAT100_437489#152433)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DAT100_437489#152433)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATARR_437490#152436)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATARR_437490#152436)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUARR_437491#152514)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUARR_437491#152514)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCOT_437492#152437)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCOT_437492#152437)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUCOT_437493#152515)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUCOT_437493#152515)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAL_437494#152570)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAL_437494#152570)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN1_437495#152603)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN1_437495#152603)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN2_437496#152604)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN2_437496#152604)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSEC_437497#152404)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSEC_437497#152404)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSRV_437498#152415)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSRV_437498#152415)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENC_437499#152392)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENC_437499#152392)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODTIT_437500#152417)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODTIT_437500#152417)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODDIC_437501#152391)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODDIC_437501#152391)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOI_437502#152468)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOI_437502#152468)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENV_437503#152444)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENV_437503#152444)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIP_437504#152467)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIP_437504#152467)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVP_437505#152443)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVP_437505#152443)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAF_437506#152569)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAF_437506#152569)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_437507#152547)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_437507#152547)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ORIDEM_437508#152572)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ORIDEM_437508#152572)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MODTRT_437509#152529)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MODTRT_437509#152529)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATASS_437510#152536)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATASS_437510#152536)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMACC_437511#152541)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMACC_437511#152541)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC_437512#152435)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC_437512#152435)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFAC_437513#152557)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFAC_437513#152557)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_437514#152596)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_437514#152596)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TARIF_437515#152618)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TARIF_437515#152618)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_SECU_437516#152471)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_SECU_437516#152471)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_COT_437517#152538)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_COT_437517#152538)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_FAC_437518#152539)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_FAC_437518#152539)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VERSION_437519#152629)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_VERSION_437519#152629)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_437520#152406)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_437520#152406)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATMAJ_437521#152446)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATMAJ_437521#152446)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUTI_437522#152419)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUTI_437522#152419)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRE_437523#152450)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRE_437523#152450)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCMU_437524#152484)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCMU_437524#152484)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCRE_437525#152438)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCRE_437525#152438)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUFL_437526#152418)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUFL_437526#152418)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMLOC_437527#152559)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMLOC_437527#152559)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLACCID_437528#152479)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLACCID_437528#152479)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPEXO_437529#152623)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPEXO_437529#152623)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RNGNAI_437530#152598)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_RNGNAI_437530#152598)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPEC_437531#152500)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPEC_437531#152500)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGAT_437532#152401)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGAT_437532#152401)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIAT_437533#152387)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIAT_437533#152387)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLREFER_437534#152503)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLREFER_437534#152503)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODPJ_437535#152400)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODPJ_437535#152400)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGPJ_437536#152402)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGPJ_437536#152402)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#152388)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#152388)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCARNET_437538#152483)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCARNET_437538#152483)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_QUALDP_437539#152585)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_QUALDP_437539#152585)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TIERSP_437540#152621)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TIERSP_437540#152621)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC2_437541#152434)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC2_437541#152434)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPJ_437542#152448)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPJ_437542#152448)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDOMIC_437543#152488)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDOMIC_437543#152488)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DROITS_437544#152461)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DROITS_437544#152461)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPM_437545#152507)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPM_437545#152507)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPR_437546#152508)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPR_437546#152508)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENT_437547#152441)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENT_437547#152441)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENT_437548#152393)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENT_437548#152393)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CONMUT_437549#152422)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CONMUT_437549#152422)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ADHMUT_437550#152377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ADHMUT_437550#152377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GARMUT_437551#152512)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_GARMUT_437551#152512)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTITMED_437552#152506)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTITMED_437552#152506)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#152480)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#152480)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#152576)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#152576)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#152577)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#152577)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#152579)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#152579)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#152580)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#152580)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNUM_437558#152498)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNUM_437558#152498)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFACT_437559#152490)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFACT_437559#152490)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLGRATUI_437560#152492)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLGRATUI_437560#152492)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_437561#152563)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_437561#152563)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_437562#152565)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_437562#152565)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_437563#152567)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_437563#152567)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MDTMUT_437564#152528)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MDTMUT_437564#152528)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIC_437565#152466)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIC_437565#152466)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVC_437566#152442)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVC_437566#152442)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODM_H_437567#152399)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODM_H_437567#152399)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODATS_437568#152386)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODATS_437568#152386)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STAOPI_437569#152613)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STAOPI_437569#152613)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPRES_437570#152625)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPRES_437570#152625)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMMENT_437571#152420)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMMENT_437571#152420)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODROUT_437572#152403)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODROUT_437572#152403)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOMAINE_437573#152458)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOMAINE_437573#152458)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INDTRAI_437574#152520)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INDTRAI_437574#152520)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDHOTE_437575#152519)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDHOTE_437575#152519)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSTS_437576#152416)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSTS_437576#152416)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRCHAMC_437577#152583)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRCHAMC_437577#152583)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TPAMC_437578#152622)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TPAMC_437578#152622)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PJAMC_437579#152582)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PJAMC_437579#152582)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPFAC_437580#152624)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPFAC_437580#152624)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCENAT_437581#152389)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCENAT_437581#152389)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLARMAT_437582#152482)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLARMAT_437582#152482)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORC_437583#152510)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORC_437583#152510)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#152493)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#152493)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#152452)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#152452)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#152478)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#152478)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOTDB_437587#152522)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOTDB_437587#152522)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCVIM_437588#152485)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCVIM_437588#152485)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOAMC_437589#152521)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOAMC_437589#152521)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODIPS_437590#152395)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODIPS_437590#152395)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMTR_437591#152398)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMTR_437591#152398)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_437592#152532)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_437592#152532)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#152591)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#152591)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_437594#152610)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_437594#152610)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#152611)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#152611)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_437596#152608)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_437596#152608)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#152609)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#152609)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_437598#152606)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_437598#152606)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#152607)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#152607)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTELE_437600#152505)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTELE_437600#152505)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#152548)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#152548)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#152597)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#152597)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#152502)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#152502)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAME_437604#152481)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAME_437604#152481)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#152486)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#152486)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMOP_437606#152561)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMOP_437606#152561)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#152543)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#152543)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#152546)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#152546)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_437609#152592)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_437609#152592)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#152593)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#152593)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_437611#152594)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_437611#152594)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#152595)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#152595)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CH_437613#152426)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CH_437613#152426)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CF_437614#152425)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CF_437614#152425)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MH_437615#152428)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MH_437615#152428)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MF_437616#152427)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MF_437616#152427)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AH_437617#152424)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AH_437617#152424)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AF_437618#152423)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AF_437618#152423)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PAVMUT_437619#152581)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PAVMUT_437619#152581)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#152411)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#152411)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#152410)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#152410)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#152413)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#152413)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#152412)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#152412)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#152409)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#152409)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#152408)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#152408)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#152568)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#152568)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#152564)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#152564)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#152566)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#152566)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSCAI_437629#152495)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSCAI_437629#152495)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSMUT_437630#152496)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSMUT_437630#152496)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSPAT_437631#152497)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSPAT_437631#152497)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CD_437632#152600)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CD_437632#152600)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CD_437633#152462)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CD_437633#152462)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LOCK_437634#152527)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_LOCK_437634#152527)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRC_437635#152449)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRC_437635#152449)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUPRC_437636#152517)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUPRC_437636#152517)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODACC_437637#152385)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODACC_437637#152385)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MOTPAS_437638#152531)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MOTPAS_437638#152531)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTBDI_437639#152504)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTBDI_437639#152504)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTENTE_437640#152382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTENTE_437640#152382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#152383)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#152383)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEST_437642#152453)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEST_437642#152453)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#152616)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#152616)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#152553)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#152553)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#152394)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#152394)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#152407)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#152407)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#152556)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#152556)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URG_437648#152627)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_URG_437648#152627)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_STD_437649#152524)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_STD_437649#152524)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_SPE_437650#152523)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_SPE_437650#152523)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#152612)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#152612)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RCP_437652#152586)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_RCP_437652#152586)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#152429)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#152429)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#152615)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#152615)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFTIMP_437655#152491)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFTIMP_437655#152491)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#152617)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#152617)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#152550)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#152550)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PAT_437658#152455)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PAT_437658#152455)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#152456)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#152456)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#152534)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#152534)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMPRG_437661#152562)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMPRG_437661#152562)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_437662#152476)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_437662#152476)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPARTI_437663#152499)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPARTI_437663#152499)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPARTI_437664#152447)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPARTI_437664#152447)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDFACSIT_437665#152518)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDFACSIT_437665#152518)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#152552)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#152552)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ALARMES_437667#152378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ALARMES_437667#152378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#152454)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#152454)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLVIP_437669#152509)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLVIP_437669#152509)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#152501)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#152501)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#152477)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#152477)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#152474)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#152474)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#152533)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#152533)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#152487)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#152487)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DMPAUT_437675#152457)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DMPAUT_437675#152457)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLLIBERE_437676#152494)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLLIBERE_437676#152494)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACCNUM_437677#152375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACCNUM_437677#152375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CR_437678#152431)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CR_437678#152431)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CD_437679#152430)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CD_437679#152430)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_F_437680#152432)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_F_437680#152432)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLENTREE_437681#152489)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLENTREE_437681#152489)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENTREE_437682#152440)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENTREE_437682#152440)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUENTREE_437683#152516)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUENTREE_437683#152516)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRESCS_437684#152584)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRESCS_437684#152584)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#152376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#152376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#152555)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#152555)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSPE_437687#152414)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSPE_437687#152414)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMTRT_437688#152571)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMTRT_437688#152571)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#152396)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#152396)), MARX) END)

FileScan parquet [EM_ACCNUM_437677#152375,EM_ACTES_ESTIM_437685#152376,EM_ADHMUT_437550#152377,EM_ALARMES_437667#152378,EM_ANGIO_437448#152379,EM_ANNVAL_437465#152380,EM_ASTREI_437441#152381,EM_ATTENTE_437640#152382,EM_ATTMOTIF_437641#152383,EM_AUTR_437449#152384,EM_CODACC_437637#152385,EM_CODATS_437568#152386,EM_CODCAIAT_437533#152387,EM_CODCAIPJ_437537#152388,EM_CODCENAT_437581#152389,EM_CODC_A_437451#152390,EM_CODDIC_437501#152391,EM_CODENC_437499#152392,EM_CODENT_437548#152393,EM_CODETAB_PROD_437645#152394,EM_CODIPS_437590#152395,EM_CODMEDPAT_437689#152396,EM_CODMED_437437#152397,EM_CODMTR_437591#152398,... 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#152375, EM_ACTES_ESTIM_437685#152376, EM_ADHMUT_437550#152377, EM_ALARMES_437667#152378, EM_ANGIO_437448#152379, EM_ANNVAL_437465#152380, EM_ASTREI_437441#152381, EM_ATTENTE_437640#152382, EM_ATTMOTIF_437641#152383, EM_AUTR_437449#152384, EM_CODACC_437637#152385, EM_CODATS_437568#152386, EM_CODCAIAT_437533#152387, EM_CODCAIPJ_437537#152388, EM_CODCENAT_437581#152389, EM_CODC_A_437451#152390, EM_CODDIC_437501#152391, EM_CODENC_437499#152392, EM_CODENT_437548#152393, EM_CODETAB_PROD_437645#152394, EM_CODIPS_437590#152395, EM_CODMEDPAT_437689#152396, EM_CODMED_437437#152397, EM_CODMTR_437591#152398, EM_CODM_H_437567#152399, EM_CODPJ_437535#152400, EM_CODREGAT_437532#152401, EM_CODREGPJ_437536#152402, EM_CODROUT_437572#152403, EM_CODSEC_437497#152404, EM_CODSER_437450#152405, EM_CODSIT_437520#152406, EM_CODSIT_PROD_437646#152407, EM_CODSOC_AF_437625#152408, EM_CODSOC_AH_437624#152409, EM_CODSOC_CF_437621#152410, EM_CODSOC_CH_437620#152411, EM_CODSOC_MF_437623#152412, EM_CODSOC_MH_437622#152413, EM_CODSPE_437687#152414, EM_CODSRV_437498#152415, EM_CODSTS_437576#152416, EM_CODTIT_437500#152417, EM_CODUFL_437526#152418, EM_CODUTI_437522#152419, EM_COMMENT_437571#152420, EM_COMM_1_437463#152421, EM_CONMUT_437549#152422, EM_CRL_AF_437618#152423, EM_CRL_AH_437617#152424, EM_CRL_CF_437614#152425, EM_CRL_CH_437613#152426, EM_CRL_MF_437616#152427, EM_CRL_MH_437615#152428, EM_CR_ATTENDU_437653#152429, EM_C_R_CD_437679#152430, EM_C_R_CR_437678#152431, EM_C_R_F_437680#152432, EM_DAT100_437489#152433, EM_DATACC2_437541#152434, EM_DATACC_437512#152435, EM_DATARR_437490#152436, EM_DATCOT_437492#152437, EM_DATCRE_437525#152438, EM_DATCSS_437488#152439, EM_DATENTREE_437682#152440, EM_DATENT_437547#152441, EM_DATENVC_437566#152442, EM_DATENVP_437505#152443, EM_DATENV_437503#152444, EM_DATF_D_437487#152445, EM_DATMAJ_437521#152446, EM_DATPARTI_437664#152447, EM_DATPJ_437542#152448, EM_DATPRC_437635#152449, EM_DATPRE_437523#152450, EM_DATRV_437438#152451, EM_DEBEXOMAT_437585#152452, EM_DEST_437642#152453, EM_DIF_DEFER_437668#152454, EM_DIF_PAT_437658#152455, EM_DIF_PRESC_437659#152456, EM_DMPAUT_437675#152457, EM_DOMAINE_437573#152458, EM_DOSCLO_437462#152459, EM_DOSCOM_437439#152460, EM_DROITS_437544#152461, EM_D_R_CD_437633#152462, EM_D_R_CR_437460#152463, EM_D_R_F_437461#152464, EM_ECHO_437447#152465, EM_ENVOIC_437565#152466, EM_ENVOIP_437504#152467, EM_ENVOI_437502#152468, EM_ETAPE_437456#152469, EM_EXA_LO_437446#152470, EM_EXA_SECU_437516#152471, EM_FACCON_437468#152472, EM_FACTUR_437467#152473, EM_FACTUR_ESTIM_437672#152474, EM_FERIE_437443#152475, EM_FINESS_437662#152476, EM_FINESS_HONO_437671#152477, EM_FINEXOMAT_437586#152478, EM_FLACCID_437528#152479, EM_FLAMCFSE_437553#152480, EM_FLAME_437604#152481, EM_FLARMAT_437582#152482, EM_FLCARNET_437538#152483, EM_FLCMU_437524#152484, EM_FLCVIM_437588#152485, EM_FLDECLMTR_437605#152486, EM_FLDMP_SECRET_437674#152487, EM_FLDOMIC_437543#152488, EM_FLENTREE_437681#152489, EM_FLFACT_437559#152490, EM_FLFTIMP_437655#152491, EM_FLGRATUI_437560#152492, EM_FLHOSPIT_437584#152493, EM_FLLIBERE_437676#152494, EM_FLNSCAI_437629#152495, EM_FLNSMUT_437630#152496, EM_FLNSPAT_437631#152497, EM_FLNUM_437558#152498, EM_FLPARTI_437663#152499, EM_FLPEC_437531#152500, EM_FLPORTAIL_437670#152501, EM_FLPRESCINF_437603#152502, EM_FLREFER_437534#152503, EM_FLTBDI_437639#152504, EM_FLTELE_437600#152505, EM_FLTITMED_437552#152506, EM_FLTOPM_437545#152507, EM_FLTOPR_437546#152508, EM_FLVIP_437669#152509, EM_FORC_437583#152510, EM_FORFAI_437444#152511, EM_GARMUT_437551#152512, EM_GROUPE_437464#152513, EM_HEUARR_437491#152514, EM_HEUCOT_437493#152515, EM_HEUENTREE_437683#152516, EM_HEUPRC_437636#152517, EM_IDFACSIT_437665#152518, EM_IDHOTE_437575#152519, EM_INDTRAI_437574#152520, EM_INFOAMC_437589#152521, EM_INFOTDB_437587#152522, EM_INT_SPE_437650#152523, EM_INT_STD_437649#152524, EM_IRM_437445#152525, EM_LIBEL_437453#152526, EM_LOCK_437634#152527, EM_MDTMUT_437564#152528, EM_MODTRT_437509#152529, EM_MONNAIE_437466#152530, EM_MOTPAS_437638#152531, EM_MTDEP_437592#152532, EM_MTDEP_ESTIM_437673#152533, EM_MT_PEC_SMG_437660#152534, EM_M_FORF_437469#152535, EM_NATASS_437510#152536, EM_NATURE_437455#152537, EM_NB_COT_437517#152538, EM_NB_FAC_437518#152539, EM_NUIT_437442#152540, EM_NUMACC_437511#152541, EM_NUMBOC_437481#152542, EM_NUMBOC_FT_437607#152543, EM_NUMBOF_437483#152544, EM_NUMBOM_437482#152545, EM_NUMBOM_FT_437608#152546, EM_NUMBOT_437507#152547, EM_NUMBOT_FT_437601#152548, EM_NUMCAI_437484#152549, EM_NUMCAI_FT_437657#152550, EM_NUMDEM_437436#152551, EM_NUMDEM_ORI_437666#152552, EM_NUMDEM_PROD_437644#152553, EM_NUMDOS_437435#152554, EM_NUMDOS_ORI_437686#152555, EM_NUMDOS_PROD_437647#152556, EM_NUMFAC_437513#152557, EM_NUMFOR_437486#152558, EM_NUMLOC_437527#152559, EM_NUMMUT_437485#152560, EM_NUMOP_437606#152561, EM_NUMPRG_437661#152562, EM_NUMREL_C_437561#152563, EM_NUMREL_C_F_437627#152564, EM_NUMREL_M_437562#152565, EM_NUMREL_M_F_437628#152566, EM_NUMREL_P_437563#152567, EM_NUMREL_P_F_437626#152568, EM_NUMSAF_437506#152569, EM_NUMSAL_437494#152570, EM_NUMTRT_437688#152571, EM_ORIDEM_437508#152572, EM_PARCAI_437471#152573, EM_PARFOR_437475#152574, EM_PARMUT_437473#152575, EM_PARMUT_FT_437554#152576, EM_PARMUT_HON_437555#152577, EM_PARPAT_437470#152578, EM_PARPAT_FT_437556#152579, EM_PARPAT_HON_437557#152580, EM_PAVMUT_437619#152581, EM_PJAMC_437579#152582, EM_PRCHAMC_437577#152583, EM_PRESCS_437684#152584, EM_QUALDP_437539#152585, EM_RCP_437652#152586, EM_REGCAI_437477#152587, EM_REGFOR_437479#152588, EM_REGMUT_437478#152589, EM_REGPAT_437476#152590, EM_REGPAT_HON_437593#152591, EM_REJBOC_437609#152592, EM_REJBOC_FT_437610#152593, EM_REJBOM_437611#152594, EM_REJBOM_FT_437612#152595, EM_REJBOT_437514#152596, EM_REJBOT_FT_437602#152597, EM_RNGNAI_437530#152598, EM_R_A_R_437480#152599, EM_R_CD_437632#152600, EM_R_CR_437458#152601, EM_R_F_437459#152602, EM_SCAN1_437495#152603, EM_SCAN2_437496#152604, EM_SIGMA_437452#152605, EM_SLDCAI_437598#152606, EM_SLDCAI_FT_437599#152607, EM_SLDMUT_437596#152608, EM_SLDMUT_FT_437597#152609, EM_SLDPAT_437594#152610, EM_SLDPAT_FT_437595#152611, EM_SPL_TRANS_437651#152612, EM_STAOPI_437569#152613, EM_STATCR_437457#152614, EM_STATUT_ENVOI_437654#152615, EM_STATUT_SMS_437643#152616, EM_SUPMOTIF_437656#152617, EM_TARIF_437515#152618, EM_TAUCAI_437472#152619, EM_TAUMUT_437474#152620, EM_TIERSP_437540#152621, EM_TPAMC_437578#152622, EM_TYPEXO_437529#152623, EM_TYPFAC_437580#152624, EM_TYPRES_437570#152625, EM_URGEN_437440#152626, EM_URG_437648#152627, EM_VALID_437454#152628, EM_VERSION_437519#152629]
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#152375, EM_ACTES_ESTIM_437685#152376, EM_ADHMUT_437550#152377, EM_ALARMES_437667#152378, EM_ANGIO_437448#152379, EM_ANNVAL_437465#152380, EM_ASTREI_437441#152381, EM_ATTENTE_437640#152382, EM_ATTMOTIF_437641#152383, EM_AUTR_437449#152384, EM_CODACC_437637#152385, EM_CODATS_437568#152386, EM_CODCAIAT_437533#152387, EM_CODCAIPJ_437537#152388, EM_CODCENAT_437581#152389, EM_CODC_A_437451#152390, EM_CODDIC_437501#152391, EM_CODENC_437499#152392, EM_CODENT_437548#152393, EM_CODETAB_PROD_437645#152394, EM_CODIPS_437590#152395, EM_CODMEDPAT_437689#152396, EM_CODMED_437437#152397, EM_CODMTR_437591#152398, EM_CODM_H_437567#152399, EM_CODPJ_437535#152400, EM_CODREGAT_437532#152401, EM_CODREGPJ_437536#152402, EM_CODROUT_437572#152403, EM_CODSEC_437497#152404, EM_CODSER_437450#152405, EM_CODSIT_437520#152406, EM_CODSIT_PROD_437646#152407, EM_CODSOC_AF_437625#152408, EM_CODSOC_AH_437624#152409, EM_CODSOC_CF_437621#152410, EM_CODSOC_CH_437620#152411, EM_CODSOC_MF_437623#152412, EM_CODSOC_MH_437622#152413, EM_CODSPE_437687#152414, EM_CODSRV_437498#152415, EM_CODSTS_437576#152416, EM_CODTIT_437500#152417, EM_CODUFL_437526#152418, EM_CODUTI_437522#152419, EM_COMMENT_437571#152420, EM_COMM_1_437463#152421, EM_CONMUT_437549#152422, EM_CRL_AF_437618#152423, EM_CRL_AH_437617#152424, EM_CRL_CF_437614#152425, EM_CRL_CH_437613#152426, EM_CRL_MF_437616#152427, EM_CRL_MH_437615#152428, EM_CR_ATTENDU_437653#152429, EM_C_R_CD_437679#152430, EM_C_R_CR_437678#152431, EM_C_R_F_437680#152432, EM_DAT100_437489#152433, EM_DATACC2_437541#152434, EM_DATACC_437512#152435, EM_DATARR_437490#152436, EM_DATCOT_437492#152437, EM_DATCRE_437525#152438, EM_DATCSS_437488#152439, EM_DATENTREE_437682#152440, EM_DATENT_437547#152441, EM_DATENVC_437566#152442, EM_DATENVP_437505#152443, EM_DATENV_437503#152444, EM_DATF_D_437487#152445, EM_DATMAJ_437521#152446, EM_DATPARTI_437664#152447, EM_DATPJ_437542#152448, EM_DATPRC_437635#152449, EM_DATPRE_437523#152450, EM_DATRV_437438#152451, EM_DEBEXOMAT_437585#152452, EM_DEST_437642#152453, EM_DIF_DEFER_437668#152454, EM_DIF_PAT_437658#152455, EM_DIF_PRESC_437659#152456, EM_DMPAUT_437675#152457, EM_DOMAINE_437573#152458, EM_DOSCLO_437462#152459, EM_DOSCOM_437439#152460, EM_DROITS_437544#152461, EM_D_R_CD_437633#152462, EM_D_R_CR_437460#152463, EM_D_R_F_437461#152464, EM_ECHO_437447#152465, EM_ENVOIC_437565#152466, EM_ENVOIP_437504#152467, EM_ENVOI_437502#152468, EM_ETAPE_437456#152469, EM_EXA_LO_437446#152470, EM_EXA_SECU_437516#152471, EM_FACCON_437468#152472, EM_FACTUR_437467#152473, EM_FACTUR_ESTIM_437672#152474, EM_FERIE_437443#152475, EM_FINESS_437662#152476, EM_FINESS_HONO_437671#152477, EM_FINEXOMAT_437586#152478, EM_FLACCID_437528#152479, EM_FLAMCFSE_437553#152480, EM_FLAME_437604#152481, EM_FLARMAT_437582#152482, EM_FLCARNET_437538#152483, EM_FLCMU_437524#152484, EM_FLCVIM_437588#152485, EM_FLDECLMTR_437605#152486, EM_FLDMP_SECRET_437674#152487, EM_FLDOMIC_437543#152488, EM_FLENTREE_437681#152489, EM_FLFACT_437559#152490, EM_FLFTIMP_437655#152491, EM_FLGRATUI_437560#152492, EM_FLHOSPIT_437584#152493, EM_FLLIBERE_437676#152494, EM_FLNSCAI_437629#152495, EM_FLNSMUT_437630#152496, EM_FLNSPAT_437631#152497, EM_FLNUM_437558#152498, EM_FLPARTI_437663#152499, EM_FLPEC_437531#152500, EM_FLPORTAIL_437670#152501, EM_FLPRESCINF_437603#152502, EM_FLREFER_437534#152503, EM_FLTBDI_437639#152504, EM_FLTELE_437600#152505, EM_FLTITMED_437552#152506, EM_FLTOPM_437545#152507, EM_FLTOPR_437546#152508, EM_FLVIP_437669#152509, EM_FORC_437583#152510, EM_FORFAI_437444#152511, EM_GARMUT_437551#152512, EM_GROUPE_437464#152513, EM_HEUARR_437491#152514, EM_HEUCOT_437493#152515, EM_HEUENTREE_437683#152516, EM_HEUPRC_437636#152517, EM_IDFACSIT_437665#152518, EM_IDHOTE_437575#152519, EM_INDTRAI_437574#152520, EM_INFOAMC_437589#152521, EM_INFOTDB_437587#152522, EM_INT_SPE_437650#152523, EM_INT_STD_437649#152524, EM_IRM_437445#152525, EM_LIBEL_437453#152526, EM_LOCK_437634#152527, EM_MDTMUT_437564#152528, EM_MODTRT_437509#152529, EM_MONNAIE_437466#152530, EM_MOTPAS_437638#152531, EM_MTDEP_437592#152532, EM_MTDEP_ESTIM_437673#152533, EM_MT_PEC_SMG_437660#152534, EM_M_FORF_437469#152535, EM_NATASS_437510#152536, EM_NATURE_437455#152537, EM_NB_COT_437517#152538, EM_NB_FAC_437518#152539, EM_NUIT_437442#152540, EM_NUMACC_437511#152541, EM_NUMBOC_437481#152542, EM_NUMBOC_FT_437607#152543, EM_NUMBOF_437483#152544, EM_NUMBOM_437482#152545, EM_NUMBOM_FT_437608#152546, EM_NUMBOT_437507#152547, EM_NUMBOT_FT_437601#152548, EM_NUMCAI_437484#152549, EM_NUMCAI_FT_437657#152550, EM_NUMDEM_437436#152551, EM_NUMDEM_ORI_437666#152552, EM_NUMDEM_PROD_437644#152553, EM_NUMDOS_437435#152554, EM_NUMDOS_ORI_437686#152555, EM_NUMDOS_PROD_437647#152556, EM_NUMFAC_437513#152557, EM_NUMFOR_437486#152558, EM_NUMLOC_437527#152559, EM_NUMMUT_437485#152560, EM_NUMOP_437606#152561, EM_NUMPRG_437661#152562, EM_NUMREL_C_437561#152563, EM_NUMREL_C_F_437627#152564, EM_NUMREL_M_437562#152565, EM_NUMREL_M_F_437628#152566, EM_NUMREL_P_437563#152567, EM_NUMREL_P_F_437626#152568, EM_NUMSAF_437506#152569, EM_NUMSAL_437494#152570, EM_NUMTRT_437688#152571, EM_ORIDEM_437508#152572, EM_PARCAI_437471#152573, EM_PARFOR_437475#152574, EM_PARMUT_437473#152575, EM_PARMUT_FT_437554#152576, EM_PARMUT_HON_437555#152577, EM_PARPAT_437470#152578, EM_PARPAT_FT_437556#152579, EM_PARPAT_HON_437557#152580, EM_PAVMUT_437619#152581, EM_PJAMC_437579#152582, EM_PRCHAMC_437577#152583, EM_PRESCS_437684#152584, EM_QUALDP_437539#152585, EM_RCP_437652#152586, EM_REGCAI_437477#152587, EM_REGFOR_437479#152588, EM_REGMUT_437478#152589, EM_REGPAT_437476#152590, EM_REGPAT_HON_437593#152591, EM_REJBOC_437609#152592, EM_REJBOC_FT_437610#152593, EM_REJBOM_437611#152594, EM_REJBOM_FT_437612#152595, EM_REJBOT_437514#152596, EM_REJBOT_FT_437602#152597, EM_RNGNAI_437530#152598, EM_R_A_R_437480#152599, EM_R_CD_437632#152600, EM_R_CR_437458#152601, EM_R_F_437459#152602, EM_SCAN1_437495#152603, EM_SCAN2_437496#152604, EM_SIGMA_437452#152605, EM_SLDCAI_437598#152606, EM_SLDCAI_FT_437599#152607, EM_SLDMUT_437596#152608, EM_SLDMUT_FT_437597#152609, EM_SLDPAT_437594#152610, EM_SLDPAT_FT_437595#152611, EM_SPL_TRANS_437651#152612, EM_STAOPI_437569#152613, EM_STATCR_437457#152614, EM_STATUT_ENVOI_437654#152615, EM_STATUT_SMS_437643#152616, EM_SUPMOTIF_437656#152617, EM_TARIF_437515#152618, EM_TAUCAI_437472#152619, EM_TAUMUT_437474#152620, EM_TIERSP_437540#152621, EM_TPAMC_437578#152622, EM_TYPEXO_437529#152623, EM_TYPFAC_437580#152624, EM_TYPRES_437570#152625, EM_URGEN_437440#152626, EM_URG_437648#152627, EM_VALID_437454#152628, EM_VERSION_437519#152629]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_437435#152554)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_437435#152554)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_437436#152551)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_437436#152551)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMED_437437#152397)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMED_437437#152397)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATRV_437438#152451)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATRV_437438#152451)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCOM_437439#152460)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCOM_437439#152460)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URGEN_437440#152626)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_URGEN_437440#152626)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ASTREI_437441#152381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ASTREI_437441#152381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUIT_437442#152540)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUIT_437442#152540)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FERIE_437443#152475)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FERIE_437443#152475)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORFAI_437444#152511)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORFAI_437444#152511)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IRM_437445#152525)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IRM_437445#152525)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_LO_437446#152470)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_LO_437446#152470)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ECHO_437447#152465)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ECHO_437447#152465)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANGIO_437448#152379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANGIO_437448#152379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_AUTR_437449#152384)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_AUTR_437449#152384)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSER_437450#152405)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSER_437450#152405)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODC_A_437451#152390)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODC_A_437451#152390)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SIGMA_437452#152605)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SIGMA_437452#152605)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LIBEL_437453#152526)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_LIBEL_437453#152526)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VALID_437454#152628)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_VALID_437454#152628)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATURE_437455#152537)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATURE_437455#152537)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ETAPE_437456#152469)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ETAPE_437456#152469)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATCR_437457#152614)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATCR_437457#152614)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CR_437458#152601)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CR_437458#152601)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_F_437459#152602)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_F_437459#152602)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CR_437460#152463)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CR_437460#152463)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_F_437461#152464)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_F_437461#152464)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOSCLO_437462#152459)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOSCLO_437462#152459)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMM_1_437463#152421)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMM_1_437463#152421)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GROUPE_437464#152513)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_GROUPE_437464#152513)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ANNVAL_437465#152380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ANNVAL_437465#152380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MONNAIE_437466#152530)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MONNAIE_437466#152530)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_437467#152473)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_437467#152473)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACCON_437468#152472)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACCON_437468#152472)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_M_FORF_437469#152535)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_M_FORF_437469#152535)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_437470#152578)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_437470#152578)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARCAI_437471#152573)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARCAI_437471#152573)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUCAI_437472#152619)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUCAI_437472#152619)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_437473#152575)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_437473#152575)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TAUMUT_437474#152620)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TAUMUT_437474#152620)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARFOR_437475#152574)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARFOR_437475#152574)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_437476#152590)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_437476#152590)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGCAI_437477#152587)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGCAI_437477#152587)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGMUT_437478#152589)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGMUT_437478#152589)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGFOR_437479#152588)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGFOR_437479#152588)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_A_R_437480#152599)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_A_R_437480#152599)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_437481#152542)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_437481#152542)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_437482#152545)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_437482#152545)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOF_437483#152544)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOF_437483#152544)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_437484#152549)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_437484#152549)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMMUT_437485#152560)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMMUT_437485#152560)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFOR_437486#152558)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFOR_437486#152558)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATF_D_437487#152445)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATF_D_437487#152445)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCSS_437488#152439)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCSS_437488#152439)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DAT100_437489#152433)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DAT100_437489#152433)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATARR_437490#152436)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATARR_437490#152436)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUARR_437491#152514)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUARR_437491#152514)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCOT_437492#152437)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCOT_437492#152437)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUCOT_437493#152515)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUCOT_437493#152515)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAL_437494#152570)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAL_437494#152570)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN1_437495#152603)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN1_437495#152603)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SCAN2_437496#152604)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SCAN2_437496#152604)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSEC_437497#152404)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSEC_437497#152404)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSRV_437498#152415)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSRV_437498#152415)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENC_437499#152392)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENC_437499#152392)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODTIT_437500#152417)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODTIT_437500#152417)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODDIC_437501#152391)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODDIC_437501#152391)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOI_437502#152468)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOI_437502#152468)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENV_437503#152444)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENV_437503#152444)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIP_437504#152467)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIP_437504#152467)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVP_437505#152443)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVP_437505#152443)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMSAF_437506#152569)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMSAF_437506#152569)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_437507#152547)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_437507#152547)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ORIDEM_437508#152572)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ORIDEM_437508#152572)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MODTRT_437509#152529)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MODTRT_437509#152529)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NATASS_437510#152536)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NATASS_437510#152536)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMACC_437511#152541)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMACC_437511#152541)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC_437512#152435)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC_437512#152435)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMFAC_437513#152557)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMFAC_437513#152557)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_437514#152596)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_437514#152596)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TARIF_437515#152618)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TARIF_437515#152618)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_EXA_SECU_437516#152471)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_EXA_SECU_437516#152471)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_COT_437517#152538)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_COT_437517#152538)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NB_FAC_437518#152539)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NB_FAC_437518#152539)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_VERSION_437519#152629)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_VERSION_437519#152629)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_437520#152406)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_437520#152406)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATMAJ_437521#152446)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATMAJ_437521#152446)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUTI_437522#152419)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUTI_437522#152419)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRE_437523#152450)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRE_437523#152450)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCMU_437524#152484)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCMU_437524#152484)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATCRE_437525#152438)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATCRE_437525#152438)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODUFL_437526#152418)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODUFL_437526#152418)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMLOC_437527#152559)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMLOC_437527#152559)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLACCID_437528#152479)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLACCID_437528#152479)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPEXO_437529#152623)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPEXO_437529#152623)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RNGNAI_437530#152598)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_RNGNAI_437530#152598)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPEC_437531#152500)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPEC_437531#152500)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGAT_437532#152401)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGAT_437532#152401)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIAT_437533#152387)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIAT_437533#152387)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLREFER_437534#152503)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLREFER_437534#152503)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODPJ_437535#152400)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODPJ_437535#152400)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODREGPJ_437536#152402)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODREGPJ_437536#152402)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#152388)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCAIPJ_437537#152388)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCARNET_437538#152483)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCARNET_437538#152483)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_QUALDP_437539#152585)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_QUALDP_437539#152585)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TIERSP_437540#152621)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TIERSP_437540#152621)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATACC2_437541#152434)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATACC2_437541#152434)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPJ_437542#152448)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPJ_437542#152448)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDOMIC_437543#152488)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDOMIC_437543#152488)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DROITS_437544#152461)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DROITS_437544#152461)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPM_437545#152507)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPM_437545#152507)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTOPR_437546#152508)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTOPR_437546#152508)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENT_437547#152441)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENT_437547#152441)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODENT_437548#152393)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODENT_437548#152393)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CONMUT_437549#152422)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CONMUT_437549#152422)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ADHMUT_437550#152377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ADHMUT_437550#152377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_GARMUT_437551#152512)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_GARMUT_437551#152512)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTITMED_437552#152506)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTITMED_437552#152506)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#152480)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAMCFSE_437553#152480)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#152576)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_FT_437554#152576)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#152577)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARMUT_HON_437555#152577)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#152579)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_FT_437556#152579)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#152580)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PARPAT_HON_437557#152580)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNUM_437558#152498)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNUM_437558#152498)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFACT_437559#152490)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFACT_437559#152490)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLGRATUI_437560#152492)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLGRATUI_437560#152492)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_437561#152563)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_437561#152563)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_437562#152565)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_437562#152565)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_437563#152567)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_437563#152567)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MDTMUT_437564#152528)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MDTMUT_437564#152528)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ENVOIC_437565#152466)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ENVOIC_437565#152466)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENVC_437566#152442)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENVC_437566#152442)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODM_H_437567#152399)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODM_H_437567#152399)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODATS_437568#152386)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODATS_437568#152386)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STAOPI_437569#152613)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STAOPI_437569#152613)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPRES_437570#152625)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPRES_437570#152625)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_COMMENT_437571#152420)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_COMMENT_437571#152420)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODROUT_437572#152403)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODROUT_437572#152403)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DOMAINE_437573#152458)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DOMAINE_437573#152458)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INDTRAI_437574#152520)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INDTRAI_437574#152520)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDHOTE_437575#152519)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDHOTE_437575#152519)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSTS_437576#152416)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSTS_437576#152416)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRCHAMC_437577#152583)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRCHAMC_437577#152583)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TPAMC_437578#152622)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TPAMC_437578#152622)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PJAMC_437579#152582)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PJAMC_437579#152582)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_TYPFAC_437580#152624)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_TYPFAC_437580#152624)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODCENAT_437581#152389)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODCENAT_437581#152389)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLARMAT_437582#152482)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLARMAT_437582#152482)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FORC_437583#152510)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FORC_437583#152510)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#152493)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLHOSPIT_437584#152493)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#152452)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEBEXOMAT_437585#152452)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#152478)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINEXOMAT_437586#152478)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOTDB_437587#152522)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOTDB_437587#152522)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLCVIM_437588#152485)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLCVIM_437588#152485)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INFOAMC_437589#152521)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INFOAMC_437589#152521)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODIPS_437590#152395)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODIPS_437590#152395)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMTR_437591#152398)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMTR_437591#152398)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_437592#152532)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_437592#152532)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#152591)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REGPAT_HON_437593#152591)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_437594#152610)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_437594#152610)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#152611)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDPAT_FT_437595#152611)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_437596#152608)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_437596#152608)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#152609)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDMUT_FT_437597#152609)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_437598#152606)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_437598#152606)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#152607)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SLDCAI_FT_437599#152607)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTELE_437600#152505)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTELE_437600#152505)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#152548)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOT_FT_437601#152548)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#152597)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOT_FT_437602#152597)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#152502)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPRESCINF_437603#152502)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLAME_437604#152481)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLAME_437604#152481)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#152486)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDECLMTR_437605#152486)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMOP_437606#152561)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMOP_437606#152561)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#152543)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOC_FT_437607#152543)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#152546)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMBOM_FT_437608#152546)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_437609#152592)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_437609#152592)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#152593)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOC_FT_437610#152593)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_437611#152594)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_437611#152594)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#152595)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_REJBOM_FT_437612#152595)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CH_437613#152426)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CH_437613#152426)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_CF_437614#152425)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_CF_437614#152425)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MH_437615#152428)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MH_437615#152428)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_MF_437616#152427)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_MF_437616#152427)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AH_437617#152424)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AH_437617#152424)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CRL_AF_437618#152423)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CRL_AF_437618#152423)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PAVMUT_437619#152581)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PAVMUT_437619#152581)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#152411)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CH_437620#152411)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#152410)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_CF_437621#152410)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#152413)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MH_437622#152413)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#152412)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_MF_437623#152412)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#152409)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AH_437624#152409)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#152408)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSOC_AF_437625#152408)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#152568)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_P_F_437626#152568)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#152564)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_C_F_437627#152564)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#152566)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMREL_M_F_437628#152566)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSCAI_437629#152495)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSCAI_437629#152495)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSMUT_437630#152496)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSMUT_437630#152496)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLNSPAT_437631#152497)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLNSPAT_437631#152497)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_R_CD_437632#152600)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_R_CD_437632#152600)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_D_R_CD_437633#152462)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_D_R_CD_437633#152462)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_LOCK_437634#152527)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_LOCK_437634#152527)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPRC_437635#152449)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPRC_437635#152449)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUPRC_437636#152517)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUPRC_437636#152517)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODACC_437637#152385)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODACC_437637#152385)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MOTPAS_437638#152531)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MOTPAS_437638#152531)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLTBDI_437639#152504)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLTBDI_437639#152504)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTENTE_437640#152382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTENTE_437640#152382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#152383)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ATTMOTIF_437641#152383)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DEST_437642#152453)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DEST_437642#152453)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#152616)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_SMS_437643#152616)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#152553)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_PROD_437644#152553)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#152394)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODETAB_PROD_437645#152394)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#152407)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSIT_PROD_437646#152407)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#152556)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_PROD_437647#152556)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_URG_437648#152627)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_URG_437648#152627)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_STD_437649#152524)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_STD_437649#152524)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_INT_SPE_437650#152523)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_INT_SPE_437650#152523)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#152612)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SPL_TRANS_437651#152612)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_RCP_437652#152586)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_RCP_437652#152586)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#152429)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CR_ATTENDU_437653#152429)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#152615)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_STATUT_ENVOI_437654#152615)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLFTIMP_437655#152491)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLFTIMP_437655#152491)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#152617)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_SUPMOTIF_437656#152617)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#152550)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMCAI_FT_437657#152550)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PAT_437658#152455)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PAT_437658#152455)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#152456)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_PRESC_437659#152456)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#152534)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MT_PEC_SMG_437660#152534)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMPRG_437661#152562)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMPRG_437661#152562)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_437662#152476)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_437662#152476)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPARTI_437663#152499)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPARTI_437663#152499)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATPARTI_437664#152447)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATPARTI_437664#152447)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_IDFACSIT_437665#152518)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_IDFACSIT_437665#152518)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#152552)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDEM_ORI_437666#152552)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ALARMES_437667#152378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ALARMES_437667#152378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#152454)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DIF_DEFER_437668#152454)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLVIP_437669#152509)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLVIP_437669#152509)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#152501)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLPORTAIL_437670#152501)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#152477)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FINESS_HONO_437671#152477)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#152474)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FACTUR_ESTIM_437672#152474)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#152533)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_MTDEP_ESTIM_437673#152533)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#152487)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLDMP_SECRET_437674#152487)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DMPAUT_437675#152457)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DMPAUT_437675#152457)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLLIBERE_437676#152494)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLLIBERE_437676#152494)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACCNUM_437677#152375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACCNUM_437677#152375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CR_437678#152431)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CR_437678#152431)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_CD_437679#152430)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_CD_437679#152430)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_C_R_F_437680#152432)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_C_R_F_437680#152432)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_FLENTREE_437681#152489)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_FLENTREE_437681#152489)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_DATENTREE_437682#152440)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_DATENTREE_437682#152440)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_HEUENTREE_437683#152516)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_HEUENTREE_437683#152516)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_PRESCS_437684#152584)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_PRESCS_437684#152584)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#152376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_ACTES_ESTIM_437685#152376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#152555)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMDOS_ORI_437686#152555)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODSPE_437687#152414)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODSPE_437687#152414)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_NUMTRT_437688#152571)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_NUMTRT_437688#152571)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#152396)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(EM_CODMEDPAT_437689#152396)), MARX) END)

(3) Project
Output: []
Input [255]: [EM_ACCNUM_437677#152375, EM_ACTES_ESTIM_437685#152376, EM_ADHMUT_437550#152377, EM_ALARMES_437667#152378, EM_ANGIO_437448#152379, EM_ANNVAL_437465#152380, EM_ASTREI_437441#152381, EM_ATTENTE_437640#152382, EM_ATTMOTIF_437641#152383, EM_AUTR_437449#152384, EM_CODACC_437637#152385, EM_CODATS_437568#152386, EM_CODCAIAT_437533#152387, EM_CODCAIPJ_437537#152388, EM_CODCENAT_437581#152389, EM_CODC_A_437451#152390, EM_CODDIC_437501#152391, EM_CODENC_437499#152392, EM_CODENT_437548#152393, EM_CODETAB_PROD_437645#152394, EM_CODIPS_437590#152395, EM_CODMEDPAT_437689#152396, EM_CODMED_437437#152397, EM_CODMTR_437591#152398, EM_CODM_H_437567#152399, EM_CODPJ_437535#152400, EM_CODREGAT_437532#152401, EM_CODREGPJ_437536#152402, EM_CODROUT_437572#152403, EM_CODSEC_437497#152404, EM_CODSER_437450#152405, EM_CODSIT_437520#152406, EM_CODSIT_PROD_437646#152407, EM_CODSOC_AF_437625#152408, EM_CODSOC_AH_437624#152409, EM_CODSOC_CF_437621#152410, EM_CODSOC_CH_437620#152411, EM_CODSOC_MF_437623#152412, EM_CODSOC_MH_437622#152413, EM_CODSPE_437687#152414, EM_CODSRV_437498#152415, EM_CODSTS_437576#152416, EM_CODTIT_437500#152417, EM_CODUFL_437526#152418, EM_CODUTI_437522#152419, EM_COMMENT_437571#152420, EM_COMM_1_437463#152421, EM_CONMUT_437549#152422, EM_CRL_AF_437618#152423, EM_CRL_AH_437617#152424, EM_CRL_CF_437614#152425, EM_CRL_CH_437613#152426, EM_CRL_MF_437616#152427, EM_CRL_MH_437615#152428, EM_CR_ATTENDU_437653#152429, EM_C_R_CD_437679#152430, EM_C_R_CR_437678#152431, EM_C_R_F_437680#152432, EM_DAT100_437489#152433, EM_DATACC2_437541#152434, EM_DATACC_437512#152435, EM_DATARR_437490#152436, EM_DATCOT_437492#152437, EM_DATCRE_437525#152438, EM_DATCSS_437488#152439, EM_DATENTREE_437682#152440, EM_DATENT_437547#152441, EM_DATENVC_437566#152442, EM_DATENVP_437505#152443, EM_DATENV_437503#152444, EM_DATF_D_437487#152445, EM_DATMAJ_437521#152446, EM_DATPARTI_437664#152447, EM_DATPJ_437542#152448, EM_DATPRC_437635#152449, EM_DATPRE_437523#152450, EM_DATRV_437438#152451, EM_DEBEXOMAT_437585#152452, EM_DEST_437642#152453, EM_DIF_DEFER_437668#152454, EM_DIF_PAT_437658#152455, EM_DIF_PRESC_437659#152456, EM_DMPAUT_437675#152457, EM_DOMAINE_437573#152458, EM_DOSCLO_437462#152459, EM_DOSCOM_437439#152460, EM_DROITS_437544#152461, EM_D_R_CD_437633#152462, EM_D_R_CR_437460#152463, EM_D_R_F_437461#152464, EM_ECHO_437447#152465, EM_ENVOIC_437565#152466, EM_ENVOIP_437504#152467, EM_ENVOI_437502#152468, EM_ETAPE_437456#152469, EM_EXA_LO_437446#152470, EM_EXA_SECU_437516#152471, EM_FACCON_437468#152472, EM_FACTUR_437467#152473, EM_FACTUR_ESTIM_437672#152474, EM_FERIE_437443#152475, EM_FINESS_437662#152476, EM_FINESS_HONO_437671#152477, EM_FINEXOMAT_437586#152478, EM_FLACCID_437528#152479, EM_FLAMCFSE_437553#152480, EM_FLAME_437604#152481, EM_FLARMAT_437582#152482, EM_FLCARNET_437538#152483, EM_FLCMU_437524#152484, EM_FLCVIM_437588#152485, EM_FLDECLMTR_437605#152486, EM_FLDMP_SECRET_437674#152487, EM_FLDOMIC_437543#152488, EM_FLENTREE_437681#152489, EM_FLFACT_437559#152490, EM_FLFTIMP_437655#152491, EM_FLGRATUI_437560#152492, EM_FLHOSPIT_437584#152493, EM_FLLIBERE_437676#152494, EM_FLNSCAI_437629#152495, EM_FLNSMUT_437630#152496, EM_FLNSPAT_437631#152497, EM_FLNUM_437558#152498, EM_FLPARTI_437663#152499, EM_FLPEC_437531#152500, EM_FLPORTAIL_437670#152501, EM_FLPRESCINF_437603#152502, EM_FLREFER_437534#152503, EM_FLTBDI_437639#152504, EM_FLTELE_437600#152505, EM_FLTITMED_437552#152506, EM_FLTOPM_437545#152507, EM_FLTOPR_437546#152508, EM_FLVIP_437669#152509, EM_FORC_437583#152510, EM_FORFAI_437444#152511, EM_GARMUT_437551#152512, EM_GROUPE_437464#152513, EM_HEUARR_437491#152514, EM_HEUCOT_437493#152515, EM_HEUENTREE_437683#152516, EM_HEUPRC_437636#152517, EM_IDFACSIT_437665#152518, EM_IDHOTE_437575#152519, EM_INDTRAI_437574#152520, EM_INFOAMC_437589#152521, EM_INFOTDB_437587#152522, EM_INT_SPE_437650#152523, EM_INT_STD_437649#152524, EM_IRM_437445#152525, EM_LIBEL_437453#152526, EM_LOCK_437634#152527, EM_MDTMUT_437564#152528, EM_MODTRT_437509#152529, EM_MONNAIE_437466#152530, EM_MOTPAS_437638#152531, EM_MTDEP_437592#152532, EM_MTDEP_ESTIM_437673#152533, EM_MT_PEC_SMG_437660#152534, EM_M_FORF_437469#152535, EM_NATASS_437510#152536, EM_NATURE_437455#152537, EM_NB_COT_437517#152538, EM_NB_FAC_437518#152539, EM_NUIT_437442#152540, EM_NUMACC_437511#152541, EM_NUMBOC_437481#152542, EM_NUMBOC_FT_437607#152543, EM_NUMBOF_437483#152544, EM_NUMBOM_437482#152545, EM_NUMBOM_FT_437608#152546, EM_NUMBOT_437507#152547, EM_NUMBOT_FT_437601#152548, EM_NUMCAI_437484#152549, EM_NUMCAI_FT_437657#152550, EM_NUMDEM_437436#152551, EM_NUMDEM_ORI_437666#152552, EM_NUMDEM_PROD_437644#152553, EM_NUMDOS_437435#152554, EM_NUMDOS_ORI_437686#152555, EM_NUMDOS_PROD_437647#152556, EM_NUMFAC_437513#152557, EM_NUMFOR_437486#152558, EM_NUMLOC_437527#152559, EM_NUMMUT_437485#152560, EM_NUMOP_437606#152561, EM_NUMPRG_437661#152562, EM_NUMREL_C_437561#152563, EM_NUMREL_C_F_437627#152564, EM_NUMREL_M_437562#152565, EM_NUMREL_M_F_437628#152566, EM_NUMREL_P_437563#152567, EM_NUMREL_P_F_437626#152568, EM_NUMSAF_437506#152569, EM_NUMSAL_437494#152570, EM_NUMTRT_437688#152571, EM_ORIDEM_437508#152572, EM_PARCAI_437471#152573, EM_PARFOR_437475#152574, EM_PARMUT_437473#152575, EM_PARMUT_FT_437554#152576, EM_PARMUT_HON_437555#152577, EM_PARPAT_437470#152578, EM_PARPAT_FT_437556#152579, EM_PARPAT_HON_437557#152580, EM_PAVMUT_437619#152581, EM_PJAMC_437579#152582, EM_PRCHAMC_437577#152583, EM_PRESCS_437684#152584, EM_QUALDP_437539#152585, EM_RCP_437652#152586, EM_REGCAI_437477#152587, EM_REGFOR_437479#152588, EM_REGMUT_437478#152589, EM_REGPAT_437476#152590, EM_REGPAT_HON_437593#152591, EM_REJBOC_437609#152592, EM_REJBOC_FT_437610#152593, EM_REJBOM_437611#152594, EM_REJBOM_FT_437612#152595, EM_REJBOT_437514#152596, EM_REJBOT_FT_437602#152597, EM_RNGNAI_437530#152598, EM_R_A_R_437480#152599, EM_R_CD_437632#152600, EM_R_CR_437458#152601, EM_R_F_437459#152602, EM_SCAN1_437495#152603, EM_SCAN2_437496#152604, EM_SIGMA_437452#152605, EM_SLDCAI_437598#152606, EM_SLDCAI_FT_437599#152607, EM_SLDMUT_437596#152608, EM_SLDMUT_FT_437597#152609, EM_SLDPAT_437594#152610, EM_SLDPAT_FT_437595#152611, EM_SPL_TRANS_437651#152612, EM_STAOPI_437569#152613, EM_STATCR_437457#152614, EM_STATUT_ENVOI_437654#152615, EM_STATUT_SMS_437643#152616, EM_SUPMOTIF_437656#152617, EM_TARIF_437515#152618, EM_TAUCAI_437472#152619, EM_TAUMUT_437474#152620, EM_TIERSP_437540#152621, EM_TPAMC_437578#152622, EM_TYPEXO_437529#152623, EM_TYPFAC_437580#152624, EM_TYPRES_437570#152625, EM_URGEN_437440#152626, EM_URG_437648#152627, EM_VALID_437454#152628, EM_VERSION_437519#152629]

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

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

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

(7) HashAggregate [codegen id : 2]
Input [1]: [count#154678L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#154415L]
Results [1]: [count(1)#154415L AS COL_1f59ef27-7f1c-496a-92f5-819bd5a82107#154417L]

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

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

(10) HashAggregate
Input [1]: [count#154678L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#154415L]
Results [1]: [count(1)#154415L AS COL_1f59ef27-7f1c-496a-92f5-819bd5a82107#154417L]

(11) AdaptiveSparkPlan
Output [1]: [COL_1f59ef27-7f1c-496a-92f5-819bd5a82107#154417L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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