DOO Set ID Assignments

--
SELECT
    fss.SET_ID
  , FSS.SET_NAME
  , FSA.DETERMINANT_VALUE
  , fsa.ENTERPRISE_ID
  , fsa.REFERENCE_GROUP_NAME
  , haotl.ORGANIZATION_ID
  , haotl.NAME BU_NAME
FROM
    Fnd_Setid_Assignments      FSA
  , fnd_SETID_SETS             FSS
  , HR_ORGANIZATION_UNITS_F_TL haotl
WHERE
    fss.set_ID                  = FSA.SET_ID
    AND FSA.DETERMINANT_VALUE   = haotl.ORGANIZATION_ID
    AND Reference_Group_Name LIKE 'DOO%'
    AND Determinant_Type        = 'BU'
ORDER BY
    fss.SET_ID
  , FSS.SET_NAME
  , fsa.REFERENCE_GROUP_NAME
  , fsa.REFERENCE_GROUP_NAME