12/04/2021 03:16:17  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_c_aero_carga <br><b>METODO:</b> consulta_detalles_cotpedInvalid query: ERROR:  invalid input syntax for integer: ""
LINE 69:           WHERE d.id_cotped=''
                                     ^
Whole query: SELECT     CASE WHEN d.id_tipodetalle = 'SERVI' THEN s.denser 
										WHEN d.id_tipodetalle = 'ARTIC' THEN a.denart
										WHEN d.id_tipodetalle = 'CONCE' THEN c.denconfac
										ELSE ''
								   END AS dendetalle,
								   d.*,renglon as renglon_cotped, 
								   nomfisalm, u.denunimed, u.uniabrv, f.numcotped, f.feccotped, a.spi_cuenta, s.spg_cuenta,comentario, 
								   c.denconfac, c.scg_cuenta as scg_cuenta_conc,a.canuni,a.ctlcaja,
								   a.codtipcont,
								   cont.denart as dencontvac,a.codcontvac,
								   ucont.codunimed AS codunimedcont, ucont.denunimed as denunimedcont,
								   COALESCE(aacont.existencia,0) AS existenciacont,
									CASE WHEN d.id_tipodetalle = 'SERVI' THEN s.aero_code 
										 WHEN d.id_tipodetalle = 'ARTIC' THEN ''
										 WHEN d.id_tipodetalle = 'CONCE' THEN c.aero_code_concep
										 ELSE ''
									END AS aero_code,
									CASE WHEN d.id_tipodetalle = 'SERVI' THEN s.aero_charges_due 
										 WHEN d.id_tipodetalle = 'ARTIC' THEN ''
										 WHEN d.id_tipodetalle = 'CONCE' THEN ''
										 ELSE ''
									END AS aero_charges_due,
									CASE WHEN d.id_tipodetalle = 'SERVI' THEN s.aero_charges_due 
										 WHEN d.id_tipodetalle = 'ARTIC' THEN ''
										 WHEN d.id_tipodetalle = 'CONCE' THEN ''
										 ELSE ''
									END AS aero_charges_due,
									CASE WHEN d.id_tipodetalle = 'SERVI' THEN s.tiposervflete 
										 WHEN d.id_tipodetalle = 'ARTIC' THEN ''
										 WHEN d.id_tipodetalle = 'CONCE' THEN c.conc_tiptasacarga
										 ELSE ''
									END AS aero_charges_due,
									CASE WHEN d.id_tipodetalle = 'SERVI' THEN s.procformapl 
										 WHEN d.id_tipodetalle = 'ARTIC' THEN ''
										 WHEN d.id_tipodetalle = 'CONCE' THEN c.procformapl
										 ELSE ''
									END AS procformapl,
									CASE WHEN d.id_tipodetalle = 'SERVI' THEN s.denitemformapl 
										 WHEN d.id_tipodetalle = 'ARTIC' THEN ''
										 WHEN d.id_tipodetalle = 'CONCE' THEN c.denitemformapl
										 ELSE ''
									END AS denitemformapl,					   
									s.aero_charges_due,
									c.conc_orgtasa,
									f.tascam
							 FROM cxc_dt_cotiza_pedidos d     LEFT JOIN cxc_cotiza_pedidos f ON f.id_cotped = d.id_cotped 
																	   AND f.codproc = d.codproc
										 INNER JOIN cxc_clientes cl ON cl.id_cliente = f.id_cliente	
										 LEFT JOIN siv_articulo a ON a.codart=d.coddetalle 
										                         AND f.codemp = a.codemp 
																 AND d.id_tipodetalle = 'ARTIC' 
																 
										 LEFT JOIN soc_servicios s ON s.codser=d.coddetalle 
										                          AND d.id_tipodetalle = 'SERVI'
										 LEFT JOIN cxc_conceptofac c ON c.codconfac=d.coddetalle 
										                            AND d.id_tipodetalle = 'CONCE' 
										 LEFT JOIN soc_tiposervicio ts ON s.codtipser=ts.codtipser 
										 LEFT JOIN siv_unidadmedida u ON u.codunimed = d.codunimed 
										 LEFT JOIN siv_producto p ON p.codprod = a.codmil AND p.codemp = a.codemp 
										 LEFT JOIN siv_articuloalmacen aa ON aa.codart = a.codart AND aa.codemp = a.codemp AND d.codalm = aa.codalm 
										 LEFT JOIN siv_almacen al ON al.codalm = aa.codalm AND al.codemp = aa.codemp 
										 LEFT JOIN siv_articulo cont ON cont.codemp = cont.codemp 
										  						    AND cont.codart = a.codcontvac
																    AND cont.contvacio = 1
										 LEFT JOIN siv_unidadmedida ucont ON ucont.codunimed = cont.codunimed
										 LEFT JOIN siv_articuloalmacen aacont ON aacont.codart = a.codart 
																		     AND aacont.codemp = a.codemp 
																		     AND al.codalm = aacont.codalm 
										WHERE d.id_cotped=''
										  AND d.codproc='' 																
										
										ORDER BY renglon; 

12/04/2021 03:25:11  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> VALIDACIÓN DE DATOS: Faltan la datos de la moneda para configurar la conversión