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

Line 240: ' rate FROM fa_books fabk, fa_deprn_periods fadp ' ||

236: h_formula_parsed := REPLACE(h_formula_parsed, 'LIFE_IN_MONTHS', TO_CHAR(X_Life_In_Months));
237:
238: -- Fix for Bug #2939771. Use bind variables.
239: h_formula := 'SELECT ' || h_formula_parsed ||
240: ' rate FROM fa_books fabk, fa_deprn_periods fadp ' ||
241: ' WHERE (fabk.asset_id = :v1) ' ||
242: ' AND (fabk.book_type_code = :v2' ||
243: ' ) AND (fabk.book_type_code = fadp.book_type_code) ' ||
244: ' AND (fabk.date_ineffective is null) ' ||

Line 349: fa_debug_pkg.ADD('FAXGFR','+++ Fetching current rate from fa_books', 'YES', p_log_level_rec => p_log_level_rec);

345:
346: IF fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' THEN
347: IF X_calling_interface IS NULL THEN
348: IF (p_log_level_rec.statement_level) THEN
349: fa_debug_pkg.ADD('FAXGFR','+++ Fetching current rate from fa_books', 'YES', p_log_level_rec => p_log_level_rec);
350: END IF; -- _debug
351:
352: SELECT rate_in_use
353: INTO X_Rate

Line 356: FROM fa_books

352: SELECT rate_in_use
353: INTO X_Rate
354: FROM ( SELECT rate_in_use,
355: rank() over(order by transaction_header_id_in desc) rank
356: FROM fa_books
357: WHERE book_type_code = X_Book_Type_Code
358: AND asset_id = X_Asset_Id
359: AND deprn_method_code = X_Method_Code
360: )

Line 468: FROM fa_books bk,

464: X_curr_fy_end_date,
465: h_curr_fy,
466: h_dpis,
467: h_deprn_start_date
468: FROM fa_books bk,
469: fa_fiscal_year fy,
470: fa_book_controls bc,
471: fa_book_controls bc2
472: WHERE bc.book_type_code = X_Book_Type_Code

Line 1130: raf rate_adj_factor rate_adjustment_factor in fa_books

1126:
1127: amo_reval_rsv_flag amo_reval_rsv_flag amortize_reval_reserve_flag in
1128: fa_book_controls
1129:
1130: raf rate_adj_factor rate_adjustment_factor in fa_books
1131:
1132: cur_fy cur_fy current fiscal year
1133:
1134: deprn_limit_flag use_deprn_limit_flag use depreciation limit flag

Line 1329: l_ind BINARY_INTEGER; -- For FA_BOOKS_SUMMARY

1325: cdb_bonus_deprn_rsv NUMBER;
1326:
1327: l_period_counter NUMBER(15); -- For Super Group
1328:
1329: l_ind BINARY_INTEGER; -- For FA_BOOKS_SUMMARY
1330: l_accum_rsv_adj NUMBER; -- Store reserve adjustment_amount.
1331: -- It will be accumulated if faxcde is called for
1332: -- multiple periods
1333: l_rsv_adj NUMBER; -- Store reserve adjustment amount from fa_amort_pvt

Line 1881: --- The following code is added to check whether NBV_AT_SWITCH column of fa_books has value or Not.

1877: l_request_short_name := NULL;
1878: END;
1879: END IF;
1880:
1881: --- The following code is added to check whether NBV_AT_SWITCH column of fa_books has value or Not.
1882: IF l_request_short_name = 'FAWDPR' then
1883: BEGIN
1884: SELECT nbv_at_switch
1885: INTO l_nbv_at_switch

Line 1886: FROM fa_books

1882: IF l_request_short_name = 'FAWDPR' then
1883: BEGIN
1884: SELECT nbv_at_switch
1885: INTO l_nbv_at_switch
1886: FROM fa_books
1887: WHERE asset_id = dpr.asset_id
1888: AND book_type_code = dpr.book
1889: AND transaction_header_id_out is null;
1890: EXCEPTION

Line 2338: FROM FA_BOOKS bk,

2334:
2335: /* Below query will fetch the Fiscal year and Period number of DPIS */
2336: SELECT fy.fiscal_year,cl.period_num
2337: INTO dpis_fy,dpis_perd_num
2338: FROM FA_BOOKS bk,
2339: FA_CALENDAR_PERIODS CL,
2340: FA_BOOK_CONTROLS BC,
2341: FA_FISCAL_YEAR fy
2342: WHERE bk.asset_id = dpr.asset_id

Line 3447: from fa_books_summary bs,fa_deprn_summary ds

3443:
3444: BEGIN
3445: select 'Y'
3446: into prod_life_complete
3447: from fa_books_summary bs,fa_deprn_summary ds
3448: where bs.asset_id = dpr.asset_id
3449: and bs.period_counter = l_period_counter
3450: and bs.life_complete_flag = 'Y'
3451: and bs.book_type_code = dpr.book

Line 3534: FROM fa_books

3530:
3531: --Bug 5657699
3532: SELECT adjusted_cost
3533: INTO l_temp_adj_cost
3534: FROM fa_books
3535: WHERE book_type_code = dpr.book
3536: AND asset_id = dpr.asset_id
3537: AND transaction_header_id_out IS NULL;
3538:

Line 3702: -- If this is called for maintaining FA_BOOKS_SUMAMRY table,

3698: l_rsv_adj := 0;
3699: END IF;
3700:
3701: --
3702: -- If this is called for maintaining FA_BOOKS_SUMAMRY table,
3703: -- consider reserve_adjustment_amount when calculating absolute
3704: -- value of reserve
3705: --
3706: IF (l_ind <> 0) AND

Line 3946: FROM fa_books fab1,fa_books fab2

3942:
3943: Begin
3944: SELECT fab1.adjusted_recoverable_cost
3945: INTO l_old_adj_rec_cost
3946: FROM fa_books fab1,fa_books fab2
3947: WHERE fab1.transaction_header_id_out = fab2.transaction_header_id_in
3948: AND fab1.asset_id = fab2.asset_id
3949: AND fab1.book_type_code = fab2.book_type_code
3950: AND fab2.asset_id = dpr.asset_id

Line 5071: FROM fa_books bk

5067: END IF;
5068:
5069: SELECT bk.cost
5070: INTO primary_cost
5071: FROM fa_books bk
5072: WHERE bk.book_type_code = book
5073: AND bk.asset_id = h_asset_id
5074: AND bk.transaction_header_id_out IS NULL;
5075: