Oracle 11i/ R12 – How To Determine If A Company Has Single Business Group/Single Operating Unit


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 bgs.name 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,bgs.name
order by count(orgs.business_group_id) ;

Advertisements

One thought on “Oracle 11i/ R12 – How To Determine If A Company Has Single Business Group/Single Operating Unit

Want to give some comment to author ( Shivmohan Purohit )

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s