SQL Query to List Reference Data Sets and their Assignments with Business Units in Oracle ERP Cloud

/*****************************************************************************
 *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;

/***************************************************************************** *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;