SELECT   Seat_Id,
         sl_No,
         cal_Day,
         MIN(s_No) mIn_s_No,
         MAX(s_No) Max_s_No,
         MIN(From_Time) mIn_Time,
         MAX(To_Time) Max_Time
FROM     (SELECT Seat_Id,
                 sl_No,
                 cal_Day,
                 s_No,
                 pRev_s_No,
                 From_Time,
                 To_Time,
                 COUNT(CASE 
                         WHEN pRev_s_No IS NULL  THEN 'x'
                         WHEN pRev_s_No != s_No - 1 THEN 'x'
                         ELSE NULL
                       END) OVER(PARTITION BY Seat_Id,sl_No ORDER BY s_No) AS grp
          FROM   (SELECT Seat_Id,
                         sl_No,
                         cal_Day,
                         s_No,
                         From_Time,
                         To_Time,
                         Lag(s_No) OVER(PARTITION BY Seat_Id,sl_No ORDER BY s_No) AS pRev_s_No
                  FROM   (SELECT   Seat_Id,
                                   sl_No,
                                   cal_Day,
                                   s_No,
                                   MIN(From_Time) From_Time,
                                   MAX(To_Time) To_Time
                          FROM     (SELECT mst.Seat_Id,
                                           cal.sl_No,
                                           cal.cal_Day,
                                           tm.s_No,
                                           tm.From_Time,
                                           tm.To_Time
                                    FROM   xxcgs_Adm_Seat_mst mst,
                                           xxcgs_AdmIn_Calendar cal,
                                           Time_Slots tm
                                    WHERE  cal.cal_Day >= Nvl(mst.Effective_Start,SYSDATE - 60)
                                           AND cal.cal_Day <= Nvl(mst.Effective_End,SYSDATE + 365)
                                    MINUS 
                                    SELECT Seat_Id,
                                           sl_No,
                                           cal_Day,
                                           s_No,
                                           From_Time,
                                           To_Time
                                    FROM   (SELECT   Alloc.Seat_Id,
                                                     cal.sl_No,
                                                     cal.cal_Day,
                                                     tm.s_No,
                                                     tm.From_Time,
                                                     tm.To_Time,
                                                     SUM(DECODE(Least(Alloc.Time_From,tm.From_Time),Alloc.Time_From,
                                                                DECODE(Greatest(Alloc.Time_To,tm.To_Time),Alloc.Time_To,
                                                                       1,
                                                                                                          0),
                                                                                                    0)) Availability
                                            FROM     xxcgs_Adm_Allocation Alloc,
                                                     xxcgs_AdmIn_Calendar cal,
                                                     Time_Slots tm
                                            WHERE    cal.cal_Day >= Alloc.AllocFrom_Date
                                                     AND cal.cal_Day <= Alloc.AllocTo_Date
                                            GROUP BY Alloc.Seat_Id,
                                                     cal.sl_No,
                                                     cal.cal_Day,
                                                     tm.s_No,
                                                     tm.From_Time,
                                                     tm.To_Time
                                            ORDER BY cal.sl_No,
                                                     tm.s_No) a
                                    WHERE  a.Availability = 1)
                          GROUP BY Seat_Id,
                                   sl_No,
                                   cal_Day,
                                   s_No)))
GROUP BY Seat_Id,
         sl_No,
         cal_Day,
         grp
ORDER BY Seat_Id,
         cal_Day

CREATE TABLE XXCGS_ADMIN_CALENDAR
(
CAL_DAY DATE,
SL_NO NUMBER
);

This table contains 3 years data.

In this table I inserted data with this code:
DECLARE
  v_cal_Day  DATE;
   v_sl_No    NUMBER;
BEGIN
  v_cal_Day := '01-JAN-2007';
  
  v_sl_No := 1;
  
  LOOP
    INSERT INTO xxcgs_AdmIn_Calendar
    VALUES     (v_cal_Day,
                v_sl_No);
    
    v_cal_Day := v_cal_Day + 1;
    
    v_sl_No := v_sl_No + 1;
    
    EXIT WHEN v_cal_Day > '31-DEC-2009';
  END LOOP;
END;