Customer_id   | Last_effective_date | Present_quentity
--------------+---------------------+-----------------
    96        | 2009-12-20          | 10
    96        | 2014-11-18          | 12
    96        | 2015-11-26          | 14

SELECT NM.CUSTOMER_ID customer_id,
     NM.LATEST_EFFECTIVE_DATE start_date,
     NVL (
        CASE
           WHEN nm.LATEST_EFFECTIVE_DATE IS NULL
           THEN
              TO_DATE ('12/12/9999', 'dd/mm/yyyy')
           ELSE
              FIRST_VALUE (
                 nm.LATEST_EFFECTIVE_DATE)
              OVER (ORDER BY nm.LATEST_EFFECTIVE_DATE
                    RANGE BETWEEN 1 FOLLOWING AND UNBOUNDED FOLLOWING)
        END,
        TO_DATE ('12/12/9999', 'dd/mm/yyyy'))
        end_date,
     NM.PRESENT_QUANTITY PRESENT_quantity
FROM nm_cust_appliance_history nm
WHERE NM.APPLIANCE_INFO_ID = 10484 AND NM.CUSTOMER_ID = 96
ORDER BY customer_id, start_date;

Customer_id | START_DATE |  END_DATE  | PRESENT_QUANTITY
------------+------------+------------+-----------------
    96      | 2009-12-20 | 2014-11-18 |      10
    96      | 2014-11-18 | 2015-11-26 |      12
    96      | 2015-11-26 | 9999-12-12 |      14