Human Capital Management - EBS (MOSC)

MOSC Banner

SQL Query to find Employee Expense accounts of all Employees

edited Nov 12, 2013 5:50AM in Human Capital Management - EBS (MOSC) 6 commentsAnswered ✓
 hello,
Some of our employees default expense accounts are not set up.
Hence i am looking for a query which will pull out all employees and their expense accounts.

Please check the below navigation if you do not understand what i am talking about.

Application/Responsibility: Human Resources
Navigation: People > Enter and Maintain. Query the employee name. Click on Assignment. Click on Purchase Order Information.

Please give me the query, or suggest a standard oracle report, if at all one exists.

regards,
shiva
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center