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;
WOW! Did you like this post? We'll send more interesting posts like SQL Query to List Reference Data Sets and their Assignments with Business Units in Oracle ERP Cloud to you!
Enter your Email Address: