01/08/2021 17:50:54 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_c_procesos
METODO: consulta_clientesInvalid query: ERROR: column c.id_cliente_origen does not exist
LINE 14: WHERE c.id_cliente_origen='179'
^
Whole query: SELECT c.*,tc.*,z.*,cc.*,v.*,cu.*,p.despai,e.desest,m.denmun,pa.denpar,ciu.desciu,
rut.codcliente as codruta, rut.nombre_cliente as nombreruta
FROM cxc_clientes c 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 v ON v.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
LEFT JOIN scv_ciudades ciu ON ciu.codpai = c.codpai AND ciu.codest = c.codest AND ciu.codciu = c.codciu
LEFT JOIN cxc_clientes rut ON rut.id_cliente = c.id_ruta
WHERE c.id_cliente_origen='179'