Oracle 21c

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

create table table_name(id int, Types varchar(255), DocNo int, Name varchar(255));
insert into table_name
(select 1, 'Original', 1001, 'Pdf'  from dual union all
select 2, 'Views'   , 1001, 'Pdf'  from dual union all
select 3, 'Original', 1002, 'Word' from dual union all
select 4, 'Original', 1003, 'Word' from dual union all
select 5, 'Views'   , 1003, 'Pdf'  from dual
)
5 rows affected

select min(id), 
min(case when Types = 'Original' then Types end), 
DocNo,
max(Name),
min(case when Types = 'Views' then Types end)
from table_name
group by DocNo;


MIN(ID)
MIN(CASEWHENTYPES='ORIGINAL'THENTYPESEND)
DOCNO
MAX(NAME)
MIN(CASEWHENTYPES='VIEWS'THENTYPESEND)


1
Original
1001
Pdf
Views

3
Original
1002
Word
null

4
Original
1003
Word
Views

MIN(ID)	MIN(CASEWHENTYPES='ORIGINAL'THENTYPESEND)	DOCNO	MAX(NAME)	MIN(CASEWHENTYPES='VIEWS'THENTYPESEND)
1	Original	1001	Pdf	Views
3	Original	1002	Word	null
4	Original	1003	Word	Views