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_BOOKS_SUMMARY

Line 4255: UPDATE FA_BOOKS_SUMMARY_MRC_V

4251: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4252: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4253: AND TRANSACTION_HEADER_ID_OUT is null;
4254:
4255: UPDATE FA_BOOKS_SUMMARY_MRC_V
4256: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4257: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4258: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4259: AND PERIOD_COUNTER = p_period_rec.period_counter;

Line 4269: UPDATE FA_BOOKS_SUMMARY

4265: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4266: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4267: AND TRANSACTION_HEADER_ID_OUT is null;
4268:
4269: UPDATE FA_BOOKS_SUMMARY
4270: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4271: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4272: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4273: AND PERIOD_COUNTER = p_period_rec.period_counter;

Line 4349: FROM FA_BOOKS_SUMMARY

4345: AND GROUP_ASSET_ID = p_asset_hdr_rec.asset_id;
4346:
4347: CURSOR C_GET_BS_SUM_ADJ_COST IS
4348: SELECT SUM(ADJUSTED_COST)
4349: FROM FA_BOOKS_SUMMARY
4350: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4351: AND TRANSACTION_HEADER_ID_OUT is null
4352: AND nvl(FULLY_RESERVED_FLAG, 'N') = 'N'
4353: AND nvl(FULLY_RETIRED_FLAG, 'N') = 'N'

Line 4360: FROM FA_BOOKS_SUMMARY_MRC_V

4356: AND PERIOD_COUNTER = p_period_rec.period_counter;
4357:
4358: CURSOR C_MC_GET_BS_SUM_ADJ_COST IS
4359: SELECT SUM(ADJUSTED_COST)
4360: FROM FA_BOOKS_SUMMARY_MRC_V
4361: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4362: AND TRANSACTION_HEADER_ID_OUT is null
4363: AND nvl(FULLY_RESERVED_FLAG, 'N') = 'N'
4364: AND nvl(FULLY_RETIRED_FLAG, 'N') = 'N'

Line 4944: UPDATE FA_BOOKS_SUMMARY_MRC_V

4940: l_loc := 'Before BS';
4941: -- Update FA_BOOKS_SUMAMRY_MRC_V table with new reserve adjustment amount and
4942: -- related columns. Return new adjusted_cost and deprn reserve for later use
4943: FORALL i in t_asset_id.first..t_asset_id.last
4944: UPDATE FA_BOOKS_SUMMARY_MRC_V
4945: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjustment_amount(i)
4946: , DEPRN_RESERVE = DEPRN_RESERVE + t_adjustment_amount(i)
4947: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE - t_adjustment_amount(i)
4948: WHERE ASSET_ID = t_asset_id(i)

Line 5203: UPDATE FA_BOOKS_SUMMARY

5199: l_loc := 'Before BS';
5200: -- Update FA_BOOKS_SUMAMRY table with new reserve adjustment amount and
5201: -- related columns. Return new adjusted_cost and deprn reserve for later use
5202: FORALL i in t_asset_id.first..t_asset_id.last
5203: UPDATE FA_BOOKS_SUMMARY
5204: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjustment_amount(i)
5205: , DEPRN_RESERVE = DEPRN_RESERVE + t_adjustment_amount(i)
5206: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE - t_adjustment_amount(i)
5207: WHERE ASSET_ID = t_asset_id(i)

Line 5565: UPDATE FA_BOOKS_SUMMARY_MRC_V

5561: WHERE ASSET_ID = l_last_asset_id
5562: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5563: AND TRANSACTION_HEADER_ID = l_last_thid);
5564:
5565: UPDATE FA_BOOKS_SUMMARY_MRC_V
5566: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5567: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5568: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE
5569: WHERE ASSET_ID = l_last_asset_id

Line 5590: UPDATE FA_BOOKS_SUMMARY

5586: WHERE ASSET_ID = l_last_asset_id
5587: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5588: AND TRANSACTION_HEADER_ID = l_last_thid);
5589:
5590: UPDATE FA_BOOKS_SUMMARY
5591: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5592: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5593: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE
5594: WHERE ASSET_ID = l_last_asset_id

Line 5628: UPDATE FA_BOOKS_SUMMARY_MRC_V

5624: WHERE ASSET_ID = t_asset_id(i)
5625: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5626: AND TRANSACTION_HEADER_ID = t_thid(i));
5627:
5628: UPDATE FA_BOOKS_SUMMARY_MRC_V
5629: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5630: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5631: , ADJUSTED_COST = ADJUSTED_RECOVERABLE_COST - DEPRN_RESERVE
5632: WHERE ASSET_ID = t_asset_id(i)

Line 5653: UPDATE FA_BOOKS_SUMMARY

5649: WHERE ASSET_ID = t_asset_id(i)
5650: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5651: AND TRANSACTION_HEADER_ID = t_thid(i));
5652:
5653: UPDATE FA_BOOKS_SUMMARY
5654: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5655: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5656: , ADJUSTED_COST = ADJUSTED_RECOVERABLE_COST - DEPRN_RESERVE
5657: WHERE ASSET_ID = t_asset_id(i)

Line 5690: UPDATE FA_BOOKS_SUMMARY_MRC_V

5686: WHERE ASSET_ID = t_asset_id(i)
5687: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5688: AND TRANSACTION_HEADER_ID = t_thid(i));
5689:
5690: UPDATE FA_BOOKS_SUMMARY_MRC_V
5691: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_recoverable_cost(i) -
5692: t_new_deprn_reserve(i)
5693: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
5694: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST

Line 5716: UPDATE FA_BOOKS_SUMMARY

5712: WHERE ASSET_ID = t_asset_id(i)
5713: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5714: AND TRANSACTION_HEADER_ID = t_thid(i));
5715:
5716: UPDATE FA_BOOKS_SUMMARY
5717: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_recoverable_cost(i) -
5718: t_new_deprn_reserve(i)
5719: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
5720: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST

Line 5807: UPDATE FA_BOOKS_SUMMARY_MRC_V

5803: WHERE ASSET_ID = t_asset_id(i)
5804: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5805: AND TRANSACTION_HEADER_ID = t_thid(i));
5806:
5807: UPDATE FA_BOOKS_SUMMARY_MRC_V
5808: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5809: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5810: , ADJUSTED_COST = ADJUSTED_RECOVERABLE_COST - DEPRN_RESERVE
5811: WHERE ASSET_ID = t_asset_id(i)

Line 5832: UPDATE FA_BOOKS_SUMMARY

5828: WHERE ASSET_ID = t_asset_id(i)
5829: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5830: AND TRANSACTION_HEADER_ID = t_thid(i));
5831:
5832: UPDATE FA_BOOKS_SUMMARY
5833: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5834: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5835: , ADJUSTED_COST = ADJUSTED_RECOVERABLE_COST - DEPRN_RESERVE
5836: WHERE ASSET_ID = t_asset_id(i)

Line 5863: UPDATE FA_BOOKS_SUMMARY_MRC_V

5859: WHERE ASSET_ID = t_asset_id(i)
5860: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5861: AND TRANSACTION_HEADER_ID = t_thid(i));
5862:
5863: UPDATE FA_BOOKS_SUMMARY_MRC_V
5864: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
5865: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
5866: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
5867: WHERE ASSET_ID = t_asset_id(i)

Line 5887: UPDATE FA_BOOKS_SUMMARY

5883: WHERE ASSET_ID = t_asset_id(i)
5884: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5885: AND TRANSACTION_HEADER_ID = t_thid(i));
5886:
5887: UPDATE FA_BOOKS_SUMMARY
5888: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
5889: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
5890: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
5891: WHERE ASSET_ID = t_asset_id(i)