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_PROCESS_GROUPS_PKG dependencies on FA_BOOKS

Line 205: from fa_books bk,

201: th.calling_interface,
202: th.member_transaction_header_id,
203: th.trx_reference_id,
204: th.event_id
205: from fa_books bk,
206: fa_transaction_headers th
207: where bk.asset_id in (l_source_asset_id, l_dest_asset_id)
208: and bk.book_type_code = p_book
209: and bk.adjustment_required_status = 'GADJ'

Line 227: from fa_books bk,

223: th.calling_interface,
224: th.member_transaction_header_id,
225: th.trx_reference_id,
226: th.event_id
227: from fa_books bk,
228: fa_transaction_headers th
229: where bk.book_type_code = p_book
230: and bk.adjustment_required_status = 'GADJ'
231: and bk.date_ineffective is null

Line 237: from fa_books

233: order by bk.transaction_header_id_in;
234:
235: cursor get_old_trx is
236: select transaction_header_id_in
237: from fa_books
238: where asset_id = l_asset_id
239: and book_type_code = p_book
240: and transaction_header_id_out = l_trx_id_in;
241:

Line 244: from fa_books

240: and transaction_header_id_out = l_trx_id_in;
241:
242: cursor check_adj_status is
243: select count(*)
244: from fa_books
245: where transaction_header_id_in = l_trx_id_in
246: and adjustment_required_status = 'GADJ';
247:
248: cursor get_trx_ref is

Line 923: -- now update fa_books

919: end if;
920:
921: end if;
922:
923: -- now update fa_books
924: update fa_books
925: set rate_adjustment_factor =
926: l_asset_fin_rec_new.rate_adjustment_factor,
927: reval_amortization_basis =

Line 924: update fa_books

920:
921: end if;
922:
923: -- now update fa_books
924: update fa_books
925: set rate_adjustment_factor =
926: l_asset_fin_rec_new.rate_adjustment_factor,
927: reval_amortization_basis =
928: l_asset_fin_rec_new.reval_amortization_basis,

Line 1190: update fa_books

1186: end if; -- l_trans_rec.transaction_key <> GC
1187:
1188: if (l_trans_rec.transaction_key in ('UA', 'UE', 'MR', 'MS')) then
1189:
1190: update fa_books
1191: set adjustment_required_status = 'NONE'
1192: where rowid = l_rowid;
1193:
1194: end if;

Line 1326: from fa_books

1322: and transaction_header_id_out is null;
1323:
1324: cursor get_old_trx is
1325: select transaction_header_id_in
1326: from fa_books
1327: where asset_id = l_asset_id
1328: and book_type_code = p_trx_ref_rec.book_type_code
1329: and transaction_header_id_out = l_trx_id_in;
1330:

Line 2452: update fa_books

2448:
2449: if (p_mrc_sob_type_code <> 'R') then
2450:
2451: if (l_grp_src_asset_type_rec.asset_type = 'GROUP') then
2452: update fa_books
2453: set adjustment_required_status = 'NONE'
2454: , adjusted_cost = l_grp_src_asset_fin_rec_new.adjusted_cost
2455: , rate_adjustment_factor = l_grp_src_asset_fin_rec_new.rate_adjustment_factor
2456: , formula_factor = l_grp_src_asset_fin_rec_new.formula_factor

Line 2468: update fa_books

2464: where asset_id = l_src_asset
2465: and book_type_code = p_trx_ref_rec.book_type_code
2466: and transaction_header_id_out is null;
2467: else
2468: update fa_books
2469: set adjustment_required_status = 'NONE'
2470: where asset_id = l_src_asset
2471: and book_type_code = p_trx_ref_rec.book_type_code
2472: and transaction_header_id_out is null;

Line 2476: update fa_books

2472: and transaction_header_id_out is null;
2473: end if;
2474:
2475: if (l_dest_asset_type_rec.asset_type = 'GROUP') then
2476: update fa_books
2477: set adjustment_required_status = 'NONE'
2478: , adjusted_cost = l_dest_asset_fin_rec_new.adjusted_cost
2479: , rate_adjustment_factor = l_dest_asset_fin_rec_new.rate_adjustment_factor
2480: , formula_factor = l_dest_asset_fin_rec_new.formula_factor

Line 2492: update fa_books

2488: where asset_id = l_dest_asset
2489: and book_type_code = p_trx_ref_rec.book_type_code
2490: and transaction_header_id_out is null;
2491: else
2492: update fa_books
2493: set adjustment_required_status = 'NONE'
2494: where asset_id = l_dest_asset
2495: and book_type_code = p_trx_ref_rec.book_type_code
2496: and transaction_header_id_out is null;

Line 2507: update fa_books_mrc_v

2503: where trx_reference_id = l_src_trans_rec.trx_reference_id;
2504:
2505: else
2506: if (l_grp_src_asset_type_rec.asset_type = 'GROUP') then
2507: update fa_books_mrc_v
2508: set adjustment_required_status = 'NONE'
2509: , adjusted_cost = l_grp_src_asset_fin_rec_new.adjusted_cost
2510: , rate_adjustment_factor = l_grp_src_asset_fin_rec_new.rate_adjustment_factor
2511: , formula_factor = l_grp_src_asset_fin_rec_new.formula_factor

Line 2523: update fa_books_mrc_v

2519: where asset_id = l_src_asset
2520: and book_type_code = p_trx_ref_rec.book_type_code
2521: and transaction_header_id_out is null;
2522: else
2523: update fa_books_mrc_v
2524: set adjustment_required_status = 'NONE'
2525: where asset_id = l_src_asset
2526: and book_type_code = p_trx_ref_rec.book_type_code
2527: and transaction_header_id_out is null;

Line 2531: update fa_books_mrc_v

2527: and transaction_header_id_out is null;
2528: end if;
2529:
2530: if (l_dest_asset_type_rec.asset_type = 'GROUP') then
2531: update fa_books_mrc_v
2532: set adjustment_required_status = 'NONE'
2533: , adjusted_cost = l_dest_asset_fin_rec_new.adjusted_cost
2534: , rate_adjustment_factor = l_dest_asset_fin_rec_new.rate_adjustment_factor
2535: , formula_factor = l_dest_asset_fin_rec_new.formula_factor

Line 2547: update fa_books_mrc_v

2543: where asset_id = l_dest_asset
2544: and book_type_code = p_trx_ref_rec.book_type_code
2545: and transaction_header_id_out is null;
2546: else
2547: update fa_books_mrc_v
2548: set adjustment_required_status = 'NONE'
2549: where asset_id = l_dest_asset
2550: and book_type_code = p_trx_ref_rec.book_type_code
2551: and transaction_header_id_out is null;