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

Line 131: from fa_mc_adjustments

127: and rownum = 1;
128: else
129: select count(*)
130: into l_balance_tfr_in_tax
131: from fa_mc_adjustments
132: where book_type_code = RET.book
133: and asset_id = RET.asset_id
134: and transaction_header_id = l_id_out -- Corp's TRANSFER OUT THID
135: and source_type_code in ('TRANSFER', 'RETIREMENT') -- TRANSFER for part-ret, RETIREMENT for reinst of full retirement

Line 195: from fa_mc_adjustments

191: and transaction_header_id_out is NULL
192: and rownum = 1
193: and distribution_id =
194: nvl((select max(distribution_id) /*Bug 8301287. There may be a case where there exists no Records*/
195: from fa_mc_adjustments
196: where book_type_code = RET.book
197: and asset_id = RET.asset_id
198: -- and source_type_code in ('ADDITION')
199: and adjustment_amount <> 0

Line 619: FROM FA_MC_ADJUSTMENTS

615: 'CR', ADJUSTMENT_AMOUNT,
616: -1 * ADJUSTMENT_AMOUNT), 0)*
617: DECODE(ADJUSTMENT_TYPE, 'RESERVE', -1,
618: 'IMPAIR RESERVE', -1, 1)) --hh: 6867027
619: FROM FA_MC_ADJUSTMENTS
620: WHERE (DISTRIBUTION_ID = c_dist_id
621: OR DISTRIBUTION_ID = c_new_dist_id)
622: AND BOOK_TYPE_CODE = ret.book
623: AND PERIOD_COUNTER_CREATED = cpd_ctr

Line 655: from fa_mc_adjustments

651: and adjustment_type = 'RESERVE';
652:
653: CURSOR c_get_g_rsv_ret_mrc is --Bug 9103418
654: select adjustment_amount
655: from fa_mc_adjustments
656: where asset_id = bk.group_asset_id
657: and book_type_code = ret.book
658: and transaction_header_id = ret.th_id_in
659: and adjustment_type = 'RESERVE'

Line 682: from fa_mc_adjustments

678: ,'COST', decode(debit_credit_flag,'CR', nvl(adjustment_amount,0), -1 * nvl(adjustment_amount,0))
679: ,'RESERVE', decode(debit_credit_flag,'DR', -1 * nvl(adjustment_amount,0), nvl(adjustment_amount,0))
680: ,'IMPAIR RESERVE', decode(debit_credit_flag,'DR', -1 * nvl(adjustment_amount,0), nvl(adjustment_amount,0))
681: ,0))
682: from fa_mc_adjustments
683: where asset_id = ret.asset_id
684: and book_type_code = ret.book
685: and transaction_header_id = ret.th_id_in
686: and source_type_code='RETIREMENT'

Line 2536: fa_mc_adjustments faadj

2532: FROM
2533: fa_distribution_history fadh,
2534: fa_mc_deprn_detail fadd,
2535: fa_deprn_periods fadp,
2536: fa_mc_adjustments faadj
2537: WHERE
2538: fadd.asset_id = h_asset_id
2539: AND fadd.distribution_id = fadh.distribution_id
2540: AND fadd.book_type_code = h_book

Line 2586: fa_mc_adjustments faadj

2582: faadj.transaction_header_id
2583: FROM
2584: fa_distribution_history fadh,
2585: fa_deprn_periods fadp,
2586: fa_mc_adjustments faadj
2587: WHERE
2588: fadp.period_num = h_i
2589: AND fadp.book_type_code = h_book
2590: AND fadp.fiscal_year = h_current_fiscal_yr

Line 2796: fa_mc_adjustments faadj

2792: SELECT count(*)
2793: INTO h_ret_count
2794: FROM
2795: fa_deprn_periods fadp,
2796: fa_mc_adjustments faadj
2797: WHERE
2798: fadp.period_num = h_i
2799: AND fadp.book_type_code = h_book
2800: AND fadp.fiscal_year = h_current_fiscal_yr

Line 2813: fa_mc_adjustments faadj

2809: SELECT count(*)
2810: INTO h_adj_count
2811: FROM
2812: fa_deprn_periods fadp,
2813: fa_mc_adjustments faadj
2814: WHERE
2815: fadp.period_num = h_i
2816: AND fadp.book_type_code = h_book
2817: AND fadp.fiscal_year = h_current_fiscal_yr

Line 3566: fa_mc_adjustments adj,

3562:
3563: SELECT sum(nvl(adjustment_amount,0))--bug fix 3905436
3564: INTO h_adj_exp_row
3565: FROM
3566: fa_mc_adjustments adj,
3567: fa_deprn_periods dp,
3568: fa_transaction_headers th
3569: WHERE
3570: th.asset_id = h_asset_id

Line 3716: fa_mc_adjustments adj,

3712:
3713: SELECT sum(adjustment_amount), max(th.transaction_header_id)
3714: INTO h_adj_exp_row, h_old_reinst_trx_id
3715: FROM
3716: fa_mc_adjustments adj,
3717: fa_deprn_periods dp,
3718: fa_transaction_headers th
3719: WHERE
3720: th.asset_id = h_asset_id

Line 6054: FROM FA_MC_ADJUSTMENTS faadj

6050:
6051: begin
6052: SELECT SUM(faadj.adjustment_amount)
6053: INTO h_deprn_amt
6054: FROM FA_MC_ADJUSTMENTS faadj
6055: WHERE
6056: faadj.transaction_header_id = h_th_id_in
6057: AND faadj.source_type_code = 'RETIREMENT'
6058: AND faadj.adjustment_type = 'EXPENSE'

Line 6127: FROM FA_MC_ADJUSTMENTS faadj

6123: else
6124: begin
6125: SELECT SUM(faadj.adjustment_amount)
6126: INTO h_bonus_deprn_amt
6127: FROM FA_MC_ADJUSTMENTS faadj
6128: WHERE
6129: faadj.transaction_header_id = h_th_id_in
6130: AND faadj.source_type_code = 'RETIREMENT'
6131: AND faadj.adjustment_type = 'BONUS EXPENSE'

Line 6149: FROM FA_MC_ADJUSTMENTS faadj

6145:
6146: begin
6147: SELECT SUM(faadj.adjustment_amount)
6148: INTO h_impairment_amt
6149: FROM FA_MC_ADJUSTMENTS faadj
6150: WHERE
6151: faadj.transaction_header_id = h_th_id_in
6152: AND faadj.source_type_code = 'RETIREMENT'
6153: AND faadj.adjustment_type = 'IMPAIR EXPENSE'

Line 6202: FROM FA_MC_ADJUSTMENTS faadj

6198: else
6199: begin
6200: SELECT SUM(faadj.adjustment_amount)
6201: INTO h_reval_deprn_amt
6202: FROM FA_MC_ADJUSTMENTS faadj
6203: WHERE
6204: faadj.transaction_header_id = h_th_id_in
6205: AND faadj.source_type_code = 'RETIREMENT'
6206: AND faadj.adjustment_type = 'REVAL EXPENSE'

Line 6250: FROM FA_MC_ADJUSTMENTS faadj

6246: else
6247: begin
6248: SELECT SUM(faadj.adjustment_amount)
6249: INTO h_reval_amort
6250: FROM FA_MC_ADJUSTMENTS faadj
6251: WHERE
6252: faadj.transaction_header_id = h_th_id_in
6253: AND faadj.source_type_code = 'RETIREMENT'
6254: AND faadj.adjustment_type = 'REVAL AMORT'