Test-Regional Localization

➜ Back to Library
Description
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
  )
Download
Related Blitz Reports
AR Customers and Sites CAC Resource Costs PA Budget Upload CAC Resources by Department Setup CAC Inventory Pending Cost Adjustment - No Currencies PA Project Budget PA Missing Timecards PA Revenue, Cost, Budgets by Resources CAC WIP Account Value CAC AP Accrual IR ISO Match Analysis
Blitz Report™