Below query fetch all the user entities and corresponding DBIs.
SELECT FUE.BASE_USER_ENTITY_NAME UE_BASE_NAME
, FDI.BASE_USER_NAME DBI_BASE_NAME
, '"'||FDI.DEFINITION_TEXT||'"' DBI_TEXT
, '"'||FR.TEXT||'"' ROUTE_TEXT
FROM FF_DATABASE_ITEMS_VL FDI
, FF_USER_ENTITIES_VL FUE
, FF_ROUTES_VL FR
WHERE FDI.USER_ENTITY_ID = FUE.USER_ENTITY_ID
AND FUE.ROUTE_ID = FR.ROUTE_ID
AND FDI.base_user_name in(SELECT FDI1.BASE_USER_NAME
FROM FF_DATABASE_ITEMS_VL FDI1
, FF_USER_ENTITIES_VL FUE1
, FF_ROUTES_VL FR1
WHERE FDI1.USER_ENTITY_ID = FUE1.USER_ENTITY_ID
AND FUE1.ROUTE_ID = FR1.ROUTE_ID
/* and FUE1.BASE_USER_ENTITY_NAME in ('PER_EXT_PAY_EMPLOYEES_UE',
'ELEMENT ENTRIES',
'PERSONAL_PAYMENTS',
'PER_EXT_SEC_PERSON_UE',
'PER_EXT_NATIONAL_IDENTIFIERS_UE',
'PER_PERSON_EIT_EFF_HRX_IN_NOMINATION_UE',
'PER_EXT_EMAIL_ADDRESSES_UE',
'ELEMENT ENTRIES RANGE',
'PER_EXT_ADDRESSES_UE',
'PERSONAL_PAYMENTS_RANGE',
'PER_EXT_SEC_ASSIGNMENT_UE',
'ABS_EXT_ABSENCE_ENTRY_UE',
'PAYROLL_ASSIGNED_EMPLOYEE_UE' ,
'PER_ASG_WORK_CONTACTS_UE',
'PER_EXT_USER_ROLES_UE',
'PER_EXT_PHONES_UE',
'PER_EXT_MANAGER_HEADCOUNT_UE',
'PER_EXT_SEC_ORGANIZATION_UE',
'PER_EXT_PAY_EMPLOYEES_UE',
'ELEMENT ENTRIES RANGE',
'PER_EXT_NATIONAL_IDENTIFIERS_UE',
'PER_EXT_ADDRESSES_UE',
'PER_EXT_EMAIL_ADDRESSES_UE',
'PERSONAL_PAYMENTS_RANGE',
'PER_EXT_SEC_JOB_UE',
'PER_EXT_ACTIONS_UE',
'PER_EXT_SEC_PERSON_UE',
'PER_EXT_DRIVING_LICENSE_UE',
'PER_PER_EXT_DISABILITIES_UE',
'PER_EXT_RELIGION_UE',
'PER_EXT_PASSPORT_UE',
'PER_EXT_CONTACT_RELATIONSHIPS_UE',
'PER_EXT_ASG_ALL_ACTION_DETAILS_UE',
'PAYROLL_ASSIGNED_EMPLOYEE_UE',
'PER_EXT_SCH_ASG_UE',
'PER_EXT_SCHEDULE_ASG_EXCEPTION_UE',
'PER_EXT_HIST_ASG_SUPERVISORS_UE'
) */
)
ORDER BY FUE.BASE_USER_ENTITY_NAME, FDI.BASE_USER_NAME