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 2242: from fa_mc_books_rates br1

2238: else
2239: -- get average rate from the latest transaction record
2240: select br1.avg_exchange_rate
2241: into l_rate
2242: from fa_mc_books_rates br1
2243: where br1.asset_id = l_mrc_asset_hdr_rec.asset_id
2244: and br1.book_type_code = l_mrc_asset_hdr_rec.book_type_code
2245: and br1.set_of_books_id =
2246: l_mrc_asset_hdr_rec.set_of_books_id

Line 2250: from fa_mc_books_rates br2

2246: l_mrc_asset_hdr_rec.set_of_books_id
2247: and br1.transaction_header_id =
2248: (
2249: select max(br2.transaction_header_id)
2250: from fa_mc_books_rates br2
2251: where br2.asset_id = l_mrc_asset_hdr_rec.asset_id
2252: and br2.book_type_code =
2253: l_mrc_asset_hdr_rec.book_type_code
2254: and br2.set_of_books_id =

Line 2324: from fa_mc_books_rates br1

2320: else
2321: -- get average rate from the latest transaction record
2322: select br1.avg_exchange_rate
2323: into l_rate
2324: from fa_mc_books_rates br1
2325: where br1.asset_id = l_mrc_asset_hdr_rec.asset_id
2326: and br1.book_type_code = l_mrc_asset_hdr_rec.book_type_code
2327: and br1.set_of_books_id =
2328: l_mrc_asset_hdr_rec.set_of_books_id

Line 2332: from fa_mc_books_rates br2

2328: l_mrc_asset_hdr_rec.set_of_books_id
2329: and br1.transaction_header_id =
2330: (
2331: select max(br2.transaction_header_id)
2332: from fa_mc_books_rates br2
2333: where br2.asset_id = l_mrc_asset_hdr_rec.asset_id
2334: and br2.book_type_code =
2335: l_mrc_asset_hdr_rec.book_type_code
2336: and br2.set_of_books_id =