eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QRM_PA_AGGREGATION_P dependencies on XTR_SPOT_RATES

Line 4494: FROM xtr_spot_rates

4490: usd_base_curr_offer_rate ask_rate,
4491: 1/usd_base_curr_offer_rate bid_rate_base,
4492: 1/usd_base_curr_bid_rate ask_rate_base,
4493: currency
4494: FROM xtr_spot_rates
4495: WHERE (rate_date, currency) IN (SELECT MAX(rate_date), currency
4496: FROM xtr_spot_rates
4497: WHERE currency IN (p_base_ccy, p_contra_ccy)
4498: AND currency <> 'USD'

Line 4496: FROM xtr_spot_rates

4492: 1/usd_base_curr_bid_rate ask_rate_base,
4493: currency
4494: FROM xtr_spot_rates
4495: WHERE (rate_date, currency) IN (SELECT MAX(rate_date), currency
4496: FROM xtr_spot_rates
4497: WHERE currency IN (p_base_ccy, p_contra_ccy)
4498: AND currency <> 'USD'
4499: AND trunc(rate_date) <= trunc(p_spot_date)
4500: GROUP BY currency);