APPS.FV_FACTS_TRX_REGISTER dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1764: FROM ap_invoice_distributions_all aid

1760: SELECT aid.invoice_id,
1761: aid.distribution_line_number
1762: INTO l_reference_2,
1763: l_reference_8
1764: FROM ap_invoice_distributions_all aid
1765: WHERE aid.invoice_distribution_id = l_source_distribution_id_num_1;
1766: EXCEPTION
1767: WHEN NO_DATA_FOUND THEN
1768: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1) '||l_source_distribution_id_num_1);

Line 1776: FROM ap_invoice_distributions_all aid

1772: SELECT aid.invoice_id,
1773: aid.distribution_line_number
1774: INTO l_reference_2,
1775: l_reference_8
1776: FROM ap_invoice_distributions_all aid
1777: WHERE aid.invoice_distribution_id = l_applied_to_dist_id_num_1;
1778: EXCEPTION
1779: WHEN NO_DATA_FOUND THEN
1780: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1a) '||l_applied_to_dist_id_num_1);

Line 1791: ap_invoice_distributions_all aid,

1787: INTO l_reference_3,
1788: l_reference_4,
1789: l_reference_6
1790: FROM ap_payment_hist_dists aphd,
1791: ap_invoice_distributions_all aid,
1792: ap_invoice_payments_all aip
1793: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
1794: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1795: AND aip.invoice_payment_id = aphd.invoice_payment_id;

Line 1873: ap_invoice_distributions_all aid,

1869: INTO l_reference_3,
1870: l_reference_4,
1871: l_reference_6
1872: FROM ap_payment_hist_dists aphd,
1873: ap_invoice_distributions_all aid,
1874: ap_invoice_payments_all aip
1875: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
1876: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1877: AND aip.invoice_payment_id = aphd.invoice_payment_id;