OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Need help for queries (R12.1.2)

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

Need help for queries [message #559252]

Sat, 30 June 2012 13:43

mvsstataji
Messages: 2
Registered: June 2012
Location: hyderabad

Junior Member

Please help me to create sql statements for the following.

A. Number of employee in transfered from one department to another department(Transfer count) per month for this year.

B. Number of employee in salary change process per organization per month for this year.

C. Number of employee in position change per organization per month for this year.

D. Number of employee terminated from service per organization per month for this year.

Any help would be highly appreciated.

Thanks

Report message to a moderator

Re: Need help for queries [message #559260 is a reply to message #559252]

Sun, 01 July 2012 02:33

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Your questions are probably impossible to answer in a forum, you might want to take a course on EBS12 HR management. But in the meantime, have you looked using the QuickPaint report design facility?

Report message to a moderator