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