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_LINES_ALL

Line 311: From ap_invoice_lines_all ail

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
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'

Line 344: From ap_invoice_lines_all ail

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)
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'

Line 357: From ap_invoice_lines_all ail

353: -- Bug7187973 Starts
354: Select (NVL(ail.unit_price, 0) * NVL(ail.quantity_invoiced, 0)),
355: NVL( ail.quantity_invoiced,0)
356: Into l_original_amount, l_original_qty_invoiced
357: From ap_invoice_lines_all ail
358: Where ail.invoice_id = p_invoice_id
359: And ail.line_number = p_line_number;
360: -- Bug 7187973 Ends
361:

Line 378: From ap_invoice_lines_all ail

374: NVL( ail.quantity_invoiced,0)
375: Into l_original_amount,
376: l_corrected_original_amt,
377: l_original_qty_invoiced
378: From ap_invoice_lines_all ail
379: Where ail.invoice_id = p_invoice_id
380: And ail.line_number = p_line_number; */
381:
382: -- Bug 7187973 Ends

Line 415: ap_invoice_lines_all ail

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'
419: And aid.invoice_id=ail.invoice_id; --bug 5015014

Line 440: From ap_invoice_lines_all ail

436: */
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',

Line 953: ap_invoice_lines_all ail

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'
957: And aid.invoice_id=ail.invoice_id; --bug5015014

Line 1000: From ap_invoice_lines_all

996: --checked as those were already filtered invoice line number LOV.
997:
998: Select amount
999: Into l_line_amt
1000: From ap_invoice_lines_all
1001: Where invoice_id = p_invoice_id
1002: And line_number = p_line_number;
1003:
1004: Select Nvl(Sum(ail.amount), 0)

Line 1006: From ap_invoice_lines_all ail

1002: And line_number = p_line_number;
1003:
1004: Select Nvl(Sum(ail.amount), 0)
1005: Into l_existing_corr_amt
1006: From ap_invoice_lines_all ail
1007: Where ail.corrected_inv_id = p_invoice_id
1008: And ail.corrected_line_number = p_line_number
1009: And ail.match_type = 'LINE_CORRECTION'
1010: --Added below conditions for bug#10410133

Line 1033: From ap_invoice_lines_all

1029: Begin
1030:
1031: Select nvl(quantity_invoiced,0)
1032: Into l_line_qty
1033: From ap_invoice_lines_all
1034: Where invoice_id = p_invoice_id
1035: And line_number = p_line_number;
1036:
1037: Select Nvl(Sum(ail.quantity_invoiced), 0)

Line 1039: From ap_invoice_lines_all ail

1035: And line_number = p_line_number;
1036:
1037: Select Nvl(Sum(ail.quantity_invoiced), 0)
1038: Into l_existing_corr_qty
1039: From ap_invoice_lines_all ail
1040: Where ail.corrected_inv_id = p_invoice_id
1041: And ail.corrected_line_number = p_line_number
1042: And ail.match_type = 'LINE_CORRECTION';
1043:

Line 1062: From ap_invoice_lines_all ail

1058: Begin
1059:
1060: Select Nvl(Sum(amount), 0)
1061: Into l_invoice_amt
1062: From ap_invoice_lines_all ail
1063: Where ail.invoice_id = p_invoice_id
1064: And NVL(ail.match_type,'NOT_MATCHED') = 'NOT_MATCHED'
1065: --Added below conditions for bug#10410133
1066: And nvl(ail.discarded_flag, 'N') <> 'Y'

Line 1081: From ap_invoice_lines_all ail

1077: and aid.po_distribution_id is not null);
1078:
1079: Select Nvl(Sum(ail.amount), 0)
1080: Into l_existing_corr_amt
1081: From ap_invoice_lines_all ail
1082: Where ail.corrected_inv_id = p_invoice_id
1083: And ail.match_type = 'LINE_CORRECTION'
1084: --Added below conditions for bug#10410133
1085: And nvl(discarded_flag, 'N') <> 'Y'

Line 1892: FROM ap_invoice_lines_all ail,

1888: l_unit_meas_lookup_code,
1889: l_retained_amount,
1890: l_match_type,
1891: l_po_distribution_id
1892: FROM ap_invoice_lines_all ail,
1893: ap_invoices ai
1894: WHERE ai.invoice_id = p_invoice_id
1895: AND ail.invoice_id = ai.invoice_id
1896: AND ail.line_number = p_invoice_line_number;