eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_MATCHING_UTILS_PKG dependencies on AP_INVOICES_ALL

Line 105: ap_invoices_all ai,

101: P_minimum_accountable_unit,
102: P_precision,
103: P_release_amount_net_of_tax
104: FROM
105: ap_invoices_all ai,
106: FND_CURRENCIES FC,
107: HZ_PARTIES HP,
108: ap_suppliers pv,
109: ap_supplier_sites_all pvs,

Line 307: * bug 7118571 - added ap_invoices_all to the query to consider non-cancelled invoices only

303:
304: Begin
305:
306: /*
307: * bug 7118571 - added ap_invoices_all to the query to consider non-cancelled invoices only
308: */
309: Select Nvl(Sum(ail.quantity_invoiced), 0)
310: Into l_existing_corr_qty
311: From ap_invoice_lines_all ail

Line 312: ,ap_invoices_all ai

308: */
309: Select Nvl(Sum(ail.quantity_invoiced), 0)
310: Into l_existing_corr_qty
311: From ap_invoice_lines_all ail
312: ,ap_invoices_all ai
313: Where ail.corrected_inv_id = p_invoice_id
314: And ail.corrected_line_number = p_line_number
315: And ail.match_type = 'QTY_CORRECTION'
316: And ail.invoice_id = ai.invoice_id

Line 338: * bug 7118571 - added ap_invoices_all to the query to consider non-cancelled invoices only

334:
335: Begin
336:
337: /*
338: * bug 7118571 - added ap_invoices_all to the query to consider non-cancelled invoices only
339: */
340:
341: --Commented below code and introduced new call to find l_correction_amount
342: /* Select Nvl(Sum(ail.unit_price * ail.quantity_invoiced), 0)

Line 345: ,ap_invoices_all ai

341: --Commented below code and introduced new call to find l_correction_amount
342: /* Select Nvl(Sum(ail.unit_price * ail.quantity_invoiced), 0)
343: Into l_correction_amount
344: From ap_invoice_lines_all ail
345: ,ap_invoices_all ai
346: Where ail.corrected_inv_id = p_invoice_id
347: And ail.corrected_line_number = p_line_number
348: And ail.match_type = 'PRICE_CORRECTION'
349: And ai.invoice_id = ail.invoice_id

Line 435: * bug 7118571 - added ap_invoices_all to the query to consider non-cancelled invoices only

431:
432: Begin
433:
434: /*
435: * bug 7118571 - added ap_invoices_all to the query to consider non-cancelled invoices only
436: */
437:
438: Select Nvl(Sum(ail.amount), 0)
439: Into l_existing_corr_amt

Line 441: ,ap_invoices_all ai

437:
438: Select Nvl(Sum(ail.amount), 0)
439: Into l_existing_corr_amt
440: From ap_invoice_lines_all ail
441: ,ap_invoices_all ai
442: Where ail.corrected_inv_id = p_invoice_id
443: And ail.corrected_line_number = p_line_number
444: And ail.match_type In ( 'QTY_CORRECTION', 'PRICE_CORRECTION',
445: 'AMOUNT_CORRECTION')

Line 1395: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

1391:
1392: --bugfix:5496603
1393: l_recouped_tax_amt_in_pay_curr NUMBER;
1394: l_recouped_tax_amount NUMBER;
1395: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1396: l_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1397: l_inv_xdate ap_invoices_all.exchange_date%TYPE;
1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

Line 1396: l_inv_xrate ap_invoices_all.exchange_rate%TYPE;

1392: --bugfix:5496603
1393: l_recouped_tax_amt_in_pay_curr NUMBER;
1394: l_recouped_tax_amount NUMBER;
1395: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1396: l_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1397: l_inv_xdate ap_invoices_all.exchange_date%TYPE;
1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

Line 1397: l_inv_xdate ap_invoices_all.exchange_date%TYPE;

1393: l_recouped_tax_amt_in_pay_curr NUMBER;
1394: l_recouped_tax_amount NUMBER;
1395: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1396: l_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1397: l_inv_xdate ap_invoices_all.exchange_date%TYPE;
1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1401: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

Line 1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

1394: l_recouped_tax_amount NUMBER;
1395: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1396: l_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1397: l_inv_xdate ap_invoices_all.exchange_date%TYPE;
1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1401: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1402: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;

Line 1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

1395: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1396: l_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1397: l_inv_xdate ap_invoices_all.exchange_date%TYPE;
1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1401: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1402: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;
1403: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;

Line 1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

1396: l_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1397: l_inv_xdate ap_invoices_all.exchange_date%TYPE;
1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1401: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1402: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;
1403: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;
1404: l_prepay_dist_id_list prepay_dist_id_list;

Line 1401: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

1397: l_inv_xdate ap_invoices_all.exchange_date%TYPE;
1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1401: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1402: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;
1403: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;
1404: l_prepay_dist_id_list prepay_dist_id_list;
1405: l_recoup_amount_list recoup_amount_list;