Oracle 18c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'
CREATE TABLE schedule_hdr (schedule_id, schedule_name) AS
SELECT LEVEL, 'Schedule '||LEVEL FROM DUAL CONNECT BY LEVEL <= 3;
3 rows affected

CREATE TABLE locations ( id, name ) AS
SELECT  46, 'Door 1' FROM DUAL UNION ALL
SELECT 143, 'Door 2' FROM DUAL UNION ALL
SELECT 223, 'Door 3' FROM DUAL UNION ALL
SELECT 224, 'Door 4' FROM DUAL UNION ALL
SELECT 237, 'Door 5' FROM DUAL UNION ALL
SELECT 345, 'Door 6' FROM DUAL UNION ALL
SELECT 456, 'Door 7' FROM DUAL;
7 rows affected

WITH indexed_locations ( num, name ) AS (
  SELECT ROW_NUMBER() OVER ( ORDER BY DBMS_RANDOM.VALUE(), id ),
         name
  FROM   locations
),
random_times ( schedule_id, schedule_name, datetime, lvl, max_lvl, max_doors ) AS (
  SELECT schedule_id,
         schedule_name,
         TRUNC(sysdate)
         + NUMTODSINTERVAL( FLOOR(DBMS_RANDOM.VALUE(0,24*60)), 'MINUTE' ),
         1,
         FLOOR(DBMS_RANDOM.VALUE(1,11)),
         ( SELECT COUNT(*) FROM locations )
  FROM   schedule_hdr
UNION ALL
  SELECT schedule_id,
         schedule_name,
         datetime + NUMTODSINTERVAL(FLOOR(DBMS_RANDOM.VALUE(6,11)), 'MINUTE'),
         lvl + 1,
         max_lvl,
         max_doors
  FROM   random_times
  WHERE  lvl < max_lvl
)
SELECT rt.schedule_id,
       rt.schedule_name,
       rt.datetime,
       il.name AS door_name
FROM   random_times rt
       INNER JOIN indexed_locations il
       ON ( FLOOR( DBMS_RANDOM.VALUE( 1, rt.max_doors + 1 ) ) = il.num )
WHERE  rt.datetime < TRUNC( SYSDATE ) + INTERVAL '1' DAY
ORDER BY schedule_id, datetime;


SCHEDULE_ID
SCHEDULE_NAME
DATETIME
DOOR_NAME


1
Schedule 1
2020-07-12 23:31:00
Door 4

1
Schedule 1
2020-07-12 23:38:00
Door 1

1
Schedule 1
2020-07-12 23:45:00
Door 6

1
Schedule 1
2020-07-12 23:51:00
Door 2

2
Schedule 2
2020-07-12 10:15:00
Door 4

2
Schedule 2
2020-07-12 10:22:00
Door 1

2
Schedule 2
2020-07-12 10:30:00
Door 1

2
Schedule 2
2020-07-12 10:37:00
Door 6

3
Schedule 3
2020-07-12 21:59:00
Door 4

3
Schedule 3
2020-07-12 22:06:00
Door 1

3
Schedule 3
2020-07-12 22:13:00
Door 1

3
Schedule 3
2020-07-12 22:21:00
Door 4

SCHEDULE_ID	SCHEDULE_NAME	DATETIME	DOOR_NAME
1	Schedule 1	2020-07-12 23:31:00	Door 4
1	Schedule 1	2020-07-12 23:38:00	Door 1
1	Schedule 1	2020-07-12 23:45:00	Door 6
1	Schedule 1	2020-07-12 23:51:00	Door 2
2	Schedule 2	2020-07-12 10:15:00	Door 4
2	Schedule 2	2020-07-12 10:22:00	Door 1
2	Schedule 2	2020-07-12 10:30:00	Door 1
2	Schedule 2	2020-07-12 10:37:00	Door 6
3	Schedule 3	2020-07-12 21:59:00	Door 4
3	Schedule 3	2020-07-12 22:06:00	Door 1
3	Schedule 3	2020-07-12 22:13:00	Door 1
3	Schedule 3	2020-07-12 22:21:00	Door 4