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_LOOKUPS_B

Line 2246: -- changed fa_lookups to fa_lookups_b for high-cost sql fix

2242: p_asset_id number;
2243: p_dpis date;
2244:
2245:
2246: -- changed fa_lookups to fa_lookups_b for high-cost sql fix
2247: CURSOR bk_cursor IS
2248: select bk.transaction_header_id_in
2249: ,bk.Allowed_Deprn_Limit_Amount
2250: ,bk.date_effective

Line 2257: ,fa_lookups_b lk

2253: ,lk.lookup_type
2254: from fa_books bk
2255: ,fa_itc_rates itc
2256: ,fa_ceilings ce
2257: ,fa_lookups_b lk
2258: where bk.asset_id = p_asset_id
2259: and bk.book_type_code = p_book_type_code
2260: and bk.date_ineffective is null
2261: and bk.itc_amount_id = itc.itc_amount_id(+)

Line 2279: ,fa_lookups_b lk

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
2281: and bk.book_type_code = p_book_type_code
2282: and bk.date_ineffective is null
2283: and bk.itc_amount_id = itc.itc_amount_id(+)