APPS.FUN_RECON_RPT_PKG dependencies on AP_INVOICES_ALL

Line 2141: from ap_invoices_all

2137: l_ap_invoice_id := p_ap_ar_invoice_id;
2138:
2139: select invoice_num
2140: into l_invoice_num
2141: from ap_invoices_all
2142: where invoice_id = l_ap_invoice_id;
2143:
2144: -- this invoice_num is = ra_customer_trx_all.customer_trx_id (we are assuming)
2145: l_ar_invoice_id := to_number(l_invoice_num);

Line 2152: from ap_invoices_all

2148: l_ar_invoice_id := p_ap_ar_invoice_id;
2149:
2150: select invoice_id
2151: into l_ap_invoice_id
2152: from ap_invoices_all
2153: where invoice_num = l_ar_invoice_id;
2154:
2155: else
2156: return 'UNMATCHED';