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

Line 126: fa_books bk,

122: , bk.period_counter_fully_reserved --phase5
123: , 0 reval_loss_balance
124: FROM fa_additions_b ad,
125: fa_methods mt,
126: fa_books bk,
127: fa_itf_impairments imp
128: WHERE bk.book_type_code = p_book_type_code
129: AND (bk.period_counter_fully_retired is null OR
130: bk.adjustment_required_status <> 'NONE')

Line 1347: (asset_id in (select asset_id from fa_books fbs

1343: select 'POSTED'
1344: from fa_mc_impairments
1345: where status = 'POSTED'
1346: and ((asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id) or
1347: (asset_id in (select asset_id from fa_books fbs
1348: where fbs.book_type_code = p_book_type_code
1349: and fbs.transaction_header_id_out is null
1350: and fbs.cash_generating_unit_id = c_cgu_id)) or
1351: (cash_generating_unit_id = (select cash_generating_unit_id from fa_books fbs

Line 1351: (cash_generating_unit_id = (select cash_generating_unit_id from fa_books fbs

1347: (asset_id in (select asset_id from fa_books fbs
1348: where fbs.book_type_code = p_book_type_code
1349: and fbs.transaction_header_id_out is null
1350: and fbs.cash_generating_unit_id = c_cgu_id)) or
1351: (cash_generating_unit_id = (select cash_generating_unit_id from fa_books fbs
1352: where fbs.book_type_code = p_book_type_code
1353: and fbs.transaction_header_id_out is null
1354: and fbs.asset_id = c_asset_id)))
1355: and book_type_code = p_book_type_code /*Bug# 8263733 - Added filter condition with book_type_code */

Line 1364: (asset_id in (select asset_id from fa_books fbs

1360: select 'POSTED'
1361: from fa_impairments
1362: where status = 'POSTED'
1363: and ((asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id) or
1364: (asset_id in (select asset_id from fa_books fbs
1365: where fbs.book_type_code = p_book_type_code
1366: and fbs.transaction_header_id_out is null
1367: and fbs.cash_generating_unit_id = c_cgu_id)) or
1368: (cash_generating_unit_id = (select cash_generating_unit_id from fa_books fbs

Line 1368: (cash_generating_unit_id = (select cash_generating_unit_id from fa_books fbs

1364: (asset_id in (select asset_id from fa_books fbs
1365: where fbs.book_type_code = p_book_type_code
1366: and fbs.transaction_header_id_out is null
1367: and fbs.cash_generating_unit_id = c_cgu_id)) or
1368: (cash_generating_unit_id = (select cash_generating_unit_id from fa_books fbs
1369: where fbs.book_type_code = p_book_type_code
1370: and fbs.transaction_header_id_out is null
1371: and fbs.asset_id = c_asset_id)))
1372: and book_type_code = p_book_type_code /*Bug# 8263733 - Added filter condition with book_type_code */

Line 1911: , fa_books inbk

1907: , inbk.life_in_months
1908: , inbk.adjusted_rate
1909: , inbk.production_capacity
1910: from fa_transaction_headers th
1911: , fa_books inbk
1912: , fa_books outbk
1913: , fa_calendar_types ct
1914: , fa_calendar_periods cp
1915: , fa_fiscal_year fy

Line 1912: , fa_books outbk

1908: , inbk.adjusted_rate
1909: , inbk.production_capacity
1910: from fa_transaction_headers th
1911: , fa_books inbk
1912: , fa_books outbk
1913: , fa_calendar_types ct
1914: , fa_calendar_periods cp
1915: , fa_fiscal_year fy
1916: where th.asset_id = p_asset_id

Line 3038: -- Preserve rows in FA_BOOKS_SUMMARY_T table for later use

3034:
3035: END LOOP; -- i in 1..fa_amort_pvt.t_period_counter.count
3036:
3037: --
3038: -- Preserve rows in FA_BOOKS_SUMMARY_T table for later use
3039: --
3040: if (p_log_level_rec.statement_level) then
3041: fa_debug_pkg.add(l_calling_fn,'Inserting into FA_BOOKS_SUMMARY_T',
3042: fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);

Line 3041: fa_debug_pkg.add(l_calling_fn,'Inserting into FA_BOOKS_SUMMARY_T',

3037: --
3038: -- Preserve rows in FA_BOOKS_SUMMARY_T table for later use
3039: --
3040: if (p_log_level_rec.statement_level) then
3041: fa_debug_pkg.add(l_calling_fn,'Inserting into FA_BOOKS_SUMMARY_T',
3042: fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);
3043: end if;
3044:
3045: FORALL i in 1..fa_amort_pvt.t_period_counter.count

Line 3046: INSERT INTO FA_BOOKS_SUMMARY_T(

3042: fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);
3043: end if;
3044:
3045: FORALL i in 1..fa_amort_pvt.t_period_counter.count
3046: INSERT INTO FA_BOOKS_SUMMARY_T(
3047: REQUEST_ID
3048: , IMPAIRMENT_ID
3049: , ASSET_ID
3050: , BOOK_TYPE_CODE

Line 3371: FROM fa_books_summary_t

3367: -- , POLISH_ADJ_REC_COST
3368: , IMPAIRMENT_AMOUNT
3369: , YTD_IMPAIRMENT
3370: , IMPAIRMENT_RESERVE
3371: FROM fa_books_summary_t
3372: WHERE asset_id = c_asset_id
3373: AND book_type_code = p_book_type_code
3374: AND period_counter >= p_imp_period_rec.period_counter
3375: AND request_id = p_request_id