DBA Data[Home] [Help]

APPS.FUN_RECON_RPT_PKG dependencies on AP_INVOICES_ALL

Line 2035: from ap_invoices_all

2031: l_ap_invoice_id := p_ap_ar_invoice_id;
2032:
2033: select invoice_num
2034: into l_invoice_num
2035: from ap_invoices_all
2036: where invoice_id = l_ap_invoice_id;
2037:
2038: -- this invoice_num is = ra_customer_trx_all.customer_trx_id (we are assuming)
2039: l_ar_invoice_id := to_number(l_invoice_num);

Line 2046: from ap_invoices_all

2042: l_ar_invoice_id := p_ap_ar_invoice_id;
2043:
2044: select invoice_id
2045: into l_ap_invoice_id
2046: from ap_invoices_all
2047: where invoice_num = l_ar_invoice_id;
2048:
2049: else
2050: return 'UNMATCHED';