CODIGO PLSQL

SELECT DISTINCT
    (SELECT COUNT(IE_RESERVA) FROM FRINTERNET_CODIGOS_VW WHERE IE_RESERVA=RV_RESERVA) AS NUM_CODIGOS,
    RV_RESERVA,
    RV_STATUS,
    NVL(RV_AGENCIAM, RV_AGENCIA) AS AGENCIA,
    RV_MAYORISTA,
    RV_NOCHES
FROM FRESERVA, FRFECHAS,FRINTERNET_CODIGOS_VW
WHERE IE_RESERVA=RV_RESERVA
    AND  FECHA  BETWEEN RV_LLEGADA AND RV_SALIDA-1
    AND FECHA BETWEEN '011117' AND '301117'
    AND RV_STATUS <> 'C'
GROUP BY RV_RESERVA, RV_STATUS, NVL(RV_AGENCIAM, RV_AGENCIA), RV_MAYORISTA, RV_NOCHES
ORDER BY NUM_CODIGOS DESC, RV_RESERVA;