Business units Query-Oracle Fusion

The below Query will be handy while fetching Business unit name in r13 instance.

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_DATE

FROM FUN_BU_USAGES_V FUBU, HR_OPERATING_UNITS HOU

WHERE FUBU.BUSINESS_UNIT_ID = HOU.ORGANIZATION_ID

AND FUBU.STATUS = 'A'

AND FUBU.CONFIGURATION_STATUS = 'Y'

AND SYSDATE BETWEEN NVL(HOU.DATE_FROM, SYSDATE - 1) AND NVL(HOU.DATE_TO, SYSDATE+1)

Hope this helps !