Query to get Business unit (ORGANIZATION_ID) Detail in oracle Fusion

  SELECT HAO.ORGANIZATION_ID AS BUSINESS_UNIT_ID, 

       HAOT.NAME, 

       HAO.BUSINESS_GROUP_ID, 

       HAO.EFFECTIVE_START_DATE, 

       HAO.EFFECTIVE_END_DATE 

  FROM HR_ALL_ORGANIZATION_UNITS_F HAO, HR_ORGANIZATION_UNITS_F_TL HAOT 

 WHERE HAO.ORGANIZATION_ID = HAOT.ORGANIZATION_ID 

   AND HAO.EFFECTIVE_START_DATE = HAOT.EFFECTIVE_START_DATE 

   AND HAO.EFFECTIVE_END_DATE = HAOT.EFFECTIVE_END_DATE 

   AND TRUNC(SYSDATE) BETWEEN HAO.EFFECTIVE_START_DATE AND 

       HAO.EFFECTIVE_END_DATE 

   AND HAOT.LANGUAGE = 'US' 

 ORDER BY HAOT.NAME

Currency code and Currency detail in oracle Fusion

select a.enterprise_id, a.currency_code, a.CURRENCY_CODE || '-' || b.NAME

  from FND_CURRENCIES_B a, FND_CURRENCIES_TL b

 where a.enterprise_id = b.enterprise_id

   and a.currency_code = b.currency_code

   and a.enabled_flag = 'Y'

   and a.currency_flag = 'Y'

   and a.iso_flag = 'Y'

   and b.language = 'US'