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 414: From ap_invoice_distributions_all aid,

410: Begin
411:
412: Select Nvl(Sum(aid.corrected_quantity), 0)
413: Into l_existing_corr_qty
414: From ap_invoice_distributions_all aid,
415: ap_invoice_lines_all ail
416: Where aid.corrected_invoice_dist_id = p_invoice_dist_id
417: And ail.line_number = aid.invoice_line_number
418: And ail.match_type = 'QTY_CORRECTION'

Line 465: FROM ap_invoice_distributions_all

461:
462: -- Bug 5585744 , added the line_type_lookup_code condition
463: SELECT count(*)
464: INTO p_num_line_dists
465: FROM ap_invoice_distributions_all
466: WHERE invoice_id = P_invoice_id
467: AND invoice_line_number = P_invoice_line_number
468: AND line_type_lookup_code in ('ITEM', 'ACCRUAL')
469: AND prepay_distribution_id is NULL;

Line 474: FROM ap_invoice_distributions_all

470:
471: If (p_num_line_dists = 1 ) Then
472: SELECT invoice_distribution_id
473: INTO p_inv_distribution_id
474: FROM ap_invoice_distributions_all
475: WHERE invoice_id = P_invoice_id
476: AND invoice_line_number = P_invoice_line_number
477: AND line_type_lookup_code in ('ITEM', 'ACCRUAL')
478: AND prepay_distribution_id is NULL;

Line 510: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

506:
507: l_invoice_line_rec ap_invoice_lines%ROWTYPE;
508: l_match_mode VARCHAR2(8);
509: l_index po_distributions_all.po_distribution_id%TYPE;
510: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
511: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
512: l_dist_tab ap_matching_pkg.dist_tab_type;
513: l_othr_chrg_tab ap_othr_chrg_match_pkg.othr_chrg_match_tabtype;
514: l_corr_dist_tab ap_matching_pkg.corr_dist_tab_type;

Line 511: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;

507: l_invoice_line_rec ap_invoice_lines%ROWTYPE;
508: l_match_mode VARCHAR2(8);
509: l_index po_distributions_all.po_distribution_id%TYPE;
510: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
511: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
512: l_dist_tab ap_matching_pkg.dist_tab_type;
513: l_othr_chrg_tab ap_othr_chrg_match_pkg.othr_chrg_match_tabtype;
514: l_corr_dist_tab ap_matching_pkg.corr_dist_tab_type;
515: l_inv_line_tab ap_invoice_corrections_pkg.line_tab_type;

Line 947: From ap_invoice_distributions_all

943: Begin
944:
945: Select amount
946: Into l_dist_amt
947: From ap_invoice_distributions_all
948: Where invoice_distribution_id = p_invoice_dist_id;
949:
950: Select Nvl(Sum(aid.amount), 0)
951: Into l_existing_corr_amt

Line 952: From ap_invoice_distributions_all aid,

948: Where invoice_distribution_id = p_invoice_dist_id;
949:
950: Select Nvl(Sum(aid.amount), 0)
951: Into l_existing_corr_amt
952: From ap_invoice_distributions_all aid,
953: ap_invoice_lines_all ail
954: Where aid.corrected_invoice_dist_id = p_invoice_dist_id
955: And ail.line_number = aid.invoice_line_number
956: And ail.match_type = 'LINE_CORRECTION'

Line 1074: from ap_invoice_distributions_all aid

1070: AND ail.line_type_lookup_code not in ('AWT','TAX')
1071: AND (ail.line_type_lookup_code <> 'PREPAY'
1072: OR nvl(ail.invoice_includes_prepay_flag,'N') = 'Y')
1073: AND not exists (select 'matched dists'
1074: from ap_invoice_distributions_all aid
1075: where aid.invoice_id = ail.invoice_id
1076: and aid.invoice_line_number = ail.line_number
1077: and aid.po_distribution_id is not null);
1078:

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

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;
1406:

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

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;
1406:
1407: tax_exception EXCEPTION;