24/03/2021 02:45:31  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Invalid query: ERROR:  syntax error at or near "."
LINE 15:           .,
                   ^
Whole query: SELECT DISTINCT cxp_solicitudes.numsol as numsol,
									 cxp_solicitudes. as codproben,
									 cxp_solicitudes.fecemisol as fecemisol,
									 cxp_solicitudes.tipproben as tipproben,
									 cxp_solicitudes.fecpagsol as fecpagsol,
									 cxp_solicitudes.consol as consol,
									 cxp_solicitudes.estprosol as estprosol,
									 cxp_solicitudes.monsol as monsol,
									 cxp_solicitudes.obssol as obssol,
									 cxp_solicitudes.codsuc as codsuc,
									 cxp_solicitudes.codmon as codmon,
									 cxp_solicitudes.tascam as tascam,
									 sigesp_moneda.abrmon,
									 sigesp_moneda.denmon,
									 .,
									 cxp_solicitudes.numordpagmin,
									 cxp_solicitudes.codtipfon,
									 cxp_solicitudes.tipsolpag
								FROM cxp_solicitudes
								LEFT JOIN sigesp_moneda ON sigesp_moneda.codmon = cxp_solicitudes.codmon
								, , cxp_rd, cxp_dt_solicitudes
							   WHERE cxp_solicitudes.codemp='0001'
								 AND cxp_solicitudes.tipproben=''
								  AND cxp_solicitudes.fecemisol BETWEEN '2021-03-24T00:00:00' AND '2021-03-24T00:00:00' 
								 AND cxp_solicitudes.estprosol='C' 
								 AND cxp_solicitudes.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_solicitudes.numsol=cxp_dt_solicitudes.numsol
								 AND cxp_rd.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_rd.numrecdoc=cxp_dt_solicitudes.numrecdoc
								 AND cxp_rd.codtipdoc=cxp_dt_solicitudes.codtipdoc
								 AND cxp_rd.cod_pro=cxp_dt_solicitudes.cod_pro
								 AND cxp_rd.ced_bene=cxp_dt_solicitudes.ced_bene 
								 AND cxp_solicitudes.numsol NOT IN (SELECT numsol
																	  FROM scb_prog_pago
																	 WHERE codemp='0001'
																	   AND numsol=cxp_solicitudes.numsol)
								  ORDER BY 1 

24/03/2021 03:02:25  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Invalid query: ERROR:  syntax error at or near "as"
LINE 2: ...  cxp_solicitudes.cod_pro, cod_pro as codproben,  as codprob...
                                                             ^
Whole query: SELECT DISTINCT cxp_solicitudes.numsol as numsol,
									 cxp_solicitudes.cod_pro, cod_pro as codproben,  as codproben,
									 cxp_solicitudes.fecemisol as fecemisol,
									 cxp_solicitudes.tipproben as tipproben,
									 cxp_solicitudes.fecpagsol as fecpagsol,
									 cxp_solicitudes.consol as consol,
									 cxp_solicitudes.estprosol as estprosol,
									 cxp_solicitudes.monsol as monsol,
									 cxp_solicitudes.obssol as obssol,
									 cxp_solicitudes.codsuc as codsuc,
									 cxp_solicitudes.codmon as codmon,
									 cxp_solicitudes.tascam as tascam,
									 sigesp_moneda.abrmon,
									 sigesp_moneda.denmon,
									 rpc_proveedor .nompro as nomproben,
									 cxp_solicitudes.numordpagmin,
									 cxp_solicitudes.codtipfon,
									 cxp_solicitudes.tipsolpag,
									 round((cxp_solicitudes.monsol/cxp_solicitudes.tascam)::numeric,2) monsol_ext
								FROM cxp_solicitudes
								LEFT JOIN sigesp_moneda ON sigesp_moneda.codmon = cxp_solicitudes.codmon
								, rpc_proveedor , cxp_rd, cxp_dt_solicitudes
							   WHERE cxp_solicitudes.codemp='0001'
								 AND cxp_solicitudes.tipproben='P'
								  AND cxp_solicitudes.fecemisol BETWEEN '2021-01-01' AND '2021-03-24' 
								 AND cxp_solicitudes.estprosol='C' 
								 AND cxp_solicitudes.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_solicitudes.numsol=cxp_dt_solicitudes.numsol
								 AND cxp_rd.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_rd.numrecdoc=cxp_dt_solicitudes.numrecdoc
								 AND cxp_rd.codtipdoc=cxp_dt_solicitudes.codtipdoc
								 AND cxp_rd.cod_pro=cxp_dt_solicitudes.cod_pro
								 AND cxp_rd.ced_bene=cxp_dt_solicitudes.ced_bene AND rpc_proveedor.codemp=cxp_solicitudes.codemp AND rpc_proveedor.cod_pro=cxp_solicitudes.cod_pro
								 AND cxp_solicitudes.numsol NOT IN (SELECT numsol
																	  FROM scb_prog_pago
																	 WHERE codemp='0001'
																	   AND numsol=cxp_solicitudes.numsol)
								  ORDER BY 1 

24/03/2021 03:03:29  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Invalid query: ERROR:  syntax error at or near "as"
LINE 2: ...  cxp_solicitudes.cod_pro, cod_pro as codproben,  as codprob...
                                                             ^
Whole query: SELECT DISTINCT cxp_solicitudes.numsol as numsol,
									 cxp_solicitudes.cod_pro, cod_pro as codproben,  as codproben,
									 cxp_solicitudes.fecemisol as fecemisol,
									 cxp_solicitudes.tipproben as tipproben,
									 cxp_solicitudes.fecpagsol as fecpagsol,
									 cxp_solicitudes.consol as consol,
									 cxp_solicitudes.estprosol as estprosol,
									 cxp_solicitudes.monsol as monsol,
									 cxp_solicitudes.obssol as obssol,
									 cxp_solicitudes.codsuc as codsuc,
									 cxp_solicitudes.codmon as codmon,
									 cxp_solicitudes.tascam as tascam,
									 sigesp_moneda.abrmon,
									 sigesp_moneda.denmon,
									 rpc_proveedor .nompro as nomproben,
									 cxp_solicitudes.numordpagmin,
									 cxp_solicitudes.codtipfon,
									 cxp_solicitudes.tipsolpag,
									 round((cxp_solicitudes.monsol/cxp_solicitudes.tascam)::numeric,2) monsol_ext
								FROM cxp_solicitudes
								LEFT JOIN sigesp_moneda ON sigesp_moneda.codmon = cxp_solicitudes.codmon
								, rpc_proveedor , cxp_rd, cxp_dt_solicitudes
							   WHERE cxp_solicitudes.codemp='0001'
								 AND cxp_solicitudes.tipproben='P'
								  AND cxp_solicitudes.fecemisol BETWEEN '2021-01-01' AND '2021-03-24' 
								 AND cxp_solicitudes.estprosol='C' 
								 AND cxp_solicitudes.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_solicitudes.numsol=cxp_dt_solicitudes.numsol
								 AND cxp_rd.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_rd.numrecdoc=cxp_dt_solicitudes.numrecdoc
								 AND cxp_rd.codtipdoc=cxp_dt_solicitudes.codtipdoc
								 AND cxp_rd.cod_pro=cxp_dt_solicitudes.cod_pro
								 AND cxp_rd.ced_bene=cxp_dt_solicitudes.ced_bene AND rpc_proveedor.codemp=cxp_solicitudes.codemp AND rpc_proveedor.cod_pro=cxp_solicitudes.cod_pro
								 AND cxp_solicitudes.numsol NOT IN (SELECT numsol
																	  FROM scb_prog_pago
																	 WHERE codemp='0001'
																	   AND numsol=cxp_solicitudes.numsol)
								  ORDER BY 1 

24/03/2021 03:08:14  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Invalid query: ERROR:  syntax error at or near "as"
LINE 2: ...  cxp_solicitudes.cod_pro, cod_pro as codproben,  as codprob...
                                                             ^
Whole query: SELECT DISTINCT cxp_solicitudes.numsol as numsol,
									 cxp_solicitudes.cod_pro, cod_pro as codproben,  as codproben,
									 cxp_solicitudes.fecemisol as fecemisol,
									 cxp_solicitudes.tipproben as tipproben,
									 cxp_solicitudes.fecpagsol as fecpagsol,
									 cxp_solicitudes.consol as consol,
									 cxp_solicitudes.estprosol as estprosol,
									 cxp_solicitudes.monsol as monsol,
									 cxp_solicitudes.obssol as obssol,
									 cxp_solicitudes.codsuc as codsuc,
									 cxp_solicitudes.codmon as codmon,
									 cxp_solicitudes.tascam as tascam,
									 sigesp_moneda.abrmon,
									 sigesp_moneda.denmon,
									 rpc_proveedor .nompro as nomproben,
									 cxp_solicitudes.numordpagmin,
									 cxp_solicitudes.codtipfon,
									 cxp_solicitudes.tipsolpag
								FROM cxp_solicitudes
								LEFT JOIN sigesp_moneda ON sigesp_moneda.codmon = cxp_solicitudes.codmon
								, rpc_proveedor , cxp_rd, cxp_dt_solicitudes
							   WHERE cxp_solicitudes.codemp='0001'
								 AND cxp_solicitudes.tipproben='P'
								  AND cxp_solicitudes.fecemisol BETWEEN '2021-01-01' AND '2021-03-24' 
								 AND cxp_solicitudes.estprosol='C' 
								 AND cxp_solicitudes.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_solicitudes.numsol=cxp_dt_solicitudes.numsol
								 AND cxp_rd.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_rd.numrecdoc=cxp_dt_solicitudes.numrecdoc
								 AND cxp_rd.codtipdoc=cxp_dt_solicitudes.codtipdoc
								 AND cxp_rd.cod_pro=cxp_dt_solicitudes.cod_pro
								 AND cxp_rd.ced_bene=cxp_dt_solicitudes.ced_bene AND rpc_proveedor.codemp=cxp_solicitudes.codemp AND rpc_proveedor.cod_pro=cxp_solicitudes.cod_pro
								 AND cxp_solicitudes.numsol NOT IN (SELECT numsol
																	  FROM scb_prog_pago
																	 WHERE codemp='0001'
																	   AND numsol=cxp_solicitudes.numsol)
								  ORDER BY 1 

24/03/2021 03:18:44  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Invalid query: ERROR:  division by zero
Whole query: SELECT DISTINCT cxp_solicitudes.numsol as numsol,
									 cxp_solicitudes.cod_pro  as codproben,
									 cxp_solicitudes.fecemisol as fecemisol,
									 cxp_solicitudes.tipproben as tipproben,
									 cxp_solicitudes.fecpagsol as fecpagsol,
									 cxp_solicitudes.consol as consol,
									 cxp_solicitudes.estprosol as estprosol,
									 cxp_solicitudes.monsol as monsol,
									 cxp_solicitudes.obssol as obssol,
									 cxp_solicitudes.codsuc as codsuc,
									 cxp_solicitudes.codmon as codmon,
									 cxp_solicitudes.tascam as tascam,
									 sigesp_moneda.abrmon,
									 sigesp_moneda.denmon,
									 rpc_proveedor .nompro as nomproben,
									 cxp_solicitudes.numordpagmin,
									 cxp_solicitudes.codtipfon,
									 cxp_solicitudes.tipsolpag,
									 (cxp_solicitudes.monsol/cxp_solicitudes.tascam) as monsol_ext
								FROM cxp_solicitudes
								LEFT JOIN sigesp_moneda ON sigesp_moneda.codmon = cxp_solicitudes.codmon
								, rpc_proveedor , cxp_rd, cxp_dt_solicitudes
							   WHERE cxp_solicitudes.codemp='0001'
								 AND cxp_solicitudes.tipproben='P'
								  AND cxp_solicitudes.fecemisol BETWEEN '2021-01-01' AND '2021-03-24' 
								 AND cxp_solicitudes.estprosol='C' 
								 AND cxp_solicitudes.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_solicitudes.numsol=cxp_dt_solicitudes.numsol
								 AND cxp_rd.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_rd.numrecdoc=cxp_dt_solicitudes.numrecdoc
								 AND cxp_rd.codtipdoc=cxp_dt_solicitudes.codtipdoc
								 AND cxp_rd.cod_pro=cxp_dt_solicitudes.cod_pro
								 AND cxp_rd.ced_bene=cxp_dt_solicitudes.ced_bene AND rpc_proveedor.codemp=cxp_solicitudes.codemp AND rpc_proveedor.cod_pro=cxp_solicitudes.cod_pro
								 AND cxp_solicitudes.numsol NOT IN (SELECT numsol
																	  FROM scb_prog_pago
																	 WHERE codemp='0001'
																	   AND numsol=cxp_solicitudes.numsol)
								  ORDER BY 1 

24/03/2021 17:21:18  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Invalid query: ERROR:  division by zero
Whole query: SELECT DISTINCT cxp_solicitudes.numsol as numsol,
									 cxp_solicitudes.cod_pro  as codproben,
									 cxp_solicitudes.fecemisol as fecemisol,
									 cxp_solicitudes.tipproben as tipproben,
									 cxp_solicitudes.fecpagsol as fecpagsol,
									 cxp_solicitudes.consol as consol,
									 cxp_solicitudes.estprosol as estprosol,
									 cxp_solicitudes.monsol as monsol,
									 cxp_solicitudes.obssol as obssol,
									 cxp_solicitudes.codsuc as codsuc,
									 cxp_solicitudes.codmon as codmon,
									 cxp_solicitudes.tascam as tascam,
									 sigesp_moneda.abrmon,
									 sigesp_moneda.denmon,
									 rpc_proveedor .nompro as nomproben,
									 cxp_solicitudes.numordpagmin,
									 cxp_solicitudes.codtipfon,
									 cxp_solicitudes.tipsolpag,
									 (cxp_solicitudes.monsol/cxp_solicitudes.tascam) as monsol_ext
								FROM cxp_solicitudes
								LEFT JOIN sigesp_moneda ON sigesp_moneda.codmon = cxp_solicitudes.codmon
								, rpc_proveedor , cxp_rd, cxp_dt_solicitudes
							   WHERE cxp_solicitudes.codemp='0001'
								 AND cxp_solicitudes.tipproben='P'
								  AND cxp_solicitudes.fecemisol BETWEEN '2020-12-14' AND '2021-03-24' 
								 AND cxp_solicitudes.estprosol='C' 
								 AND cxp_solicitudes.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_solicitudes.numsol=cxp_dt_solicitudes.numsol
								 AND cxp_rd.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_rd.numrecdoc=cxp_dt_solicitudes.numrecdoc
								 AND cxp_rd.codtipdoc=cxp_dt_solicitudes.codtipdoc
								 AND cxp_rd.cod_pro=cxp_dt_solicitudes.cod_pro
								 AND cxp_rd.ced_bene=cxp_dt_solicitudes.ced_bene AND rpc_proveedor.codemp=cxp_solicitudes.codemp AND rpc_proveedor.cod_pro=cxp_solicitudes.cod_pro
								 AND cxp_solicitudes.numsol NOT IN (SELECT numsol
																	  FROM scb_prog_pago
																	 WHERE codemp='0001'
																	   AND numsol=cxp_solicitudes.numsol)
								  ORDER BY 1 

24/03/2021 17:21:21  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Invalid query: ERROR:  division by zero
Whole query: SELECT DISTINCT cxp_solicitudes.numsol as numsol,
									 cxp_solicitudes.cod_pro  as codproben,
									 cxp_solicitudes.fecemisol as fecemisol,
									 cxp_solicitudes.tipproben as tipproben,
									 cxp_solicitudes.fecpagsol as fecpagsol,
									 cxp_solicitudes.consol as consol,
									 cxp_solicitudes.estprosol as estprosol,
									 cxp_solicitudes.monsol as monsol,
									 cxp_solicitudes.obssol as obssol,
									 cxp_solicitudes.codsuc as codsuc,
									 cxp_solicitudes.codmon as codmon,
									 cxp_solicitudes.tascam as tascam,
									 sigesp_moneda.abrmon,
									 sigesp_moneda.denmon,
									 rpc_proveedor .nompro as nomproben,
									 cxp_solicitudes.numordpagmin,
									 cxp_solicitudes.codtipfon,
									 cxp_solicitudes.tipsolpag,
									 (cxp_solicitudes.monsol/cxp_solicitudes.tascam) as monsol_ext
								FROM cxp_solicitudes
								LEFT JOIN sigesp_moneda ON sigesp_moneda.codmon = cxp_solicitudes.codmon
								, rpc_proveedor , cxp_rd, cxp_dt_solicitudes
							   WHERE cxp_solicitudes.codemp='0001'
								 AND cxp_solicitudes.tipproben='P'
								  AND cxp_solicitudes.fecemisol BETWEEN '2020-12-14' AND '2021-03-24' 
								 AND cxp_solicitudes.estprosol='C' 
								 AND cxp_solicitudes.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_solicitudes.numsol=cxp_dt_solicitudes.numsol
								 AND cxp_rd.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_rd.numrecdoc=cxp_dt_solicitudes.numrecdoc
								 AND cxp_rd.codtipdoc=cxp_dt_solicitudes.codtipdoc
								 AND cxp_rd.cod_pro=cxp_dt_solicitudes.cod_pro
								 AND cxp_rd.ced_bene=cxp_dt_solicitudes.ced_bene AND rpc_proveedor.codemp=cxp_solicitudes.codemp AND rpc_proveedor.cod_pro=cxp_solicitudes.cod_pro
								 AND cxp_solicitudes.numsol NOT IN (SELECT numsol
																	  FROM scb_prog_pago
																	 WHERE codemp='0001'
																	   AND numsol=cxp_solicitudes.numsol)
								  ORDER BY 1 

24/03/2021 17:23:37  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Invalid query: ERROR:  division by zero
Whole query: SELECT DISTINCT cxp_solicitudes.numsol as numsol,
									 cxp_solicitudes.cod_pro  as codproben,
									 cxp_solicitudes.fecemisol as fecemisol,
									 cxp_solicitudes.tipproben as tipproben,
									 cxp_solicitudes.fecpagsol as fecpagsol,
									 cxp_solicitudes.consol as consol,
									 cxp_solicitudes.estprosol as estprosol,
									 cxp_solicitudes.monsol as monsol,
									 cxp_solicitudes.obssol as obssol,
									 cxp_solicitudes.codsuc as codsuc,
									 cxp_solicitudes.codmon as codmon,
									 cxp_solicitudes.tascam as tascam,
									 sigesp_moneda.abrmon,
									 sigesp_moneda.denmon,
									 rpc_proveedor .nompro as nomproben,
									 cxp_solicitudes.numordpagmin,
									 cxp_solicitudes.codtipfon,
									 cxp_solicitudes.tipsolpag,
									 (cxp_solicitudes.monsol/cxp_solicitudes.tascam) as monsol_ext
								FROM cxp_solicitudes
								LEFT JOIN sigesp_moneda ON sigesp_moneda.codmon = cxp_solicitudes.codmon
								, rpc_proveedor , cxp_rd, cxp_dt_solicitudes
							   WHERE cxp_solicitudes.codemp='0001'
								 AND cxp_solicitudes.tipproben='P'
								  AND cxp_solicitudes.fecemisol BETWEEN '2020-11-14' AND '2021-03-24' 
								 AND cxp_solicitudes.estprosol='C' 
								 AND cxp_solicitudes.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_solicitudes.numsol=cxp_dt_solicitudes.numsol
								 AND cxp_rd.codemp=cxp_dt_solicitudes.codemp
								 AND cxp_rd.numrecdoc=cxp_dt_solicitudes.numrecdoc
								 AND cxp_rd.codtipdoc=cxp_dt_solicitudes.codtipdoc
								 AND cxp_rd.cod_pro=cxp_dt_solicitudes.cod_pro
								 AND cxp_rd.ced_bene=cxp_dt_solicitudes.ced_bene AND rpc_proveedor.codemp=cxp_solicitudes.codemp AND rpc_proveedor.cod_pro=cxp_solicitudes.cod_pro
								 AND cxp_solicitudes.numsol NOT IN (SELECT numsol
																	  FROM scb_prog_pago
																	 WHERE codemp='0001'
																	   AND numsol=cxp_solicitudes.numsol)
								  ORDER BY 1