Tech Trainings

Oracle Fusion Account Address Set Query

November 17, 2022 by admin

SELECT fsa.reference_group_name,
         fs.set_id,
	 fsa.determinant_value,
         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 IN ('HZ_CUSTOMER_ACCOUNT_SITE')
ORDER BY reference_group_name,
         set_code,
         set_name,
         bu_name

Comments |0|