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

Line 496: FROM fa_mc_book_controls fmcbc,fa_book_controls fbc, fa_retirements retire, fa_mc_books bk

492: retire.transaction_header_id_in,
493: bk.group_asset_id,
494: bk.member_rollup_flag,
495: bk.tracking_method
496: FROM fa_mc_book_controls fmcbc,fa_book_controls fbc, fa_retirements retire, fa_mc_books bk
497: WHERE
498: retire.retirement_id = RET.retirement_id
499: AND retire.units is not null
500: AND fbc.distribution_source_book = retire.book_type_code

Line 1636: from fa_mc_books

1632: else -- for reporting
1633: -- MRC
1634: /*select nvl(rate_in_use,0)
1635: into l_rate_in_use
1636: from fa_mc_books
1637: where asset_id = ret.asset_id
1638: and book_type_code = ret.book
1639: and set_of_books_id = ret.set_of_books_id
1640: and transaction_header_id_out is null;*/

Line 1820: INSERT into fa_mc_books

1816: WHERE asset_id = ret.asset_id
1817: AND book_type_code = ret.book
1818: AND transaction_header_id_out = h_rethdrout;
1819: else -- for reporting
1820: INSERT into fa_mc_books
1821: (book_type_Code, asset_id, date_placed_in_service,
1822: transaction_header_id_in, date_effective, transaction_header_id_out,
1823: date_ineffective, deprn_start_date, deprn_method_code,
1824: life_in_months, rate_adjustment_factor, adjusted_cost, cost,

Line 1936: FROM fa_mc_books

1932: , retirement_deprn_option
1933: , p_asset_fin_rec_new.adjusted_recoverable_cost /* fix for bug 3149457 */
1934: , cash_generating_unit_id
1935: , set_of_books_id
1936: FROM fa_mc_books
1937: WHERE asset_id = ret.asset_id
1938: AND book_type_code = ret.book
1939: AND set_of_books_id = ret.set_of_books_id
1940: AND transaction_header_id_out = h_rethdrout;

Line 1972: /*update fa_mc_books

1968: end if;
1969:
1970: else -- For Reporting
1971: -- TO DO -- MRC
1972: /*update fa_mc_books
1973: set rate_in_use = l_rate_in_use
1974: where asset_id = ret.asset_id
1975: and book_type_code = ret.Book
1976: and set_of_books_id = ret.set_of_books_id

Line 5136: FROM fa_mc_books

5132: ELSE
5133:
5134: SELECT group_asset_id
5135: INTO l_cur_grp_id
5136: FROM fa_mc_books
5137: WHERE asset_id = ret.asset_id
5138: AND book_type_code = ret.book
5139: AND set_of_books_id = ret.set_of_books_id
5140: AND transaction_header_id_out IS NULL;