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.FA_ASSET_DESC_PUB dependencies on FA_MC_BOOKS_RATES

Line 2312: from fa_mc_books_rates br1

2308: else
2309: -- get average rate from the latest transaction record
2310: select br1.avg_exchange_rate
2311: into l_rate
2312: from fa_mc_books_rates br1
2313: where br1.asset_id = l_mrc_asset_hdr_rec.asset_id
2314: and br1.book_type_code = l_mrc_asset_hdr_rec.book_type_code
2315: and br1.set_of_books_id =
2316: l_mrc_asset_hdr_rec.set_of_books_id

Line 2320: from fa_mc_books_rates br2

2316: l_mrc_asset_hdr_rec.set_of_books_id
2317: and br1.transaction_header_id =
2318: (
2319: select max(br2.transaction_header_id)
2320: from fa_mc_books_rates br2
2321: where br2.asset_id = l_mrc_asset_hdr_rec.asset_id
2322: and br2.book_type_code =
2323: l_mrc_asset_hdr_rec.book_type_code
2324: and br2.set_of_books_id =

Line 2396: from fa_mc_books_rates br1

2392:
2393: -- get average rate from the latest transaction record
2394: select br1.avg_exchange_rate
2395: into l_rate
2396: from fa_mc_books_rates br1
2397: where br1.asset_id = l_mrc_asset_hdr_rec.asset_id
2398: and br1.book_type_code = l_mrc_asset_hdr_rec.book_type_code
2399: and br1.set_of_books_id =
2400: l_mrc_asset_hdr_rec.set_of_books_id

Line 2404: from fa_mc_books_rates br2

2400: l_mrc_asset_hdr_rec.set_of_books_id
2401: and br1.transaction_header_id =
2402: (
2403: select max(br2.transaction_header_id)
2404: from fa_mc_books_rates br2
2405: where br2.asset_id = l_mrc_asset_hdr_rec.asset_id
2406: and br2.book_type_code =
2407: l_mrc_asset_hdr_rec.book_type_code
2408: and br2.set_of_books_id =