18/10/2015 14:03:07  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_scv_c_viaticos <br><b>METODO:</b> SelectInfoViaticoPersona <br><b>ERROR->:</b><br>Invalid query: ERROR:  error de sintaxis en o cerca de «,»
LINE 6:            ,ua.desuniadm,uf.desubifis,
                   ^
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,					   
				       ,ua.desuniadm,uf.desubifis,
					   e_estsolvia.descequiv AS desc_estsolvia,p.cedper,p.codper, 
					   (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,
					   (CASE n.racnom WHEN '1' THEN ac.denasicar ELSE ca.descar END) AS cargo,
					   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 sv.fecsolvia BETWEEN '2015-10-17' AND '2015-10-18' 
				ORDER BY sv.codsolvia,sv.fecsolvia
		

18/10/2015 15:15:07  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_scv_c_viaticos <br><b>METODO:</b> SelectUbicaViatico <br><b>ERROR->:</b><br>Invalid query: ERROR:  no existe la columna uf.desuniadm
LINE 16:        uf.desuniadm,
                ^
Whole query:  
				   SELECT DATE_PART('month',sv.fecsolvia) as mes,
				   (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,
				   uf.desuniadm,
				   sum(monpervia) as subtot,count(*) as cantidad         
			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
			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_cargo ca ON pn.codemp = ca.codemp
						  AND pn.codnom = ca.codnom
						  AND pn.codcar = ca.codcar
			LEFT JOIN sno_ubicacionfisica uf ON pn.codemp = uf.codemp
							                AND pn.codubifis = uf.codubifis	
			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 sno_asignacioncargo ac ON pn.codemp = ac.codemp
							AND pn.codnom = ac.codnom
							AND pn.codasicar = ac.codasicar
			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 pn.minorguniadm||pn.ofiuniadm||pn.uniuniadm||pn.depuniadm||pn.prouniadm=''
			  AND sv.estsolvia!='A'
			GROUP BY 1,3,sv.fecsolvia
			ORDER BY 1,3

		

18/10/2015 16:56:43  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <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 75: ...olvia BETWEEN '2015-10-17' AND '2015-10-17'   AND ua.codunia...
                                                              ^
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 sv.fecsolvia BETWEEN '2015-10-17' AND '2015-10-17'   AND ua.coduniadm ='0000-00-00-00-27' 
				ORDER BY sv.codsolvia,sv.fecsolvia