Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE /*meta.*/object_meta_v (object_id, element_name, attribute) AS
SELECT 1, 'A', 'Provider'  FROM DUAL UNION ALL
SELECT 2, 'B', 'Commodity' FROM DUAL;
2 rows affected

CREATE TABLE /*dw.*/load_set2_curve (curve_id, load_set_id) AS
SELECT 1, 100 FROM DUAL UNION ALL
SELECT 2, 200 FROM DUAL;
2 rows affected

CREATE TABLE /*sources.*/dataset (id, name) AS
SELECT 100, 'DS1' FROM DUAL UNION ALL
SELECT 200, 'DS2' FROM DUAL;
2 rows affected

select ds.name setName,
       x.element_name Commodity_Is,
       y.element_name Provider_Is
from   /*meta.*/object_meta_v x
       CROSS JOIN /*meta.*/object_meta_v y
       INNER JOIN /*dw.*/load_set2_curve lsc
       ON x.object_id = lsc.curve_id
       INNER JOIN /*Sources.*/dataset ds
       ON ds.id =  lsc.load_set_id
where  lsc.curve_id in (
         select max(curve_id) sample_curve_id
         from   /*dw.*/load_Set2_curve
         group by load_set_id
       )
and    (  x.attribute = 'Provider'
       or y.attribute = 'Commodity');


SETNAME
COMMODITY_IS
PROVIDER_IS


DS1
A
B

DS1
A
A

DS2
B
B