Payables and Cash Management - EBS (MOSC)

MOSC Banner

how can I get a report showing all the expense reports unapproved by the manager?

edited Dec 17, 2012 5:37AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered ✓
Hi,
I need a pl/sql query which shows all the expense reports not yet approved by the respective managers of the traveler.
The below query give an output with duplicates. All the expense reports are double. Please help me in correcting this.

select p.full_name traveller,
       a.invoice_num,
       a.creation_date,
       a.report_submitted_date,
       a.employee_id,
       a.expense_status_code
  from ap.ap_expense_report_headers_all a, per_all_people_f p
 where a.expense_status_code = 'PENDMGR'
   and a.employee_id = p.person_id
 order by a.report_submitted_date
select * from ap_expense_report_headers_all

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