[Home] [Help]
1791: l_distribution_count NUMBER := 0;
1792: l_sum_matched_qty NUMBER := 0;
1793: l_sum_matched_amt NUMBER := 0;
1794: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
1795: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1796: i NUMBER := 1;
1797: l_max_line_num
1798: ap_invoice_distributions.distribution_line_number%TYPE;
1799: l_matched_uom VARCHAR2(30);
1861: pll.matching_basis,
1862: aid1.invoice_id prepay_invoice_id,
1863: aid1.invoice_line_number prepay_line_number
1864: FROM ap_invoice_distributions_all AID ,
1865: po_line_locations pll,
1866: ap_invoice_distributions_all AID1
1867: WHERE aid.invoice_id = p_line_rec.invoice_id
1868: AND aid.invoice_line_number = p_line_rec.line_number
1869: --Contract Payments: Added the 'PREPAY' to the clause
1907: NVL(AID.corrected_quantity, 0) + NVL(AID.quantity_invoiced,0))) quantity
1908: from ap_invoice_lines_all ail
1909: ,ap_invoice_distributions_all aid
1910: ,po_distributions_all pod
1911: ,po_line_locations_all pll
1912: where ail.invoice_id = p_line_rec.invoice_id
1913: and ail.line_number = p_line_rec.line_number
1914: and ail.invoice_id = aid.invoice_id
1915: and ail.line_number = aid.invoice_line_number
2395: );
2396:
2397: END IF;
2398:
2399: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
2400: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2401: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2402: END IF;
2403: