Tag Archives: Reference Data Sets

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 =… Read More »