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

1896: -- get average rate from the latest transaction record
1897: -- when cost is zero
1898: select br1.avg_exchange_rate
1899: into l_rate
1900: from fa_mc_books_rates br1
1901: where br1.asset_id = l_asset_hdr_rec.asset_id
1902: and br1.book_type_code = l_asset_hdr_rec.book_type_code
1903: and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
1904: and br1.transaction_header_id =

Line 1906: from fa_mc_books_rates br2

1902: and br1.book_type_code = l_asset_hdr_rec.book_type_code
1903: and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
1904: and br1.transaction_header_id =
1905: (select max(br2.transaction_header_id)
1906: from fa_mc_books_rates br2
1907: where br2.asset_id = l_asset_hdr_rec.asset_id
1908: and br2.book_type_code = l_asset_hdr_rec.book_type_code
1909: and br2.set_of_books_id = l_asset_hdr_rec.set_of_books_id);
1910: *****/

Line 2269: select /+ INDEX (bk fa_mc_books_n1)/

2265: and nvl(ce.end_date, bk.date_placed_in_service)
2266: and bk.ceiling_name = lk.lookup_code(+)
2267: and p_mrc_sob_type_code = 'P'
2268: UNION
2269: select /*+ INDEX (bk fa_mc_books_n1)*/
2270: bk.transaction_header_id_in
2271: ,bk.Allowed_Deprn_Limit_Amount
2272: ,bk.date_effective
2273: ,itc.basis_reduction_rate

Line 2276: from fa_mc_books bk

2272: ,bk.date_effective
2273: ,itc.basis_reduction_rate
2274: ,ce.limit
2275: ,lk.lookup_type
2276: from fa_mc_books bk
2277: ,fa_itc_rates itc
2278: ,fa_ceilings ce
2279: ,fa_lookups_b lk
2280: where bk.asset_id = p_asset_id

Line 3979: from fa_mc_books