[Home] [Help]
328: count(*) over () count_recs --Bug#14604983
329: FROM rcv_transactions rt,
330: ap_invoice_distributions d,
331: ap_invoices i,
332: ap_invoice_lines l,
333: mtl_units_of_measure muom
334: WHERE l.line_type_lookup_code IN ('ITEM', 'MISCELLANEOUS', 'FREIGHT', 'TAX')
335: AND d.match_status_flag = p_match_status_flag --Bug#14604983
336: AND rt.lcm_shipment_line_id IS NOT NULL
457: END IF;
458:
459: IF c_distr_rec.line_type = 'ITEM' OR c_distr_rec.correction_type = 'ITEM' THEN
460: -- The distribution cursor does not get IPV lines
461: -- To get the exact qty and amt we access the ap_invoice_lines
462: l_matches_int_tbl(i).charge_line_type_id := NULL;
463: l_matches_int_tbl(i).matched_qty := l_quantity_invoiced; --c_distr_rec.quantity_invoiced;
464: l_matches_int_tbl(i).matched_uom_code := c_distr_rec.uom_code;
465: l_matches_int_tbl(i).matched_amt := l_line_amount; --c_distr_rec.distr_amount;
487: p_var_value => c_distr_rec.correction_type
488: );
489: SELECT count(*)
490: INTO l_count_to_match_amt
491: FROM ap_invoice_lines_all l
492: WHERE l.invoice_id = p_invoice_id
493: AND l.line_type_lookup_code <> 'ITEM';
494:
495: IF l_count_to_match_amt < 2 THEN
538: ail.line_type_lookup_code
539: INTO l_par_cost_factor_id,
540: l_par_line_type_lookup_code
541: FROM ap_invoice_distributions aid,
542: ap_invoice_lines ail
543: WHERE aid.invoice_id = ail.invoice_id
544: AND aid.invoice_line_number = ail.line_number
545: AND aid.invoice_distribution_id = c_distr_rec.charge_applicable_to_dist_id
546: AND aid.invoice_id = c_distr_rec.invoice_id;