Oracle 23c

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

CREATE TABLE t1 (
    id NUMBER,
    ins_dt TIMESTAMP,
    base_id VARCHAR(20)
);

INSERT INTO t1 (id, ins_dt, base_id) VALUES 
  (10000, TO_TIMESTAMP('2024-03-27 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1234/45678/000/00'),
  (10000, TO_TIMESTAMP('2024-03-27 06:30:00', 'YYYY-MM-DD HH24:MI:SS'), '1234/45678/001/00'),
  (10000, TO_TIMESTAMP('2024-03-27 09:30:00', 'YYYY-MM-DD HH24:MI:SS'), '1234/45678/002/00');

3 rows affected

CREATE TABLE t2 (
    id NUMBER,
    ins_dt TIMESTAMP,
    cv VARCHAR(2)
);

INSERT INTO t2 (id, ins_dt, cv) 
  VALUES 
  (10000, TO_TIMESTAMP('2024-03-27 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'OD'),
  (10000, TO_TIMESTAMP('2024-03-27 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'TP'),
  (10000, TO_TIMESTAMP('2024-03-27 06:30:00', 'YYYY-MM-DD HH24:MI:SS'), 'PA');
3 rows affected

select t1.id,
       t1.base_id,
       t2.cv
  from t1
 inner
  join t2
    on t1.id = t2.id
   and t1.ins_dt >= t2.ins_dt
 order
    by t1.ins_dt,
       t2.cv


ID
BASE_ID
CV


10000
1234/45678/000/00
OD

10000
1234/45678/000/00
TP

10000
1234/45678/001/00
OD

10000
1234/45678/001/00
PA

10000
1234/45678/001/00
TP

10000
1234/45678/002/00
OD

10000
1234/45678/002/00
PA

10000
1234/45678/002/00
TP

ID	BASE_ID	CV
10000	1234/45678/000/00	OD
10000	1234/45678/000/00	TP
10000	1234/45678/001/00	OD
10000	1234/45678/001/00	PA
10000	1234/45678/001/00	TP
10000	1234/45678/002/00	OD
10000	1234/45678/002/00	PA
10000	1234/45678/002/00	TP