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_MC_ITF_IMPAIRMENTS

Line 234: fa_mc_itf_impairments imp

230: , 0 reval_loss_balance
231: FROM fa_additions_b ad,
232: fa_methods mt,
233: fa_mc_books bk,
234: fa_mc_itf_impairments imp
235: WHERE bk.book_type_code = p_book_type_code
236: AND bk.set_of_books_id = p_set_of_books_id
237: AND (bk.period_counter_fully_retired is null OR
238: bk.adjustment_required_status <> 'NONE')

Line 1083: UPDATE FA_MC_ITF_IMPAIRMENTS

1079:
1080:
1081: if (p_mrc_sob_type_code = 'R') then
1082: FORALL i in 1..t_asset_id.count
1083: UPDATE FA_MC_ITF_IMPAIRMENTS
1084: SET NET_BOOK_VALUE = t_net_book_value(i)
1085: , YTD_IMPAIRMENT = t_ytd_impairment(i)
1086: , impairment_reserve = t_impairment_reserve(i)
1087: , DEPRN_RUN_DATE = t_deprn_run_date(i)

Line 1265: , fa_mc_itf_impairments itf

1261: , nvl(books.sorp_enabled_flag, 'N') -- Bug 6666666
1262: , imp.net_selling_price --Bug# 7511258
1263: , imp.value_in_use --Bug# 7511258
1264: from fa_mc_impairments imp
1265: , fa_mc_itf_impairments itf
1266: , fa_book_controls books
1267: where imp.request_id = p_request_id
1268: and imp.book_type_code = p_book_type_code
1269: and imp.impairment_id = itf.impairment_id

Line 1293: from fa_mc_itf_impairments

1289: and nvl(goodwill_asset_flag, 'N') <> 'Y';
1290:
1291: CURSOR c_mc_get_sum(c_impairment_id number) IS
1292: select sum(impairment_amount)
1293: from fa_mc_itf_impairments
1294: where impairment_id = c_impairment_id
1295: and nvl(goodwill_asset_flag, 'N') <> 'Y'
1296: and set_of_books_id = p_set_of_books_id;
1297:

Line 1315: from fa_mc_itf_impairments

1311: , net_book_value
1312: , impairment_amount
1313: , ytd_impairment
1314: , impairment_reserve
1315: from fa_mc_itf_impairments
1316: where impairment_id = c_impairment_id
1317: and net_book_value <> 0
1318: and nvl(goodwill_asset_flag, 'N') <> 'Y'
1319: and set_of_books_id = p_set_of_books_id;

Line 1332: from fa_mc_itf_impairments

1328: and (asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id) order by impairment_id;
1329:
1330: CURSOR c_mc_get_itf(c_asset_id number,c_cgu_id number) is
1331: select impairment_id
1332: from fa_mc_itf_impairments
1333: where request_id = p_request_id
1334: and (asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id)
1335: and set_of_books_id = p_set_of_books_id
1336: order by impairment_id;

Line 1493: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

1489: end if;
1490:
1491: if (p_mrc_sob_type_code = 'R') then
1492: FORALL i in 1..t_impairment_id.count
1493: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
1494: SET IMPAIRMENT_AMOUNT = least(round(t_impairment_amount(i) *
1495: (NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
1496: NET_BOOK_VALUE)
1497: , YTD_IMPAIRMENT = YTD_IMPAIRMENT + least(round(t_impairment_amount(i) *

Line 1515: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

1511: AND t_net_book_value(i) <> 0
1512: AND set_of_books_id = p_set_of_books_id; -- Bug# 6920854
1513:
1514: FORALL i in 1..t_impairment_id.count
1515: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
1516: SET NET_BOOK_VALUE = COST - DEPRN_RESERVE - impairment_reserve
1517: WHERE IMPAIRMENT_ID = t_impairment_id(i)
1518: AND GOODWILL_ASSET_FLAG = 'Y'
1519: AND set_of_books_id = p_set_of_books_id;

Line 1679: UPDATE FA_MC_ITF_IMPAIRMENTS

1675: END LOOP; -- j in 1..ti_rowid.count
1676:
1677: if p_mrc_sob_type_code = 'R' then
1678: FORALL j in 1..ti_rowid.count
1679: UPDATE FA_MC_ITF_IMPAIRMENTS
1680: SET IMPAIRMENT_AMOUNT = ti_impairment_amount(j)
1681: , YTD_IMPAIRMENT = ti_ytd_impairment(j)
1682: , impairment_reserve = ti_impairment_reserve(j)
1683: , NET_BOOK_VALUE = ti_net_book_value(j)

Line 1729: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

1725: end if;
1726:
1727: if (p_mrc_sob_type_code = 'R') then
1728: FORALL i in 1..t_impairment_id.count
1729: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
1730: SET IMPAIRMENT_AMOUNT = IMPAIRMENT_AMOUNT - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
1731: , YTD_IMPAIRMENT = YTD_IMPAIRMENT - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
1732: , REVAL_RESERVE = REVAL_RESERVE - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
1733: , REVAL_RESERVE_ADJ_AMOUNT = least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)

Line 1776: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

1772: -- Bug# 7000391 start
1773: if p_mrc_sob_type_code = 'R' then
1774: --Bug# 7045739 start - when impairment_amount > NBV,basically to sync Asset Impairment report and Preview form.
1775: FORALL i in 1..t_impairment_id.count
1776: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
1777: SET DEPRN_RESERVE = DEPRN_RESERVE + (nvl(impairment_reserve,0) - NET_BOOK_VALUE),
1778: IMPAIRMENT_AMOUNT = t_impairment_amount(i),
1779: impairment_reserve = t_impairment_amount(i),
1780: NET_BOOK_VALUE = t_net_book_value(i)

Line 1787: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

1783: AND set_of_books_id = p_set_of_books_id;
1784:
1785: --To set status to deprn failed when multiple rows are uploaded for an asset.
1786: FORALL i in 1..t_impairment_id.count
1787: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
1788: SET PERIOD_OF_ADDITION_FLAG = 'F'
1789: WHERE IMPAIRMENT_ID = t_impairment_id(i)
1790: AND p_nbv(i) in (-1,-2,-3,-4)
1791: AND set_of_books_id = p_set_of_books_id; --Bug#7594562 Added -2