Oracle 23c

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

Create table Calc(CALC_CD VARCHAR(10), FORMULA1 VARCHAR(200), FORMULA2 VARCHAR(200), FORMULA3 VARCHAR(200), FORMULA4 VARCHAR(200));
    
Create table UnitData(UnitNumber VARCHAR(100), CALC_CD VARCHAR(10), GRP_CD VARCHAR(100), GRP_AMT DECIMAL);
 insert into Calc VALUES('M10', 'SI01/VI01', 'SI02/VI02', 'Part1 * 0.3', 'Part2 + Part3');
        
1 rows affected

insert into UnitData select '111E', 'M10', 'SI01', 233.23 from dual
  union
select '111E', 'M10', 'VI01', 4.98 from dual
  union
    select '111E', 'M10', 'SI02', 233.23 from dual
  union
    select '111E', 'M10', 'VI02', 4.98 from dual
  union
    select '112E', 'M10', 'SI01', 133.23 from dual
  union
    select '112E', 'M10', 'VI01', 3.98 from dual
  union
    select '112E', 'M10', 'SI02', 133.23 from dual
  union
    select '112E', 'M10', 'VI02', 3.98 from dual
    
    
8 rows affected

Select * From Calc


CALC_CD
FORMULA1
FORMULA2
FORMULA3
FORMULA4


M10
SI01/VI01
SI02/VI02
Part1 * 0.3
Part2 + Part3


Select * From UnitData


UNITNUMBER
CALC_CD
GRP_CD
GRP_AMT


111E
M10
SI01
233

111E
M10
VI01
5

111E
M10
SI02
233

111E
M10
VI02
5

112E
M10
SI01
133

112E
M10
VI01
4

112E
M10
SI02
133

112E
M10
VI02
4

UNITNUMBER	CALC_CD	GRP_CD	GRP_AMT
111E	M10	SI01	233
111E	M10	VI01	5
111E	M10	SI02	233
111E	M10	VI02	5
112E	M10	SI01	133
112E	M10	VI01	4
112E	M10	SI02	133
112E	M10	VI02	4