Query to find Business Units -Oracle Fusion
SELECT FUBU.BU_NAME, FUBU.SHORT_CODE, FUBU.STATUS, FUBU.MODULE_NAME,FUBU.CONFIGURATION_STATUS,TO_CHAR(HOU.DATE_FROM, 'MM/DD/YYYY') FROM_DATE,TO_CHAR(HOU.DATE_TO, 'MM/DD/YYYY') TO_DATEFROM FUN_BU_USAGES_V FUBU, HR_OPERATING_UNITS HOUWHERE FUBU.BUSINESS_UNIT_ID = HOU.ORGANIZATION_IDAND FUBU.STATUS = 'A'AND FUBU.CONFIGURATION_STATUS = 'Y'AND SYSDATE BETWEEN NVL(HOU.DATE_FROM, SYSDATE - 1) AND NVL(HOU.DATE_TO, SYSDATE+1)