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_RETIREMENT_PUB dependencies on FA_MC_BOOKS

Line 1720: from fa_mc_books_rates br1

1716: -- get average rate from the latest transaction record
1717: -- when cost is zero
1718: select br1.avg_exchange_rate
1719: into l_rate
1720: from fa_mc_books_rates br1
1721: where br1.asset_id = l_asset_hdr_rec.asset_id
1722: and br1.book_type_code = l_asset_hdr_rec.book_type_code
1723: and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
1724: and br1.transaction_header_id =

Line 1726: from fa_mc_books_rates br2

1722: and br1.book_type_code = l_asset_hdr_rec.book_type_code
1723: and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
1724: and br1.transaction_header_id =
1725: (select max(br2.transaction_header_id)
1726: from fa_mc_books_rates br2
1727: where br2.asset_id = l_asset_hdr_rec.asset_id
1728: and br2.book_type_code = l_asset_hdr_rec.book_type_code
1729: and br2.set_of_books_id = l_asset_hdr_rec.set_of_books_id);
1730: *****/

Line 2056: from fa_mc_books bk

2052: ,bk.date_effective
2053: ,itc.basis_reduction_rate
2054: ,ce.limit
2055: ,lk.lookup_type
2056: from fa_mc_books bk
2057: ,fa_itc_rates itc
2058: ,fa_ceilings ce
2059: ,fa_lookups_b lk
2060: where bk.asset_id = p_asset_id

Line 3694: from fa_mc_books

3690: and retirement_id = c_ret_id
3691: and c_reporting_flag <> 'R'
3692: union
3693: select cost
3694: from fa_mc_books
3695: where asset_id = c_asset_id
3696: and book_type_code = c_book
3697: and retirement_id = c_ret_id
3698: and c_reporting_flag = 'R';