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_INVOICE_DISTRIBUTIONS_ALL

Line 374: From ap_invoice_distributions_all aid,

370: Begin
371:
372: Select Nvl(Sum(aid.corrected_quantity), 0)
373: Into l_existing_corr_qty
374: From ap_invoice_distributions_all aid,
375: ap_invoice_lines_all ail
376: Where aid.corrected_invoice_dist_id = p_invoice_dist_id
377: And ail.line_number = aid.invoice_line_number
378: And ail.match_type = 'QTY_CORRECTION'

Line 425: FROM ap_invoice_distributions_all

421:
422: -- Bug 5585744 , added the line_type_lookup_code condition
423: SELECT count(*)
424: INTO p_num_line_dists
425: FROM ap_invoice_distributions_all
426: WHERE invoice_id = P_invoice_id
427: AND invoice_line_number = P_invoice_line_number
428: AND line_type_lookup_code in ('ITEM', 'ACCRUAL')
429: AND prepay_distribution_id is NULL;

Line 434: FROM ap_invoice_distributions_all

430:
431: If (p_num_line_dists = 1 ) Then
432: SELECT invoice_distribution_id
433: INTO p_inv_distribution_id
434: FROM ap_invoice_distributions_all
435: WHERE invoice_id = P_invoice_id
436: AND invoice_line_number = P_invoice_line_number
437: AND line_type_lookup_code in ('ITEM', 'ACCRUAL')
438: AND prepay_distribution_id is NULL;

Line 470: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

466:
467: l_invoice_line_rec ap_invoice_lines%ROWTYPE;
468: l_match_mode VARCHAR2(8);
469: l_index po_distributions_all.po_distribution_id%TYPE;
470: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
471: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
472: l_dist_tab ap_matching_pkg.dist_tab_type;
473: l_othr_chrg_tab ap_othr_chrg_match_pkg.othr_chrg_match_tabtype;
474: l_corr_dist_tab ap_matching_pkg.corr_dist_tab_type;

Line 471: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;

467: l_invoice_line_rec ap_invoice_lines%ROWTYPE;
468: l_match_mode VARCHAR2(8);
469: l_index po_distributions_all.po_distribution_id%TYPE;
470: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
471: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
472: l_dist_tab ap_matching_pkg.dist_tab_type;
473: l_othr_chrg_tab ap_othr_chrg_match_pkg.othr_chrg_match_tabtype;
474: l_corr_dist_tab ap_matching_pkg.corr_dist_tab_type;
475: l_inv_line_tab ap_invoice_corrections_pkg.line_tab_type;

Line 904: From ap_invoice_distributions_all

900: Begin
901:
902: Select amount
903: Into l_dist_amt
904: From ap_invoice_distributions_all
905: Where invoice_distribution_id = p_invoice_dist_id;
906:
907: Select Nvl(Sum(aid.amount), 0)
908: Into l_existing_corr_amt

Line 909: From ap_invoice_distributions_all aid,

905: Where invoice_distribution_id = p_invoice_dist_id;
906:
907: Select Nvl(Sum(aid.amount), 0)
908: Into l_existing_corr_amt
909: From ap_invoice_distributions_all aid,
910: ap_invoice_lines_all ail
911: Where aid.corrected_invoice_dist_id = p_invoice_dist_id
912: And ail.line_number = aid.invoice_line_number
913: And ail.match_type = 'LINE_CORRECTION'

Line 1336: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;

1332: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1333: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1334: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1335: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1336: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;
1337: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;
1338: l_prepay_dist_id_list prepay_dist_id_list;
1339: l_recoup_amount_list recoup_amount_list;
1340:

Line 1337: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;

1333: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1334: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1335: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1336: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;
1337: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;
1338: l_prepay_dist_id_list prepay_dist_id_list;
1339: l_recoup_amount_list recoup_amount_list;
1340:
1341: tax_exception EXCEPTION;