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

–c_successful_invoices
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
WHERE ai.APPLICATION_ID = 200
AND ai.PRODUCT_TABLE = ‘AP_EXPENSE_REPORT_HEADERS_ALL’
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:

WordPress.com Logo

You are commenting using your WordPress.com 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