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 575: from fa_books corp_bk,

571: -- if so, don't copy the addition
572:
573: select count(*)
574: into l_count
575: from fa_books corp_bk,
576: fa_deprn_periods dp,
577: fa_transaction_headers corp_th
578: where corp_bk.transaction_header_id_in = corp_th.transaction_header_id
579: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

Line 653: from fa_books

649: l_asset_fin_rec.group_asset_id,
650: l_asset_fin_rec.salvage_type,
651: l_asset_fin_rec.percent_salvage_value,
652: l_asset_fin_rec.salvage_value
653: from fa_books
654: where asset_id = p_asset_id
655: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
656: and transaction_header_id_in = p_corp_thid;
657:

Line 974: fa_books corp_bk_new,

970: tax_bk.group_asset_id
971: from fa_asset_history ah,
972: fa_transaction_headers corp_th,
973: fa_additions_b ad,
974: fa_books corp_bk_new,
975: fa_books corp_bk_old,
976: fa_books tax_bk
977: where corp_th.transaction_header_id = p_corp_thid
978: and corp_th.asset_id = ah.asset_id

Line 975: fa_books corp_bk_old,

971: from fa_asset_history ah,
972: fa_transaction_headers corp_th,
973: fa_additions_b ad,
974: fa_books corp_bk_new,
975: fa_books corp_bk_old,
976: fa_books tax_bk
977: where corp_th.transaction_header_id = p_corp_thid
978: and corp_th.asset_id = ah.asset_id
979: and ah.date_ineffective is null

Line 976: fa_books tax_bk

972: fa_transaction_headers corp_th,
973: fa_additions_b ad,
974: fa_books corp_bk_new,
975: fa_books corp_bk_old,
976: fa_books tax_bk
977: where corp_th.transaction_header_id = p_corp_thid
978: and corp_th.asset_id = ah.asset_id
979: and ah.date_ineffective is null
980: and ah.asset_type = 'CAPITALIZED'

Line 1686: fa_books corp_bk,

1682: corp_rt.reference_num,
1683: corp_rt.sold_to,
1684: corp_rt.trade_in_asset_id
1685: from fa_transaction_headers corp_th,
1686: fa_books corp_bk,
1687: fa_books tax_bk,
1688: fa_retirements corp_rt,
1689: fa_additions_b ad,
1690: fa_asset_history ah

Line 1687: fa_books tax_bk,

1683: corp_rt.sold_to,
1684: corp_rt.trade_in_asset_id
1685: from fa_transaction_headers corp_th,
1686: fa_books corp_bk,
1687: fa_books tax_bk,
1688: fa_retirements corp_rt,
1689: fa_additions_b ad,
1690: fa_asset_history ah
1691: where corp_th.transaction_header_id = p_corp_thid

Line 2612: from fa_books books,

2608: books.group_asset_id,
2609: books.date_placed_in_service,
2610: books.transaction_header_id_in,
2611: books.period_counter_fully_retired
2612: from fa_books books,
2613: fa_additions_b ad,
2614: fa_deprn_periods dp,
2615: fa_asset_history ah -- bug fix 5925965
2616: where books.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)

Line 2633: fa_books taxbk,

2629: and nvl(dp.period_counter,
2630: l_corp_period_rec.period_counter + 1) > l_corp_period_rec.period_counter
2631: and ad.asset_type in ('CAPITALIZED', 'GROUP')
2632: and ad.asset_id = books.asset_id) assets,
2633: fa_books taxbk,
2634: fa_category_book_defaults cbd
2635: where taxbk.asset_id(+) = assets.asset_id
2636: and taxbk.book_type_code(+) = p_book_type_code
2637: and taxbk.transaction_header_id_out(+) is null

Line 2725: fa_books corp_bk,

2721: corp_bk_old.group_asset_id old_group_asset_id,
2722: corp_bk.group_asset_id new_group_asset_id
2723: from fa_additions_b ad,
2724: fa_transaction_headers corp_th,
2725: fa_books corp_bk,
2726: fa_books corp_bk_old,
2727: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
2728: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
2729: and corp_th.transaction_type_code = trx.column_value

Line 2726: fa_books corp_bk_old,

2722: corp_bk.group_asset_id new_group_asset_id
2723: from fa_additions_b ad,
2724: fa_transaction_headers corp_th,
2725: fa_books corp_bk,
2726: fa_books corp_bk_old,
2727: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
2728: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
2729: and corp_th.transaction_type_code = trx.column_value
2730: and corp_th.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)

Line 2742: fa_books tax_bk,

2738: and corp_bk_old.asset_id(+) = corp_th.asset_id
2739: and corp_bk_old.book_type_code(+) = corp_th.book_type_code
2740: and corp_bk_old.transaction_header_id_out(+) = corp_th.transaction_header_id) assets,
2741: fa_transaction_headers tax_th,
2742: fa_books tax_bk,
2743: fa_category_book_defaults cbd
2744: where tax_th.book_type_code(+) = p_book_type_code
2745: and tax_th.asset_id(+) = assets.asset_id
2746: and tax_th.source_transaction_header_id(+) = assets.transaction_header_id