APPS.AP_RECT_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1256: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid

1252: 'ITEM_TO_SERVICE_RECEIPT',0,
1253: NVL(aid.corrected_quantity, 0) +
1254: NVL(aid.quantity_invoiced, 0))),0)
1255: INTO l_billed_txn_qty
1256: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid
1257: WHERE aid.PO_DISTRIBUTION_ID = l_po_distribution_id;
1258: END IF;
1259:
1260: l_billed_txn_qty := nvl(l_billed_txn_qty,0);

Line 3864: FROM ap_invoice_distributions_all

3860: /*
3861: BEGIN
3862: SELECT nvl(sum(amount),0) -- Bug 5629985. Added the NVL
3863: INTO l_price_variance
3864: FROM ap_invoice_distributions_all
3865: WHERE invoice_id = x_corrected_invoice_id
3866: AND invoice_line_number = x_corrected_line_number
3867: AND line_type_lookup_code = 'IPV';
3868: EXCEPTION