21/01/2016 15:28:22  *****  ERROR DE SISTEMA:   *****  jsantana  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_cotpedInvalid query: ERROR:  no existe la columna f.cxc_estatuscotped
LINE 31:             AND f.cxc_estatuscotped!='PRO'                  ...
                         ^
Whole query: SELECT   f.*, c.*, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago, cp.diascred as diascredito, 
					            denestcotped,cp.operacion as opespi,
					            suc.nomsuc,suc.sucmatriz,suc.sigsuc,
								(now()::date - f.feccotped) as diasemicot, 							
							    (CASE WHEN ((now()::date - f.fecvencotped)::integer - (now()::date - f.feccotped)::integer)::integer<0 AND f.estcotped!='ANU'  
									   THEN abs(((now()::date - f.fecvencotped)::integer - (now()::date - f.feccotped)::integer)::integer)
								 ELSE 0
								 END) as diasvencot
							   FROM cxc_cotiza_pedidos f 
									  LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
									                              AND suc.codsuc = f.codsuc
									  LEFT JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
									  LEFT JOIN cxc_vendedores v ON v.id_vend = f.id_vend
									  LEFT JOIN cxc_transporte t ON t.id_transp = f.id_transp
									  LEFT JOIN sigesp_moneda mo ON f.codmon = mo.codmon
									  LEFT JOIN cxc_condiciones_pago cp ON cp.id_condpago = f.id_condpago
									  LEFT JOIN cxc_estatuscotped es ON es.estcotped = f.estcotped
									  LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
									  LEFT JOIN cxc_zonas z ON z.id_zona = c.id_zona
									  LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = c.id_clasif_cliente
									  LEFT JOIN cxc_vendedores vc ON vc.id_vend = c.id_vend
									  LEFT JOIN scg_cuentas cu ON cu.codemp = c.codemp AND cu.sc_cuenta = c.sc_cuenta AND status='C'
									  LEFT JOIN sigesp_pais p ON p.codpai = c.codpai
									  LEFT JOIN sigesp_estados e ON e.codpai = c.codpai AND e.codest = c.codest 
									  LEFT JOIN sigesp_municipio m ON m.codpai = c.codpai AND m.codest = c.codest AND m.codmun = c.codmun
									  LEFT JOIN sigesp_parroquia pa ON pa.codpai = c.codpai AND pa.codest = c.codest AND pa.codmun = c.codmun AND pa.codpar = c.codpar
									  WHERE f.codemp = '0001'
									    AND f.codproc='COT' 
									    AND f.descrip ILIKE('%%')	
									    AND f.coment ILIKE('%%')	
									   AND f.cxc_estatuscotped!='PRO' 							  								 
									  ORDER BY f.numcotped