APPS.AP_MATCHING_UTILS_PKG dependencies on AP_INVOICE_LINES_ALL

Line 304: From ap_invoice_lines_all ail

300: * bug 7118571 - added ap_invoices_all to the query to consider non-cancelled invoices only
301: */
302: Select Nvl(Sum(ail.quantity_invoiced), 0)
303: Into l_existing_corr_qty
304: From ap_invoice_lines_all ail
305: ,ap_invoices_all ai
306: Where ail.corrected_inv_id = p_invoice_id
307: And ail.corrected_line_number = p_line_number
308: And ail.match_type = 'QTY_CORRECTION'

Line 334: From ap_invoice_lines_all ail

330: * bug 7118571 - added ap_invoices_all to the query to consider non-cancelled invoices only
331: */
332: Select Nvl(Sum(ail.unit_price * ail.quantity_invoiced), 0)
333: Into l_correction_amount
334: From ap_invoice_lines_all ail
335: ,ap_invoices_all ai
336: Where ail.corrected_inv_id = p_invoice_id
337: And ail.corrected_line_number = p_line_number
338: And ail.match_type = 'PRICE_CORRECTION'

Line 345: From ap_invoice_lines_all ail

341:
342: Select (NVL(ail.unit_price, 0) * NVL(ail.quantity_invoiced, 0)),
343: NVL( ail.quantity_invoiced,0)
344: Into l_original_amount, l_original_qty_invoiced
345: From ap_invoice_lines_all ail
346: Where ail.invoice_id = p_invoice_id
347: And ail.line_number = p_line_number;
348:
349: l_existing_corr_qty := Get_Correction_Quantity(p_invoice_id, p_line_number);

Line 375: ap_invoice_lines_all ail

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

Line 400: From ap_invoice_lines_all ail

396: */
397:
398: Select Nvl(Sum(ail.amount), 0)
399: Into l_existing_corr_amt
400: From ap_invoice_lines_all ail
401: ,ap_invoices_all ai
402: Where ail.corrected_inv_id = p_invoice_id
403: And ail.corrected_line_number = p_line_number
404: And ail.match_type In ( 'QTY_CORRECTION', 'PRICE_CORRECTION',

Line 910: ap_invoice_lines_all ail

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

Line 954: From ap_invoice_lines_all

950: Begin
951:
952: Select amount
953: Into l_line_amt
954: From ap_invoice_lines_all
955: Where invoice_id = p_invoice_id
956: And line_number = p_line_number;
957:
958: Select Nvl(Sum(ail.amount), 0)

Line 960: From ap_invoice_lines_all ail

956: And line_number = p_line_number;
957:
958: Select Nvl(Sum(ail.amount), 0)
959: Into l_existing_corr_amt
960: From ap_invoice_lines_all ail
961: Where ail.corrected_inv_id = p_invoice_id
962: And ail.corrected_line_number = p_line_number
963: And ail.match_type = 'LINE_CORRECTION';
964:

Line 984: From ap_invoice_lines_all

980: Begin
981:
982: Select nvl(quantity_invoiced,0)
983: Into l_line_qty
984: From ap_invoice_lines_all
985: Where invoice_id = p_invoice_id
986: And line_number = p_line_number;
987:
988: Select Nvl(Sum(ail.quantity_invoiced), 0)

Line 990: From ap_invoice_lines_all ail

986: And line_number = p_line_number;
987:
988: Select Nvl(Sum(ail.quantity_invoiced), 0)
989: Into l_existing_corr_qty
990: From ap_invoice_lines_all ail
991: Where ail.corrected_inv_id = p_invoice_id
992: And ail.corrected_line_number = p_line_number
993: And ail.match_type = 'LINE_CORRECTION';
994:

Line 1013: From ap_invoice_lines_all

1009: Begin
1010:
1011: Select Nvl(Sum(amount), 0)
1012: Into l_invoice_amt
1013: From ap_invoice_lines_all
1014: Where invoice_id = p_invoice_id
1015: And match_type = 'NOT_MATCHED';
1016:
1017: Select Nvl(Sum(ail.amount), 0)

Line 1019: From ap_invoice_lines_all ail

1015: And match_type = 'NOT_MATCHED';
1016:
1017: Select Nvl(Sum(ail.amount), 0)
1018: Into l_existing_corr_amt
1019: From ap_invoice_lines_all ail
1020: Where ail.corrected_inv_id = p_invoice_id
1021: And ail.match_type = 'LINE_CORRECTION';
1022:
1023: l_avail_corr_amt := l_invoice_amt - abs(l_existing_corr_amt);

Line 1824: FROM ap_invoice_lines_all ail,

1820: l_unit_meas_lookup_code,
1821: l_retained_amount,
1822: l_match_type,
1823: l_po_distribution_id
1824: FROM ap_invoice_lines_all ail,
1825: ap_invoices ai
1826: WHERE ai.invoice_id = p_invoice_id
1827: AND ail.invoice_id = ai.invoice_id
1828: AND ail.line_number = p_invoice_line_number;