Oracle 18c

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

CREATE TABLE test(
  ID     INTEGER NOT NULL
  ,TYPE   VARCHAR(14) NOT NULL
  ,AMOUNT NUMBER
  ,AWARD  NUMBER
  ,MYDATE   DATE
);
begin
INSERT INTO test(ID,TYPE,AMOUNT,AWARD,MYDATE) VALUES (7186,'INSPECT',942164.81,NULL,NULL);
INSERT INTO test(ID,TYPE,AMOUNT,AWARD,MYDATE) VALUES (7186,'CMP',1392528.28,NULL,NULL);
INSERT INTO test(ID,TYPE,AMOUNT,AWARD,MYDATE) VALUES (7186,'CON',92464162.51,NULL,NULL);
end;
/
1 rows affected

select * from test;


ID
TYPE
AMOUNT
AWARD
MYDATE


7186
INSPECT
942164.81
null
null

7186
CMP
1392528.28
null
null

7186
CON
92464162.51
null
null


CREATE TABLE award(
   ID     INTEGER  NOT NULL PRIMARY KEY 
  ,AWARD  NUMBER NOT NULL
  ,MYDATE DATE  NOT NULL
);

INSERT INTO award(ID,AWARD,MYDATE) VALUES (7186,83157895,date'2007-06-25');
1 rows affected

select * from award


ID
AWARD
MYDATE


7186
83157895
25-JUN-07


merge into test t
using (select id, sum(award) award, max(mydate) mydate from award group by id) a
on (a.id = t.id and t.type = 'CMP')
when matched then update set t.award = a.award, t.mydate = a.mydate
1 rows affected

select * from test


ID
TYPE
AMOUNT
AWARD
MYDATE


7186
INSPECT
942164.81
null
null

7186
CMP
1392528.28
83157895
25-JUN-07

7186
CON
92464162.51
null
null

ID	TYPE	AMOUNT	AWARD	MYDATE
7186	INSPECT	942164.81	null	null
7186	CMP	1392528.28	null	null
7186	CON	92464162.51	null	null