17/09/2021 23:43:33  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaIngresosCajaInvalid query: ERROR:  invalid input syntax for integer: "undefined"
LINE 18:           AND ing.nroing='undefined' 
                                  ^
Whole query: SELECT   ing.*,fp.*,ei.*,suc.*,caj.*,c.*,mo.*,b.*,
							   cbe.codban, cbe.ctaban, cbe.codtipcta, cbe.ctabanext, cbe.dencta, 
							   be.codsudeban,b.nomban as nombancli,be.nomban as nombanemp  FROM cxc_ingresos ing  INNER JOIN cxc_formapago fp ON fp.codforpag = ing.codforpag
					                  INNER JOIN cxc_esting ei ON ei.esting = ing.esting
					                  INNER JOIN cxc_sucursales suc ON suc.codemp = ing.codemp 
									                              AND suc.codsuc = ing.codsuc
								      INNER JOIN cxc_cajas caj ON caj.codemp = ing.codemp 
																 AND caj.codsuc = ing.codsuc
																 AND caj.codcaj = ing.codcaj 
									  LEFT JOIN cxc_clientes c ON c.id_cliente = ing.id_cliente
									  LEFT JOIN sigesp_moneda mo ON ing.codmon = mo.codmon	
									  LEFT JOIN cxc_bancos b ON b.codban = ing.codbancli 
									  LEFT JOIN scb_banco be ON be.codemp = ing.codemp AND be.codban = ing.codban 
									  LEFT JOIN scb_ctabanco cbe ON cbe.codemp = ing.codemp AND cbe.codban = ing.codban AND cbe.ctaban = ing.ctaban 							   
					                  WHERE ing.codemp='0001' 
									    AND ing.codsuc='undefined' 
										AND ing.codcaj='undefined' 
										AND ing.nroing='undefined'