13/07/2021 11:08:06  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_listado_personaljub ERROR->Invalid query: ERROR:  column u.codnom does not exist
LINE 5:               AND pn.codnom = u.codnom
                                      ^
Whole query: SELECT DISTINCT (sno_personal.codper), sno_personal.nomper, sno_personal.apeper, sno_personal.sexper, sno_personal.anoperobr, 		sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.fecnacper, sno_personal.fecjubper, 		sno_personal.fecingadmpubper, sno_nomina.desnom, sno_personal.anoservprefijo,sno_personal.codtippersss, 		sno_componente.descom, sno_rango.desran   FROM sno_personal  INNER JOIN (sno_personalnomina pn        INNER JOIN sno_nomina 	         ON pn.codemp = '0001'  AND (pn.staper = '1' OR pn.staper = '2') AND sno_nomina.espnom = '0'  AND pn.codnom BETWEEN '0001' AND '0007'         AND pn.codemp=sno_nomina.codemp          AND pn.codnom=sno_nomina.codnom)     ON  sno_personal.codemp = '0001'  AND sno_personal.estper = '1'  AND sno_personal.codtippersss IN ('0000001','0000004','0000007')  AND (sno_personal.sexper='M' OR sno_personal.sexper='F')   AND sno_personal.codemp=pn.codemp    AND sno_personal.codper=pn.codper 
				   INNER JOIN sno_cargo ca ON ca.codemp = pn.codemp AND ca.codcar = pn.codcar AND  ca.codnom = pn.codnom
                   INNER JOIN sno_asignacioncargo ac ON ac.codemp = pn.codemp AND ac.codasicar = pn.codasicar AND  ac.codnom = pn.codnom
				   INNER JOIN sno_unidadadmin u ON pn.codemp = u.codemp											 
											   AND pn.codnom = u.codnom
											   AND pn.minorguniadm = u.minorguniadm
											   AND pn.ofiuniadm = u.ofiuniadm
											   AND pn.uniuniadm = u.uniuniadm
											   AND pn.depuniadm = u.depuniadm
											   AND pn.prouniadm = u.prouniadm
				
				  LEFT JOIN sno_componente     ON  sno_personal.codemp = '0001'  AND sno_personal.estper = '1'  AND sno_personal.codtippersss IN ('0000001','0000004','0000007')  AND (sno_personal.sexper='M' OR sno_personal.sexper='F')   AND sno_personal.codemp=sno_componente.codemp    AND sno_personal.codcom= sno_componente.codcom  LEFT JOIN sno_rango     ON  sno_personal.codemp = '0001'  AND sno_personal.estper = '1'  AND sno_personal.codtippersss IN ('0000001','0000004','0000007')  AND (sno_personal.sexper='M' OR sno_personal.sexper='F')   AND sno_personal.codemp=sno_rango.codemp    AND sno_personal.codcom= sno_rango.codcom    AND sno_personal.codran= sno_rango.codran  WHERE  sno_personal.codemp = '0001'  AND sno_personal.estper = '1'  AND sno_personal.codtippersss IN ('0000001','0000004','0000007')  AND (sno_personal.sexper='M' OR sno_personal.sexper='F') ORDER BY sno_personal.codper