SQL Query to find Employee Expense accounts of all Employees
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.
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:
4