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_ADDITIONS_B

Line 494: FROM fa_category_book_defaults, fa_additions_b a

490: l_ret_prorate_convention,
491: l_use_stl_retirements_flag,
492: l_stl_method_code,
493: l_stl_life_in_months
494: FROM fa_category_book_defaults, fa_additions_b a
495: WHERE book_type_code = l_asset_hdr_rec.book_type_code
496: and category_id = a.asset_category_id
497: and a.asset_id = l_asset_hdr_rec.asset_id
498: and l_asset_fin_rec.Date_Placed_In_Service between start_dpis and

Line 1295: FROM fa_category_book_defaults, fa_additions_b a

1291: l_ret_prorate_convention,
1292: l_use_stl_retirements_flag,
1293: l_stl_method_code,
1294: l_stl_life_in_months
1295: FROM fa_category_book_defaults, fa_additions_b a
1296: WHERE book_type_code = l_asset_hdr_rec.book_type_code
1297: and category_id = a.asset_category_id
1298: and a.asset_id = l_asset_hdr_rec.asset_id
1299: and l_asset_fin_rec.Date_Placed_In_Service between start_dpis and

Line 2080: from fa_additions_b fad

2076: select cbd.percent_salvage_value
2077: ,cbd.use_deprn_limits_flag
2078: ,cbd.allowed_deprn_limit
2079: ,cbd.special_deprn_limit_amount
2080: from fa_additions_b fad
2081: ,fa_category_book_defaults cbd
2082: where fad.asset_id = p_asset_id
2083: and cbd.category_id = fad.asset_category_id
2084: and cbd.book_type_code = p_book_type_code