APPS.FV_FACTS_TRX_REGISTER dependencies on AP_INVOICE_DISTRIBUTIONS

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;

Line 3176: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;

3172: l_check_date Date;
3173: l_inv_payment_id Number;
3174: l_gl_date Date;
3175: l_rec_public_law_code VARCHAR2(150);
3176: l_parent_reversal_id ap_invoice_distributions.parent_reversal_id%TYPE;
3177: l_event_type_code ap_accounting_events.event_type_code%TYPE;
3178: l_receipt_hist_status ar_cash_receipt_history_all.status%TYPE;
3179: l_dummy_rev_exists VARCHAR2(1);
3180:

Line 3663: FROM ap_invoice_distributions a

3659: BEGIN
3660: l_parent_reversal_id := NULL;
3661: SELECT a.parent_reversal_id
3662: INTO l_parent_reversal_id
3663: FROM ap_invoice_distributions a
3664: WHERE a.invoice_id = p_reference2
3665: AND a.distribution_line_number = p_reference3;
3666: EXCEPTION
3667: WHEN NO_DATA_FOUND THEN