APPS.FA_AMORT_PVT dependencies on FA_RETIREMENTS_MRC_V

Line 1560: from fa_retirements_mrc_v ret

1556: , ret.cost_retired
1557: , nvl(ret.reserve_retired, 0)
1558: , ret.proceeds_of_sale
1559: , ret.cost_of_removal
1560: from fa_retirements_mrc_v ret
1561: where ret.transaction_header_id_in = c_transaction_header_id
1562: and ret.transaction_header_id_out is null;
1563:
1564:

Line 2610: from fa_retirements_mrc_v ret

2606: select ret.proceeds_of_sale
2607: , ret.cost_of_removal
2608: , -1 * nvl(ret.reserve_retired, 0)
2609: , -1 * nbv_retired
2610: from fa_retirements_mrc_v ret
2611: where ret.transaction_header_id_in = c_transaction_header_id
2612: and ret.transaction_header_id_out is null;
2613:
2614: --

Line 2636: from fa_retirements_mrc_v ret

2632: select -1 * ret.proceeds_of_sale
2633: , -1 * ret.cost_of_removal
2634: , nvl(ret.reserve_retired, 0)
2635: , nbv_retired
2636: from fa_retirements_mrc_v ret
2637: , fa_transaction_headers mth
2638: where mth.transaction_header_id = c_transaction_header_id
2639: and mth.asset_id = ret.asset_id
2640: and mth.book_type_code = p_asset_hdr_rec.book_type_code

Line 3384: from fa_retirements_mrc_v ret

3380: select -1 * ret.proceeds_of_sale
3381: , -1 * ret.cost_of_removal
3382: , nvl(ret.reserve_retired, 0)
3383: , nbv_retired
3384: from fa_retirements_mrc_v ret
3385: , fa_transaction_headers mth
3386: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
3387: and mth.asset_id = ret.asset_id
3388: and mth.book_type_code = p_asset_hdr_rec.book_type_code

Line 8052: from fa_retirements_mrc_v ret,

8048:
8049: CURSOR c_get_mc_ret_trx IS
8050: select nvl(sum(ret.reserve_retired), 0),
8051: nvl(sum(ret.eofy_reserve), 0)
8052: from fa_retirements_mrc_v ret,
8053: fa_transaction_headers mth,
8054: fa_transaction_headers gth,
8055: fa_book_controls_mrc_v bc,
8056: fa_fiscal_year fy

Line 8476: from fa_retirements_mrc_v ret,

8472: G_TRX_TYPE_TFR_VOID)
8473: and nvl(th.amortization_start_date,
8474: th.transaction_date_entered) <= p_transaction_date_entered
8475: and not exists(select 'Exclude This Retirement'
8476: from fa_retirements_mrc_v ret,
8477: fa_transaction_headers reith
8478: where ret.transaction_header_id_in = th.transaction_header_id
8479: and ret.transaction_header_id_out = reith.transaction_header_id
8480: and nvl(reith.amortization_start_date,

Line 11625: from fa_retirements_mrc_v

11621: reval_reserve_retired,
11622: unrevalued_cost_retired,
11623: bonus_reserve_retired,
11624: null -- recognize_gain_loss
11625: from fa_retirements_mrc_v
11626: where transaction_header_id_in = c_transaction_header_id
11627: and transaction_header_id_out is null;
11628:
11629: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++