[Home] [Help]
1546: , ret.cost_retired
1547: , nvl(ret.reserve_retired, 0)
1548: , ret.proceeds_of_sale
1549: , ret.cost_of_removal
1550: from fa_retirements ret
1551: where ret.transaction_header_id_in = c_transaction_header_id
1552: and ret.transaction_header_id_out is null;
1553:
1554: CURSOR c_get_mc_ret_info (c_transaction_header_id number) IS
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:
2597: select ret.proceeds_of_sale
2598: , ret.cost_of_removal
2599: , -1 * nvl(ret.reserve_retired, 0)
2600: , -1 * nbv_retired
2601: from fa_retirements ret
2602: where ret.transaction_header_id_in = c_transaction_header_id
2603: and ret.transaction_header_id_out is null;
2604:
2605: CURSOR c_get_mc_ret_info (c_transaction_header_id number) IS
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: --
2619: select -1 * ret.proceeds_of_sale
2620: , -1 * ret.cost_of_removal
2621: , nvl(ret.reserve_retired, 0)
2622: , nbv_retired
2623: from fa_retirements ret
2624: , fa_transaction_headers mth
2625: where mth.transaction_header_id = c_transaction_header_id
2626: and mth.asset_id = ret.asset_id
2627: and mth.book_type_code = p_asset_hdr_rec.book_type_code
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
3367: select -1 * ret.proceeds_of_sale
3368: , -1 * ret.cost_of_removal
3369: , ret.reserve_retired
3370: , nbv_retired
3371: from fa_retirements ret
3372: , fa_transaction_headers mth
3373: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
3374: and mth.asset_id = ret.asset_id
3375: and mth.book_type_code = p_asset_hdr_rec.book_type_code
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
8017:
8018: CURSOR c_get_ret_trx IS
8019: select nvl(sum(ret.reserve_retired), 0),
8020: nvl(sum(ret.eofy_reserve), 0)
8021: from fa_retirements ret,
8022: fa_transaction_headers mth,
8023: fa_transaction_headers gth,
8024: fa_book_controls bc,
8025: fa_fiscal_year fy
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
8079:
8080: CURSOR c_get_ret_trx2 IS
8081: select nvl(sum(ret.reserve_retired), 0),
8082: nvl(sum(ret.eofy_reserve), 0)
8083: from fa_retirements ret,
8084: fa_transaction_headers th,
8085: fa_book_controls bc,
8086: fa_fiscal_year fy
8087: where th.asset_id = p_asset_hdr_rec.asset_id
8422: G_TRX_TYPE_TFR_VOID)
8423: and nvl(th.amortization_start_date,
8424: th.transaction_date_entered) <= p_transaction_date_entered
8425: and not exists(select 'Exclude This Retirement'
8426: from fa_retirements ret,
8427: fa_transaction_headers reith
8428: where ret.transaction_header_id_in = th.transaction_header_id
8429: and ret.transaction_header_id_out = reith.transaction_header_id
8430: and nvl(reith.amortization_start_date,
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,
11288: ret.date_effective date_effective,
11289: ret.transaction_type_code transaction_type_code
11290: from fa_transaction_headers ret,
11291: fa_transaction_headers rei,
11292: fa_retirements faret
11293: where ret.asset_id = p_asset_hdr_rec.asset_id
11294: and rei.asset_id = p_asset_hdr_rec.asset_id
11295: and ret.book_type_code = p_asset_hdr_rec.book_type_code
11296: and rei.book_type_code = p_asset_hdr_rec.book_type_code
11472: th.trx_reference_id trx_reference_id,
11473: th.invoice_transaction_id,
11474: '2nd SELECT in c_get_ths_adj'
11475: from fa_transaction_headers th,
11476: fa_retirements ret,
11477: fa_conventions con,
11478: fa_calendar_periods cp,
11479: fa_calendar_periods cptrx
11480: where th.asset_id = p_asset_hdr_rec.asset_id
11602: reval_reserve_retired,
11603: unrevalued_cost_retired,
11604: bonus_reserve_retired,
11605: null -- recognize_gain_loss
11606: from fa_retirements
11607: where transaction_header_id_in = c_transaction_header_id
11608: and transaction_header_id_out is null;
11609:
11610: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11626: where transaction_header_id_in = c_transaction_header_id
11627: and transaction_header_id_out is null;
11628:
11629: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11630: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it
11631: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11632: CURSOR c_get_rsv_retired (c_transaction_header_id number) IS
11633: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
11634: adjustment_amount))
11640: and transaction_header_id = c_transaction_header_id;
11641:
11642: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11643: -- For MRC
11644: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it
11645: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11646: CURSOR c_get_mc_rsv_retired (c_transaction_header_id number) IS
11647: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
11648: adjustment_amount))
12134:
12135: begin
12136: select transaction_header_id_in
12137: into l_retirement_thid -- retirement thid
12138: from fa_retirements
12139: where asset_id = p_asset_hdr_rec.asset_id
12140: and book_type_code = p_asset_hdr_rec.book_type_code
12141: and transaction_header_id_out = l_incoming_thid;
12142: exception when others then null;