APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 11349: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid

11345: END IF;
11346:
11347: SELECT DISTINCT ai.invoice_id, ail.amount
11348: INTO l_price_correct_inv_id, l_base_match_amount
11349: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid
11350: WHERE ai.invoice_num = p_invoice_lines_rec.price_correct_inv_num
11351: AND ail.invoice_id = ai.invoice_id
11352: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
11353: AND aid.invoice_id = ail.invoice_id

Line 11444: FROM ap_invoice_distributions

11440: --distribution matched to this po distribution
11441:
11442: SELECT 'Y'
11443: INTO l_pc_inv_valid
11444: FROM ap_invoice_distributions
11445: WHERE invoice_id = l_price_correct_inv_id
11446: AND invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num
11447: AND po_distribution_id = l_po_distribution_id;
11448:

Line 11490: FROM ap_invoice_distributions

11486: --distribution matched to one of the po dists for this shipment
11487:
11488: SELECT 'Y'
11489: INTO l_pc_inv_valid
11490: FROM ap_invoice_distributions
11491: WHERE invoice_id = l_price_correct_inv_id
11492: AND invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num
11493: AND po_distribution_id IN (
11494: SELECT po_distribution_id

Line 11878: FROM ap_invoice_distributions

11874:
11875: IF l_total_quantity_invoiced > 0 then
11876:
11877: FOR pc_inv_dists IN (SELECT quantity_invoiced, amount, invoice_distribution_id
11878: FROM ap_invoice_distributions
11879: WHERE invoice_id = l_price_correct_inv_id
11880: AND invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num)
11881:
11882: LOOP

Line 11888: FROM ap_invoice_distributions aid

11884: BEGIN
11885:
11886: SELECT sum(aid.amount)
11887: INTO l_correction_dist_amount
11888: FROM ap_invoice_distributions aid
11889: WHERE corrected_invoice_dist_id = pc_inv_dists.invoice_distribution_id
11890: GROUP BY corrected_invoice_dist_id ;
11891:
11892: EXCEPTION WHEN OTHERS THEN

Line 12026: FROM ap_invoice_distributions

12022: INTO l_total_amount_billed, l_total_quantity_billed
12023: FROM po_distributions
12024: WHERE line_location_id = l_po_line_location_id
12025: AND po_distribution_id IN (SELECT po_distribution_id
12026: FROM ap_invoice_distributions
12027: WHERE invoice_id = l_price_correct_inv_id
12028: AND invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num);
12029:
12030: --bugfix:5640388

Line 12088: FROM ap_invoice_distributions aid

12084: FROM po_distributions pod
12085: WHERE pod.line_location_id = l_po_line_location_id
12086: AND pod.po_distribution_id IN (
12087: SELECT aid.po_distribution_id
12088: FROM ap_invoice_distributions aid
12089: WHERE aid.invoice_id = l_price_correct_inv_id
12090: AND aid.invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num))
12091: LOOP
12092: