Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table PROD_DATA (STATION_NUMBER, PART_NO, BOOK_DATE) as (
select 11111, 'A', timestamp '2021-08-01 6:00:00' from dual union all
select 11111, 'A', timestamp '2021-08-01 6:05:00' from dual union all
select 11111, 'A', timestamp '2021-08-01 6:07:00' from dual union all
select 11111, 'A', timestamp '2021-08-01 6:08:00' from dual union all
select 11111, 'B', timestamp '2021-08-01 7:10:00' from dual union all
select 11111, 'B', timestamp '2021-08-01 7:13:00' from dual union all
select 11111, 'B', timestamp '2021-08-01 7:15:00' from dual union all
select 11111, 'B', timestamp '2021-08-01 7:25:00' from dual union all
select 11111, 'A', timestamp '2021-08-01 8:10:00' from dual union all
select 11111, 'A', timestamp '2021-08-01 8:12:00' from dual union all
select 11111, 'A', timestamp '2021-08-01 8:16:00' from dual union all
select 11111, 'A', timestamp '2021-08-01 8:19:00' from dual union all
select 22222, 'A', timestamp '2021-08-01 6:00:00' from dual union all
select 22222, 'A', timestamp '2021-08-01 6:05:00' from dual union all
select 22222, 'A', timestamp '2021-08-01 6:07:00' from dual union all
select 22222, 'A', timestamp '2021-08-01 6:08:00' from dual union all
select 22222, 'B', timestamp '2021-08-01 7:10:00' from dual union all
select 22222, 'B', timestamp '2021-08-01 7:13:00' from dual union all
select 22222, 'B', timestamp '2021-08-01 7:15:00' from dual union all
select 22222, 'B', timestamp '2021-08-01 7:25:00' from dual union all
select 22222, 'A', timestamp '2021-08-01 8:10:00' from dual union all
select 22222, 'A', timestamp '2021-08-01 8:12:00' from dual union all
select 22222, 'A', timestamp '2021-08-01 8:16:00' from dual union all
select 22222, 'A', timestamp '2021-08-01 8:19:00' from dual
) 
;

24 rows affected

STATION_NUMBER	PART_NO	START_BOOK_DATE	END_BOOK_DATE
11111	A	01-AUG-21 06.00.00.000000000 AM	01-AUG-21 06.08.00.000000000 AM
11111	B	01-AUG-21 07.10.00.000000000 AM	01-AUG-21 07.25.00.000000000 AM
11111	A	01-AUG-21 08.10.00.000000000 AM	01-AUG-21 08.19.00.000000000 AM
22222	A	01-AUG-21 06.00.00.000000000 AM	01-AUG-21 06.08.00.000000000 AM
22222	B	01-AUG-21 07.10.00.000000000 AM	01-AUG-21 07.25.00.000000000 AM
22222	A	01-AUG-21 08.10.00.000000000 AM	01-AUG-21 08.19.00.000000000 AM