27/08/2021 06:55:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_retencionesiva_detalle ERROR->Invalid query: ERROR:  column "codopencd" does not exist
LINE 6:         max(codopencd) as codopencd,
                    ^
HINT:  Perhaps you meant to reference the column "scb_dt_cmp_ret.codope".
Whole query: SELECT max(codret) as codret, max(numcom) as numcom, max(numope) as numope, max(fecfac) as fecfac, 
						 max(numfac) as numfac, max(numcon) as numcon, max(numnd) as numnd, max(numnc) as numnc, 
						 max(tiptrans) as tiptrans, SUM(totcmp_sin_iva) as totcmp_sin_iva , max(totcmp_con_iva) as totcmp_con_iva, 
						 SUM(basimp) as basimp, porimp, SUM(totimp) as totimp, SUM(iva_ret) as iva_ret, max(desope) as desope, max(cmp_porcret) as cmp_porcret,  
						 max(numsop) as numsop, max(codban) as codban, max(ctaban) as ctaban, max(numdoc) as numdoc, max(codope) as codope, 
						  max(codopencd) as codopencd,
				       (SELECT MAX(nomban)
						   FROM scb_banco,cxp_sol_banco,cxp_solicitudes
				         WHERE cxp_sol_banco.codemp=cxp_solicitudes.codemp
				           AND cxp_sol_banco.numsol=cxp_solicitudes.numsol
				           AND cxp_sol_banco.codban=scb_banco.codban
				           AND scb_dt_cmp_ret.codemp=cxp_solicitudes.codemp
				           AND scb_dt_cmp_ret.numsop=cxp_solicitudes.numsol
						  GROUP BY cxp_sol_banco.numsol) AS nomban,
				       (SELECT MAX(fecmov)
						   FROM scb_movbco,cxp_sol_banco,cxp_solicitudes
				         WHERE cxp_sol_banco.codemp=cxp_solicitudes.codemp
				           AND cxp_sol_banco.numsol=cxp_solicitudes.numsol
				           AND cxp_sol_banco.codemp=scb_movbco.codemp
				           AND cxp_sol_banco.codban=scb_movbco.codban
				           AND cxp_sol_banco.ctaban=scb_movbco.ctaban
				           AND cxp_sol_banco.numdoc=scb_movbco.numdoc
				           AND cxp_sol_banco.codope=scb_movbco.codope
				           AND cxp_sol_banco.estmov=scb_movbco.estmov
				           AND scb_dt_cmp_ret.codemp=cxp_solicitudes.codemp
				           AND scb_dt_cmp_ret.numsop=cxp_solicitudes.numsol
						  GROUP BY cxp_sol_banco.numsol) AS fecmov,
				       (SELECT MAX(monto)
						   FROM cxp_sol_banco,cxp_solicitudes
				         WHERE cxp_sol_banco.codemp=cxp_solicitudes.codemp
				           AND cxp_sol_banco.numsol=cxp_solicitudes.numsol
				           AND scb_dt_cmp_ret.codemp=cxp_solicitudes.codemp
				           AND scb_dt_cmp_ret.numsop=cxp_solicitudes.numsol  GROUP BY cxp_sol_banco.numsol) AS montopag,
				       (SELECT MAX(numdoc)
						   FROM cxp_sol_banco,cxp_solicitudes
				         WHERE cxp_sol_banco.codemp=cxp_solicitudes.codemp
				           AND cxp_sol_banco.numsol=cxp_solicitudes.numsol
				           AND scb_dt_cmp_ret.codemp=cxp_solicitudes.codemp
				           AND scb_dt_cmp_ret.numsop=cxp_solicitudes.numsol  GROUP BY cxp_sol_banco.numsol) AS numdocpag, max(tipsolpag) as tipsolpag
				  FROM scb_dt_cmp_ret 
				 WHERE codemp='0001' 
				    AND numcom=trim('20210100000001')  
				 	AND codret='0000000001'  
				  GROUP BY codemp, numfac, porimp, numnd,numnc, numsop 
				  ORDER BY numope