SELECT FSSV.SET_NAME,
FSSV.DESCRIPTION,
FABU.BU_NAME,
ASFD.REFERENCE_GROUP_NAME,
FSSV.SET_ID,
FSSV.SET_CODE
FROM FND_SETID_ASSIGNMENTS ASFD,
FUN_ALL_BUSINESS_UNITS_V FABU,
FND_SETID_SETS_VL FSSV
WHERE ASFD.DETERMINANT_TYPE = 'BU'
AND ASFD.DETERMINANT_VALUE = FABU.BU_ID
AND ASFD.SET_ID = FSSV.SET_ID
AND ASFD.REFERENCE_GROUP_NAME LIKE 'PER%'
Related Posts
