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_BOOKS

Line 644: UPDATE FA_MC_BOOKS

640: nvl(l_asset_fin_rec_old.member_rollup_flag,'N') = 'Y' and
641: l_asset_fin_rec_old.recognize_gain_loss = 'NO'
642: ) then
643: if(p_mrc_sob_type_code = 'R') then
644: UPDATE FA_MC_BOOKS
645: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
646: WHERE GROUP_ASSET_ID = l_asset_hdr_rec.asset_id
647: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
648: AND TRANSACTION_HEADER_ID_OUT is null

Line 2359: from fa_mc_books inbk , fa_mc_books outbk

2355: and outbk.transaction_header_id_out = p_asset_retire_rec.detail_info.transaction_header_id_in;
2356:
2357: CURSOR c_get_ret_salvage_mrc IS
2358: select outbk.salvage_value - inbk.salvage_value
2359: from fa_mc_books inbk , fa_mc_books outbk
2360: where inbk.transaction_header_id_in = p_asset_retire_rec.detail_info.transaction_header_id_in
2361: and outbk.asset_id = p_asset_hdr_rec.asset_id
2362: and outbk.book_type_code = p_asset_hdr_rec.book_type_code
2363: and outbk.transaction_header_id_out = p_asset_retire_rec.detail_info.transaction_header_id_in

Line 4052: from fa_mc_books

4048: and mth.transaction_header_id = gth.member_transaction_header_id;
4049:
4050: cursor c_mc_member_exists IS
4051: select 'Y'
4052: from fa_mc_books
4053: where book_type_code = p_book_type_code
4054: and group_asset_id = p_asset_id
4055: and period_counter_fully_retired is null
4056: and transaction_header_id_out is null

Line 4064: fa_mc_books bk

4060: select max(gth.transaction_header_id)
4061: from fa_transaction_headers gth,
4062: fa_transaction_headers mth,
4063: fa_mc_retirements ret,
4064: fa_mc_books bk
4065: where bk.group_asset_id = p_asset_id
4066: and bk.book_type_code = p_book_type_code
4067: and bk.set_of_books_id = p_set_of_books_id
4068: and ret.asset_id = bk.asset_id

Line 4476: from fa_mc_books

4472: and transaction_header_id_out is null;
4473:
4474: CURSOR c_find_mc_member IS
4475: select asset_id
4476: from fa_mc_books
4477: where group_asset_id = p_asset_hdr_rec.asset_id
4478: and book_type_code = p_asset_hdr_rec.book_type_code
4479: and period_counter_fully_retired is null
4480: and transaction_header_id_out is null

Line 4601: UPDATE FA_MC_BOOKS

4597: -- processed during depreciation
4598: --
4599: if (p_mrc_sob_type_code = 'R') then
4600:
4601: UPDATE FA_MC_BOOKS
4602: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4603: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4604: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4605: AND TRANSACTION_HEADER_ID_OUT is null

Line 4608: UPDATE FA_MC_BOOKS_SUMMARY

4604: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4605: AND TRANSACTION_HEADER_ID_OUT is null
4606: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
4607:
4608: UPDATE FA_MC_BOOKS_SUMMARY
4609: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4610: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4611: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4612: AND PERIOD_COUNTER = p_period_rec.period_counter

Line 4616: UPDATE FA_MC_BOOKS

4612: AND PERIOD_COUNTER = p_period_rec.period_counter
4613: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
4614:
4615: /*bug#15897249 starts */
4616: UPDATE FA_MC_BOOKS
4617: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4618: WHERE GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4619: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4620: AND TRANSACTION_HEADER_ID_OUT is null

Line 4730: FROM FA_MC_BOOKS BK

4726: , BK.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
4727: , BK.RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
4728: , BK.ADJUSTED_COST ADJUSTED_COST
4729: , BK.RECOVERABLE_COST RECOVERABLE_COST
4730: FROM FA_MC_BOOKS BK
4731: , FA_ADDITIONS_B AD
4732: , fa_transaction_headers th
4733: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4734: AND BK.TRANSACTION_HEADER_ID_OUT is null

Line 4759: FROM FA_MC_BOOKS

4755:
4756:
4757: CURSOR C_MC_GET_SUM_REC_COST IS
4758: SELECT SUM(RECOVERABLE_COST)
4759: FROM FA_MC_BOOKS
4760: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4761: AND TRANSACTION_HEADER_ID_OUT is null
4762: AND PERIOD_COUNTER_FULLY_RESERVED is null
4763: AND PERIOD_COUNTER_FULLY_RETIRED is null

Line 4781: FROM FA_MC_BOOKS_SUMMARY

4777: AND PERIOD_COUNTER = p_period_rec.period_counter;
4778:
4779: CURSOR C_MC_GET_BS_SUM_ADJ_COST IS
4780: SELECT SUM(ADJUSTED_COST)
4781: FROM FA_MC_BOOKS_SUMMARY
4782: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4783: AND TRANSACTION_HEADER_ID_OUT is null
4784: AND nvl(FULLY_RESERVED_FLAG, 'N') = 'N'
4785: AND nvl(FULLY_RETIRED_FLAG, 'N') = 'N'

Line 4862: FROM FA_MC_BOOKS BK

4858: , BK.ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST
4859: , AD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
4860: , AD.CURRENT_UNITS CURRENT_UNITS
4861: , 'NO' REINS_ASSET_FLAG
4862: FROM FA_MC_BOOKS BK
4863: , FA_ADDITIONS_B AD
4864: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4865: AND BK.TRANSACTION_HEADER_ID_OUT is null
4866: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id

Line 4885: FROM FA_MC_BOOKS BK

4881: , BK.ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST
4882: , AD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
4883: , AD.CURRENT_UNITS CURRENT_UNITS
4884: , 'YES' REINS_ASSET_FLAG
4885: FROM FA_MC_BOOKS BK
4886: , FA_ADDITIONS_B AD
4887: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4888: AND BK.TRANSACTION_HEADER_ID_OUT is null
4889: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id

Line 4936: FROM FA_MC_BOOKS BK

4932: , BK.RECOVERABLE_COST -
4933: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id
4934: , null, 'R' ) )
4935: ADJUSTED_COST
4936: FROM FA_MC_BOOKS BK
4937: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4938: AND TRANSACTION_HEADER_ID_OUT is null
4939: AND GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4940: AND PERIOD_COUNTER_FULLY_RESERVED is null

Line 5002: , fa_mc_books bk

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
5004: -- and th.date_effective = gth.date_effective
5005: and th.source_transaction_header_id = gth.transaction_header_id
5006: and gth.book_type_code = p_asset_hdr_rec.book_type_code

Line 5038: from fa_mc_books

5034: and transaction_header_id_out is null;
5035:
5036: CURSOR c_mc_get_thid (c_asset_id number) IS
5037: select transaction_header_id_in
5038: from fa_mc_books
5039: where book_type_code = p_asset_hdr_rec.book_type_code
5040: and asset_id = c_asset_id
5041: and transaction_header_id_out is null
5042: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;

Line 5814: -- Update FA_MC_BOOKS_SUMAMRY table with new reserve adjustment amount and

5810: /* Bug 8633654 ends*/
5811:
5812: if (p_mrc_sob_type_code = 'R') then
5813: l_loc := 'Before MRC BS';
5814: -- Update FA_MC_BOOKS_SUMAMRY table with new reserve adjustment amount and
5815: -- related columns. Return new adjusted_cost and deprn reserve for later use
5816: FORALL i in t_asset_id.first..t_asset_id.last
5817: UPDATE FA_MC_BOOKS_SUMMARY
5818: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjustment_amount(i)

Line 5817: UPDATE FA_MC_BOOKS_SUMMARY

5813: l_loc := 'Before MRC BS';
5814: -- Update FA_MC_BOOKS_SUMAMRY table with new reserve adjustment amount and
5815: -- related columns. Return new adjusted_cost and deprn reserve for later use
5816: FORALL i in t_asset_id.first..t_asset_id.last
5817: UPDATE FA_MC_BOOKS_SUMMARY
5818: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjustment_amount(i)
5819: , DEPRN_RESERVE = DEPRN_RESERVE + t_adjustment_amount(i)
5820: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE - t_adjustment_amount(i)
5821: WHERE ASSET_ID = t_asset_id(i)

Line 5830: UPDATE FA_MC_BOOKS

5826:
5827: l_loc := 'Before MRC Books';
5828: -- Deactivate FA_BOOKS row for processed assets
5829: FORALL i in t_asset_id.first..t_asset_id.last
5830: UPDATE FA_MC_BOOKS
5831: SET DATE_INEFFECTIVE = p_trans_rec.who_info.last_update_date
5832: , TRANSACTION_HEADER_ID_OUT = t_thid(i)
5833: WHERE TRANSACTION_HEADER_ID_IN = t_transaction_header_id_in(i)
5834: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;

Line 5839: INSERT INTO FA_MC_BOOKS( BOOK_TYPE_CODE

5835:
5836: l_loc := 'Before MRC Insert Books';
5837: -- Insert new FA_BOOKS records for processed assets
5838: FORALL i in t_asset_id.first..t_asset_id.last
5839: INSERT INTO FA_MC_BOOKS( BOOK_TYPE_CODE
5840: , ASSET_ID
5841: , DATE_PLACED_IN_SERVICE
5842: , DATE_EFFECTIVE
5843: , DEPRN_START_DATE

Line 6069: FROM FA_MC_BOOKS

6065: , SUPER_GROUP_ID
6066: , OVER_DEPRECIATE_OPTION
6067: , DISABLED_FLAG
6068: , SET_OF_BOOKS_ID
6069: FROM FA_MC_BOOKS
6070: WHERE TRANSACTION_HEADER_ID_IN = t_transaction_header_id_in(i)
6071: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
6072:
6073: else

Line 6463: UPDATE FA_MC_BOOKS_SUMMARY

6459: AND TRANSACTION_HEADER_ID = l_last_thid
6460: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id)
6461: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
6462:
6463: UPDATE FA_MC_BOOKS_SUMMARY
6464: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6465: , DEPRN_RESERVE = DEPRN_RESERVE + ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6466: , ADJUSTED_COST = ADJUSTED_COST - ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6467: WHERE ASSET_ID = l_last_asset_id

Line 6474: UPDATE FA_MC_BOOKS

6470: AND TRANSACTION_HEADER_ID_OUT IS NULL
6471: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
6472:
6473:
6474: UPDATE FA_MC_BOOKS
6475: SET ADJUSTED_COST = ADJUSTED_COST - ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6476: WHERE TRANSACTION_HEADER_ID_IN = l_last_thid
6477: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
6478: else

Line 6588: UPDATE FA_MC_BOOKS_SUMMARY

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));
6587:
6588: UPDATE FA_MC_BOOKS_SUMMARY
6589: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + (l_reallocate_amount * sign(p_reserve_amount) * -1)
6590: , DEPRN_RESERVE = DEPRN_RESERVE + (l_reallocate_amount * sign(p_reserve_amount) * -1)
6591: , ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
6592: WHERE ASSET_ID = t_asset_id(i)

Line 6599: UPDATE FA_MC_BOOKS

6595: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
6596: AND TRANSACTION_HEADER_ID_OUT is null;
6597:
6598:
6599: UPDATE FA_MC_BOOKS
6600: SET ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
6601: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i)
6602: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
6603: else

Line 6652: UPDATE FA_MC_BOOKS_SUMMARY

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));
6651:
6652: UPDATE FA_MC_BOOKS_SUMMARY
6653: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
6654: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
6655: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
6656: WHERE ASSET_ID = t_asset_id(i)

Line 6662: UPDATE FA_MC_BOOKS

6658: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
6659: AND PERIOD_COUNTER = p_period_rec.period_counter;
6660:
6661:
6662: UPDATE FA_MC_BOOKS
6663: SET ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
6664: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i)
6665: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
6666: else