Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to find number of employees per organization (R12 hrms)
Query to find number of employees per organization [message #475715] Thu, 16 September 2010 23:38 Go to next message
nestor
Messages: 34
Registered: September 2010
Member

Please help me create an sql statement that retrieves employees per organization. Thank you
Re: Query to find number of employees per organization [message #475721 is a reply to message #475715] Fri, 17 September 2010 01:17 Go to previous messageGo to next message
Littlefoot
Messages: 21687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't use Oracle Apps., but - this is how it is supposed to look like:
select organization, count(*)
from some_table
group by organization
Re: Query to find number of employees per organization [message #475722 is a reply to message #475721] Fri, 17 September 2010 01:22 Go to previous messageGo to next message
nestor
Messages: 34
Registered: September 2010
Member

i know that format. That is from sql. But what i need are the exact table name and its join. FYI these will come from 2 tables.
Re: Query to find number of employees per organization [message #475723 is a reply to message #475722] Fri, 17 September 2010 01:32 Go to previous messageGo to next message
Littlefoot
Messages: 21687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sorry, no idea. As I said, I don't know Oracle Apps. nor its tables. I was hoping that such a "general" query might help.
Re: Query to find number of employees per organization [message #475724 is a reply to message #475723] Fri, 17 September 2010 01:34 Go to previous messageGo to next message
nestor
Messages: 34
Registered: September 2010
Member

no problem. Thanks for the effort to help anyway.
Re: Query to find number of employees per organization [message #475813 is a reply to message #475715] Fri, 17 September 2010 14:27 Go to previous messageGo to next message
Alien
Messages: 282
Registered: June 1999
Senior Member
Hi,

without regarding BG's and security. And only for the current date:

select organization_id, count(distinct person_id)
from per_assignments_x asg
group by organization_id;

join with hr_(all_)organization_units. And the per_people views for more information.

If you're not familiar with date-track, it's a good idea to read about it, since you need to deal with it in querying HR information from eBS.

Regards,

Arian
Re: Query to find number of employees per organization [message #475958 is a reply to message #475813] Mon, 20 September 2010 01:09 Go to previous message
nestor
Messages: 34
Registered: September 2010
Member

Thanks arian
Previous Topic: NEED INFO 4 E-BUSINESS
Next Topic: Creating Oracle database account for Oracle Application User
Goto Forum:
  


Current Time: Sun Sep 19 01:08:04 CDT 2021