SELECT frs.request_set_name,
--frs.description AS request_set_description,
frg.request_group_name,
frg.description AS request_group_description
FROM apps.fnd_request_sets frs
JOIN apps.fnd_request_group_units frgu
ON frs.request_set_id = frgu.request_unit_id
JOIN apps.fnd_request_groups frg
ON frgu.request_group_id = frg.request_group_id
WHERE frs.request_set_name = 'SAMPLE_REQ_SET_NAME';
--frs.description AS request_set_description,
frg.request_group_name,
frg.description AS request_group_description
FROM apps.fnd_request_sets frs
JOIN apps.fnd_request_group_units frgu
ON frs.request_set_id = frgu.request_unit_id
JOIN apps.fnd_request_groups frg
ON frgu.request_group_id = frg.request_group_id
WHERE frs.request_set_name = 'SAMPLE_REQ_SET_NAME';