27/07/2020 02:51:42  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> ConsultaAnticipoInvalid query: ERROR:  falta una entrada para la tabla «f» en la cláusula FROM
LINE 12:            f.numfact,
                    ^
Whole query: SELECT  
						     a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato, 
						     a.scg_cuenta_ant, 
						     a.fecant, a.conant, a.porant, a.codmon, 
						     a.tascam AS tascam, 
						     a.monant, 
						     a.estant, 
						     a.fecanuant, 
						     a.conanuant, a.fecregant, a.usuregant, a.horaregant, 
						     a.nroing, a.codsucres, 
						     a.codcajres, a.resing, a.codmonref, a.tascamref,
						     f.numfact,
					         cl.*,mo.*,e.*,
					         (
									a.monant
									-
									( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0) 
									  FROM cxc_dt_anticipos da 
									  INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
													AND da.id_cliente = ant.id_cliente
													AND da.nroant = ant.nroant
													AND ant.estant!='ANU'	
									  INNER JOIN cxc_factura f ON f.id_fact = da.id_fact		
									  WHERE da.codemp=a.codemp  
									  AND da.id_cliente=a.id_cliente
									  AND da.nroant=a.nroant
									  AND estdesc='P'
									 )
							
							) AS saldo_ant,
							(
								SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0) 
							    FROM cxc_dt_anticipos da 
							    INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
											AND da.id_cliente = ant.id_cliente
											AND da.nroant = ant.nroant
											AND ant.estant!='ANU'
								INNER JOIN cxc_factura f ON f.id_fact = da.id_fact		
							    WHERE da.codemp=a.codemp 
							    AND da.id_cliente=a.id_cliente
							    AND da.nroant=a.nroant
							    AND estdesc='P'
							) AS ant_apl
						   
						     FROM cxc_anticipos a   INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
					                   INNER JOIN cxc_estanticipo e ON e.estant = a.estant
					                   LEFT JOIN sigesp_moneda mo ON a.codmon = mo.codmon	
					                   WHERE a.conant ILIKE('%%') 
									    AND a.id_cliente = '1'  AND a.estant != 'ANU'  
									   ORDER BY a.id_cliente, a.nroant