[Home] [Help]
1846: l_distribution_count NUMBER := 0;
1847: l_sum_matched_qty NUMBER := 0;
1848: l_sum_matched_amt NUMBER := 0;
1849: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
1850: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1851: i NUMBER := 1;
1852: l_max_line_num
1853: ap_invoice_distributions.distribution_line_number%TYPE;
1854: l_matched_uom VARCHAR2(30);
1943: pll.matching_basis,
1944: aid1.invoice_id prepay_invoice_id,
1945: aid1.invoice_line_number prepay_line_number
1946: FROM ap_invoice_distributions_all AID ,
1947: po_line_locations pll,
1948: ap_invoice_distributions_all AID1
1949: WHERE aid.invoice_id = p_line_rec.invoice_id
1950: AND aid.invoice_line_number = p_line_rec.line_number
1951: --Contract Payments: Added the 'PREPAY' to the clause
1990: NVL(AID.corrected_quantity, 0) + NVL(AID.quantity_invoiced,0))) quantity
1991: from ap_invoice_lines_all ail
1992: ,ap_invoice_distributions_all aid
1993: ,po_distributions_all pod
1994: ,po_line_locations_all pll
1995: where ail.invoice_id = p_line_rec.invoice_id
1996: and ail.line_number = p_line_rec.line_number
1997: and ail.invoice_id = aid.invoice_id
1998: and ail.line_number = aid.invoice_line_number
4009: );
4010:
4011: END IF;
4012:
4013: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
4014: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4015: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4016: END IF;
4017: