APPS.FV_FACTS_TRX_REGISTER dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1833: FROM ap_invoice_distributions_all aid

1829: SELECT aid.invoice_id,
1830: aid.distribution_line_number
1831: INTO l_reference_2,
1832: l_reference_8
1833: FROM ap_invoice_distributions_all aid
1834: WHERE aid.invoice_distribution_id = l_source_distribution_id_num_1;
1835: EXCEPTION
1836: WHEN NO_DATA_FOUND THEN
1837: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1) '||l_source_distribution_id_num_1);

Line 1845: FROM ap_invoice_distributions_all aid

1841: SELECT aid.invoice_id,
1842: aid.distribution_line_number
1843: INTO l_reference_2,
1844: l_reference_8
1845: FROM ap_invoice_distributions_all aid
1846: WHERE aid.invoice_distribution_id = l_applied_to_dist_id_num_1;
1847: EXCEPTION
1848: WHEN NO_DATA_FOUND THEN
1849: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1a) '||l_applied_to_dist_id_num_1);

Line 1860: ap_invoice_distributions_all aid,

1856: INTO l_reference_3,
1857: l_reference_4,
1858: l_reference_6
1859: FROM ap_payment_hist_dists aphd,
1860: ap_invoice_distributions_all aid,
1861: ap_invoice_payments_all aip
1862: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
1863: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1864: AND aip.invoice_payment_id = aphd.invoice_payment_id;

Line 1953: ap_invoice_distributions_all aid,

1949: INTO l_reference_3,
1950: l_reference_4,
1951: l_reference_6
1952: FROM ap_payment_hist_dists aphd,
1953: ap_invoice_distributions_all aid,
1954: ap_invoice_payments_all aip
1955: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
1956: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1957: AND aip.invoice_payment_id = aphd.invoice_payment_id;