este es el codigo
Código SQL:
Ver originalSELECT FUPE.FUPE_NRO_EMPLEADO AS NRO_EMP,
FUPE.FUPE_DV_NRO_EMP AS DV,
FUPE.PERS_RUT AS RUT,
FUPE.PERS_DV AS DV,
FUPE.FUPE_APELLIDO_PATERNO||' '||FUPE.FUPE_APELLIDO_MATERNO APELLIDOS,
FUPE.FUPE_NOMBRES NOMBRES,
FUPE.AFPS_COD AS AFP,
FUPE.ISAP_COD AS FS,
u.DESCRIPCION_JTA AS unidad_origen,
u1.DESCRIPCION_JTA AS unidad_destino,
d.ddoc_fec_inclusion AS Destinacion,
d.ddoc_fec_despacho AS Despacho,
MAX(d.ddoc_fec_termino) AS Precentacion,
CU.CARGO_DES AS Cargos,
f1.PERS_COD AS Rut_Cony,
f1.fupe_nombres AS Nombre_Cony,
F1.FUPE_APELLIDO_PATERNO||' '||F1.FUPE_APELLIDO_MATERNO AS Apellidos_Cony,
F1.FUEX_COD AS Tipo
FROM ddoc d, fuex f, grje g, grje g1,unfa u, unfa u1, fupe, FUPE F1, TPAR T, CARGOS_UNIDAD CU
WHERE FUPE.FUPE_CATEGORIA_MANDATORIA = 'S'
AND FUPE.ESDO_COD IN ('ACT','EXT','PSG')
AND d.fuex_cod=f.fuex_cod(+)
AND rtrim(d.grje_cod_actual)=g1.grje_cod(+)
AND rtrim(d.grje_cod)=g.grje_cod(+)
AND d.PERS_COD = fupe.PERS_COD
AND d.unfa_cod=u.unfa_cod(+)
AND d.unfa_cod_destino=u1.unfa_cod(+)
AND tido_cod IN ('INIDES','ININOM')
AND sist_cod = 'SIA'
AND F1.FUEX_COD IN ('CAFA','FAMILIAR','EXCAFA')
AND T.TPAR_COD = '01'
AND FUPE.PERS_COD = F1.PERS_COD_REF
AND CU.PERS_COD=FUPE.PERS_COD
AND F1.TPAR_COD = T.TPAR_COD(+)
AND D.PERS_cod='7628824'
GROUP BY FUPE.FUPE_NRO_EMPLEADO,
FUPE.FUPE_DV_NRO_EMP,
FUPE.PERS_RUT,
FUPE.PERS_DV,
FUPE.FUPE_APELLIDO_PATERNO||' '||FUPE.FUPE_APELLIDO_MATERNO,
FUPE.FUPE_NOMBRES,
FUPE.AFPS_COD,
FUPE.ISAP_COD,
u.DESCRIPCION_JTA,
u1.DESCRIPCION_JTA,
d.ddoc_fec_inclusion,
d.ddoc_fec_despacho,
d.ddoc_fec_termino,
/*CU.CARGO_DES,*/
CU.CARGO_DES,
f1.PERS_COD,
f1.fupe_nombres,
F1.FUPE_APELLIDO_PATERNO||' '||F1.FUPE_APELLIDO_MATERNO,
F1.FUEX_COD
ORDER BY d.ddoc_fec_termino DESC;