my code stock.com

marcus.sacramento

ERRO_CONHECIDO_ARS_ASSOCIADO
by marcus.sacramento

Snippet options

Download: Download snippet as erro_conhecido_ars_associado.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

SELECT	 a.erro_conhecido_id, a.submetido_por, a.data_abertura AS data_abertura, a.designado_para, a.modificado_por,
				 a.data_modificacao AS data_modificacao, a.status AS status, a.createassettype, a.criado_por, a.origem_erro_conhecido, a.prioridade_falha,
				 a.agente_sol_abert, a.agente_de_solucao, a.subtipo_erro, a.data_alvo AS data_alvo, a.descricao_erro, a.rd_causa_raiz, a.numero_porque, a.servicos_impactados,
				 a.demanda_projeto, a.aux_ass_prob, a.tecnico_responsavel, a.det_status, a.desc_sol_definitiva, a.causa_raiz, a.sistema_afetado, a.tipo_erro, a.rd_causa_raiz_identificada,
				 ars.c1 as NUM_CHAMADO, ars.c7 AS status_chamado, ars.C536870990
	FROM	 aradmin.telem_erroconhecido a, aradmin.telem_joinerroconxchamados e, t90 ars
 WHERE	 a.erro_conhecido_id = e.num_pke_fk(+) AND e.nun_ars_fk = ars.c1(+);

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.