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_GROUP_RECLASS2_PVT dependencies on FA_ADJUSTMENTS

Line 485: delete from fa_adjustments

481: and adjustment_type in ('EXPENSE', 'BONUS EXPENSE', 'IMPAIR EXPENSE')
482: and source_type_code = 'DEPRECIATION'
483: and set_of_books_id = px_src_asset_hdr_rec.set_of_books_id;
484: else
485: delete from fa_adjustments
486: where asset_id = px_src_asset_hdr_rec.asset_id
487: and book_type_code = px_src_asset_hdr_rec.book_type_code
488: and transaction_header_id = px_src_trans_rec.transaction_header_id
489: and adjustment_type in ('EXPENSE', 'BONUS EXPENSE', 'IMPAIR EXPENSE')

Line 746: delete from fa_adjustments

742: 'IMPAIR EXPENSE')
743: and source_type_code = 'DEPRECIATION'
744: and set_of_books_id = px_dest_asset_hdr_rec.set_of_books_id;
745: else
746: delete from fa_adjustments
747: where asset_id = px_dest_asset_hdr_rec.asset_id
748: and book_type_code = px_dest_asset_hdr_rec.book_type_code
749: and transaction_header_id = px_dest_trans_rec.transaction_header_id
750: and adjustment_type in ('EXPENSE', 'BONUS EXPENSE',

Line 987: from fa_adjustments adj

983: CURSOR c_get_exp_amount IS
984: select NVL(SUM(DECODE(adj.debit_credit_flag,
985: 'DR', adj.adjustment_amount,
986: 'CR', -1 * adj.adjustment_amount)), 0)
987: from fa_adjustments adj
988: where adj.asset_id = p_asset_hdr_rec.asset_id
989: and adj.book_type_code = p_asset_hdr_rec.book_type_code
990: and adj.adjustment_type = 'EXPENSE'
991: and adj.period_counter_created = p_period_rec.period_counter

Line 995: we need to consider the expense just inserted into fa_adjustments by this transaction*/

991: and adj.period_counter_created = p_period_rec.period_counter
992: and adj.track_member_flag = 'Y'
993: and adj.transaction_header_id = px_trans_rec.transaction_header_id;
994: /* Bug 8237945 added above transaction_header_id condition. To get the backed out expense
995: we need to consider the expense just inserted into fa_adjustments by this transaction*/
996:
997: --bug6983091: MRC: getting expense just backed out
998: CURSOR c_get_mc_exp_amount IS
999: select NVL(SUM(DECODE(adj.debit_credit_flag,

Line 1011: we need to consider the expense just inserted into fa_adjustments by this transaction*/

1007: and adj.track_member_flag = 'Y'
1008: and adj.transaction_header_id = px_trans_rec.transaction_header_id
1009: and adj.set_of_books_id = p_asset_hdr_rec.set_of_books_id;
1010: /* Bug 8237945 added above transaction_header_id condition. To get the backed out expense
1011: we need to consider the expense just inserted into fa_adjustments by this transaction*/
1012:
1013: l_calling_fn VARCHAR2(35) := 'fa_group_reclass_pvt.do_adjustment';
1014: grp_rec_err EXCEPTION;
1015:

Line 1122: -- basically, derive the info for each insert into fa_adjustments

1118: l_exp_adj.mrc_sob_type_code := p_mrc_sob_type_code;
1119: l_exp_adj.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
1120:
1121: -- most of the following logic was stolen from FAVGRCLB.pls (CRL)
1122: -- basically, derive the info for each insert into fa_adjustments
1123: -- based on the source / destination / asset type, etc
1124:
1125: -- set up the accounting related values in the adj_ptr
1126: if (p_src_dest = 'SOURCE') then

Line 1969: from fa_adjustments adj

1965: cursor FA_ADJ_RESERVE is
1966: select sum(decode(adj.debit_credit_flag,
1967: 'DR',adj.adjustment_amount,
1968: 'CR', -1 * adj.adjustment_amount))
1969: from fa_adjustments adj
1970: where adj.book_type_code = h_book_type_code
1971: and adj.asset_id = h_member_asset_id
1972: and adj.adjustment_type = 'RESERVE'
1973: and adj.source_type_code = 'ADJUSTMENT'