pessoal, o leonardo me ajudou demais nessa empreitada, segue abaixo as mudanças, no arquivo queries dentro de includes, fazer o select abaixo:
SELECT
o.numero as numero, o.problema as prob_cod, o.descricao as descricao, o.equipamento as etiqueta,
o.sistema as area_cod, o.contato as contato, o.telefone as telefone, o.local as setor_cod,
o.operador as operador_cod, o.data_abertura as data_abertura, o.data_fechamento as data_fechamento,
o.status as status_cod, o.data_atendimento as data_atendimento, o.instituicao as unidade_cod,
o.aberto_por as aberto_por_cod, o.oco_scheduled, o.oco_real_open_date, o.date_first_queued,
o.aberto_por as aberto_por_cod, o.usu_nota as usu_nota,o.ip as ip,assentamento,
o.oco_script_sol, o.oco_prior,
i.inst_nome as unidade,
p.problema as problema, p.prob_area as prob_area_cod, p.prob_sla as sla_solucao_cod,
a.sistema as area, a.sis_email as area_email, a.sis_atende as sis_atende,
l.local as setor, l.loc_reitoria as reitoria_cod, l.loc_prior as loc_prior_cod, l.loc_dominio as dominio_cod,
l.loc_predio as predio_cod,
pr.prior_nivel as prioridade_nivel, pr.prior_sla as sla_resposta_cod,
u.login as login,u.depto as depto, u.nome as nome, u.email as user_email, u.AREA as user_area, u.user_admin as user_admin,
ua.nome as aberto_por,
s.status as chamado_status, s.stat_cat as stat_cat_cod, s.stat_painel as stat_painel_cod,
stc.stc_desc as status_cat,
sls.slas_desc as sla_solucao, sls.slas_tempo as sla_solucao_tempo,
slr.slas_desc as sla_resposta, slr.slas_tempo as sla_resposta_tempo,
sol.script_desc, prioridade_atendimento.pr_nivel as pr_atendimento, prioridade_atendimento.pr_color as cor
FROM
ocorrencias as o left join sistemas as a on a.sis_id = o.sistema
left join localizacao as l on l.loc_id = o.local
left join instituicao as i on i.inst_cod = o.instituicao
left join usuarios as u on u.user_id = o.operador
left join usuarios as ua on ua.user_id = o.aberto_por
left join `status` as s on s.stat_id = o.status
left join status_categ as stc on stc.stc_cod = s.stat_cat
left join problemas as p on p.prob_id = o.problema
left join sla_solucao as sls on sls.slas_cod = p.prob_sla
left join prioridades as pr on pr.prior_cod = l.loc_prior
left join sla_solucao as slr on slr.slas_cod = pr.prior_sla
left join assentamentos as a on (o.numero=a.ocorrencia)
left join script_solution as sol on sol.script_cod = o.oco_script_sol
left join prior_atend as prioridade_atendimento on prioridade_atendimento.pr_cod = o.oco_prior
e comentar no arquivo relatorio_geral o seguinte texto:
if (strlen($query)>0) {$query_ini.=" WHERE o.numero = o.numero ".$query;}