DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FA_ASSET_HISTORY

Line 971: from fa_asset_history ah,

967: tax_bk.life_in_months,
968: decode(tax_bk.period_counter_fully_reserved,null,
969: (nvl(tax_bk.period_counter_life_complete,0)), 0),
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,

Line 1690: fa_asset_history ah

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
1692: and corp_th.asset_id = ah.asset_id
1693: and corp_th.date_effective < nvl(ah.date_ineffective,
1694: sysdate)

Line 2615: fa_asset_history ah -- bug fix 5925965

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)
2617: and nvl(books.date_ineffective, sysdate) > nvl(l_corp_period_rec.period_close_date, sysdate - 1)
2618: and books.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
2619: