"JIRA_Summary" AS "JIRA_Summary", "JIRA_Issue key" AS "JIRA_Issue key", "Custom field (GCMA's Code)" AS "Custom field (GCMA's Code)", "Custom field (Order Number)" AS "Custom field (Order Number)", "Custom field (Business Unit)" AS "Custom field (Business Unit)", "Custom field (Primary Brand)" AS "Custom field (Primary Brand)", "Custom field (Number of assets)" AS "Custom field (Number of assets)", "Custom field (Week Number)" AS "Custom field (Week Number)", ROUND(CAST("Custom field (Week Number)" AS DOUBLE), 0) AS "formula_result" FROM ( SELECT "JIRA_Summary", "JIRA_JIRA_Sprint_info", "JIRA_Issue key", "JIRA_Custom field (Business Unit)", "JIRA_Custom field (Data Source)_2", "JIRA_Custom field (Execution Channel)", "JIRA_Jira_CodigoGCMA", "JIRA_Custom field (Location)", "JIRA_Custom field (Number of assets)", "JIRA_Custom field (Order Number)", "JIRA_Custom field (Primary Brand)", "JIRA_Custom field (Week Number)", "CTRL_Nome tarefa", "CTRL_Código tarefa", "CTRL_Código GCMA", "CTRL_Código AWF", "CTRL_BU", "CTRL_Marca", "CTRL_Quantidade de peças", "CTRL_Sprint", "GCMA_DOC_JOB_NUMBER", "GCMA_DOCUMENT_NM", "GCMA_BUSINESS", "GCMA_BUSINESS_UNIT", "GCMA_THERAPEUTIC_AREA", "GCMA_BRAND", "GCMA_DOCUMENT_NUMBER_OF_PAGES", "GCMA_UNBRANDED_CONTENT_PLATFORM", "GCMA_DOCUMENT_BU", "Sprint_Number" AS "Custom field (Week Number)", "Business_Unit" AS "Custom field (Business Unit)", "AWF_Code" AS "Custom field (Order Number)", "GCMA_Code" AS "Custom field (GCMA's Code)", "Primary_Brand" AS "Custom field (Primary Brand)", "Assets_Number" AS "Custom field (Number of assets)" FROM ( SELECT "JIRA_Summary", "JIRA_JIRA_Sprint_info", "JIRA_Issue key", "JIRA_Custom field (Business Unit)", "JIRA_Custom field (Data Source)_2", "JIRA_Custom field (Execution Channel)", "JIRA_Jira_CodigoGCMA", "JIRA_Custom field (Location)", "JIRA_Custom field (Number of assets)", "JIRA_Custom field (Order Number)", "JIRA_Custom field (Primary Brand)", "JIRA_Custom field (Week Number)", "CTRL_Nome tarefa", "CTRL_Código tarefa", "CTRL_Código GCMA", "CTRL_Código AWF", "CTRL_BU", "CTRL_Marca", "CTRL_Quantidade de peças", "CTRL_Sprint", "GCMA_DOC_JOB_NUMBER", "GCMA_DOCUMENT_NM", "GCMA_BUSINESS", "GCMA_BUSINESS_UNIT", "GCMA_THERAPEUTIC_AREA", "GCMA_BRAND", "GCMA_DOCUMENT_NUMBER_OF_PAGES", "GCMA_UNBRANDED_CONTENT_PLATFORM", "GCMA_DOCUMENT_BU", "Sprint_Number", "Business_Unit", "AWF_Code", "GCMA_Code", CASE WHEN "Primary_Brand" = 'ABRYSVO--281' THEN 'ABRYSVO--281' ELSE CASE WHEN "Primary_Brand" = 'PAXLOVID--240' THEN 'PAXLOVID--240' ELSE CASE WHEN "Primary_Brand" = 'ZAVICEFTA--234' THEN 'ZAVICEFTA--234' ELSE CASE WHEN "Primary_Brand" = 'LORBRENA--226' THEN 'LORBRENA--226' ELSE CASE WHEN "Primary_Brand" = 'XELJANZ' THEN 'XELJANZ--189' ELSE CASE WHEN "Primary_Brand" = 'TALZENNA--243' THEN 'TALZENNA--243' ELSE CASE WHEN "Primary_Brand" = 'PREV(E)NAR 20' THEN 'PREVENAR--145' ELSE CASE WHEN "Primary_Brand" = 'ABRYSVO' THEN 'ABRYSVO--281' ELSE CASE WHEN "Primary_Brand" = 'BRAFTOVI MEKTOVI' THEN 'BRAFTOVI MEKTOVI--294' ELSE CASE WHEN "Primary_Brand" = 'ACEL-IMONE--2' THEN 'ACEL-IMONE--2' ELSE CASE WHEN "Primary_Brand" = 'BRAFTOVI' THEN 'BRAFTOVI--246' ELSE CASE WHEN "Primary_Brand" = 'PREV(E)NAR 20,ABRYSVO' THEN 'PREVENAR--145, ABRYSVO--2811' ELSE CASE WHEN "Primary_Brand" = 'UNBRANDED' THEN 'Unbranded--233' ELSE CASE WHEN "Primary_Brand" = 'PADCEV' THEN 'PADCEV' ELSE CASE WHEN "Primary_Brand" = 'COMIRNATY--235' THEN 'COMIRNATY--235' ELSE CASE WHEN "Primary_Brand" = 'NGENLA--278' THEN 'NGENLA--278' ELSE CASE WHEN "Primary_Brand" = 'HYMPAVZI' THEN 'HYMPAVZI-(Marstacimab)-295' ELSE CASE WHEN "Primary_Brand" = 'PREV(E)NAR 20,COMIRNATY,ABRYSVO' THEN 'PREVENAR--145, COMIRNATY--235, ABRYSVO--2811' ELSE CASE WHEN "Primary_Brand" = 'RIMEGEPANT--282' THEN 'RIMEGEPANT--282' ELSE CASE WHEN "Primary_Brand" = 'LORBRENA,TALZENNA,BRAFTOVI' THEN 'LORBRENA--226, TALZENA--243, BRAFTOVI--246' ELSE CASE WHEN "Primary_Brand" = 'BOSULIF,BESPONSA,MYLOTARG,ELREXFIO' THEN 'BOSULIF--244, BESPONSA--211' ELSE CASE WHEN "Primary_Brand" = 'IBRANCE--202' THEN 'IBRANCE--202' ELSE CASE WHEN "Primary_Brand" = 'ELREXFIO' THEN 'ELREXFIO--291' ELSE CASE WHEN "Primary_Brand" = 'ZAVICEFTA' THEN 'ZAVICEFTA--234' ELSE CASE WHEN "Primary_Brand" = 'VYNDAMAX' THEN 'VYNDAMAX--241' ELSE CASE WHEN "Primary_Brand" = 'UNASYN--179' THEN 'UNASYN--179' ELSE CASE WHEN "Primary_Brand" = 'VYNDAQEL' THEN 'VYNDAQEL--222' ELSE CASE WHEN "Primary_Brand" = 'PAXLOVID' THEN 'PAXLOVID--240' ELSE CASE WHEN "Primary_Brand" = 'LITFULO--279' THEN 'LITFULO--279' ELSE CASE WHEN "Primary_Brand" = 'ENBREL--44' THEN 'ENBREL--44' ELSE CASE WHEN "Primary_Brand" = 'NGENLA' THEN 'NGENLA--278' ELSE CASE WHEN "Primary_Brand" = 'VYNDAMAX--241' THEN 'VYNDAMAX--241' ELSE CASE WHEN "Primary_Brand" = 'ELIQUIS--43' THEN 'ELIQUIS--43' ELSE CASE WHEN "Primary_Brand" = 'BRAFTOVI--246' THEN 'BRAFTOVI--246' ELSE CASE WHEN "Primary_Brand" = 'GENOTROPIN--85' THEN 'GENOTROPIN--85' ELSE CASE WHEN "Primary_Brand" = 'XALKORI--223' THEN 'XALKORI--223' ELSE CASE WHEN "Primary_Brand" = 'CIBINQO--242' THEN 'CIBINQO--242' ELSE CASE WHEN "Primary_Brand" = 'PREV(E)NAR 20,COMIRNATY,PAXLOVID,ABRYSVO' THEN 'PREVENAR--145, COMIRNATY--235, PAXLOVID--240, ABRYSVO--2811' ELSE CASE WHEN "Primary_Brand" = 'TORGENA--220' THEN 'TORGENA--220' ELSE CASE WHEN "Primary_Brand" = 'VYNDAQEL--222' THEN 'VYNDAQEL--222' ELSE CASE WHEN "Primary_Brand" = 'LITFULO' THEN 'LITFULO--279' ELSE CASE WHEN "Primary_Brand" = 'COMIRNATY' THEN 'COMIRNATY--235' ELSE CASE WHEN "Primary_Brand" = 'ATGAM' THEN 'ATGAM' ELSE CASE WHEN "Primary_Brand" = 'BESPONSA--211' THEN 'BESPONSA--211' ELSE CASE WHEN "Primary_Brand" = 'IBRANCE,LORBRENA,BRAFTOVI,MEKTOVI' THEN 'IBRANCE--202' ELSE CASE WHEN "Primary_Brand" = 'XELJANZ--189' THEN 'XELJANZ--189' ELSE CASE WHEN "Primary_Brand" = 'GENRYZON--290' THEN 'GENRYZON--290' ELSE CASE WHEN "Primary_Brand" = 'PREVENAR--145' THEN 'PREVENAR--145' ELSE CASE WHEN "Primary_Brand" = 'CIBINQO' THEN 'CIBINQO--242' ELSE CASE WHEN "Primary_Brand" = 'HYMPAVZI-(Marstacimab)-295' THEN 'HYMPAVZI-(Marstacimab)-295' ELSE CASE WHEN "Primary_Brand" = 'ELREXFIO--291' THEN 'ELREXFIO--291' ELSE CASE WHEN "Primary_Brand" = 'LORBRENA' THEN 'LORBRENA--226' ELSE CASE WHEN "Primary_Brand" = 'Unbranded--233' THEN 'Unbranded--233' ELSE "Primary_Brand" END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END END AS "Primary_Brand", CASE WHEN (CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Number of assets)" IS NOT NULL AND ("JIRA_Custom field (Number of assets)" != 0 OR "JIRA_Custom field (Number of assets)" IS NULL AND 0 IS NOT NULL OR "JIRA_Custom field (Number of assets)" IS NOT NULL AND 0 IS NULL) THEN "JIRA_Custom field (Number of assets)" WHEN (NOT ((CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Number of assets)" IS NOT NULL AND ("JIRA_Custom field (Number of assets)" != 0 OR "JIRA_Custom field (Number of assets)" IS NULL AND 0 IS NOT NULL OR "JIRA_Custom field (Number of assets)" IS NOT NULL AND 0 IS NULL)) OR (((CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Number of assets)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Number of assets)" IS NOT NULL AND ("JIRA_Custom field (Number of assets)" != 0 OR "JIRA_Custom field (Number of assets)" IS NULL AND 0 IS NOT NULL OR "JIRA_Custom field (Number of assets)" IS NOT NULL AND 0 IS NULL)) IS NULL)) AND (CAST("CTRL_Quantidade de peças" AS VARCHAR) != '' OR CAST("CTRL_Quantidade de peças" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("CTRL_Quantidade de peças" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "CTRL_Quantidade de peças" IS NOT NULL AND ("CTRL_Quantidade de peças" != '0' OR "CTRL_Quantidade de peças" IS NULL AND '0' IS NOT NULL OR "CTRL_Quantidade de peças" IS NOT NULL AND '0' IS NULL) THEN "CTRL_Quantidade de peças" END AS "Assets_Number" FROM ( SELECT "JIRA_Summary", "JIRA_JIRA_Sprint_info", "JIRA_Issue key", "JIRA_Custom field (Business Unit)", "JIRA_Custom field (Data Source)_2", "JIRA_Custom field (Execution Channel)", "JIRA_Jira_CodigoGCMA", "JIRA_Custom field (Location)", "JIRA_Custom field (Number of assets)", "JIRA_Custom field (Order Number)", "JIRA_Custom field (Primary Brand)", "JIRA_Custom field (Week Number)", "CTRL_Nome tarefa", "CTRL_Código tarefa", "CTRL_Código GCMA", "CTRL_Código AWF", "CTRL_BU", "CTRL_Marca", "CTRL_Quantidade de peças", "CTRL_Sprint", "GCMA_DOC_JOB_NUMBER", "GCMA_DOCUMENT_NM", "GCMA_BUSINESS", "GCMA_BUSINESS_UNIT", "GCMA_THERAPEUTIC_AREA", "GCMA_BRAND", "GCMA_DOCUMENT_NUMBER_OF_PAGES", "GCMA_UNBRANDED_CONTENT_PLATFORM", "GCMA_DOCUMENT_BU", "Sprint_Number", "Business_Unit", "AWF_Code", "GCMA_Code", CASE WHEN (CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Primary Brand)" IS NOT NULL THEN "JIRA_Custom field (Primary Brand)" WHEN (NOT ((CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Primary Brand)" IS NOT NULL) OR (((CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Primary Brand)" IS NOT NULL) IS NULL)) AND (CAST("GCMA_BRAND" AS VARCHAR) != '' OR CAST("GCMA_BRAND" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BRAND" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BRAND" IS NOT NULL THEN "GCMA_BRAND" WHEN (NOT ((CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Primary Brand)" IS NOT NULL OR (CAST("GCMA_BRAND" AS VARCHAR) != '' OR CAST("GCMA_BRAND" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BRAND" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BRAND" IS NOT NULL) OR (((CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Primary Brand)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Primary Brand)" IS NOT NULL OR (CAST("GCMA_BRAND" AS VARCHAR) != '' OR CAST("GCMA_BRAND" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BRAND" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BRAND" IS NOT NULL) IS NULL)) AND (CAST("CTRL_Marca" AS VARCHAR) != '' OR CAST("CTRL_Marca" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("CTRL_Marca" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "CTRL_Marca" IS NOT NULL THEN "CTRL_Marca" END AS "Primary_Brand" FROM ( SELECT "JIRA_Summary", "JIRA_JIRA_Sprint_info", "JIRA_Issue key", "JIRA_Custom field (Business Unit)", "JIRA_Custom field (Data Source)_2", "JIRA_Custom field (Execution Channel)", "JIRA_Jira_CodigoGCMA", "JIRA_Custom field (Location)", "JIRA_Custom field (Number of assets)", "JIRA_Custom field (Order Number)", "JIRA_Custom field (Primary Brand)", "JIRA_Custom field (Week Number)", "CTRL_Nome tarefa", "CTRL_Código tarefa", "CTRL_Código GCMA", "CTRL_Código AWF", "CTRL_BU", "CTRL_Marca", "CTRL_Quantidade de peças", "CTRL_Sprint", "GCMA_DOC_JOB_NUMBER", "GCMA_DOCUMENT_NM", "GCMA_BUSINESS", "GCMA_BUSINESS_UNIT", "GCMA_THERAPEUTIC_AREA", "GCMA_BRAND", "GCMA_DOCUMENT_NUMBER_OF_PAGES", "GCMA_UNBRANDED_CONTENT_PLATFORM", "GCMA_DOCUMENT_BU", "Sprint_Number", "Business_Unit", "AWF_Code", CASE WHEN (CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) != '' OR CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Jira_CodigoGCMA" IS NOT NULL AND ("JIRA_Jira_CodigoGCMA" != 'Inserir código GCMA da peça criada' OR "JIRA_Jira_CodigoGCMA" IS NULL AND 'Inserir código GCMA da peça criada' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND 'Inserir código GCMA da peça criada' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '0' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '0' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '0' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != 'GCMA INEXISTENTE' OR "JIRA_Jira_CodigoGCMA" IS NULL AND 'GCMA INEXISTENTE' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND 'GCMA INEXISTENTE' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL) THEN "JIRA_Jira_CodigoGCMA" WHEN (NOT ((CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) != '' OR CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Jira_CodigoGCMA" IS NOT NULL AND ("JIRA_Jira_CodigoGCMA" != 'Inserir código GCMA da peça criada' OR "JIRA_Jira_CodigoGCMA" IS NULL AND 'Inserir código GCMA da peça criada' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND 'Inserir código GCMA da peça criada' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '0' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '0' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '0' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != 'GCMA INEXISTENTE' OR "JIRA_Jira_CodigoGCMA" IS NULL AND 'GCMA INEXISTENTE' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND 'GCMA INEXISTENTE' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL)) OR (((CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) != '' OR CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Jira_CodigoGCMA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Jira_CodigoGCMA" IS NOT NULL AND ("JIRA_Jira_CodigoGCMA" != 'Inserir código GCMA da peça criada' OR "JIRA_Jira_CodigoGCMA" IS NULL AND 'Inserir código GCMA da peça criada' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND 'Inserir código GCMA da peça criada' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '0' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '0' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '0' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != 'GCMA INEXISTENTE' OR "JIRA_Jira_CodigoGCMA" IS NULL AND 'GCMA INEXISTENTE' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND 'GCMA INEXISTENTE' IS NULL) AND ("JIRA_Jira_CodigoGCMA" != '' OR "JIRA_Jira_CodigoGCMA" IS NULL AND '' IS NOT NULL OR "JIRA_Jira_CodigoGCMA" IS NOT NULL AND '' IS NULL)) IS NULL)) AND (CAST("CTRL_Código GCMA" AS VARCHAR) != '' OR CAST("CTRL_Código GCMA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("CTRL_Código GCMA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "CTRL_Código GCMA" IS NOT NULL AND ("CTRL_Código GCMA" != 'Inserir código GCMA da peça criada' OR "CTRL_Código GCMA" IS NULL AND 'Inserir código GCMA da peça criada' IS NOT NULL OR "CTRL_Código GCMA" IS NOT NULL AND 'Inserir código GCMA da peça criada' IS NULL) AND ("CTRL_Código GCMA" != '' OR "CTRL_Código GCMA" IS NULL AND '' IS NOT NULL OR "CTRL_Código GCMA" IS NOT NULL AND '' IS NULL) AND ("CTRL_Código GCMA" != '' OR "CTRL_Código GCMA" IS NULL AND '' IS NOT NULL OR "CTRL_Código GCMA" IS NOT NULL AND '' IS NULL) AND ("CTRL_Código GCMA" != '0' OR "CTRL_Código GCMA" IS NULL AND '0' IS NOT NULL OR "CTRL_Código GCMA" IS NOT NULL AND '0' IS NULL) AND ("CTRL_Código GCMA" != 'GCMA INEXISTENTE' OR "CTRL_Código GCMA" IS NULL AND 'GCMA INEXISTENTE' IS NOT NULL OR "CTRL_Código GCMA" IS NOT NULL AND 'GCMA INEXISTENTE' IS NULL) AND ("CTRL_Código GCMA" != '' OR "CTRL_Código GCMA" IS NULL AND '' IS NOT NULL OR "CTRL_Código GCMA" IS NOT NULL AND '' IS NULL) THEN "CTRL_Código GCMA" END AS "GCMA_Code" FROM ( SELECT "JIRA_Summary", "JIRA_JIRA_Sprint_info", "JIRA_Issue key", "JIRA_Custom field (Business Unit)", "JIRA_Custom field (Data Source)_2", "JIRA_Custom field (Execution Channel)", "JIRA_Jira_CodigoGCMA", "JIRA_Custom field (Location)", "JIRA_Custom field (Number of assets)", "JIRA_Custom field (Order Number)", "JIRA_Custom field (Primary Brand)", "JIRA_Custom field (Week Number)", "CTRL_Nome tarefa", "CTRL_Código tarefa", "CTRL_Código GCMA", "CTRL_Código AWF", "CTRL_BU", "CTRL_Marca", "CTRL_Quantidade de peças", "CTRL_Sprint", "GCMA_DOC_JOB_NUMBER", "GCMA_DOCUMENT_NM", "GCMA_BUSINESS", "GCMA_BUSINESS_UNIT", "GCMA_THERAPEUTIC_AREA", "GCMA_BRAND", "GCMA_DOCUMENT_NUMBER_OF_PAGES", "GCMA_UNBRANDED_CONTENT_PLATFORM", "GCMA_DOCUMENT_BU", "Sprint_Number", "Business_Unit", CASE WHEN (CAST("JIRA_Custom field (Order Number)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Order Number)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Order Number)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Order Number)" IS NOT NULL AND ("JIRA_Custom field (Order Number)" != 'Insira o código AWF da peça.' OR "JIRA_Custom field (Order Number)" IS NULL AND 'Insira o código AWF da peça.' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND 'Insira o código AWF da peça.' IS NULL) AND ("JIRA_Custom field (Order Number)" != '-' OR "JIRA_Custom field (Order Number)" IS NULL AND '-' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND '-' IS NULL) AND ("JIRA_Custom field (Order Number)" != '' OR "JIRA_Custom field (Order Number)" IS NULL AND '' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND '' IS NULL) AND ("JIRA_Custom field (Order Number)" != 'N/A' OR "JIRA_Custom field (Order Number)" IS NULL AND 'N/A' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND 'N/A' IS NULL) THEN "JIRA_Custom field (Order Number)" WHEN (NOT ((CAST("JIRA_Custom field (Order Number)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Order Number)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Order Number)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Order Number)" IS NOT NULL AND ("JIRA_Custom field (Order Number)" != 'Insira o código AWF da peça.' OR "JIRA_Custom field (Order Number)" IS NULL AND 'Insira o código AWF da peça.' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND 'Insira o código AWF da peça.' IS NULL) AND ("JIRA_Custom field (Order Number)" != '-' OR "JIRA_Custom field (Order Number)" IS NULL AND '-' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND '-' IS NULL) AND ("JIRA_Custom field (Order Number)" != '' OR "JIRA_Custom field (Order Number)" IS NULL AND '' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND '' IS NULL) AND ("JIRA_Custom field (Order Number)" != 'N/A' OR "JIRA_Custom field (Order Number)" IS NULL AND 'N/A' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND 'N/A' IS NULL)) OR (((CAST("JIRA_Custom field (Order Number)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Order Number)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Order Number)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Order Number)" IS NOT NULL AND ("JIRA_Custom field (Order Number)" != 'Insira o código AWF da peça.' OR "JIRA_Custom field (Order Number)" IS NULL AND 'Insira o código AWF da peça.' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND 'Insira o código AWF da peça.' IS NULL) AND ("JIRA_Custom field (Order Number)" != '-' OR "JIRA_Custom field (Order Number)" IS NULL AND '-' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND '-' IS NULL) AND ("JIRA_Custom field (Order Number)" != '' OR "JIRA_Custom field (Order Number)" IS NULL AND '' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND '' IS NULL) AND ("JIRA_Custom field (Order Number)" != 'N/A' OR "JIRA_Custom field (Order Number)" IS NULL AND 'N/A' IS NOT NULL OR "JIRA_Custom field (Order Number)" IS NOT NULL AND 'N/A' IS NULL)) IS NULL)) AND (CAST("CTRL_Código AWF" AS VARCHAR) != '' OR CAST("CTRL_Código AWF" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("CTRL_Código AWF" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "CTRL_Código AWF" IS NOT NULL AND ("CTRL_Código AWF" != 'Insira o código AWF da peça.' OR "CTRL_Código AWF" IS NULL AND 'Insira o código AWF da peça.' IS NOT NULL OR "CTRL_Código AWF" IS NOT NULL AND 'Insira o código AWF da peça.' IS NULL) AND ("CTRL_Código AWF" != '-' OR "CTRL_Código AWF" IS NULL AND '-' IS NOT NULL OR "CTRL_Código AWF" IS NOT NULL AND '-' IS NULL) AND ("CTRL_Código AWF" != 'N/A' OR "CTRL_Código AWF" IS NULL AND 'N/A' IS NOT NULL OR "CTRL_Código AWF" IS NOT NULL AND 'N/A' IS NULL) AND ("CTRL_Código AWF" != '' OR "CTRL_Código AWF" IS NULL AND '' IS NOT NULL OR "CTRL_Código AWF" IS NOT NULL AND '' IS NULL) THEN "CTRL_Código AWF" END AS "AWF_Code" FROM ( SELECT "JIRA_Summary", "JIRA_JIRA_Sprint_info", "JIRA_Issue key", "JIRA_Custom field (Business Unit)", "JIRA_Custom field (Data Source)_2", "JIRA_Custom field (Execution Channel)", "JIRA_Jira_CodigoGCMA", "JIRA_Custom field (Location)", "JIRA_Custom field (Number of assets)", "JIRA_Custom field (Order Number)", "JIRA_Custom field (Primary Brand)", "JIRA_Custom field (Week Number)", "CTRL_Nome tarefa", "CTRL_Código tarefa", "CTRL_Código GCMA", "CTRL_Código AWF", "CTRL_BU", "CTRL_Marca", "CTRL_Quantidade de peças", "CTRL_Sprint", "GCMA_DOC_JOB_NUMBER", "GCMA_DOCUMENT_NM", "GCMA_BUSINESS", "GCMA_BUSINESS_UNIT", "GCMA_THERAPEUTIC_AREA", "GCMA_BRAND", "GCMA_DOCUMENT_NUMBER_OF_PAGES", "GCMA_UNBRANDED_CONTENT_PLATFORM", "GCMA_DOCUMENT_BU", "Sprint_Number", CASE WHEN (CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL THEN "JIRA_Custom field (Business Unit)" WHEN (NOT ((CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL) OR (((CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL) IS NULL)) AND (CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) != '' OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BUSINESS_UNIT" IS NOT NULL THEN "GCMA_BUSINESS_UNIT" WHEN (NOT ((CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL OR (CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) != '' OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BUSINESS_UNIT" IS NOT NULL) OR (((CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL OR (CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) != '' OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BUSINESS_UNIT" IS NOT NULL) IS NULL)) AND (CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) != '' OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_THERAPEUTIC_AREA" IS NOT NULL THEN "GCMA_THERAPEUTIC_AREA" WHEN (NOT ((CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL OR (CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) != '' OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BUSINESS_UNIT" IS NOT NULL OR (CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) != '' OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_THERAPEUTIC_AREA" IS NOT NULL) OR (((CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL OR (CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) != '' OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BUSINESS_UNIT" IS NOT NULL OR (CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) != '' OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_THERAPEUTIC_AREA" IS NOT NULL) IS NULL)) AND (CAST("GCMA_DOCUMENT_BU" AS VARCHAR) != '' OR CAST("GCMA_DOCUMENT_BU" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_DOCUMENT_BU" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_DOCUMENT_BU" IS NOT NULL THEN "GCMA_DOCUMENT_BU" WHEN (NOT ((CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL OR (CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) != '' OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BUSINESS_UNIT" IS NOT NULL OR (CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) != '' OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_THERAPEUTIC_AREA" IS NOT NULL OR (CAST("GCMA_DOCUMENT_BU" AS VARCHAR) != '' OR CAST("GCMA_DOCUMENT_BU" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_DOCUMENT_BU" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_DOCUMENT_BU" IS NOT NULL) OR (((CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Business Unit)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Business Unit)" IS NOT NULL OR (CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) != '' OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_BUSINESS_UNIT" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_BUSINESS_UNIT" IS NOT NULL OR (CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) != '' OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_THERAPEUTIC_AREA" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_THERAPEUTIC_AREA" IS NOT NULL OR (CAST("GCMA_DOCUMENT_BU" AS VARCHAR) != '' OR CAST("GCMA_DOCUMENT_BU" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("GCMA_DOCUMENT_BU" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "GCMA_DOCUMENT_BU" IS NOT NULL) IS NULL)) AND (CAST("CTRL_BU" AS VARCHAR) != '' OR CAST("CTRL_BU" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("CTRL_BU" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "CTRL_BU" IS NOT NULL THEN "CTRL_BU" END AS "Business_Unit" FROM ( SELECT "JIRA_Summary", "JIRA_JIRA_Sprint_info", "JIRA_Issue key", "JIRA_Custom field (Business Unit)", "JIRA_Custom field (Data Source)_2", "JIRA_Custom field (Execution Channel)", "JIRA_Jira_CodigoGCMA", "JIRA_Custom field (Location)", "JIRA_Custom field (Number of assets)", "JIRA_Custom field (Order Number)", "JIRA_Custom field (Primary Brand)", "JIRA_Custom field (Week Number)", "CTRL_Nome tarefa", "CTRL_Código tarefa", "CTRL_Código GCMA", "CTRL_Código AWF", "CTRL_BU", "CTRL_Marca", "CTRL_Quantidade de peças", "CTRL_Sprint", "GCMA_DOC_JOB_NUMBER", "GCMA_DOCUMENT_NM", "GCMA_BUSINESS", "GCMA_BUSINESS_UNIT", "GCMA_THERAPEUTIC_AREA", "GCMA_BRAND", "GCMA_DOCUMENT_NUMBER_OF_PAGES", "GCMA_UNBRANDED_CONTENT_PLATFORM", "GCMA_DOCUMENT_BU", CASE WHEN (CAST("JIRA_Custom field (Week Number)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Week Number)" IS NOT NULL AND ("JIRA_Custom field (Week Number)" != '0' OR "JIRA_Custom field (Week Number)" IS NULL AND '0' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0' IS NULL) AND ("JIRA_Custom field (Week Number)" != '' OR "JIRA_Custom field (Week Number)" IS NULL AND '' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '' IS NULL) AND ("JIRA_Custom field (Week Number)" != '0.00000' OR "JIRA_Custom field (Week Number)" IS NULL AND '0.00000' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0.00000' IS NULL) THEN "JIRA_Custom field (Week Number)" WHEN (NOT ((CAST("JIRA_Custom field (Week Number)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Week Number)" IS NOT NULL AND ("JIRA_Custom field (Week Number)" != '0' OR "JIRA_Custom field (Week Number)" IS NULL AND '0' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0' IS NULL) AND ("JIRA_Custom field (Week Number)" != '' OR "JIRA_Custom field (Week Number)" IS NULL AND '' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '' IS NULL) AND ("JIRA_Custom field (Week Number)" != '0.00000' OR "JIRA_Custom field (Week Number)" IS NULL AND '0.00000' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0.00000' IS NULL)) OR (((CAST("JIRA_Custom field (Week Number)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Week Number)" IS NOT NULL AND ("JIRA_Custom field (Week Number)" != '0' OR "JIRA_Custom field (Week Number)" IS NULL AND '0' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0' IS NULL) AND ("JIRA_Custom field (Week Number)" != '' OR "JIRA_Custom field (Week Number)" IS NULL AND '' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '' IS NULL) AND ("JIRA_Custom field (Week Number)" != '0.00000' OR "JIRA_Custom field (Week Number)" IS NULL AND '0.00000' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0.00000' IS NULL)) IS NULL)) AND (CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) != '' OR CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_JIRA_Sprint_info" IS NOT NULL AND ("JIRA_JIRA_Sprint_info" != '0' OR "JIRA_JIRA_Sprint_info" IS NULL AND '0' IS NOT NULL OR "JIRA_JIRA_Sprint_info" IS NOT NULL AND '0' IS NULL) AND ("JIRA_JIRA_Sprint_info" != '' OR "JIRA_JIRA_Sprint_info" IS NULL AND '' IS NOT NULL OR "JIRA_JIRA_Sprint_info" IS NOT NULL AND '' IS NULL) THEN "JIRA_JIRA_Sprint_info" WHEN (NOT ((CAST("JIRA_Custom field (Week Number)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Week Number)" IS NOT NULL AND ("JIRA_Custom field (Week Number)" != '0' OR "JIRA_Custom field (Week Number)" IS NULL AND '0' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0' IS NULL) AND ("JIRA_Custom field (Week Number)" != '' OR "JIRA_Custom field (Week Number)" IS NULL AND '' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '' IS NULL) AND ("JIRA_Custom field (Week Number)" != '0.00000' OR "JIRA_Custom field (Week Number)" IS NULL AND '0.00000' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0.00000' IS NULL) OR (CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) != '' OR CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_JIRA_Sprint_info" IS NOT NULL AND ("JIRA_JIRA_Sprint_info" != '0' OR "JIRA_JIRA_Sprint_info" IS NULL AND '0' IS NOT NULL OR "JIRA_JIRA_Sprint_info" IS NOT NULL AND '0' IS NULL) AND ("JIRA_JIRA_Sprint_info" != '' OR "JIRA_JIRA_Sprint_info" IS NULL AND '' IS NOT NULL OR "JIRA_JIRA_Sprint_info" IS NOT NULL AND '' IS NULL)) OR (((CAST("JIRA_Custom field (Week Number)" AS VARCHAR) != '' OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_Custom field (Week Number)" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_Custom field (Week Number)" IS NOT NULL AND ("JIRA_Custom field (Week Number)" != '0' OR "JIRA_Custom field (Week Number)" IS NULL AND '0' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0' IS NULL) AND ("JIRA_Custom field (Week Number)" != '' OR "JIRA_Custom field (Week Number)" IS NULL AND '' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '' IS NULL) AND ("JIRA_Custom field (Week Number)" != '0.00000' OR "JIRA_Custom field (Week Number)" IS NULL AND '0.00000' IS NOT NULL OR "JIRA_Custom field (Week Number)" IS NOT NULL AND '0.00000' IS NULL) OR (CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) != '' OR CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("JIRA_JIRA_Sprint_info" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "JIRA_JIRA_Sprint_info" IS NOT NULL AND ("JIRA_JIRA_Sprint_info" != '0' OR "JIRA_JIRA_Sprint_info" IS NULL AND '0' IS NOT NULL OR "JIRA_JIRA_Sprint_info" IS NOT NULL AND '0' IS NULL) AND ("JIRA_JIRA_Sprint_info" != '' OR "JIRA_JIRA_Sprint_info" IS NULL AND '' IS NOT NULL OR "JIRA_JIRA_Sprint_info" IS NOT NULL AND '' IS NULL)) IS NULL)) AND (CAST("CTRL_Sprint" AS VARCHAR) != '' OR CAST("CTRL_Sprint" AS VARCHAR) IS NULL AND '' IS NOT NULL OR CAST("CTRL_Sprint" AS VARCHAR) IS NOT NULL AND '' IS NULL) AND "CTRL_Sprint" IS NOT NULL AND ("CTRL_Sprint" != '0' OR "CTRL_Sprint" IS NULL AND '0' IS NOT NULL OR "CTRL_Sprint" IS NOT NULL AND '0' IS NULL) AND ("CTRL_Sprint" != '' OR "CTRL_Sprint" IS NULL AND '' IS NOT NULL OR "CTRL_Sprint" IS NOT NULL AND '' IS NULL) THEN "CTRL_Sprint" END AS "Sprint_Number" FROM ( SELECT "JIRA_Summary", "JIRA_JIRA_Sprint_info", "JIRA_Issue key", "JIRA_Custom field (Business Unit)", "JIRA_Custom field (Data Source)_2", "JIRA_Custom field (Execution Channel)", "JIRA_Jira_CodigoGCMA", "JIRA_Custom field (Location)", "JIRA_Custom field (Number of assets)", "JIRA_Custom field (Order Number)", "JIRA_Custom field (Primary Brand)", REPLACE("JIRA_Custom field (Week Number)", '', NULL) AS "JIRA_Custom field (Week Number)", "CTRL_Nome tarefa", "CTRL_Código tarefa", "CTRL_Código GCMA", "CTRL_Código AWF", "CTRL_BU", "CTRL_Marca", "CTRL_Quantidade de peças", "CTRL_Sprint", "GCMA_DOC_JOB_NUMBER", "GCMA_DOCUMENT_NM", "GCMA_BUSINESS", "GCMA_BUSINESS_UNIT", "GCMA_THERAPEUTIC_AREA", "GCMA_BRAND", "GCMA_DOCUMENT_NUMBER_OF_PAGES", "GCMA_UNBRANDED_CONTENT_PLATFORM", "GCMA_DOCUMENT_BU" FROM "BRMATEUSSANDBOX"."BRMATEUSSANDBOX_ICD-JIRA_PREP_CRUZAMENTO_2_JOIN_OPERACAOCONSOLIDADANOJIRA_GCMA_JOIN" "__input_table" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" ) "__dku_before_xxx" [12:09:44] [DEBUG] [dku.resourceusage] - Reporting start of CRU:{"context":{"type":"JOB_ACTIVITY","authIdentifier":"olivem85","projectKey":"BRMATEUSSANDBOX","jobId":"Build_from_ICD_Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_2026-09-09T16-09-37.535","activityId":"compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP","activityType":"recipe","recipeType":"shaker","recipeName":"compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared"},"type":"SQL_QUERY","id":"NABFJ2I3DvdW8Crr","startTime":1788970184845,"sqlQuery":{"connectionUsageId":"ZuIjOA4XyA84z9pu","connection":"VAW_SF_COMMERCIAL_EMEA_DESIGN_RW","query":" \nINSERT INTO \"BRMATEUSSANDBOX\".\"BRMATEUSSANDBOX_ICD-JIRA_PREP_CRUZAMENTO_2_JOIN_OPERACAOCONSOLIDADANOJIRA_GCMA_JOIN_PREPARED\" \nSELECT \n \"JIRA_Summary\",\n \"JIRA_Issue key\",\n \"Custom field (GCMA\u0027s Code)\",\n \"Custom field (Order Number)\",\n CASE \n WHEN \"Custom field (Number of assets)\" IS NULL OR (CAST(\"Custom field (Number of assets)\" AS VARCHAR) \u003d \u0027\u0027) THEN NULL\n ELSE CAST(\"Custom field (Number of assets)\" AS BIGINT)\nEND AS \"Custom field (Number of assets)\",\n \"Custom field (Week Number)\",\n \"formula_result\",\n \"Custom field (Primary Brand)\",\n \"Custom field (Business Unit)\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_Issue key\",\n \"Custom field (GCMA\u0027s Code)\",\n \"Custom field (Order Number)\",\n \"Custom field (Business Unit)\",\n \"Custom field (Primary Brand)\",\n \"Custom field (Number of assets)\",\n \"Custom field (Week Number)\",\n CONCAT(IFNULL(TO_VARCHAR(ROUND(CAST(\"Custom field (Week Number)\" AS DOUBLE), 0)), \u0027\u0027), \u0027 \u0027) AS \"formula_result\"\n FROM (\n SELECT \n \"JIRA_Summary\" AS \"JIRA_Summary\",\n \"JIRA_Issue key\" AS \"JIRA_Issue key\",\n \"Custom field (GCMA\u0027s Code)\" AS \"Custom field (GCMA\u0027s Code)\",\n \"Custom field (Order Number)\" AS \"Custom field (Order Number)\",\n \"Custom field (Business Unit)\" AS \"Custom field (Business Unit)\",\n \"Custom field (Primary Brand)\" AS \"Custom field (Primary Brand)\",\n \"Custom field (Number of assets)\" AS \"Custom field (Number of assets)\",\n \"formula_result\" AS \"Custom field (Week Number)\"\n FROM (\n SELECT \n \"JIRA_Summary\" AS \"JIRA_Summary\",\n \"JIRA_Issue key\" AS \"JIRA_Issue key\",\n \"Custom field (GCMA\u0027s Code)\" AS \"Custom field (GCMA\u0027s Code)\",\n \"Custom field (Order Number)\" AS \"Custom field (Order Number)\",\n \"Custom field (Business Unit)\" AS \"Custom field (Business Unit)\",\n \"Custom field (Primary Brand)\" AS \"Custom field (Primary Brand)\",\n \"Custom field (Number of assets)\" AS \"Custom field (Number of assets)\",\n \"Custom field (Week Number)\" AS \"Custom field (Week Number)\",\n ROUND(CAST(\"Custom field (Week Number)\" AS DOUBLE), 0) AS \"formula_result\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\" AS \"Custom field (Week Number)\",\n \"Business_Unit\" AS \"Custom field (Business Unit)\",\n \"AWF_Code\" AS \"Custom field (Order Number)\",\n \"GCMA_Code\" AS \"Custom field (GCMA\u0027s Code)\",\n \"Primary_Brand\" AS \"Custom field (Primary Brand)\",\n \"Assets_Number\" AS \"Custom field (Number of assets)\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n \"Business_Unit\",\n \"AWF_Code\",\n \"GCMA_Code\",\n CASE \n WHEN \"Primary_Brand\" \u003d \u0027ABRYSVO--281\u0027 THEN \u0027ABRYSVO--281\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PAXLOVID--240\u0027 THEN \u0027PAXLOVID--240\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ZAVICEFTA--234\u0027 THEN \u0027ZAVICEFTA--234\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LORBRENA--226\u0027 THEN \u0027LORBRENA--226\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027XELJANZ\u0027 THEN \u0027XELJANZ--189\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027TALZENNA--243\u0027 THEN \u0027TALZENNA--243\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREV(E)NAR 20\u0027 THEN \u0027PREVENAR--145\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ABRYSVO\u0027 THEN \u0027ABRYSVO--281\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BRAFTOVI MEKTOVI\u0027 THEN \u0027BRAFTOVI MEKTOVI--294\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ACEL-IMONE--2\u0027 THEN \u0027ACEL-IMONE--2\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BRAFTOVI\u0027 THEN \u0027BRAFTOVI--246\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREV(E)NAR 20,ABRYSVO\u0027 THEN \u0027PREVENAR--145, ABRYSVO--2811\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027UNBRANDED\u0027 THEN \u0027Unbranded--233\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PADCEV\u0027 THEN \u0027PADCEV\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027COMIRNATY--235\u0027 THEN \u0027COMIRNATY--235\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027NGENLA--278\u0027 THEN \u0027NGENLA--278\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027HYMPAVZI\u0027 THEN \u0027HYMPAVZI-(Marstacimab)-295\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREV(E)NAR 20,COMIRNATY,ABRYSVO\u0027 THEN \u0027PREVENAR--145, COMIRNATY--235, ABRYSVO--2811\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027RIMEGEPANT--282\u0027 THEN \u0027RIMEGEPANT--282\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LORBRENA,TALZENNA,BRAFTOVI\u0027 THEN \u0027LORBRENA--226, TALZENA--243, BRAFTOVI--246\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BOSULIF,BESPONSA,MYLOTARG,ELREXFIO\u0027 THEN \u0027BOSULIF--244, BESPONSA--211\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027IBRANCE--202\u0027 THEN \u0027IBRANCE--202\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ELREXFIO\u0027 THEN \u0027ELREXFIO--291\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ZAVICEFTA\u0027 THEN \u0027ZAVICEFTA--234\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027VYNDAMAX\u0027 THEN \u0027VYNDAMAX--241\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027UNASYN--179\u0027 THEN \u0027UNASYN--179\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027VYNDAQEL\u0027 THEN \u0027VYNDAQEL--222\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PAXLOVID\u0027 THEN \u0027PAXLOVID--240\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LITFULO--279\u0027 THEN \u0027LITFULO--279\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ENBREL--44\u0027 THEN \u0027ENBREL--44\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027NGENLA\u0027 THEN \u0027NGENLA--278\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027VYNDAMAX--241\u0027 THEN \u0027VYNDAMAX--241\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ELIQUIS--43\u0027 THEN \u0027ELIQUIS--43\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BRAFTOVI--246\u0027 THEN \u0027BRAFTOVI--246\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027GENOTROPIN--85\u0027 THEN \u0027GENOTROPIN--85\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027XALKORI--223\u0027 THEN \u0027XALKORI--223\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027CIBINQO--242\u0027 THEN \u0027CIBINQO--242\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREV(E)NAR 20,COMIRNATY,PAXLOVID,ABRYSVO\u0027 THEN \u0027PREVENAR--145, COMIRNATY--235, PAXLOVID--240, ABRYSVO--2811\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027TORGENA--220\u0027 THEN \u0027TORGENA--220\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027VYNDAQEL--222\u0027 THEN \u0027VYNDAQEL--222\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LITFULO\u0027 THEN \u0027LITFULO--279\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027COMIRNATY\u0027 THEN \u0027COMIRNATY--235\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ATGAM\u0027 THEN \u0027ATGAM\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BESPONSA--211\u0027 THEN \u0027BESPONSA--211\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027IBRANCE,LORBRENA,BRAFTOVI,MEKTOVI\u0027 THEN \u0027IBRANCE--202\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027XELJANZ--189\u0027 THEN \u0027XELJANZ--189\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027GENRYZON--290\u0027 THEN \u0027GENRYZON--290\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREVENAR--145\u0027 THEN \u0027PREVENAR--145\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027CIBINQO\u0027 THEN \u0027CIBINQO--242\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027HYMPAVZI-(Marstacimab)-295\u0027 THEN \u0027HYMPAVZI-(Marstacimab)-295\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ELREXFIO--291\u0027 THEN \u0027ELREXFIO--291\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LORBRENA\u0027 THEN \u0027LORBRENA--226\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027Unbranded--233\u0027 THEN \u0027Unbranded--233\u0027\n ELSE \"Primary_Brand\"\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END AS \"Primary_Brand\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND (\"JIRA_Custom field (Number of assets)\" !\u003d 0 OR \"JIRA_Custom field (Number of assets)\" IS NULL AND 0 IS NOT NULL OR \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND 0 IS NULL) THEN \"JIRA_Custom field (Number of assets)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND (\"JIRA_Custom field (Number of assets)\" !\u003d 0 OR \"JIRA_Custom field (Number of assets)\" IS NULL AND 0 IS NOT NULL OR \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND 0 IS NULL)) OR (((CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND (\"JIRA_Custom field (Number of assets)\" !\u003d 0 OR \"JIRA_Custom field (Number of assets)\" IS NULL AND 0 IS NOT NULL OR \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND 0 IS NULL)) IS NULL)) AND (CAST(\"CTRL_Quantidade de peças\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Quantidade de peças\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Quantidade de peças\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Quantidade de peças\" IS NOT NULL AND (\"CTRL_Quantidade de peças\" !\u003d \u00270\u0027 OR \"CTRL_Quantidade de peças\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"CTRL_Quantidade de peças\" IS NOT NULL AND \u00270\u0027 IS NULL) THEN \"CTRL_Quantidade de peças\"\n END AS \"Assets_Number\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n \"Business_Unit\",\n \"AWF_Code\",\n \"GCMA_Code\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL THEN \"JIRA_Custom field (Primary Brand)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL) IS NULL)) AND (CAST(\"GCMA_BRAND\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BRAND\" IS NOT NULL THEN \"GCMA_BRAND\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL OR (CAST(\"GCMA_BRAND\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BRAND\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL OR (CAST(\"GCMA_BRAND\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BRAND\" IS NOT NULL) IS NULL)) AND (CAST(\"CTRL_Marca\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Marca\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Marca\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Marca\" IS NOT NULL THEN \"CTRL_Marca\"\n END AS \"Primary_Brand\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n \"Business_Unit\",\n \"AWF_Code\",\n CASE \n WHEN (CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027Inserir código GCMA da peça criada\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A JIRA\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u00270\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027GCMA INEXISTENTE\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027GCMA INEXISTENTE\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027GCMA INEXISTENTE\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A CTRL\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NULL) THEN \"JIRA_Jira_CodigoGCMA\"\n WHEN (NOT ((CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027Inserir código GCMA da peça criada\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A JIRA\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u00270\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027GCMA INEXISTENTE\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027GCMA INEXISTENTE\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027GCMA INEXISTENTE\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A CTRL\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NULL)) OR (((CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027Inserir código GCMA da peça criada\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A JIRA\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u00270\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027GCMA INEXISTENTE\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027GCMA INEXISTENTE\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027GCMA INEXISTENTE\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A CTRL\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NULL)) IS NULL)) AND (CAST(\"CTRL_Código GCMA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Código GCMA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Código GCMA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Código GCMA\" IS NOT NULL AND (\"CTRL_Código GCMA\" !\u003d \u0027Inserir código GCMA da peça criada\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u0027\u003cN/A JIRA\u003e\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u00270\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u0027GCMA INEXISTENTE\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027GCMA INEXISTENTE\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027GCMA INEXISTENTE\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u0027\u003cN/A CTRL\u003e\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NULL) THEN \"CTRL_Código GCMA\"\n END AS \"GCMA_Code\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n \"Business_Unit\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Order Number)\" IS NOT NULL AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027Insira o código AWF da peça.\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027Insira o código AWF da peça.\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027Insira o código AWF da peça.\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027-\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027-\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027-\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027N/A\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027N/A\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027N/A\u0027 IS NULL) THEN \"JIRA_Custom field (Order Number)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Order Number)\" IS NOT NULL AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027Insira o código AWF da peça.\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027Insira o código AWF da peça.\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027Insira o código AWF da peça.\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027-\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027-\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027-\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027N/A\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027N/A\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027N/A\u0027 IS NULL)) OR (((CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Order Number)\" IS NOT NULL AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027Insira o código AWF da peça.\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027Insira o código AWF da peça.\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027Insira o código AWF da peça.\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027-\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027-\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027-\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027N/A\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027N/A\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027N/A\u0027 IS NULL)) IS NULL)) AND (CAST(\"CTRL_Código AWF\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Código AWF\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Código AWF\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Código AWF\" IS NOT NULL AND (\"CTRL_Código AWF\" !\u003d \u0027Insira o código AWF da peça.\u0027 OR \"CTRL_Código AWF\" IS NULL AND \u0027Insira o código AWF da peça.\u0027 IS NOT NULL OR \"CTRL_Código AWF\" IS NOT NULL AND \u0027Insira o código AWF da peça.\u0027 IS NULL) AND (\"CTRL_Código AWF\" !\u003d \u0027-\u0027 OR \"CTRL_Código AWF\" IS NULL AND \u0027-\u0027 IS NOT NULL OR \"CTRL_Código AWF\" IS NOT NULL AND \u0027-\u0027 IS NULL) AND (\"CTRL_Código AWF\" !\u003d \u0027N/A\u0027 OR \"CTRL_Código AWF\" IS NULL AND \u0027N/A\u0027 IS NOT NULL OR \"CTRL_Código AWF\" IS NOT NULL AND \u0027N/A\u0027 IS NULL) AND (\"CTRL_Código AWF\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"CTRL_Código AWF\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"CTRL_Código AWF\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) THEN \"CTRL_Código AWF\"\n END AS \"AWF_Code\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL THEN \"JIRA_Custom field (Business Unit)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL) IS NULL)) AND (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL THEN \"GCMA_BUSINESS_UNIT\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL) IS NULL)) AND (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL THEN \"GCMA_THERAPEUTIC_AREA\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL OR (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL OR (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL) IS NULL)) AND (CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_DOCUMENT_BU\" IS NOT NULL THEN \"GCMA_DOCUMENT_BU\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL OR (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL OR (CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_DOCUMENT_BU\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL OR (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL OR (CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_DOCUMENT_BU\" IS NOT NULL) IS NULL)) AND (CAST(\"CTRL_BU\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_BU\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_BU\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_BU\" IS NOT NULL THEN \"CTRL_BU\"\n END AS \"Business_Unit\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL) THEN \"JIRA_Custom field (Week Number)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL)) OR (((CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL)) IS NULL)) AND (CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u00270\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) THEN \"JIRA_JIRA_Sprint_info\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL) OR (CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u00270\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL)) OR (((CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL) OR (CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u00270\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL)) IS NULL)) AND (CAST(\"CTRL_Sprint\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Sprint\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Sprint\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Sprint\" IS NOT NULL AND (\"CTRL_Sprint\" !\u003d \u00270\u0027 OR \"CTRL_Sprint\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"CTRL_Sprint\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"CTRL_Sprint\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"CTRL_Sprint\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"CTRL_Sprint\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) THEN \"CTRL_Sprint\"\n END AS \"Sprint_Number\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n REPLACE(\"JIRA_Custom field (Week Number)\", \u0027\u003cN/A\u003e\u0027, NULL) AS \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\"\n FROM \"BRMATEUSSANDBOX\".\"BRMATEUSSANDBOX_ICD-JIRA_PREP_CRUZAMENTO_2_JOIN_OPERACAOCONSOLIDADANOJIRA_GCMA_JOIN\" \"__input_table\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\""}} [12:09:46] [INFO] [dku.flow.sql] - Statement done [12:09:46] [DEBUG] [dku.resourceusage] - Reporting completion of CRU:{"context":{"type":"JOB_ACTIVITY","authIdentifier":"olivem85","projectKey":"BRMATEUSSANDBOX","jobId":"Build_from_ICD_Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_2026-09-09T16-09-37.535","activityId":"compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP","activityType":"recipe","recipeType":"shaker","recipeName":"compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared"},"type":"SQL_QUERY","id":"NABFJ2I3DvdW8Crr","startTime":1788970184845,"sqlQuery":{"connectionUsageId":"ZuIjOA4XyA84z9pu","connection":"VAW_SF_COMMERCIAL_EMEA_DESIGN_RW","query":" \nINSERT INTO \"BRMATEUSSANDBOX\".\"BRMATEUSSANDBOX_ICD-JIRA_PREP_CRUZAMENTO_2_JOIN_OPERACAOCONSOLIDADANOJIRA_GCMA_JOIN_PREPARED\" \nSELECT \n \"JIRA_Summary\",\n \"JIRA_Issue key\",\n \"Custom field (GCMA\u0027s Code)\",\n \"Custom field (Order Number)\",\n CASE \n WHEN \"Custom field (Number of assets)\" IS NULL OR (CAST(\"Custom field (Number of assets)\" AS VARCHAR) \u003d \u0027\u0027) THEN NULL\n ELSE CAST(\"Custom field (Number of assets)\" AS BIGINT)\nEND AS \"Custom field (Number of assets)\",\n \"Custom field (Week Number)\",\n \"formula_result\",\n \"Custom field (Primary Brand)\",\n \"Custom field (Business Unit)\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_Issue key\",\n \"Custom field (GCMA\u0027s Code)\",\n \"Custom field (Order Number)\",\n \"Custom field (Business Unit)\",\n \"Custom field (Primary Brand)\",\n \"Custom field (Number of assets)\",\n \"Custom field (Week Number)\",\n CONCAT(IFNULL(TO_VARCHAR(ROUND(CAST(\"Custom field (Week Number)\" AS DOUBLE), 0)), \u0027\u0027), \u0027 \u0027) AS \"formula_result\"\n FROM (\n SELECT \n \"JIRA_Summary\" AS \"JIRA_Summary\",\n \"JIRA_Issue key\" AS \"JIRA_Issue key\",\n \"Custom field (GCMA\u0027s Code)\" AS \"Custom field (GCMA\u0027s Code)\",\n \"Custom field (Order Number)\" AS \"Custom field (Order Number)\",\n \"Custom field (Business Unit)\" AS \"Custom field (Business Unit)\",\n \"Custom field (Primary Brand)\" AS \"Custom field (Primary Brand)\",\n \"Custom field (Number of assets)\" AS \"Custom field (Number of assets)\",\n \"formula_result\" AS \"Custom field (Week Number)\"\n FROM (\n SELECT \n \"JIRA_Summary\" AS \"JIRA_Summary\",\n \"JIRA_Issue key\" AS \"JIRA_Issue key\",\n \"Custom field (GCMA\u0027s Code)\" AS \"Custom field (GCMA\u0027s Code)\",\n \"Custom field (Order Number)\" AS \"Custom field (Order Number)\",\n \"Custom field (Business Unit)\" AS \"Custom field (Business Unit)\",\n \"Custom field (Primary Brand)\" AS \"Custom field (Primary Brand)\",\n \"Custom field (Number of assets)\" AS \"Custom field (Number of assets)\",\n \"Custom field (Week Number)\" AS \"Custom field (Week Number)\",\n ROUND(CAST(\"Custom field (Week Number)\" AS DOUBLE), 0) AS \"formula_result\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\" AS \"Custom field (Week Number)\",\n \"Business_Unit\" AS \"Custom field (Business Unit)\",\n \"AWF_Code\" AS \"Custom field (Order Number)\",\n \"GCMA_Code\" AS \"Custom field (GCMA\u0027s Code)\",\n \"Primary_Brand\" AS \"Custom field (Primary Brand)\",\n \"Assets_Number\" AS \"Custom field (Number of assets)\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n \"Business_Unit\",\n \"AWF_Code\",\n \"GCMA_Code\",\n CASE \n WHEN \"Primary_Brand\" \u003d \u0027ABRYSVO--281\u0027 THEN \u0027ABRYSVO--281\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PAXLOVID--240\u0027 THEN \u0027PAXLOVID--240\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ZAVICEFTA--234\u0027 THEN \u0027ZAVICEFTA--234\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LORBRENA--226\u0027 THEN \u0027LORBRENA--226\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027XELJANZ\u0027 THEN \u0027XELJANZ--189\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027TALZENNA--243\u0027 THEN \u0027TALZENNA--243\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREV(E)NAR 20\u0027 THEN \u0027PREVENAR--145\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ABRYSVO\u0027 THEN \u0027ABRYSVO--281\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BRAFTOVI MEKTOVI\u0027 THEN \u0027BRAFTOVI MEKTOVI--294\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ACEL-IMONE--2\u0027 THEN \u0027ACEL-IMONE--2\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BRAFTOVI\u0027 THEN \u0027BRAFTOVI--246\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREV(E)NAR 20,ABRYSVO\u0027 THEN \u0027PREVENAR--145, ABRYSVO--2811\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027UNBRANDED\u0027 THEN \u0027Unbranded--233\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PADCEV\u0027 THEN \u0027PADCEV\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027COMIRNATY--235\u0027 THEN \u0027COMIRNATY--235\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027NGENLA--278\u0027 THEN \u0027NGENLA--278\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027HYMPAVZI\u0027 THEN \u0027HYMPAVZI-(Marstacimab)-295\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREV(E)NAR 20,COMIRNATY,ABRYSVO\u0027 THEN \u0027PREVENAR--145, COMIRNATY--235, ABRYSVO--2811\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027RIMEGEPANT--282\u0027 THEN \u0027RIMEGEPANT--282\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LORBRENA,TALZENNA,BRAFTOVI\u0027 THEN \u0027LORBRENA--226, TALZENA--243, BRAFTOVI--246\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BOSULIF,BESPONSA,MYLOTARG,ELREXFIO\u0027 THEN \u0027BOSULIF--244, BESPONSA--211\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027IBRANCE--202\u0027 THEN \u0027IBRANCE--202\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ELREXFIO\u0027 THEN \u0027ELREXFIO--291\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ZAVICEFTA\u0027 THEN \u0027ZAVICEFTA--234\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027VYNDAMAX\u0027 THEN \u0027VYNDAMAX--241\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027UNASYN--179\u0027 THEN \u0027UNASYN--179\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027VYNDAQEL\u0027 THEN \u0027VYNDAQEL--222\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PAXLOVID\u0027 THEN \u0027PAXLOVID--240\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LITFULO--279\u0027 THEN \u0027LITFULO--279\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ENBREL--44\u0027 THEN \u0027ENBREL--44\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027NGENLA\u0027 THEN \u0027NGENLA--278\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027VYNDAMAX--241\u0027 THEN \u0027VYNDAMAX--241\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ELIQUIS--43\u0027 THEN \u0027ELIQUIS--43\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BRAFTOVI--246\u0027 THEN \u0027BRAFTOVI--246\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027GENOTROPIN--85\u0027 THEN \u0027GENOTROPIN--85\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027XALKORI--223\u0027 THEN \u0027XALKORI--223\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027CIBINQO--242\u0027 THEN \u0027CIBINQO--242\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREV(E)NAR 20,COMIRNATY,PAXLOVID,ABRYSVO\u0027 THEN \u0027PREVENAR--145, COMIRNATY--235, PAXLOVID--240, ABRYSVO--2811\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027TORGENA--220\u0027 THEN \u0027TORGENA--220\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027VYNDAQEL--222\u0027 THEN \u0027VYNDAQEL--222\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LITFULO\u0027 THEN \u0027LITFULO--279\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027COMIRNATY\u0027 THEN \u0027COMIRNATY--235\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ATGAM\u0027 THEN \u0027ATGAM\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027BESPONSA--211\u0027 THEN \u0027BESPONSA--211\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027IBRANCE,LORBRENA,BRAFTOVI,MEKTOVI\u0027 THEN \u0027IBRANCE--202\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027XELJANZ--189\u0027 THEN \u0027XELJANZ--189\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027GENRYZON--290\u0027 THEN \u0027GENRYZON--290\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027PREVENAR--145\u0027 THEN \u0027PREVENAR--145\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027CIBINQO\u0027 THEN \u0027CIBINQO--242\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027HYMPAVZI-(Marstacimab)-295\u0027 THEN \u0027HYMPAVZI-(Marstacimab)-295\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027ELREXFIO--291\u0027 THEN \u0027ELREXFIO--291\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027LORBRENA\u0027 THEN \u0027LORBRENA--226\u0027\n ELSE CASE \n WHEN \"Primary_Brand\" \u003d \u0027Unbranded--233\u0027 THEN \u0027Unbranded--233\u0027\n ELSE \"Primary_Brand\"\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END\n END AS \"Primary_Brand\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND (\"JIRA_Custom field (Number of assets)\" !\u003d 0 OR \"JIRA_Custom field (Number of assets)\" IS NULL AND 0 IS NOT NULL OR \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND 0 IS NULL) THEN \"JIRA_Custom field (Number of assets)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND (\"JIRA_Custom field (Number of assets)\" !\u003d 0 OR \"JIRA_Custom field (Number of assets)\" IS NULL AND 0 IS NOT NULL OR \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND 0 IS NULL)) OR (((CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Number of assets)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND (\"JIRA_Custom field (Number of assets)\" !\u003d 0 OR \"JIRA_Custom field (Number of assets)\" IS NULL AND 0 IS NOT NULL OR \"JIRA_Custom field (Number of assets)\" IS NOT NULL AND 0 IS NULL)) IS NULL)) AND (CAST(\"CTRL_Quantidade de peças\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Quantidade de peças\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Quantidade de peças\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Quantidade de peças\" IS NOT NULL AND (\"CTRL_Quantidade de peças\" !\u003d \u00270\u0027 OR \"CTRL_Quantidade de peças\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"CTRL_Quantidade de peças\" IS NOT NULL AND \u00270\u0027 IS NULL) THEN \"CTRL_Quantidade de peças\"\n END AS \"Assets_Number\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n \"Business_Unit\",\n \"AWF_Code\",\n \"GCMA_Code\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL THEN \"JIRA_Custom field (Primary Brand)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL) IS NULL)) AND (CAST(\"GCMA_BRAND\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BRAND\" IS NOT NULL THEN \"GCMA_BRAND\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL OR (CAST(\"GCMA_BRAND\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BRAND\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Primary Brand)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Primary Brand)\" IS NOT NULL OR (CAST(\"GCMA_BRAND\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BRAND\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BRAND\" IS NOT NULL) IS NULL)) AND (CAST(\"CTRL_Marca\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Marca\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Marca\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Marca\" IS NOT NULL THEN \"CTRL_Marca\"\n END AS \"Primary_Brand\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n \"Business_Unit\",\n \"AWF_Code\",\n CASE \n WHEN (CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027Inserir código GCMA da peça criada\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A JIRA\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u00270\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027GCMA INEXISTENTE\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027GCMA INEXISTENTE\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027GCMA INEXISTENTE\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A CTRL\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NULL) THEN \"JIRA_Jira_CodigoGCMA\"\n WHEN (NOT ((CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027Inserir código GCMA da peça criada\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A JIRA\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u00270\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027GCMA INEXISTENTE\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027GCMA INEXISTENTE\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027GCMA INEXISTENTE\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A CTRL\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NULL)) OR (((CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Jira_CodigoGCMA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027Inserir código GCMA da peça criada\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A JIRA\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u00270\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027GCMA INEXISTENTE\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027GCMA INEXISTENTE\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027GCMA INEXISTENTE\u0027 IS NULL) AND (\"JIRA_Jira_CodigoGCMA\" !\u003d \u0027\u003cN/A CTRL\u003e\u0027 OR \"JIRA_Jira_CodigoGCMA\" IS NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NOT NULL OR \"JIRA_Jira_CodigoGCMA\" IS NOT NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NULL)) IS NULL)) AND (CAST(\"CTRL_Código GCMA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Código GCMA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Código GCMA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Código GCMA\" IS NOT NULL AND (\"CTRL_Código GCMA\" !\u003d \u0027Inserir código GCMA da peça criada\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027Inserir código GCMA da peça criada\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u0027\u003cN/A JIRA\u003e\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027\u003cN/A JIRA\u003e\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u00270\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u0027GCMA INEXISTENTE\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027GCMA INEXISTENTE\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027GCMA INEXISTENTE\u0027 IS NULL) AND (\"CTRL_Código GCMA\" !\u003d \u0027\u003cN/A CTRL\u003e\u0027 OR \"CTRL_Código GCMA\" IS NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NOT NULL OR \"CTRL_Código GCMA\" IS NOT NULL AND \u0027\u003cN/A CTRL\u003e\u0027 IS NULL) THEN \"CTRL_Código GCMA\"\n END AS \"GCMA_Code\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n \"Business_Unit\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Order Number)\" IS NOT NULL AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027Insira o código AWF da peça.\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027Insira o código AWF da peça.\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027Insira o código AWF da peça.\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027-\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027-\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027-\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027N/A\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027N/A\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027N/A\u0027 IS NULL) THEN \"JIRA_Custom field (Order Number)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Order Number)\" IS NOT NULL AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027Insira o código AWF da peça.\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027Insira o código AWF da peça.\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027Insira o código AWF da peça.\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027-\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027-\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027-\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027N/A\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027N/A\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027N/A\u0027 IS NULL)) OR (((CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Order Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Order Number)\" IS NOT NULL AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027Insira o código AWF da peça.\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027Insira o código AWF da peça.\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027Insira o código AWF da peça.\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027-\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027-\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027-\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Order Number)\" !\u003d \u0027N/A\u0027 OR \"JIRA_Custom field (Order Number)\" IS NULL AND \u0027N/A\u0027 IS NOT NULL OR \"JIRA_Custom field (Order Number)\" IS NOT NULL AND \u0027N/A\u0027 IS NULL)) IS NULL)) AND (CAST(\"CTRL_Código AWF\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Código AWF\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Código AWF\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Código AWF\" IS NOT NULL AND (\"CTRL_Código AWF\" !\u003d \u0027Insira o código AWF da peça.\u0027 OR \"CTRL_Código AWF\" IS NULL AND \u0027Insira o código AWF da peça.\u0027 IS NOT NULL OR \"CTRL_Código AWF\" IS NOT NULL AND \u0027Insira o código AWF da peça.\u0027 IS NULL) AND (\"CTRL_Código AWF\" !\u003d \u0027-\u0027 OR \"CTRL_Código AWF\" IS NULL AND \u0027-\u0027 IS NOT NULL OR \"CTRL_Código AWF\" IS NOT NULL AND \u0027-\u0027 IS NULL) AND (\"CTRL_Código AWF\" !\u003d \u0027N/A\u0027 OR \"CTRL_Código AWF\" IS NULL AND \u0027N/A\u0027 IS NOT NULL OR \"CTRL_Código AWF\" IS NOT NULL AND \u0027N/A\u0027 IS NULL) AND (\"CTRL_Código AWF\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"CTRL_Código AWF\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"CTRL_Código AWF\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) THEN \"CTRL_Código AWF\"\n END AS \"AWF_Code\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n \"Sprint_Number\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL THEN \"JIRA_Custom field (Business Unit)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL) IS NULL)) AND (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL THEN \"GCMA_BUSINESS_UNIT\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL) IS NULL)) AND (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL THEN \"GCMA_THERAPEUTIC_AREA\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL OR (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL OR (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL) IS NULL)) AND (CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_DOCUMENT_BU\" IS NOT NULL THEN \"GCMA_DOCUMENT_BU\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL OR (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL OR (CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_DOCUMENT_BU\" IS NOT NULL) OR (((CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Business Unit)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Business Unit)\" IS NOT NULL OR (CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_BUSINESS_UNIT\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_BUSINESS_UNIT\" IS NOT NULL OR (CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_THERAPEUTIC_AREA\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_THERAPEUTIC_AREA\" IS NOT NULL OR (CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"GCMA_DOCUMENT_BU\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"GCMA_DOCUMENT_BU\" IS NOT NULL) IS NULL)) AND (CAST(\"CTRL_BU\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_BU\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_BU\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_BU\" IS NOT NULL THEN \"CTRL_BU\"\n END AS \"Business_Unit\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\",\n CASE \n WHEN (CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL) THEN \"JIRA_Custom field (Week Number)\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL)) OR (((CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL)) IS NULL)) AND (CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u00270\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) THEN \"JIRA_JIRA_Sprint_info\"\n WHEN (NOT ((CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL) OR (CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u00270\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL)) OR (((CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_Custom field (Week Number)\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_Custom field (Week Number)\" IS NOT NULL AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) AND (\"JIRA_Custom field (Week Number)\" !\u003d \u00270.00000\u0027 OR \"JIRA_Custom field (Week Number)\" IS NULL AND \u00270.00000\u0027 IS NOT NULL OR \"JIRA_Custom field (Week Number)\" IS NOT NULL AND \u00270.00000\u0027 IS NULL) OR (CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"JIRA_JIRA_Sprint_info\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u00270\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"JIRA_JIRA_Sprint_info\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"JIRA_JIRA_Sprint_info\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"JIRA_JIRA_Sprint_info\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL)) IS NULL)) AND (CAST(\"CTRL_Sprint\" AS VARCHAR) !\u003d \u0027\u0027 OR CAST(\"CTRL_Sprint\" AS VARCHAR) IS NULL AND \u0027\u0027 IS NOT NULL OR CAST(\"CTRL_Sprint\" AS VARCHAR) IS NOT NULL AND \u0027\u0027 IS NULL) AND \"CTRL_Sprint\" IS NOT NULL AND (\"CTRL_Sprint\" !\u003d \u00270\u0027 OR \"CTRL_Sprint\" IS NULL AND \u00270\u0027 IS NOT NULL OR \"CTRL_Sprint\" IS NOT NULL AND \u00270\u0027 IS NULL) AND (\"CTRL_Sprint\" !\u003d \u0027\u003cN/A\u003e\u0027 OR \"CTRL_Sprint\" IS NULL AND \u0027\u003cN/A\u003e\u0027 IS NOT NULL OR \"CTRL_Sprint\" IS NOT NULL AND \u0027\u003cN/A\u003e\u0027 IS NULL) THEN \"CTRL_Sprint\"\n END AS \"Sprint_Number\"\n FROM (\n SELECT \n \"JIRA_Summary\",\n \"JIRA_JIRA_Sprint_info\",\n \"JIRA_Issue key\",\n \"JIRA_Custom field (Business Unit)\",\n \"JIRA_Custom field (Data Source)_2\",\n \"JIRA_Custom field (Execution Channel)\",\n \"JIRA_Jira_CodigoGCMA\",\n \"JIRA_Custom field (Location)\",\n \"JIRA_Custom field (Number of assets)\",\n \"JIRA_Custom field (Order Number)\",\n \"JIRA_Custom field (Primary Brand)\",\n REPLACE(\"JIRA_Custom field (Week Number)\", \u0027\u003cN/A\u003e\u0027, NULL) AS \"JIRA_Custom field (Week Number)\",\n \"CTRL_Nome tarefa\",\n \"CTRL_Código tarefa\",\n \"CTRL_Código GCMA\",\n \"CTRL_Código AWF\",\n \"CTRL_BU\",\n \"CTRL_Marca\",\n \"CTRL_Quantidade de peças\",\n \"CTRL_Sprint\",\n \"GCMA_DOC_JOB_NUMBER\",\n \"GCMA_DOCUMENT_NM\",\n \"GCMA_BUSINESS\",\n \"GCMA_BUSINESS_UNIT\",\n \"GCMA_THERAPEUTIC_AREA\",\n \"GCMA_BRAND\",\n \"GCMA_DOCUMENT_NUMBER_OF_PAGES\",\n \"GCMA_UNBRANDED_CONTENT_PLATFORM\",\n \"GCMA_DOCUMENT_BU\"\n FROM \"BRMATEUSSANDBOX\".\"BRMATEUSSANDBOX_ICD-JIRA_PREP_CRUZAMENTO_2_JOIN_OPERACAOCONSOLIDADANOJIRA_GCMA_JOIN\" \"__input_table\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\"\n ) \"__dku_before_xxx\""}} [12:09:46] [DEBUG] [dku.connections.sql.provider] - Commit conn=VAW_SF_COMMERCIAL_EMEA_DESIGN_RW-AdwfJYe [12:09:46] [DEBUG] [dku.connections.sql.provider] - Close conn=VAW_SF_COMMERCIAL_EMEA_DESIGN_RW-AdwfJYe [12:09:46] [DEBUG] [dku.resourceusage] - Reporting completion of CRU:{"context":{"type":"JOB_ACTIVITY","authIdentifier":"olivem85","projectKey":"BRMATEUSSANDBOX","jobId":"Build_from_ICD_Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_2026-09-09T16-09-37.535","activityId":"compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP","activityType":"recipe","recipeType":"shaker","recipeName":"compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared"},"type":"SQL_CONNECTION","id":"ZuIjOA4XyA84z9pu","startTime":1788970183053,"sqlConnection":{"connection":"VAW_SF_COMMERCIAL_EMEA_DESIGN_RW"}} [12:09:46] [INFO] [dku.flow.activity] - Run thread done for activity compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP [12:09:46] [INFO] [dku.flow.activity] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - activity is finished [12:09:46] [INFO] [dku.flow.activity] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Executing default post-activity lifecycle hook [12:09:46] [INFO] [dku.cluster.selector] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Using cached grant: cluster::USE::dss-emea-prod-eks-11 [12:09:46] [INFO] [dku.flow.activity] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Activity successful, computing metrics and running checks or Data Quality rules [12:09:47] [INFO] [dku.flow.activity] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Activity checks and Data Quality rules produced 0 value [12:09:47] [INFO] [dku.flow.activity] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Activity is successful, computing timestamps to propagate [12:09:47] [INFO] [dku.flow.activity] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Activity is successful, propagating 3 timestamps [12:09:47] [INFO] [dku.timestamps.sql] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Starting to propagate 3 hashes [12:09:47] [DEBUG] [dku.connections.sql.provider] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Commit conn=dssdb-ext-EZDLxo6 [12:09:47] [INFO] [dku.timestamps.sql] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Hashes propagated in 8 ms [12:09:47] [INFO] [dku.flow.activity] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Done post-activity tasks [12:09:47] [INFO] [dku.flow.activity] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - done handling times [12:09:47] [DEBUG] [dku.flow.jobrunner] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - runActivity terminated, success=true [12:09:47] [DEBUG] [dku.flow.jobrunner] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Signaling end of activity to backend [12:09:47] [DEBUG] [dku.flow.jobrunner] running compute_ICD-Jira_prep_Cruzamento_2_join_OperacaoConsolidadaNoJira_GCMA_join_prepared_NP - Done signaling end of activity to backend