Reports – Query to get business Unit details

Use below query to get business unit details:

SELECT fabuv.bu_name,
fabuv.short_code,
to_char(fabuv.date_from, 'yyyy/mm/dd') start_date,
to_char(fabuv.date_to, 'yyyy/mm/dd') end_date,
fabuv.enabled_for_hr_flag
FROM fun_all_business_units_v fabuv
WHERE TRUNC(SYSDATE) BETWEEN fabuv.date_from AND NVL(fabuv.date_to,TRUNC(SYSDATE))