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_MASSCP_PKG dependencies on FA_BOOKS

Line 803: from fa_books corp_bk,

799: -- if so, don't copy the addition
800:
801: select count(*)
802: into l_count
803: from fa_books corp_bk,
804: fa_deprn_periods dp,
805: fa_transaction_headers corp_th
806: where corp_bk.transaction_header_id_in = corp_th.transaction_header_id
807: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

Line 881: from fa_books

877: l_asset_fin_rec.group_asset_id,
878: l_asset_fin_rec.salvage_type,
879: l_asset_fin_rec.percent_salvage_value,
880: l_asset_fin_rec.salvage_value
881: from fa_books
882: where asset_id = p_asset_id
883: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
884: and transaction_header_id_in = p_corp_thid;
885:

Line 1228: fa_books corp_bk_new,

1224: tax_bk.group_asset_id
1225: from fa_asset_history ah,
1226: fa_transaction_headers corp_th,
1227: fa_additions_b ad,
1228: fa_books corp_bk_new,
1229: fa_books corp_bk_old,
1230: fa_books tax_bk
1231: where corp_th.transaction_header_id = p_corp_thid
1232: and corp_th.asset_id = ah.asset_id

Line 1229: fa_books corp_bk_old,

1225: from fa_asset_history ah,
1226: fa_transaction_headers corp_th,
1227: fa_additions_b ad,
1228: fa_books corp_bk_new,
1229: fa_books corp_bk_old,
1230: fa_books tax_bk
1231: where corp_th.transaction_header_id = p_corp_thid
1232: and corp_th.asset_id = ah.asset_id
1233: and ah.date_ineffective is null

Line 1230: fa_books tax_bk

1226: fa_transaction_headers corp_th,
1227: fa_additions_b ad,
1228: fa_books corp_bk_new,
1229: fa_books corp_bk_old,
1230: fa_books tax_bk
1231: where corp_th.transaction_header_id = p_corp_thid
1232: and corp_th.asset_id = ah.asset_id
1233: and ah.date_ineffective is null
1234: and ah.asset_type = 'CAPITALIZED'

Line 1980: fa_books corp_bk,

1976: corp_rt.reference_num,
1977: corp_rt.sold_to,
1978: corp_rt.trade_in_asset_id
1979: from fa_transaction_headers corp_th,
1980: fa_books corp_bk,
1981: fa_books tax_bk,
1982: fa_retirements corp_rt,
1983: fa_additions_b ad,
1984: fa_asset_history ah

Line 1981: fa_books tax_bk,

1977: corp_rt.sold_to,
1978: corp_rt.trade_in_asset_id
1979: from fa_transaction_headers corp_th,
1980: fa_books corp_bk,
1981: fa_books tax_bk,
1982: fa_retirements corp_rt,
1983: fa_additions_b ad,
1984: fa_asset_history ah
1985: where corp_th.transaction_header_id = p_corp_thid

Line 2938: from fa_books books,

2934: books.group_asset_id,
2935: books.date_placed_in_service,
2936: books.transaction_header_id_in,
2937: books.period_counter_fully_retired
2938: from fa_books books,
2939: fa_additions_b ad,
2940: fa_deprn_periods dp,
2941: fa_asset_history ah -- bug fix 5900321
2942: where books.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)

Line 2959: fa_books taxbk,

2955: and nvl(dp.period_counter,
2956: l_corp_period_rec.period_counter + 1) > l_corp_period_rec.period_counter
2957: and ad.asset_type in ('CAPITALIZED', 'GROUP')
2958: and ad.asset_id = books.asset_id) assets,
2959: fa_books taxbk,
2960: fa_category_book_defaults cbd
2961: where taxbk.asset_id(+) = assets.asset_id
2962: and taxbk.book_type_code(+) = p_book_type_code
2963: and taxbk.transaction_header_id_out(+) is null

Line 3051: fa_books corp_bk,

3047: corp_bk_old.group_asset_id old_group_asset_id,
3048: corp_bk.group_asset_id new_group_asset_id
3049: from fa_additions_b ad,
3050: fa_transaction_headers corp_th,
3051: fa_books corp_bk,
3052: fa_books corp_bk_old,
3053: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
3054: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
3055: and corp_th.transaction_type_code = trx.column_value

Line 3052: fa_books corp_bk_old,

3048: corp_bk.group_asset_id new_group_asset_id
3049: from fa_additions_b ad,
3050: fa_transaction_headers corp_th,
3051: fa_books corp_bk,
3052: fa_books corp_bk_old,
3053: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
3054: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
3055: and corp_th.transaction_type_code = trx.column_value
3056: and corp_th.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)

Line 3068: fa_books tax_bk,

3064: and corp_bk_old.asset_id(+) = corp_th.asset_id
3065: and corp_bk_old.book_type_code(+) = corp_th.book_type_code
3066: and corp_bk_old.transaction_header_id_out(+) = corp_th.transaction_header_id) assets,
3067: fa_transaction_headers tax_th,
3068: fa_books tax_bk,
3069: fa_category_book_defaults cbd
3070: where tax_th.book_type_code(+) = p_book_type_code
3071: and tax_th.asset_id(+) = assets.asset_id
3072: and tax_th.source_transaction_header_id(+) = assets.transaction_header_id