Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table table1(
u_a_id number, 
d_c_s number,
c_nm varchar2(200),
c_seq number,
r_c_p number
);
INSERT INTO table1 (u_a_id ,d_c_s, c_nm, c_seq, r_c_p)
VALUES 
(1,908,'Test1',1,20);
1 rows affected

INSERT INTO table1 (u_a_id ,d_c_s, c_nm, c_seq, r_c_p)
VALUES 
(10,908,'Test1',1,21);
1 rows affected

INSERT INTO table1 (u_a_id ,d_c_s, c_nm, c_seq, r_c_p)
VALUES 
(11,908,'Test1',1,12);
1 rows affected

INSERT INTO table1 (u_a_id ,d_c_s, c_nm, c_seq, r_c_p)
VALUES 
(12759,908,'Test1',1,31);
1 rows affected

INSERT INTO table1 (u_a_id ,d_c_s, c_nm, c_seq, r_c_p)
VALUES 
(12759,908,'Test1',1,32);
1 rows affected

INSERT INTO table1 (u_a_id ,d_c_s, c_nm, c_seq, r_c_p)
VALUES 
(12861,878,'Test2',1,43);
1 rows affected

INSERT INTO table1 (u_a_id ,d_c_s, c_nm, c_seq, r_c_p)
VALUES 
(12861,878,'Test2',1,44);
1 rows affected

select * from table1;


U_A_ID
D_C_S
C_NM
C_SEQ
R_C_P


1
908
Test1
1
20

10
908
Test1
1
21

11
908
Test1
1
12

12759
908
Test1
1
31

12759
908
Test1
1
32

12861
878
Test2
1
43

12861
878
Test2
1
44


create table table2(
d_c_s number, 
c_nm varchar2(200),
c_seq number,
n_min_d_c_s number,
n_min_c_nm varchar2(200)
);
INSERT INTO table2 (d_c_s,c_nm,c_seq,n_min_d_c_s,n_min_c_nm
)
VALUES 
(908,'Test1',1, 12001,'Test1, First');
1 rows affected

INSERT INTO table2 (d_c_s,c_nm,c_seq,n_min_d_c_s,n_min_c_nm
)
VALUES 
(878,'Test2',1, 12001,'Test2, First');
1 rows affected

select * from table2;


D_C_S
C_NM
C_SEQ
N_MIN_D_C_S
N_MIN_C_NM


908
Test1
1
12001
Test1, First

878
Test2
1
12001
Test2, First


UPDATE table1 t1
SET t1.d_c_s =
(select 
t2.n_min_d_c_s
from
table2 t2
WHERE t1.d_c_s=t2.d_c_s
AND t1.c_nm=t2.c_nm
AND t1.c_seq=t2.c_seq),
t1.c_nm = 
(select 
t2.n_min_c_nm
from
table2 t2
WHERE t1.d_c_s=t2.d_c_s
AND t1.c_nm=t2.c_nm
AND t1.c_seq=t2.c_seq)

WHERE t1.r_c_p in (
SELECT min(r_c_p) min_r_c_p 
from table1
where c_nm not in ('VOID', 'WRONG') 
group by u_a_id, d_c_s, c_nm, c_seq 
having count(*) > 1
);
2 rows affected

select * from table1


U_A_ID
D_C_S
C_NM
C_SEQ
R_C_P


1
908
Test1
1
20

10
908
Test1
1
21

11
908
Test1
1
12

12759
12001
Test1, First
1
31

12759
908
Test1
1
32

12861
12001
Test2, First
1
43

12861
878
Test2
1
44
U_A_ID	D_C_S	C_NM	C_SEQ	R_C_P
1	908	Test1	1	20
10	908	Test1	1	21
11	908	Test1	1	12
12759	908	Test1	1	31
12759	908	Test1	1	32
12861	878	Test2	1	43
12861	878	Test2	1	44