22/06/2020 19:31:13  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_select_despachos ERROR->Invalid query: ERROR:  column reference "codtipdesp" is ambiguous
LINE 20: ...cdes >='2020-04-23' AND fecdes <='2020-04-23' AND codtipdesp...
                                                              ^
Whole query: SELECT siv_despacho.numorddes,siv_despacho.numsol,siv_despacho.coduniadm,siv_despacho.obsdes,
		                siv_despacho.fecdes,siv_despacho.modprocede,
						MAX(aero_ruta) AS aero_ruta,
						MAX(aero_nave) AS aero_nave,
						MAX(denequip) AS denequip,						
						MAX(aero_matricula) AS aero_matricula,
						MAX(aero_vuelo) AS aero_vuelo,
						MAX(opedes.dentipconope) AS dentipconope,
						MAX(opedes.codtipconope) AS codtipconope,
						MAX(tdesp.dentipdesp) AS dentipdesp, 
						MAX (CASE WHEN siv_despacho.tipclipro='PROV' THEN p.nompro
						          ELSE c.nombre_cliente 
							      END) AS nomclipro, 
						        (SELECT nombre FROM sigesp_empresa         WHERE siv_despacho.codemp=sigesp_empresa.codemp) AS nombre,       (SELECT count(codart) FROM siv_dt_despacho         WHERE siv_dt_despacho.numorddes=siv_despacho.numorddes) AS total,       (SELECT spg_unidadadministrativa.denuniadm FROM spg_unidadadministrativa         WHERE spg_unidadadministrativa.coduniadm=siv_despacho.coduniadm) AS denuniadm  FROM siv_despacho
				   LEFT JOIN siv_tipoconcepope opedes ON opedes.codtipconope = siv_despacho.codtipconope
				   LEFT JOIN rpc_proveedor p ON p.cod_pro = siv_despacho.cod_pro
				   LEFT JOIN cxc_clientes c ON c.id_cliente = siv_despacho.id_cliente
				   LEFT JOIN siv_tipodespacho tdesp ON tdesp.codtipdesp = siv_despacho.codtipdesp
				   LEFT JOIN aero_equipos eq ON eq.id_equipo = siv_despacho.aero_nave::integer
				 WHERE siv_despacho.codemp='0001'    AND siv_despacho.estrevdes = 1 AND fecdes >='2020-04-23' AND fecdes <='2020-04-23' AND codtipdesp = 'REQ' GROUP BY siv_despacho.codemp,siv_despacho.numorddes,siv_despacho.numsol,siv_despacho.coduniadm,siv_despacho.obsdes,siv_despacho.fecdes,modprocede ORDER BY fecdes

22/06/2020 19:31:33  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_select_despachos ERROR->Invalid query: ERROR:  column reference "codtipdesp" is ambiguous
LINE 20: ...cdes >='2020-04-23' AND fecdes <='2020-04-23' AND codtipdesp...
                                                              ^
Whole query: SELECT siv_despacho.numorddes,siv_despacho.numsol,siv_despacho.coduniadm,siv_despacho.obsdes,
		                siv_despacho.fecdes,siv_despacho.modprocede,
						MAX(aero_ruta) AS aero_ruta,
						MAX(aero_nave) AS aero_nave,
						MAX(denequip) AS denequip,						
						MAX(aero_matricula) AS aero_matricula,
						MAX(aero_vuelo) AS aero_vuelo,
						MAX(opedes.dentipconope) AS dentipconope,
						MAX(opedes.codtipconope) AS codtipconope,
						MAX(tdesp.dentipdesp) AS dentipdesp, 
						MAX (CASE WHEN siv_despacho.tipclipro='PROV' THEN p.nompro
						          ELSE c.nombre_cliente 
							      END) AS nomclipro, 
						        (SELECT nombre FROM sigesp_empresa         WHERE siv_despacho.codemp=sigesp_empresa.codemp) AS nombre,       (SELECT count(codart) FROM siv_dt_despacho         WHERE siv_dt_despacho.numorddes=siv_despacho.numorddes) AS total,       (SELECT spg_unidadadministrativa.denuniadm FROM spg_unidadadministrativa         WHERE spg_unidadadministrativa.coduniadm=siv_despacho.coduniadm) AS denuniadm  FROM siv_despacho
				   LEFT JOIN siv_tipoconcepope opedes ON opedes.codtipconope = siv_despacho.codtipconope
				   LEFT JOIN rpc_proveedor p ON p.cod_pro = siv_despacho.cod_pro
				   LEFT JOIN cxc_clientes c ON c.id_cliente = siv_despacho.id_cliente
				   LEFT JOIN siv_tipodespacho tdesp ON tdesp.codtipdesp = siv_despacho.codtipdesp
				   LEFT JOIN aero_equipos eq ON eq.id_equipo = siv_despacho.aero_nave::integer
				 WHERE siv_despacho.codemp='0001'    AND siv_despacho.estrevdes = 1 AND fecdes >='2020-04-23' AND fecdes <='2020-04-23' AND codtipdesp = 'REQ' GROUP BY siv_despacho.codemp,siv_despacho.numorddes,siv_despacho.numsol,siv_despacho.coduniadm,siv_despacho.obsdes,siv_despacho.fecdes,modprocede ORDER BY fecdes