12/07/2020 22:28:05  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Contabiliza MÉTODO->uf_select_solicitudes_contabilizar ERROR->Invalid query: 
Whole query: 

12/07/2020 22:29:03  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Contabiliza MÉTODO->uf_select_solicitudes_contabilizar ERROR->Invalid query: ERROR:  no existe la columna c.codsuc
LINE 85:          AND ( c.codsuc IN (
                        ^
Whole query:   SELECT  
					  CASE WHEN c.tipo_destino='C' THEN cli.nombre_cliente
						   WHEN c.tipo_destino='P' THEN pro.nompro
						   WHEN c.tipo_destino='B' THEN ben.nombene||' '||ben.apebene
						   ELSE ''
					  END AS nomdestinatario,
					  CASE WHEN c.tipo_destino='C' THEN cli.tipperrif||'-'||cli.numpririf||'-'||cli.numterrif
						   WHEN c.tipo_destino='P' THEN pro.rifpro
						   WHEN c.tipo_destino='B' THEN ben.rifben
						   ELSE ''
					  END AS rifdestinatario,
					  CASE WHEN c.tipo_destino='C' THEN c.id_cliente::text
						   WHEN c.tipo_destino='P' THEN c.cod_pro::text
						   WHEN c.tipo_destino='B' THEN c.ced_bene::text
						   ELSE ''
					  END AS codprobencli,
					  dc.*,
					  td.*,
					  ec.denetapa,
					  c.codtipcont, c.codestcont, c.dencont, c.desccont, c.obscont, 
					  c.feccont, c.fecinicont, c.fecfincont, 
					  c.codpai, c.codest, c.codmun, c.codpar, c.codciu,  
					  c.moncont, c.nomrespcont, c.cedrespcont, c.telrespcont, c.emailrespcont, 
					  c.esttransp, c.id_obr, c.id_cliente, c.cod_pro, c.ced_bene, c.tipo_destino, 
					  c.codmoncont, c.codunitecmed, c.canunitecmed, c.dircont, c.codsuccont,
					  c.cedinspec,c.nominspec,c.telinspec,c.emailinspec,c.civinspec,
					  c.cedresid,c.nomresid,c.telresid,c.emailresid,c.civresid,
					  est.denestcont,u.denunitecmed,
					  tip.dentipcont,		 
					  pai.despai,e.desest,m.denmun,pa.denpar,ciu.desciu,
					  suc.nomsuc, 
					  suc.sigsuc, suc.sucmatriz, suc.codseriesuc, suc.nrocontinisuc, 
					  suc.coduniejesuc, suc.enablescgunieje,
					  mo.denmon,mo.abrmon,
					  o.codtipobr, o.denobr, o.fecobr, o.feciniobr, o.fecfinobr, o.estobr, 
					  o.codsucobr, o.codunitecmed, o.canunitecmed, o.dirobr, o.descobr
				 
				   FROM sco_dt_documentos dc 
		                   INNER JOIN sco_contrato c ON c.codcont = dc.codcont
						   INNER JOIN sco_tipo_documento td ON td.tipdoccont = dc.tipdoccont
						   INNER JOIN sco_dt_etapas ec ON ec.codcont = dc.codcont
													  AND ec.nroetapa = dc.nroetapa
													 
						   INNER JOIN sco_estcont est ON est.codestcont = c.codestcont
						   INNER JOIN sco_tipocontrato tip ON tip.codtipcont = c.codtipcont
						   INNER JOIN cxc_sucursales suc ON suc.codemp = 'Array'
														AND suc.codsuc = c.codsuccont
						   INNER JOIN sco_unidad_tecnica_medida u ON u.codunitecmed = c.codunitecmed		          
						   LEFT JOIN sigesp_moneda mo ON mo.codmon = c.codmoncont
						   LEFT JOIN sigesp_pais pai ON pai.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 sco_obras o ON o.id_obr = c.id_obr
						   LEFT JOIN cxc_clientes cli ON cli.id_cliente = c.id_cliente
						   LEFT JOIN rpc_proveedor pro ON pro.codemp = 'Array'
														AND pro.cod_pro = c.cod_pro
						   LEFT JOIN rpc_beneficiario ben ON ben.codemp = 'Array'
														 AND ben.ced_bene = c.ced_bene							 
						 
						  WHERE  dc.estdoccont IN('PEND')
						    AND  td.tipdocdestino = 'SEP-SOC'
							AND 'SCO'||'-'||dc.tipdoccont||'-'||dc.codcont||'-'||dc.nrodoccont 
								 NOT IN (
											SELECT numdoccom 
											FROM cxp_rd_spg, cxp_rd 
											WHERE cxp_rd_spg.procede_doc = 'SCODOC' 
											AND cxp_rd.estprodoc <> 'A' 
											AND cxp_rd.codemp = cxp_rd_spg.codemp 
											AND cxp_rd.numrecdoc = cxp_rd_spg.numrecdoc 
											AND cxp_rd.codtipdoc = cxp_rd_spg.codtipdoc 
											AND cxp_rd.ced_bene = cxp_rd_spg.ced_bene 
											AND cxp_rd.cod_pro = cxp_rd_spg.cod_pro 
											GROUP BY cxp_rd_spg.numdoccom
										 )						  
						   AND ( c.codsuc IN (
														SELECT p.codintper 
														FROM sss_permisos_internos p 
														INNER JOIN cxc_sucursales suc ON suc.codsuc = p.codintper
														WHERE codsis='CXC'
														  AND codusu='ADMINISTRADOR'
													)
								  OR c.codsuc=''
								  OR c.codsuc IS NULL
							   )	
						     
						 
						  ORDER BY dc.codcont,dc.nrodoccont