21/07/2021 22:03:22  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_cxp_c_cmp_retencion MÉTODO->BuscarRecepciones ERROR->Invalid query: ERROR:  missing FROM-clause entry for table "dt"
LINE 21: ...    INNER JOIN cxp_anticipos a ON a.nroanticipo = dt.nroanti...
                                                              ^
Whole query:   SELECT rd.tipproben,so.cod_pro,rd.ced_bene,pro.nompro,pro.rifpro,
						   so.numsol,so.estprosol,so.tipsolpag,e_estaprosol.descequiv AS desc_estaprosol,
						   e_estprosol.descequiv AS desc_estprosol,
						   rd.numrecdoc,rd.dencondoc,rdd.codtipdoc,
						   e_estprodoc.descequiv AS estatus_rd,
						   e_estaprord.descequiv AS estatus_aprord,
						   rdd.procede_doc, rdd.numdoccom,
						   rdd.codded,ded.dended,
						   rd.numrecdoc,
						   rd.montotdoc,rd.mondeddoc,rd.moncardoc,
						   rdd.monobjret,
						   rdd.monret,
						   ded.porded,
						   sum(rdc.monobjret) AS subtotbasimp, 
                           sum(rdc.monret) AS moncar,
						   round((sum(rdc.monret)*(ded.porded/100))::numeric,2) as subtotret,
						   
						   (
								SELECT COALESCE(sum(montodesc),0) AS montodesc
								FROM cxp_dt_anticipos dta
								INNER JOIN cxp_anticipos a ON a.nroanticipo = dt.nroanticipo 
														  AND a.tipproben = dt.tipproben
														  AND a.ced_bene = dt.ced_bene
														  AND a.cod_pro = dt.cod_pro 
								WHERE dt.tipproben=rd.tipproben
								  AND dt.cod_pro=rd.cod_pro
								  AND dt.ced_bene=rd.ced_bene
								  AND dt.numrecdocdes=rd.numrecdoc
								  AND dt.estdoc!='A'
							) AS monantapl,
						    
						   MAX(rdc.codcar) AS codcar,
						   rdc.porcar, 
						   rdc.formula,						   
						   so.fechaconta,
						   so.fecemisol,
						   so.fecaprosol,rd.fecemidoc,
						   rd.fecregdoc,rd.fecaprord,
						   rdd.sc_cuenta,rd.numref,
						   rd.codproalt,proalt.nompro AS nomproalt,proalt.rifpro AS rifproalt,ded.iva
					FROM cxp_solicitudes so
					INNER JOIN cxp_dt_solicitudes ds ON so.codemp=ds.codemp
													 AND so.numsol=ds.numsol
					INNER JOIN  cxp_rd rd ON rd.codemp=ds.codemp
										 AND rd.numrecdoc=ds.numrecdoc
										 AND rd.codtipdoc=ds.codtipdoc
										 AND rd.ced_bene=ds.ced_bene
										 AND rd.cod_pro=ds.cod_pro
					INNER JOIN  cxp_rd_deducciones rdd ON rdd.codemp=ds.codemp
										  			  AND rdd.numrecdoc=ds.numrecdoc
										  			  AND rdd.codtipdoc=ds.codtipdoc
										  			  AND rdd.ced_bene=ds.ced_bene
										  			  AND rdd.cod_pro=ds.cod_pro
					INNER JOIN sigesp_deducciones ded ON  ded.codemp=rdd.codemp
										             AND ded.codded=rdd.codded
					 INNER JOIN rpc_proveedor pro ON rd.cod_pro=pro.cod_pro 
					LEFT JOIN rpc_proveedor proalt ON rd.codproalt=proalt.cod_pro
					LEFT JOIN  cxp_rd_cargos rdc ON rdc.codemp=rd.codemp
										  		AND rdc.numrecdoc=rd.numrecdoc
										  		AND rdc.codtipdoc=rd.codtipdoc
										  		AND rdc.ced_bene=rd.ced_bene
										  		AND rdc.cod_pro=rd.cod_pro										  
										  		AND ded.iva=1
										  		/*AND rdd.monobjret = rdc.monret*/			   							 
					LEFT JOIN covensol_sigesp_equiv e_estprosol ON e_estprosol.dominio='cxp_solicitudes'
											  AND e_estprosol.campo='estprosol'
											  AND e_estprosol.valor= so.estprosol::text
					LEFT JOIN covensol_sigesp_equiv e_estaprosol ON e_estaprosol.dominio='cxp_solicitudes'
											  AND e_estaprosol.campo='estaprosol'
											  AND e_estaprosol.valor= so.estaprosol::text
					LEFT JOIN covensol_sigesp_equiv e_estprodoc ON e_estprodoc.dominio='cxp_rd'
											  AND e_estprodoc.campo='estprodoc'
											  AND e_estprodoc.valor= rd.estprodoc::text
					LEFT JOIN covensol_sigesp_equiv e_estaprord ON e_estaprord.dominio='cxp_rd'
											  AND e_estaprord.campo='estaprord'
											  AND e_estaprord.valor= rd.estaprord::text
					WHERE so.codemp='0001'
					 AND ded.iva=1 
					AND so.estprosol NOT IN ('A','N')					
					AND rd.estprodoc='C'
					 AND rdd.estcmp='0' 					
					   AND (so.fecemisol BETWEEN '2021-07-01' AND '2021-07-31') AND (so.tipsolpag ='SOPA' OR so.tipsolpag ='FOAN' OR so.tipsolpag ='FOAV' OR so.tipsolpag ='LIQA')  AND rd.tipproben='P'  
                   GROUP BY rd.tipproben,so.cod_pro,rd.ced_bene,pro.nompro,pro.rifpro, 
						so.numsol,so.estprosol,so.tipsolpag,e_estaprosol.descequiv,
						e_estprosol.descequiv, rd.numrecdoc,
						rd.dencondoc,rdd.codtipdoc, e_estprodoc.descequiv, 
						e_estaprord.descequiv, rdd.procede_doc, rdd.numdoccom, 
						rdd.codded,ded.dended, 
					       rd.numrecdoc, 
					       rd.montotdoc,
					       rd.mondeddoc,
					       rd.moncardoc, 
					       rdd.monobjret,
					       rdd.monret,
						   ded.porded,
					       rdc.porcar, rdc.formula, so.fechaconta,so.fecemisol, so.fecaprosol,
					       rd.fecemidoc,rd.fecregdoc,rd.fecaprord, rdd.sc_cuenta,rd.numref, rd.codproalt,
					       proalt.nompro,proalt.rifpro,ded.iva 
					ORDER BY so.cod_pro,so.numsol,rd.numrecdoc

21/07/2021 22:04:29  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_cxp_c_cmp_retencion MÉTODO->BuscarRecepciones ERROR->Invalid query: ERROR:  subquery uses ungrouped column "rd.cod_pro" from outer query
LINE 26:           AND dta.cod_pro=rd.cod_pro
                                   ^
Whole query:   SELECT rd.tipproben,so.cod_pro,rd.ced_bene,pro.nompro,pro.rifpro,
						   so.numsol,so.estprosol,so.tipsolpag,e_estaprosol.descequiv AS desc_estaprosol,
						   e_estprosol.descequiv AS desc_estprosol,
						   rd.numrecdoc,rd.dencondoc,rdd.codtipdoc,
						   e_estprodoc.descequiv AS estatus_rd,
						   e_estaprord.descequiv AS estatus_aprord,
						   rdd.procede_doc, rdd.numdoccom,
						   rdd.codded,ded.dended,
						   rd.numrecdoc,
						   rd.montotdoc,rd.mondeddoc,rd.moncardoc,
						   rdd.monobjret,
						   rdd.monret,
						   ded.porded,
						   sum(rdc.monobjret) AS subtotbasimp, 
                           sum(rdc.monret) AS moncar,
						   round((sum(rdc.monret)*(ded.porded/100))::numeric,2) as subtotret,
						   
						   (
								SELECT COALESCE(sum(montodesc),0) AS montodesc
								FROM cxp_dt_anticipos dta
								INNER JOIN cxp_anticipos a ON a.nroanticipo = dta.nroanticipo 
														  AND a.tipproben = dta.tipproben
														  AND a.ced_bene = dta.ced_bene
														  AND a.cod_pro = dta.cod_pro 
								WHERE dta.tipproben=rd.tipproben
								  AND dta.cod_pro=rd.cod_pro
								  AND dta.ced_bene=rd.ced_bene
								  AND dta.numrecdocdes=rd.numrecdoc
								  AND dta.estdoc!='A'
							) AS monantapl,
						    
						   MAX(rdc.codcar) AS codcar,
						   rdc.porcar, 
						   rdc.formula,						   
						   so.fechaconta,
						   so.fecemisol,
						   so.fecaprosol,rd.fecemidoc,
						   rd.fecregdoc,rd.fecaprord,
						   rdd.sc_cuenta,rd.numref,
						   rd.codproalt,proalt.nompro AS nomproalt,proalt.rifpro AS rifproalt,ded.iva
					FROM cxp_solicitudes so
					INNER JOIN cxp_dt_solicitudes ds ON so.codemp=ds.codemp
													 AND so.numsol=ds.numsol
					INNER JOIN  cxp_rd rd ON rd.codemp=ds.codemp
										 AND rd.numrecdoc=ds.numrecdoc
										 AND rd.codtipdoc=ds.codtipdoc
										 AND rd.ced_bene=ds.ced_bene
										 AND rd.cod_pro=ds.cod_pro
					INNER JOIN  cxp_rd_deducciones rdd ON rdd.codemp=ds.codemp
										  			  AND rdd.numrecdoc=ds.numrecdoc
										  			  AND rdd.codtipdoc=ds.codtipdoc
										  			  AND rdd.ced_bene=ds.ced_bene
										  			  AND rdd.cod_pro=ds.cod_pro
					INNER JOIN sigesp_deducciones ded ON  ded.codemp=rdd.codemp
										             AND ded.codded=rdd.codded
					 INNER JOIN rpc_proveedor pro ON rd.cod_pro=pro.cod_pro 
					LEFT JOIN rpc_proveedor proalt ON rd.codproalt=proalt.cod_pro
					LEFT JOIN  cxp_rd_cargos rdc ON rdc.codemp=rd.codemp
										  		AND rdc.numrecdoc=rd.numrecdoc
										  		AND rdc.codtipdoc=rd.codtipdoc
										  		AND rdc.ced_bene=rd.ced_bene
										  		AND rdc.cod_pro=rd.cod_pro										  
										  		AND ded.iva=1
										  		/*AND rdd.monobjret = rdc.monret*/			   							 
					LEFT JOIN covensol_sigesp_equiv e_estprosol ON e_estprosol.dominio='cxp_solicitudes'
											  AND e_estprosol.campo='estprosol'
											  AND e_estprosol.valor= so.estprosol::text
					LEFT JOIN covensol_sigesp_equiv e_estaprosol ON e_estaprosol.dominio='cxp_solicitudes'
											  AND e_estaprosol.campo='estaprosol'
											  AND e_estaprosol.valor= so.estaprosol::text
					LEFT JOIN covensol_sigesp_equiv e_estprodoc ON e_estprodoc.dominio='cxp_rd'
											  AND e_estprodoc.campo='estprodoc'
											  AND e_estprodoc.valor= rd.estprodoc::text
					LEFT JOIN covensol_sigesp_equiv e_estaprord ON e_estaprord.dominio='cxp_rd'
											  AND e_estaprord.campo='estaprord'
											  AND e_estaprord.valor= rd.estaprord::text
					WHERE so.codemp='0001'
					 AND ded.iva=1 
					AND so.estprosol NOT IN ('A','N')					
					AND rd.estprodoc='C'
					 AND rdd.estcmp='0' 					
					   AND (so.fecemisol BETWEEN '2021-07-01' AND '2021-07-31') AND (so.tipsolpag ='SOPA' OR so.tipsolpag ='FOAN' OR so.tipsolpag ='FOAV' OR so.tipsolpag ='LIQA')  AND rd.tipproben='P'  
                   GROUP BY rd.tipproben,so.cod_pro,rd.ced_bene,pro.nompro,pro.rifpro, 
						so.numsol,so.estprosol,so.tipsolpag,e_estaprosol.descequiv,
						e_estprosol.descequiv, rd.numrecdoc,
						rd.dencondoc,rdd.codtipdoc, e_estprodoc.descequiv, 
						e_estaprord.descequiv, rdd.procede_doc, rdd.numdoccom, 
						rdd.codded,ded.dended, 
					       rd.numrecdoc, 
					       rd.montotdoc,
					       rd.mondeddoc,
					       rd.moncardoc, 
					       rdd.monobjret,
					       rdd.monret,
						   ded.porded,
					       rdc.porcar, rdc.formula, so.fechaconta,so.fecemisol, so.fecaprosol,
					       rd.fecemidoc,rd.fecregdoc,rd.fecaprord, rdd.sc_cuenta,rd.numref, rd.codproalt,
					       proalt.nompro,proalt.rifpro,ded.iva 
					ORDER BY so.cod_pro,so.numsol,rd.numrecdoc

21/07/2021 22:07:44  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_cxp_c_cmp_retencion MÉTODO->BuscarRecepciones ERROR->Invalid query: ERROR:  syntax error at or near "AS"
LINE 32:        ) AS monantapl) AS montotdoc,
                  ^
Whole query:   SELECT rd.tipproben,so.cod_pro,rd.ced_bene,pro.nompro,pro.rifpro,
						   so.numsol,so.estprosol,so.tipsolpag,e_estaprosol.descequiv AS desc_estaprosol,
						   e_estprosol.descequiv AS desc_estprosol,
						   rd.numrecdoc,rd.dencondoc,rdd.codtipdoc,
						   e_estprodoc.descequiv AS estatus_rd,
						   e_estaprord.descequiv AS estatus_aprord,
						   rdd.procede_doc, rdd.numdoccom,
						   rdd.codded,ded.dended,
						   rd.numrecdoc,
						   /*rd.montotdoc,*/
						   rd.mondeddoc,
						   rd.moncardoc,
						   rdd.monobjret,
						   rdd.monret,
						   ded.porded,
						   sum(rdc.monobjret) AS subtotbasimp, 
                           sum(rdc.monret) AS moncar,
						   round((sum(rdc.monret)*(ded.porded/100))::numeric,2) as subtotret,
						   
						   (rd.montotdoc - (
								SELECT COALESCE(sum(montodesc),0) AS montodesc
								FROM cxp_dt_anticipos dta
								INNER JOIN cxp_anticipos a ON a.nroanticipo = dta.nroanticipo 
														  AND a.tipproben = dta.tipproben
														  AND a.ced_bene = dta.ced_bene
														  AND a.cod_pro = dta.cod_pro 
								WHERE dta.tipproben=rd.tipproben
								  AND dta.cod_pro=rd.cod_pro
								  AND dta.ced_bene=rd.ced_bene
								  AND dta.numrecdocdes=rd.numrecdoc
								  AND dta.estdoc!='A'
							) AS monantapl) AS montotdoc,
						    
						   MAX(rdc.codcar) AS codcar,
						   rdc.porcar, 
						   rdc.formula,						   
						   so.fechaconta,
						   so.fecemisol,
						   so.fecaprosol,rd.fecemidoc,
						   rd.fecregdoc,rd.fecaprord,
						   rdd.sc_cuenta,rd.numref,
						   rd.codproalt,proalt.nompro AS nomproalt,proalt.rifpro AS rifproalt,ded.iva
					FROM cxp_solicitudes so
					INNER JOIN cxp_dt_solicitudes ds ON so.codemp=ds.codemp
													 AND so.numsol=ds.numsol
					INNER JOIN  cxp_rd rd ON rd.codemp=ds.codemp
										 AND rd.numrecdoc=ds.numrecdoc
										 AND rd.codtipdoc=ds.codtipdoc
										 AND rd.ced_bene=ds.ced_bene
										 AND rd.cod_pro=ds.cod_pro
					INNER JOIN  cxp_rd_deducciones rdd ON rdd.codemp=ds.codemp
										  			  AND rdd.numrecdoc=ds.numrecdoc
										  			  AND rdd.codtipdoc=ds.codtipdoc
										  			  AND rdd.ced_bene=ds.ced_bene
										  			  AND rdd.cod_pro=ds.cod_pro
					INNER JOIN sigesp_deducciones ded ON  ded.codemp=rdd.codemp
										             AND ded.codded=rdd.codded
					 INNER JOIN rpc_proveedor pro ON rd.cod_pro=pro.cod_pro 
					LEFT JOIN rpc_proveedor proalt ON rd.codproalt=proalt.cod_pro
					LEFT JOIN  cxp_rd_cargos rdc ON rdc.codemp=rd.codemp
										  		AND rdc.numrecdoc=rd.numrecdoc
										  		AND rdc.codtipdoc=rd.codtipdoc
										  		AND rdc.ced_bene=rd.ced_bene
										  		AND rdc.cod_pro=rd.cod_pro										  
										  		AND ded.iva=1
										  		/*AND rdd.monobjret = rdc.monret*/			   							 
					LEFT JOIN covensol_sigesp_equiv e_estprosol ON e_estprosol.dominio='cxp_solicitudes'
											  AND e_estprosol.campo='estprosol'
											  AND e_estprosol.valor= so.estprosol::text
					LEFT JOIN covensol_sigesp_equiv e_estaprosol ON e_estaprosol.dominio='cxp_solicitudes'
											  AND e_estaprosol.campo='estaprosol'
											  AND e_estaprosol.valor= so.estaprosol::text
					LEFT JOIN covensol_sigesp_equiv e_estprodoc ON e_estprodoc.dominio='cxp_rd'
											  AND e_estprodoc.campo='estprodoc'
											  AND e_estprodoc.valor= rd.estprodoc::text
					LEFT JOIN covensol_sigesp_equiv e_estaprord ON e_estaprord.dominio='cxp_rd'
											  AND e_estaprord.campo='estaprord'
											  AND e_estaprord.valor= rd.estaprord::text
					WHERE so.codemp='0001'
					 AND ded.iva=1 
					AND so.estprosol NOT IN ('A','N')					
					AND rd.estprodoc='C'
					 AND rdd.estcmp='0' 					
					   AND (so.fecemisol BETWEEN '2021-07-01' AND '2021-07-31') AND (so.tipsolpag ='SOPA' OR so.tipsolpag ='FOAN' OR so.tipsolpag ='FOAV' OR so.tipsolpag ='LIQA')  AND rd.tipproben='P'  
                   GROUP BY rd.tipproben,so.cod_pro,rd.cod_pro,rd.ced_bene,pro.nompro,pro.rifpro, 
						so.numsol,so.estprosol,so.tipsolpag,e_estaprosol.descequiv,
						e_estprosol.descequiv, rd.numrecdoc,
						rd.dencondoc,rdd.codtipdoc, e_estprodoc.descequiv, 
						e_estaprord.descequiv, rdd.procede_doc, rdd.numdoccom, 
						rdd.codded,ded.dended, 
					       rd.numrecdoc, 
					       rd.montotdoc,
					       rd.mondeddoc,
					       rd.moncardoc, 
					       rdd.monobjret,
					       rdd.monret,
						   ded.porded,
					       rdc.porcar, rdc.formula, so.fechaconta,so.fecemisol, so.fecaprosol,
					       rd.fecemidoc,rd.fecregdoc,rd.fecaprord, rdd.sc_cuenta,rd.numref, rd.codproalt,
					       proalt.nompro,proalt.rifpro,ded.iva 
					ORDER BY so.cod_pro,so.numsol,rd.numrecdoc