How To Determine If A Company Has Single Business Group/Single Operating Unit

Currently there are no GUI Form/Reports that are available in the application.
Run the following query to get the Business Group name and the no of organizations/operating units in it

select as "Business Group Name", count(orgs.business_group_id) "No of organizations"
from per_business_groups bgs,hr.hr_all_organization_units orgs
where orgs.business_group_id = bgs.business_group_id
group by orgs.business_group_id,
order by count(orgs.business_group_id) ;

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s