SQL Query to get the Organization ID details in Oracle cloud fusion.

Here is the SQL Query to get the Organization ID in Oracle cloud fusion. This query can be tweaked accordingly for the further requirements.

SELECT 'Business Unit ID' "SETUP_NAME",
                haot.name  VALUE,
                 hao.organization_id "Value ID"
FROM HR_ALL_ORGANIZATION_UNITS_F hao,
            HR_ORGANIZATION_UNITS_F_TL haot,
            HR_ORG_UNIT_CLASSIFICATIONS_F houcf
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 houcf.organization_id = hao.organization_id
   AND houcf.classification_code = 'BUSINESS_UNIT'
   AND haot.LANGUAGE='US';