Oracle 11g Release 2

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

create table COMP_RESULTS (COMPANY_ID varchar2(20),RATING_NUMBER number, UNIQUE_ENTRY_ID varchar2(20));
insert into COMP_RESULTS values ('Org00001','1','ENTRY_C1_1');
1 rows affected

insert into COMP_RESULTS values ('Org00001','2','ENTRY_C1_2');
1 rows affected

insert into COMP_RESULTS values ('Org00001','3','ENTRY_C1_3');
1 rows affected

insert into COMP_RESULTS values ('Org00002','2','ENTRY_C2_2');
1 rows affected

insert into COMP_RESULTS values ('Org00002','3','ENTRY_C2_3');
1 rows affected

insert into COMP_RESULTS values ('Org00003','3','ENTRY_C3_3');
1 rows affected

SELECT
    DT1.COMPANY_ID
    , CASE
    WHEN DT1.RATING_NUMBER = 2 THEN DT1.UNIQUE_ENTRY_ID
    WHEN DT1.RATING_NUMBER = 1 THEN DT1.UNIQUE_ENTRY_ID
    WHEN DT1.RATING_NUMBER = 3 THEN DT1.UNIQUE_ENTRY_ID
     END AS UNIQUE_ENTRY_ID
FROM
    COMP_RESULTS DT1;


COMPANY_ID
UNIQUE_ENTRY_ID


Org00001
ENTRY_C1_1

Org00001
ENTRY_C1_2

Org00001
ENTRY_C1_3

Org00002
ENTRY_C2_2

Org00002
ENTRY_C2_3

Org00003
ENTRY_C3_3


select dt1.company_id,
  max(dt1.unique_entry_id) keep (dense_rank first
    order by case dt1.rating_number
             when 2 then 1
             when 1 then 2
             when 3 then 3
      end) as unique_entry_id
from comp_results dt1
group by dt1.company_id;


COMPANY_ID
UNIQUE_ENTRY_ID


Org00001
ENTRY_C1_2

Org00002
ENTRY_C2_2

Org00003
ENTRY_C3_3

COMPANY_ID	UNIQUE_ENTRY_ID
Org00001	ENTRY_C1_1
Org00001	ENTRY_C1_2
Org00001	ENTRY_C1_3
Org00002	ENTRY_C2_2
Org00002	ENTRY_C2_3
Org00003	ENTRY_C3_3