OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Query to find number of employees per organization

Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to find number of employees per organization (R12 hrms)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query to find number of employees per organization [message #475715]

Thu, 16 September 2010 23:38

nestor
Messages: 34
Registered: September 2010

Member

Please help me create an sql statement that retrieves employees per organization. Thank you

Report message to a moderator

Re: Query to find number of employees per organization [message #475721 is a reply to message #475715]

Fri, 17 September 2010 01:17

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

Report message to a moderator

Re: Query to find number of employees per organization [message #475722 is a reply to message #475721]

Fri, 17 September 2010 01:22

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.

Report message to a moderator

Re: Query to find number of employees per organization [message #475723 is a reply to message #475722]

Fri, 17 September 2010 01:32

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.

Report message to a moderator

Re: Query to find number of employees per organization [message #475724 is a reply to message #475723]

Fri, 17 September 2010 01:34

nestor
Messages: 34
Registered: September 2010

Member

no problem. Thanks for the effort to help anyway.

Report message to a moderator

Re: Query to find number of employees per organization [message #475813 is a reply to message #475715]

Fri, 17 September 2010 14:27

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

Report message to a moderator

Re: Query to find number of employees per organization [message #475958 is a reply to message #475813]

Mon, 20 September 2010 01:09

nestor
Messages: 34
Registered: September 2010

Member

Thanks arian

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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