Successful Expense Report in “Expense Report Export”

— Following Query gives Successful Expense Report in “Expense Report Export” Concurrent Program Output File
— This will help to debug issue related to Expense Report Export

SELECT ai.invoice_id, aerh.report_header_id,
aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
AND ai.REFERENCE_KEY1 = aerh.report_header_id
AND aerh.invoice_num = ai.invoice_num
— AND aerh.request_id = l_request_id
AND aerh.report_header_id = 693624
AND aerh.vouchno = 0;


Thanks Yogesh

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s