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_RETIREMENTS

Line 138: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp

134: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
135: faadj.adjustment_amount,
136: faadj.track_member_flag --Bug8244128
137: FROM
138: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp
139: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
140: AND faadj.asset_id = faret.asset_id
141: AND faadj.book_type_Code = faret.book_type_code
142: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 165: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp

161: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
162: faadj.adjustment_amount,
163: faadj.track_member_flag --Bug8244128
164: FROM
165: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp
166: WHERE faadj.transaction_header_id = p_group_thid
167: AND faadj.asset_id = p_group_asset_id
168: AND faadj.book_type_Code = faret.book_type_code
169: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 264: element => 'Updating fa_retirements',

260:
261: if (p_log_level_rec.statement_level) then
262: fa_debug_pkg.add
263: (fname => l_calling_fn,
264: element => 'Updating fa_retirements',
265: value => '', p_log_level_rec => p_log_level_rec);
266: end if;
267:
268: if (ret.mrc_sob_type_code <> 'R') then

Line 269: UPDATE FA_RETIREMENTS

265: value => '', p_log_level_rec => p_log_level_rec);
266: end if;
267:
268: if (ret.mrc_sob_type_code <> 'R') then
269: UPDATE FA_RETIREMENTS
270: SET status = 'DELETED',
271: last_update_date = today,
272: last_updated_by = user_id
273: WHERE retirement_id = ret.retirement_id;

Line 287: from fa_retirements

283: -- Get thid_out from fa_rets
284: -- this can never be different for primary and reporting book
285: select transaction_header_id_out
286: into h_th_id_out
287: from fa_retirements
288: where retirement_id = h_ret_id;
289:
290: if ret.wip_asset > 0 then
291: adj_row.source_type_code := 'CIP RETIREMENT';

Line 477: FROM fa_book_controls bc, fa_retirements retire, fa_books bk

473: retire.transaction_header_id_in,
474: bk.group_asset_id,
475: bk.member_rollup_flag,
476: bk.tracking_method
477: FROM fa_book_controls bc, fa_retirements retire, fa_books bk
478: WHERE
479: retire.retirement_id = RET.retirement_id
480: AND retire.units is not null
481: AND bc.distribution_source_book = retire.book_type_code

Line 496: FROM fa_mc_book_controls fmcbc,fa_book_controls fbc, fa_retirements retire, fa_mc_books bk

492: retire.transaction_header_id_in,
493: bk.group_asset_id,
494: bk.member_rollup_flag,
495: bk.tracking_method
496: FROM fa_mc_book_controls fmcbc,fa_book_controls fbc, fa_retirements retire, fa_mc_books bk
497: WHERE
498: retire.retirement_id = RET.retirement_id
499: AND retire.units is not null
500: AND fbc.distribution_source_book = retire.book_type_code

Line 1427: fa_retirements rt

1423: CURSOR PRET IS
1424: SELECT dh.distribution_id
1425: FROM fa_distribution_history dh,
1426: fa_book_controls bc,
1427: fa_retirements rt
1428: WHERE dh.asset_id = h_asset_id
1429: AND dh.book_type_code = bc.distribution_source_book
1430: AND bc.book_type_code = h_book
1431: AND rt.asset_id = dh.asset_id

Line 1580: FROM fa_retirements

1576:
1577: SELECT
1578: transaction_header_id_out
1579: INTO h_rethdrout
1580: FROM fa_retirements
1581: WHERE retirement_id = h_ret_id;
1582:
1583: if (p_log_level_rec.statement_level) then
1584: fa_debug_pkg.add

Line 2850: from fa_retirements

2846: end if;
2847:
2848: select transaction_header_id_out
2849: into h_th_id_out
2850: from fa_retirements
2851: where retirement_id = h_retirement_id;
2852:
2853: /* Bug 843625 fix */
2854: if RET.wip_asset > 0 then

Line 3096: from fa_retirements rt

3092: FROM fa_distribution_history fadh
3093: WHERE fadh.asset_id = RET.asset_id
3094: AND fadh.TRANSACTION_HEADER_ID_OUT
3095: = (select rt.transaction_header_id_out
3096: from fa_retirements rt
3097: where rt.retirement_id = RET.retirement_id
3098: )
3099: order by distribution_id;
3100:

Line 3276: from fa_retirements

3272:
3273: begin
3274: select transaction_header_id_out
3275: into h_th_id_out
3276: from fa_retirements
3277: where retirement_id = h_retirement_id;
3278: EXCEPTION
3279: when no_data_found then
3280: raise fagiav_error;

Line 3700: FROM FA_RETIREMENTS faret, fa_distribution_history fadh,

3696: * expense_amount -
3697: NVL(faadj.adjustment_amount, 0),
3698: (ABS(fadh.transaction_units) / faret.units)
3699: * expense_amount -- Bug 6666666
3700: FROM FA_RETIREMENTS faret, fa_distribution_history fadh,
3701: fa_adjustments faadj
3702: WHERE fadh.asset_id = RET.asset_id
3703: AND fadh.book_type_code = BK.dis_book
3704: AND fadh.retirement_id = RET.retirement_id

Line 3745: FA_RETIREMENTS faret,

3741: faadj.distribution_id,
3742: faadj.code_combination_id,
3743: - 1 * faadj.adjustment_amount
3744: FROM
3745: FA_RETIREMENTS faret,
3746: FA_DISTRIBUTION_HISTORY fadh,
3747: FA_ADJUSTMENTS faadj
3748: WHERE fadh.asset_id(+) = RET.asset_id
3749: AND fadh.book_type_code(+) = BK.dis_book

Line 3810: from fa_retirements

3806: end if;
3807:
3808: select transaction_header_id_out
3809: into h_th_id_out
3810: from fa_retirements
3811: where retirement_id = h_retirement_id;
3812:
3813: -- bug#5094783 fix added ((ret.cost_retired / bk.current_cost) =1 )
3814: if ( bk.current_cost is NULL or bk.current_cost <= 0 or ((ret.cost_retired / bk.current_cost) =1 )) then

Line 4809: from fa_retirements

4805:
4806: if(ret.mrc_sob_type_code <> 'R')then
4807: select transaction_header_id_out
4808: into h_th_id_out
4809: from fa_retirements
4810: where retirement_id = ret.retirement_id;
4811: else
4812: select transaction_header_id_out
4813: into h_th_id_out

Line 6241: from fa_retirements rt,

6237: end if;
6238: begin
6239: select transaction_header_id_out,transaction_type_code
6240: into h_th_id_out,h_th_type_code
6241: from fa_retirements rt,
6242: fa_transaction_headers fth
6243: where retirement_id = ret.retirement_id
6244: and rt.transaction_header_id_IN = fth.transaction_header_id
6245: and rt.asset_id = fth.asset_id