You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT
MO.cod,
CL.pd_crm_promocao,
CL.pd_crm_compra,
CL.co_empresa AS comercial_empresa,
COALESCE(CL.co_admissao, '') AS aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
FROM SM_CD_MO_MOVIMENTADOR MO
JOIN SM_CD_MO_MOVIMENTADOR_CL CL ON CL.cod = MO.cod
LEFT JOIN ST_CD_CIDADES CD_IC ON CL.co_cidade = CD_IC.codigo
LEFT JOIN ST_CD_UF UF_IC ON CD_IC.uf = UF_IC.uf
LEFT JOIN ST_CD_PAIS PA_IC ON UF_IC.pais = PA_IC.cod
LEFT JOIN ST_CD_CIDADES CD_N ON CL.ip_naturalidade = CD_N.codigo
LEFT JOIN ST_CD_UF UF_N ON CD_N.uf = UF_N.uf
LEFT JOIN ST_CD_PAIS PA_N ON UF_N.pais = PA_N.cod
LEFT JOIN SM_CD_MO_MOVIMENTADOR_CL_F FI ON 1 = FI.empresa AND MO.cod = FI.cod
WHERE MO.cod = 3
====== Test Details ======
See test core_2350.fbt (no more troubles with this ticket issue, so it can be closed).
The text was updated successfully, but these errors were encountered:
summary: The Nicknames can not exceed 31 characters that returns the error ISC error 336 068 767 .. => Aliases can not exceed 31 characters that returns the error ISC error 336068767
Submitted by: Workdev Tecnologia da Informação LTDA (workdev)
Is related to CORE2350
Is duplicated by CORE5960
SELECT
MO.cod,
CL.pd_crm_promocao,
CL.pd_crm_compra,
CL.co_empresa AS comercial_empresa,
COALESCE(CL.co_admissao, '') AS aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
FROM SM_CD_MO_MOVIMENTADOR MO
JOIN SM_CD_MO_MOVIMENTADOR_CL CL ON CL.cod = MO.cod
LEFT JOIN ST_CD_CIDADES CD_IC ON CL.co_cidade = CD_IC.codigo
LEFT JOIN ST_CD_UF UF_IC ON CD_IC.uf = UF_IC.uf
LEFT JOIN ST_CD_PAIS PA_IC ON UF_IC.pais = PA_IC.cod
LEFT JOIN ST_CD_CIDADES CD_N ON CL.ip_naturalidade = CD_N.codigo
LEFT JOIN ST_CD_UF UF_N ON CD_N.uf = UF_N.uf
LEFT JOIN ST_CD_PAIS PA_N ON UF_N.pais = PA_N.cod
LEFT JOIN SM_CD_MO_MOVIMENTADOR_CL_F FI ON 1 = FI.empresa AND MO.cod = FI.cod
WHERE MO.cod = 3
====== Test Details ======
See test core_2350.fbt (no more troubles with this ticket issue, so it can be closed).
The text was updated successfully, but these errors were encountered: