OracleAppsDNA

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;
Exit mobile version