/*****************************************************************************
*PURPOSE: SQL Query to List Reference Data Sets and their Assignments with *
Business Units in Oracle ERP Cloud *
*AUTHOR: Shailender Thallam *
*****************************************************************************/
SELECT fsa.reference_group_name,
fs.set_id,
fs.set_code,
fs.set_name,
fs.description,
bu.bu_name
FROM fnd_setid_assignments fsa,
fun_all_business_units_v bu,
fnd_setid_sets_vl fs
WHERE 1 = 1
AND fsa.determinant_type = 'BU'
AND fsa.determinant_value = bu.bu_id
AND fsa.set_id = fs.set_id
AND fsa.reference_group_name LIKE 'PER%'
ORDER BY reference_group_name,
set_code,
set_name,
bu_name;