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

Line 196: fa_mc_adjustments faadj,

192: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
193: faadj.adjustment_amount,
194: faadj.track_member_flag --Bug8244128
195: FROM
196: fa_mc_adjustments faadj,
197: fa_mc_retirements faret,
198: fa_deprn_periods dp
199: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
200: AND faadj.asset_id = faret.asset_id

Line 227: fa_mc_adjustments faadj,

223: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
224: faadj.adjustment_amount,
225: faadj.track_member_flag --Bug8244128
226: FROM
227: fa_mc_adjustments faadj,
228: fa_mc_retirements faret,
229: fa_deprn_periods dp
230: WHERE faadj.transaction_header_id = p_group_thid
231: AND faadj.asset_id = p_group_asset_id

Line 2025: UPDATE fa_mc_adjustments aj

2021: AND aj.book_type_code = h_book
2022: AND aj.distribution_id = h_pdistid
2023: AND aj.transaction_header_id = h_rethdrout;
2024: else
2025: UPDATE fa_mc_adjustments aj
2026: SET distribution_id = h_tdistid
2027: WHERE aj.asset_id = h_asset_id
2028: AND aj.book_type_code = h_book
2029: AND aj.distribution_id = h_pdistid

Line 2063: UPDATE fa_mc_adjustments aj

2059: AND aj.book_type_code = h_book
2060: AND aj.distribution_id = h_pdistid
2061: AND aj.transaction_header_id = h_rethdrout;
2062: else
2063: UPDATE fa_mc_adjustments aj
2064: SET distribution_id = h_tdistid
2065: WHERE aj.asset_id = h_asset_id
2066: AND aj.book_type_code = h_book
2067: AND aj.distribution_id = h_pdistid

Line 2491: UPDATE FA_MC_ADJUSTMENTS

2487: AND nvl (r.assigned_to, -99) = nvl (d.assigned_to, -99)
2488: );
2489:
2490: -- CHECK: this was fa_adjustments table before which i think was wrong
2491: UPDATE FA_MC_ADJUSTMENTS
2492: SET DISTRIBUTION_ID = C1_rec.distribution_id
2493: WHERE TRANSACTION_HEADER_ID = h_rethdrout
2494: AND book_type_code = h_book /* Added for bug 7659930*/
2495: AND DISTRIBUTION_ID = l_temp_dist_id1

Line 2588: UPDATE FA_MC_ADJUSTMENTS

2584: );
2585:
2586: else
2587:
2588: UPDATE FA_MC_ADJUSTMENTS
2589: SET DISTRIBUTION_ID = h_adj_distid
2590: WHERE TRANSACTION_HEADER_ID = h_rethdrout
2591: AND DISTRIBUTION_ID <> h_adj_distid
2592: AND SET_OF_BOOKS_ID = ret.set_of_books_id

Line 2775: FROM fa_mc_adjustments faadj, fa_distribution_history fadh

2771: abs(sum(decode(faadj.debit_credit_flag,'DR',faadj.adjustment_amount,-1*faadj.adjustment_amount)))
2772: adjustment_amount,
2773: 'N' adj_rec_found,
2774: faadj.code_combination_id adj_ccid
2775: FROM fa_mc_adjustments faadj, fa_distribution_history fadh
2776: where fadh.asset_id = RET.asset_id
2777: AND faadj.book_type_code = BK.dis_book
2778: AND faadj.asset_id = RET.asset_id
2779: and fadh.distribution_id = faadj.distribution_id

Line 2806: from fa_mc_adjustments faadj

2802: (
2803: select adjustment_type,
2804: sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount )) adjustment_amount,
2805: faadj.code_combination_id adj_ccid
2806: from fa_mc_adjustments faadj
2807: where faadj.asset_id = RET.asset_id
2808: and faadj.transaction_header_id = ret.th_id_in
2809: and faadj.book_type_code = ret.book
2810: and faadj.set_of_books_id = ret.set_of_books_id

Line 3187: FROM fa_mc_adjustments faadj, fa_distribution_history fadh

3183: abs(sum(decode(faadj.debit_credit_flag,'DR',faadj.adjustment_amount,-1*faadj.adjustment_amount)))
3184: adjustment_amount,
3185: 'N' adj_rec_found,
3186: faadj.code_combination_id adj_ccid
3187: FROM fa_mc_adjustments faadj, fa_distribution_history fadh
3188: where fadh.asset_id = RET.asset_id
3189: AND faadj.book_type_code = BK.dis_book
3190: AND faadj.asset_id = RET.asset_id
3191: and fadh.distribution_id = faadj.distribution_id

Line 3216: from fa_mc_adjustments faadj

3212: (
3213: select adjustment_type,
3214: sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount )) adjustment_amount,
3215: faadj.code_combination_id adj_ccid
3216: from fa_mc_adjustments faadj
3217: where ( (faadj.transaction_header_id = ret.th_id_in AND faadj.asset_id = h_asset_id)
3218: )
3219: and faadj.book_type_code = ret.book
3220: and faadj.set_of_books_id = ret.set_of_books_id

Line 3237: from fa_mc_adjustments faadj

3233: (
3234: select adjustment_type,
3235: sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount )) adjustment_amount,
3236: faadj.code_combination_id adj_ccid
3237: from fa_mc_adjustments faadj
3238: where (
3239: (faadj.transaction_header_id = l_group_thid AND faadj.asset_id = bk.group_asset_id)
3240: )
3241: and faadj.book_type_code = ret.book

Line 3611: FA_MC_ADJUSTMENTS adj

3607: * expense_amount -- Bug 6666666
3608: FROM
3609: FA_DISTRIBUTION_HISTORY dh,
3610: FA_ASSET_HISTORY ah,
3611: FA_MC_ADJUSTMENTS adj
3612: WHERE dh.asset_id = RET.asset_id
3613: AND dh.book_type_code = BK.dis_book
3614: AND dh.date_ineffective is null
3615: AND dh.distribution_id = adj.distribution_id(+)

Line 3633: FA_MC_ADJUSTMENTS adj -- bug#5094783 fix

3629: 0 -- Bug 6666666
3630: FROM
3631: FA_DISTRIBUTION_HISTORY dh,
3632: FA_ASSET_HISTORY ah,
3633: FA_MC_ADJUSTMENTS adj -- bug#5094783 fix
3634: WHERE dh.asset_id = RET.asset_id
3635: AND dh.book_type_code = BK.dis_book
3636: AND dh.date_ineffective is null
3637: AND dh.distribution_id = adj.distribution_id(+)

Line 3676: fa_mc_adjustments faadj

3672: faadj.code_combination_id,
3673: - 1 * faadj.adjustment_amount
3674: FROM
3675: fa_distribution_history fadh,
3676: fa_mc_adjustments faadj
3677: WHERE fadh.asset_id(+) = RET.asset_id
3678: AND fadh.book_type_code(+) = BK.dis_book
3679: AND fadh.date_ineffective(+) is null
3680: AND fadh.distribution_id(+) = faadj.distribution_id

Line 3724: fa_mc_adjustments faadj

3720: NVL(faadj.adjustment_amount, 0),
3721: (ABS(fadh.transaction_units) / faret.units)
3722: * expense_amount -- Bug 6666666
3723: FROM FA_MC_RETIREMENTS faret, fa_distribution_history fadh,
3724: fa_mc_adjustments faadj
3725: WHERE fadh.asset_id = RET.asset_id
3726: AND fadh.book_type_code = BK.dis_book
3727: AND fadh.retirement_id = RET.retirement_id
3728: AND fadh.distribution_id = faadj.distribution_id(+)

Line 3769: FA_MC_ADJUSTMENTS faadj

3765: - 1 * faadj.adjustment_amount
3766: FROM
3767: FA_MC_RETIREMENTS faret,
3768: FA_DISTRIBUTION_HISTORY fadh,
3769: FA_MC_ADJUSTMENTS faadj
3770: WHERE fadh.asset_id(+) = RET.asset_id
3771: AND fadh.book_type_code(+) = BK.dis_book
3772: AND fadh.retirement_id(+) = RET.retirement_id
3773: AND fadh.distribution_id(+) = faadj.distribution_id

Line 4571: FROM fa_mc_adjustments faadj

4567: -1 * faadj.adjustment_amount,
4568: faadj.adjustment_amount),
4569: faadj.adjustment_amount))
4570: INTO h_tot_deprn_adj
4571: FROM fa_mc_adjustments faadj
4572: WHERE faadj.asset_id = RET.asset_id
4573: AND faadj.book_type_code = RET.book
4574: AND faadj.source_type_code = 'RETIREMENT'
4575: AND faadj.adjustment_type in ('RESERVE', 'EXPENSE', 'REVAL EXPENSE')

Line 4621: FROM fa_mc_adjustments faadj

4617: -1 * faadj.adjustment_amount,
4618: faadj.adjustment_amount),
4619: faadj.adjustment_amount))
4620: INTO h_tot_bonus_deprn_adj
4621: FROM fa_mc_adjustments faadj
4622: WHERE faadj.asset_id = RET.asset_id
4623: AND faadj.book_type_code = RET.book
4624: AND faadj.source_type_code = 'RETIREMENT'
4625: AND faadj.adjustment_type in ('BONUS RESERVE', 'BONUS EXPENSE')

Line 4671: FROM fa_mc_adjustments faadj

4667: -1 * faadj.adjustment_amount,
4668: faadj.adjustment_amount),
4669: faadj.adjustment_amount))
4670: INTO h_tot_impairment_adj
4671: FROM fa_mc_adjustments faadj
4672: WHERE faadj.asset_id = RET.asset_id
4673: AND faadj.book_type_code = RET.book
4674: AND faadj.source_type_code = 'RETIREMENT'
4675: AND faadj.adjustment_type in ('IMPAIR RESERVE', 'IMPAIR EXPENSE')

Line 4721: FROM fa_mc_adjustments faadj

4717: -1 * faadj.adjustment_amount,
4718: faadj.adjustment_amount),
4719: -1 * faadj.adjustment_amount))
4720: INTO h_tot_reval_adj
4721: FROM fa_mc_adjustments faadj
4722: WHERE faadj.asset_id = RET.asset_id
4723: AND faadj.book_type_code = RET.book
4724: AND faadj.source_type_code = decode(RET.wip_asset,1,'CIP RETIREMENT','RETIREMENT') /*12768930 */
4725: AND faadj.adjustment_type in ('REVAL RESERVE', 'REVAL AMORT')

Line 4894: FROM fa_mc_adjustments

4890: h_ccid,
4891: h_adj_type,
4892: h_source_type_code,
4893: h_th_id
4894: FROM fa_mc_adjustments
4895: WHERE ASSET_ID = RET.ASSET_id
4896: and book_type_code = ret.book
4897: and distribution_id = h_dist_id
4898: and set_of_books_id = ret.set_of_books_id

Line 5338: from fa_mc_adjustments

5334: and transaction_header_id = ret.th_id_in;
5335: ELSE
5336: select sum(decode(debit_credit_flag, 'CR', -1, 1) * adjustment_amount)
5337: into l_reserve_ret
5338: from fa_mc_adjustments
5339: where asset_id = ret.asset_id
5340: and book_type_code = ret.book
5341: and source_type_code = 'RETIREMENT'
5342: and adjustment_type = 'RESERVE'

Line 5360: from fa_mc_adjustments

5356: and transaction_header_id = ret.th_id_in;
5357: ELSE
5358: select nvl(sum(decode(debit_credit_flag, 'DR', adjustment_amount, -adjustment_amount)), 0)
5359: into l_exp_ret
5360: from fa_mc_adjustments
5361: where asset_id = ret.asset_id
5362: and book_type_code = ret.book
5363: and source_type_code = 'RETIREMENT'
5364: and adjustment_type = 'EXPENSE'