APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

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

12474: l_price_cor_po_header_id,
12475: l_price_cor_po_line_id,
12476: l_price_cor_po_line_loc_id,
12477: l_price_cor_po_distribution_id
12478: FROM ap_invoices ai, ap_invoice_lines ail, ap_invoice_distributions aid
12479: WHERE ai.invoice_num = p_invoice_lines_rec.price_correct_inv_num
12480: AND ail.invoice_id = ai.invoice_id
12481: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
12482: AND aid.invoice_id = ail.invoice_id

Line 12603: FROM ap_invoice_distributions

12599: --distribution matched to this po distribution
12600:
12601: SELECT 'Y'
12602: INTO l_pc_inv_valid
12603: FROM ap_invoice_distributions
12604: WHERE invoice_id = l_price_correct_inv_id
12605: AND invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num
12606: AND po_distribution_id = l_po_distribution_id;
12607:

Line 12649: FROM ap_invoice_distributions

12645: --distribution matched to one of the po dists for this shipment
12646:
12647: SELECT 'Y'
12648: INTO l_pc_inv_valid
12649: FROM ap_invoice_distributions
12650: WHERE invoice_id = l_price_correct_inv_id
12651: AND invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num
12652: AND po_distribution_id IN (
12653: SELECT po_distribution_id

Line 13072: FROM ap_invoice_distributions

13068:
13069: IF l_total_quantity_invoiced > 0 then
13070:
13071: FOR pc_inv_dists IN (SELECT quantity_invoiced, amount, invoice_distribution_id
13072: FROM ap_invoice_distributions
13073: WHERE invoice_id = l_price_correct_inv_id
13074: AND invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num)
13075:
13076: LOOP

Line 13082: FROM ap_invoice_distributions aid

13078: BEGIN
13079:
13080: SELECT sum(aid.amount)
13081: INTO l_correction_dist_amount
13082: FROM ap_invoice_distributions aid
13083: WHERE corrected_invoice_dist_id = pc_inv_dists.invoice_distribution_id
13084: GROUP BY corrected_invoice_dist_id ;
13085:
13086: EXCEPTION WHEN OTHERS THEN

Line 13245: FROM ap_invoice_distributions

13241: INTO l_total_amount_billed, l_total_quantity_billed
13242: FROM po_distributions
13243: WHERE line_location_id = l_po_line_location_id
13244: AND po_distribution_id IN (SELECT po_distribution_id
13245: FROM ap_invoice_distributions
13246: WHERE invoice_id = l_price_correct_inv_id
13247: AND invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num);
13248:
13249: --bugfix:5640388

Line 13319: FROM ap_invoice_distributions aid

13315: FROM po_distributions pod
13316: WHERE pod.line_location_id = l_po_line_location_id
13317: AND pod.po_distribution_id IN (
13318: SELECT aid.po_distribution_id
13319: FROM ap_invoice_distributions aid
13320: WHERE aid.invoice_id = l_price_correct_inv_id
13321: AND aid.invoice_line_number = p_invoice_lines_rec.price_correct_inv_line_num))
13322: LOOP
13323:

Line 13772: into ap_invoice_lines and ap_invoice_distributions*/

13768: p_invoice_lines_rec.match_type := 'PRICE_CORRECTION'; /* 5400087 */
13769: END IF;
13770:
13771: /*Bug8546486 Assigning the description fetched from PO to be inserted
13772: into ap_invoice_lines and ap_invoice_distributions*/
13773: IF (l_item_description IS NOT NULL) then
13774: IF (p_invoice_lines_rec.description IS NULL) then /* B 9569917 ... added IF condition */
13775: p_invoice_lines_rec.description := l_item_description;
13776: END IF;