DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on AP_INVOICE_LINES

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 463: FROM ap_invoice_lines

459: P_Calling_Sequence IN VARCHAR2) IS
460:
461: CURSOR Invoice_Lines_Cur IS
462: SELECT *
463: FROM ap_invoice_lines
464: WHERE invoice_id = p_invoice_id
465: AND line_number = p_invoice_line_number;
466:
467: l_invoice_line_rec ap_invoice_lines%ROWTYPE;

Line 467: l_invoice_line_rec ap_invoice_lines%ROWTYPE;

463: FROM ap_invoice_lines
464: WHERE invoice_id = p_invoice_id
465: AND line_number = p_invoice_line_number;
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;

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 1259: ap_invoice_lines ail,

1255: AP_Prepay_Utils_Pkg.Get_Ln_Prep_Amt_Remain_Recoup(
1256: ai.invoice_id,ail.line_number) prepay_amount_remaining,
1257: max(aip.accounting_date) prepayment_payment_date
1258: FROM ap_invoices ai,
1259: ap_invoice_lines ail,
1260: po_line_locations pll,
1261: ap_invoice_payments aip
1262: WHERE ai.invoice_id = ail.invoice_id
1263: AND ail.po_line_id = p_po_line_id

Line 1506: ap_invoice_lines ail

1502: SELECT sum(aid.amount)
1503: INTO l_recouped_tax_amount
1504: FROM ap_invoice_distributions aid,
1505: ap_invoice_distributions aid1,
1506: ap_invoice_lines ail
1507: WHERE aid.invoice_id = p_invoice_id
1508: AND aid.invoice_line_number = p_invoice_line_number
1509: AND ail.invoice_id = aid.invoice_id
1510: AND ail.line_number = aid.invoice_line_number

Line 1596: ap_invoice_lines ail

1592:
1593: SELECT sum(aid.amount)
1594: INTO l_recouped_amount
1595: FROM ap_invoice_distributions aid,
1596: ap_invoice_lines ail
1597: WHERE aid.invoice_id = p_invoice_id
1598: AND aid.invoice_line_number = p_invoice_line_number
1599: AND ail.invoice_id = aid.invoice_id
1600: AND ail.line_number = aid.invoice_line_number

Line 1619: ap_invoice_lines ail

1615:
1616: SELECT sum(aid.amount)
1617: INTO l_recouped_amount
1618: FROM ap_invoice_distributions aid,
1619: ap_invoice_lines ail
1620: WHERE aid.invoice_id = p_invoice_id
1621: AND ail.invoice_id = aid.invoice_id
1622: AND ail.line_number = aid.invoice_line_number
1623: AND ail.line_type_lookup_code IN ('ITEM', 'RETAINAGE RELEASE')

Line 1757: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;

1753: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
1754: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;
1755: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1756: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1757: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1758: l_retained_amount AP_INVOICE_LINES.RETAINED_AMOUNT%TYPE;
1759: l_match_type AP_INVOICE_LINES.MATCH_TYPE%TYPE;
1760: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1761: l_match_mode VARCHAR2(30);

Line 1758: l_retained_amount AP_INVOICE_LINES.RETAINED_AMOUNT%TYPE;

1754: l_matching_basis PO_LINE_LOCATIONS.MATCHING_BASIS%TYPE;
1755: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1756: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1757: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1758: l_retained_amount AP_INVOICE_LINES.RETAINED_AMOUNT%TYPE;
1759: l_match_type AP_INVOICE_LINES.MATCH_TYPE%TYPE;
1760: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1761: l_match_mode VARCHAR2(30);
1762:

Line 1759: l_match_type AP_INVOICE_LINES.MATCH_TYPE%TYPE;

1755: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1756: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1757: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1758: l_retained_amount AP_INVOICE_LINES.RETAINED_AMOUNT%TYPE;
1759: l_match_type AP_INVOICE_LINES.MATCH_TYPE%TYPE;
1760: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1761: l_match_mode VARCHAR2(30);
1762:
1763: l_ordered_po_qty NUMBER;

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;