DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FA_ASSET_HISTORY

Line 1225: from fa_asset_history ah,

1221: tax_bk.life_in_months,
1222: decode(tax_bk.period_counter_fully_reserved,null,
1223: (nvl(tax_bk.period_counter_life_complete,0)), 0),
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,

Line 1984: fa_asset_history ah

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
1986: and corp_th.asset_id = ah.asset_id
1987: and corp_th.date_effective < nvl(ah.date_ineffective,
1988: sysdate)

Line 2941: fa_asset_history ah -- bug fix 5900321

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