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_RETIREMENT_PVT dependencies on FA_MC_ADJUSTMENTS

Line 716: from fa_mc_adjustments

712: and transaction_header_id = l_transaction_header_id;
713:
714: CURSOR c_mc_adj IS
715: select rowid
716: from fa_mc_adjustments
717: where transaction_header_id = l_transaction_header_id
718: and set_of_books_id = p_set_of_books_id;
719:
720: l_calling_fn VARCHAR2(100) := 'fa_group_retirement_pvt.undo_retirement_reinstatement';

Line 2401: FROM FA_MC_ADJUSTMENTS

2397: ANNUALIZED_ADJUSTMENT,
2398: PERIOD_COUNTER_ADJUSTED,
2399: PERIOD_COUNTER_CREATED,
2400: ASSET_INVOICE_ID
2401: FROM FA_MC_ADJUSTMENTS
2402: WHERE TRANSACTION_HEADER_ID = l_group_thid
2403: AND ASSET_ID = l_group_asset_id
2404: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
2405: AND PERIOD_COUNTER_CREATED = l_period_rec.period_counter

Line 3648: from fa_mc_adjustments

3644: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3645: CURSOR c_get_mc_rsv_retired (c_transaction_header_id number) IS
3646: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
3647: adjustment_amount))
3648: from fa_mc_adjustments
3649: where source_type_code = 'RETIREMENT'
3650: and adjustment_type = 'RESERVE'
3651: and asset_id = p_ret.asset_id
3652: and book_type_code = p_ret.book

Line 3677: from fa_mc_adjustments aj, fa_transaction_headers th

3673: -- For MRC: gets expense that retirement created
3674: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3675: CURSOR c_get_mc_ret_info IS
3676: select sum(decode(debit_credit_flag, 'DR', -1, 1) * adjustment_amount)
3677: from fa_mc_adjustments aj, fa_transaction_headers th
3678: where aj.source_type_code = 'RETIREMENT'
3679: and aj.adjustment_type = 'EXPENSE'
3680: and aj.asset_id = p_bk.group_asset_id
3681: and aj.book_type_code = p_ret.book

Line 4999: , fa_mc_adjustments aj

4995: , bk.adjusted_recoverable_cost
4996: , sum(aj.adjustment_amount)
4997: from fa_transaction_headers th -- member
4998: , fa_transaction_headers gth -- group
4999: , fa_mc_adjustments aj
5000: , fa_mc_deprn_periods dp
5001: , fa_additions_b ad
5002: , fa_mc_books bk
5003: where th.book_type_code = p_asset_hdr_rec.book_type_code

Line 6450: UPDATE FA_MC_ADJUSTMENTS

6446:
6447: -- Need to backout some reserve so do that from last processed asset
6448:
6449: if (p_mrc_sob_type_code = 'R') then
6450: UPDATE FA_MC_ADJUSTMENTS
6451: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
6452: WHERE ASSET_ID = l_last_asset_id
6453: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6454: AND TRANSACTION_HEADER_ID = l_last_thid

Line 6456: FROM FA_MC_ADJUSTMENTS

6452: WHERE ASSET_ID = l_last_asset_id
6453: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6454: AND TRANSACTION_HEADER_ID = l_last_thid
6455: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
6456: FROM FA_MC_ADJUSTMENTS
6457: WHERE ASSET_ID = l_last_asset_id
6458: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6459: AND TRANSACTION_HEADER_ID = l_last_thid
6460: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id)

Line 6575: UPDATE FA_MC_ADJUSTMENTS

6571: fa_debug_pkg.add(l_calling_fn, 'Rounding 2 : Adjust reallocate_amount ',' ',p_log_level_rec);
6572: end if;
6573:
6574: if (p_mrc_sob_type_code = 'R') then
6575: UPDATE FA_MC_ADJUSTMENTS
6576: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
6577: WHERE ASSET_ID = t_asset_id(i)
6578: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6579: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 6582: FROM FA_MC_ADJUSTMENTS

6578: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6579: AND TRANSACTION_HEADER_ID = t_thid(i)
6580: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
6581: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
6582: FROM FA_MC_ADJUSTMENTS
6583: WHERE ASSET_ID = t_asset_id(i)
6584: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6585: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
6586: AND TRANSACTION_HEADER_ID = t_thid(i));

Line 6639: UPDATE FA_MC_ADJUSTMENTS

6635:
6636: else
6637:
6638: if (p_mrc_sob_type_code = 'R') then
6639: UPDATE FA_MC_ADJUSTMENTS
6640: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
6641: WHERE ASSET_ID = t_asset_id(i)
6642: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6643: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 6646: FROM FA_MC_ADJUSTMENTS

6642: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6643: AND TRANSACTION_HEADER_ID = t_thid(i)
6644: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
6645: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
6646: FROM FA_MC_ADJUSTMENTS
6647: WHERE ASSET_ID = t_asset_id(i)
6648: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6649: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
6650: AND TRANSACTION_HEADER_ID = t_thid(i));