ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3A3524027412AEF8E06362FB0905453FY select count(*) over () count, hou.name from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and hou.organization_id in ( select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) union select fnd_global.org_id from dual where fnd_release.major_version=11 ) US Test-Regional Localization