Sunday, 18 September 2022

Oracle Fusion: SQL Query to Get Reference Data Sets and their Assigned with Business Units

 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

No comments:

Post a Comment