DBA Data[Home] [Help]

APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on AR_DISTRIBUTIONS_ALL

Line 1711: ar_distributions_all ard,

1707: , ard.line_id -- ref_line_id
1708: , ard.tax_code_id
1709: , ard.location_segment_id
1710: FROM ar_adjustments_all adj,
1711: ar_distributions_all ard,
1712: ar_system_parameters_all ars,
1713: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1714: MAX(to_currency) invoice_currency_code
1715: FROM ra_ar_gt

Line 2183: -- FROM ar_distributions_all

2179: -- we are proposing no tied by to original line
2180: -- in new transaction the ref_line_id will be present
2181: -- (SELECT MAX(line_id) line_id,
2182: -- source_id source_id
2183: -- FROM ar_distributions_all
2184: -- WHERE source_table = 'ADJ'
2185: -- GROUP BY source_id) ard,
2186: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
2187: MAX(to_currency) invoice_currency_code