Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Joining condition for ap_invoices_all and exm_expense_reports — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Joining condition for ap_invoices_all and exm_expense_reports

Received Response
25
Views
1
Comments
edited Mar 3, 2020 6:34AM in Expenses 1 comment

Content

I am unable to find the approver name when i am doing joining for below query:

select full_name

from

per_person_names_f ppf,

exm_expense_reports eer,

ap_invoices_all ai

where ppf.person_id=eer.current_approver_id

AND ai.reference_key1=eer.expense_report_id;

but i am unable to get the approver name when i am giving joining for ap_invoices table. Without taking invoice table i am getting the approver name.

and is invoice_num and expense_report_num is same?

can you please help me to get the issue resolved.

 

Thanks in advance,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!