DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICES_ALL

Line 274: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai

270:
271: CURSOR c_successful_invoices(l_request_id IN NUMBER) IS
272: SELECT ai.invoice_id, aerh.report_header_id,
273: aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
274: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
275: WHERE ai.APPLICATION_ID = 200
276: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'
277: AND ai.REFERENCE_KEY1 = aerh.report_header_id
278: AND aerh.invoice_num = ai.invoice_num

Line 927: table_name = 'AP_INVOICES_ALL');

923: INTO l_dummy
924: FROM fnd_doc_sequence_categories
925: WHERE code = l_invoice_rec.doc_category_code
926: AND (table_name = 'AP_INVOICES' OR
927: table_name = 'AP_INVOICES_ALL');
928: EXCEPTION
929: WHEN OTHERS THEN
930: l_reject_code := 'Invalid Doc Category';
931: raise validation_failed;