Home » Applications » Oracle Fusion Apps & E-Business Suite » Need help for queries (R12.1.2)
Need help for queries [message #559252] Sat, 30 June 2012 13:43 Go to next message
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
Re: Need help for queries [message #559260 is a reply to message #559252] Sun, 01 July 2012 02:33 Go to previous messageGo to next message
John Watson
Messages: 4692
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?
Re: Need help for queries [message #559272 is a reply to message #559260] Sun, 01 July 2012 10:40 Go to previous messageGo to next message
mvsstataji
Messages: 2
Registered: June 2012
Location: hyderabad
Junior Member
Thanks for update. please help in constructing the above queries.and i dont about QuickPaint report.Can u please elaborate the facility.
Re: Need help for queries [message #559273 is a reply to message #559272] Sun, 01 July 2012 11:06 Go to previous message
John Watson
Messages: 4692
Registered: January 2010
Location: Global Village
Senior Member
http://docs.oracle.com/cd/E18727_01/doc.121/e13509/toc.htm
Previous Topic: How to link Sales Order to AP
Next Topic: Itemwise Last Purchase Order query
Goto Forum:
  


Current Time: Fri Oct 24 12:23:02 CDT 2014

Total time taken to generate the page: 0.12788 seconds