20/05/2019 08:32:26  *****  ERROR DE SISTEMA:   *****  yjimenez  *****  <b>CLASE:</b> covensol_scv_c_viaticos <br><b>METODO:</b> SelectInfoViaticoPersona <br><b>ERROR->:</b><br>Invalid query: ERROR:  no existe la columna ua.coduniadm
LINE 76:     ORDER BY ua.coduniadm,p.nomper,sv.fecsolvia
                      ^
Whole query:  		
				SELECT dtp.codper,				       
					   
					   (CASE dtp.codnom WHEN NULL THEN  (ben.nombene||' '||ben.apebene)
									    WHEN '' THEN (ben.nombene||' '||ben.apebene) 
									    ELSE (p.nomper||' '||p.apeper) END) AS nomape,
					   
					   (CASE dtp.codnom WHEN NULL THEN ben.ced_bene
									    WHEN '' THEN ben.ced_bene
									    ELSE p.cedper END) AS cedper,
					   
					   (CASE dtp.codnom WHEN NULL THEN 'Foraneo (Benef.)'
									    WHEN '' THEN 'Foraneo (Benef.)'
									    ELSE (CASE n.racnom WHEN '1' THEN ac.denasicar ELSE ca.descar END) END) AS cargo,
					   									   					   				  
				       ua.desuniadm,uf.desubifis,
					   e_estsolvia.descequiv AS desc_estsolvia,
					   (CASE DATE_PART('month',sv.fecsolvia) WHEN '1' THEN 'enero' 
									  WHEN '2' THEN 'febrero'
									  WHEN '3' THEN 'marzo'
									  WHEN '4' THEN 'abril'
									  WHEN '5' THEN 'mayo'
									  WHEN '6' THEN 'junio'
									  WHEN '7' THEN 'julio'
									  WHEN '8' THEN 'agosto'
									  WHEN '9' THEN 'septiembre'
									  WHEN '10' THEN 'octubre'
									  WHEN '11' THEN 'noviembre'
									  WHEN '12' THEN 'diciembre'				      
									  ELSE 'numero de mes inválido' END) AS desmes,
					   (abs((sv.fecsalvia::date-sv.fecregvia::date)) + 1) as dias,
					   dtp.monpervia, pn.codnom,
					   'SCV-0'||lpad(sv.codsolvia,10,'0') AS codsolvia,
					   sv.fecsalvia,sv.fecregvia,sv.fecsolvia,
					   (SELECT DISTINCT ON(codrut) desrut
					  FROM scv_rutas rut
					 WHERE sv.codemp=rut.codemp
					   AND sv.codrut=rut.codrut
					 GROUP BY codrut,desrut) AS desrut,
					   mis.denmis
				FROM scv_dt_personal dtp
				INNER JOIN scv_solicitudviatico sv ON sv.codemp = dtp.codemp
									  AND sv.codsolvia = dtp.codsolvia
				LEFT JOIN sno_personalnomina pn ON pn.codemp = dtp.codemp
												AND pn.codper = lpad(dtp.codper,10,'0')
												AND pn.codnom = dtp.codnom
												AND pn.staper != '3'
				LEFT JOIN rpc_beneficiario ben ON dtp.codemp=ben.codemp
				                              AND dtp.codper=ben.ced_bene
				LEFT JOIN sno_personal p ON pn.codemp = p.codemp 
										 AND pn.codper = p.codper
				LEFT JOIN sno_nomina n ON n.codemp = pn.codemp
									   AND n.codnom = pn.codnom
							           AND n.espnom='0'
				LEFT JOIN sno_unidadadmin ua ON pn.codemp = ua.codemp
								  AND pn.minorguniadm = ua.minorguniadm
								  AND pn.ofiuniadm = ua.ofiuniadm
								  AND pn.uniuniadm = ua.uniuniadm
								  AND pn.depuniadm = ua.depuniadm
								  AND pn.prouniadm = ua.prouniadm
				LEFT JOIN scv_misiones mis ON mis.codemp = sv.codemp
								   AND mis.codmis = sv.codmis
				LEFT JOIN sno_cargo ca ON pn.codemp = ca.codemp
							  AND pn.codnom = ca.codnom
							  AND pn.codcar = ca.codcar
				LEFT JOIN sno_asignacioncargo ac ON pn.codemp = ac.codemp
								AND pn.codnom = ac.codnom
								AND pn.codasicar = ac.codasicar
				LEFT JOIN sno_ubicacionfisica uf ON pn.codemp = uf.codemp
								AND pn.codubifis = uf.codubifis
				LEFT JOIN covensol_sigesp_equiv e_estsolvia ON e_estsolvia.dominio='scv_solicitudviatico'
									   AND e_estsolvia.campo='estsolvia'
									   AND e_estsolvia.valor= sv.estsolvia::text
				WHERE dtp.codemp = '0001'
				  AND p.nomper ILIKE('%ALVIS %')   AND p.apeper ILIKE('%YEPEZ%')   AND p.cedper ILIKE('%12446620%')   AND pn.codubifis ='0001'   AND sv.fecsolvia BETWEEN '2019-04-01' AND '2019-05-17'   AND sv.codrut ='00164'   AND sv.codmis ='00001'   AND pn.codubifis ='0001'   AND pn.minorguniadm||'-'||pn.ofiuniadm||'-'||pn.uniuniadm||'-'||pn.depuniadm||'-'||pn.prouniadm ='0000-00-00-00-60'   AND sv.estsolvia ='P' 
				ORDER BY ua.coduniadm,p.nomper,sv.fecsolvia