Expense Report Export Criteria And Select Query

— Criteria For expense report selection during expense report export — Criteria for this cursor is: — Expense status code should not be ‘ERROR’ or ‘PEND_HOLDS_CLEARANCE’ or ‘HOLD_PENDING_RECEIPTS’ — Vouchno = 0 — XH.hold_lookup_code is […]

Rejected Expense Report in AP Invoice Interface During “Expense Report Export”

— Following Query gives Rejected Expense Report in AP Invoice Interface During “Expense Report Export” Concurrent Program processing — This will help to debug issue related to Expense Report Export — CURSOR c_rejected_invoices(l_request_id IN NUMBER) […]

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 […]

Successful Expense Report In “Expense Report Export” Concurrent Program Output File

— 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 * FROM (SELECT per.full_name, per.employee_num, aps.vendor_name, aps.segment1, […]

Rejected Expense Report From “Expense Report Export” Concurrent Program

— Following Query gives Rejected Expense Report From “Expense Report Export” Concurrent Program — This will help to debug issue related to Expense Report Export SELECT * FROM (SELECT per.full_name, per.employee_num, aps.vendor_name, aps.segment1, aeh.invoice_num, aeh.week_end_date, […]