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_UPD_PKG dependencies on FA_BOOK_CONTROLS

Line 62: ,fa_book_controls bc

58: into l_ret_id_in_corp
59: ,l_units_retired
60: from fa_transaction_headers sth
61: ,fa_retirements r
62: ,fa_book_controls bc
63: where sth.transaction_header_id = RET.th_id_in
64: and sth.asset_id = RET.asset_id
65: and sth.book_type_code = RET.book
66: and bc.book_type_code = sth.book_type_code

Line 518: FA_BOOK_CONTROLS bc

514: LOCATION_ID,
515: ASSIGNED_TO, -- bug 3519644
516: TRANSACTION_HEADER_ID_OUT
517: FROM FA_DISTRIBUTION_HISTORY dist,
518: FA_BOOK_CONTROLS bc
519: -- Bug 5149832 WHERE RETIREMENT_ID = ret.retirement_id
520: WHERE RETIREMENT_ID = nvl(l_ret_id_in_corp, ret.retirement_id)
521: AND ASSET_ID = ret.asset_id
522: -- Bug 5149832 AND BOOK_TYPE_CODE = ret.book;

Line 532: FA_BOOK_CONTROLS bc

528: c_assigned_to number, -- bug 3519644
529: c_th_id_out number) IS
530: SELECT DISTRIBUTION_ID
531: FROM FA_DISTRIBUTION_HISTORY dist,
532: FA_BOOK_CONTROLS bc
533: WHERE dist.TRANSACTION_HEADER_ID_IN = c_th_id_out
534: AND dist.TRANSACTION_HEADER_ID_OUT is NULL
535: AND dist.CODE_COMBINATION_ID = c_ccid
536: AND dist.LOCATION_ID = c_location_id

Line 551: FA_BOOK_CONTROLS bc

547: c_assigned_to number,
548: c_th_id_out number) IS
549: SELECT DISTRIBUTION_ID
550: FROM FA_DISTRIBUTION_HISTORY dist,
551: FA_BOOK_CONTROLS bc
552: WHERE
553: dist.CODE_COMBINATION_ID = c_ccid
554: AND dist.LOCATION_ID = c_location_id
555: AND dist.ASSET_ID = RET.asset_id

Line 585: FA_BOOK_CONTROLS bc

581: CURSOR c_ret_amount (c_asset_id number) is
582: SELECT DISTRIBUTION_ID,
583: CODE_COMBINATION_ID
584: FROM FA_DISTRIBUTION_HISTORY dist,
585: FA_BOOK_CONTROLS bc
586: WHERE TRANSACTION_HEADER_ID_OUT is NULL
587: AND ASSET_ID = c_asset_id
588: AND bc.book_type_code = ret.book
589: AND dist.book_type_code = bc.distribution_source_book;

Line 868: from fa_book_controls bc,

864: h_reval_rsv_retired_gain_acct,
865: h_reval_rsv_retired_loss_acct,
866: h_retire_reval_flag,
867: l_asset_cat_rec_m.category_id
868: from fa_book_controls bc,
869: fa_additions_b ad, fa_category_books cb
870: where ad.asset_id = h_asset_id
871: and cb.category_id = ad.asset_category_id
872: and cb.book_type_code = h_book

Line 1323: FA_BOOK_CONTROLS bc

1319:
1320: SELECT count(*)
1321: INTO tot_dist_lines
1322: FROM FA_DISTRIBUTION_HISTORY dist,
1323: FA_BOOK_CONTROLS bc
1324: WHERE TRANSACTION_HEADER_ID_OUT is NULL
1325: AND ASSET_ID = RET.asset_id
1326: AND bc.book_type_code = RET.book
1327: AND dist.book_type_code = bc.distribution_source_book;

Line 1334: FA_BOOK_CONTROLS bc

1330:
1331: SELECT count(*)
1332: INTO tot_dist_lines
1333: FROM FA_DISTRIBUTION_HISTORY dist,
1334: FA_BOOK_CONTROLS bc
1335: WHERE dist.RETIREMENT_ID = nvl(l_ret_id_in_corp, ret.retirement_id)
1336: AND dist.ASSET_ID = RET.asset_id
1337: AND bc.book_type_code = RET.book
1338: AND dist.book_type_code = bc.distribution_source_book;

Line 4168: fa_book_controls bc

4164: select facb.deprn_expense_acct
4165: into h_deprn_exp_acct
4166: from fa_additions_b faadd,
4167: fa_category_books facb,
4168: fa_book_controls bc
4169: where faadd.asset_id = h_asset_id
4170: and facb.category_id = faadd.asset_category_id
4171: and facb.book_type_code = h_book
4172: and bc.book_type_code = facb.book_type_code;

Line 4262: FA_BOOK_CONTROLS bc

4258: FA_BOOKS bk,
4259: FA_RETIREMENTS rt,
4260: FA_CONVENTION_TYPES ctype,
4261: FA_METHODS mt,
4262: FA_BOOK_CONTROLS bc
4263: WHERE rt.date_retired between
4264: fy1.start_date and fy1.end_date
4265: AND bk.deprn_start_date between
4266: fy2.start_date and fy2.end_date

Line 4297: FA_BOOK_CONTROLS bc

4293: FA_MC_BOOKS bk,
4294: FA_MC_RETIREMENTS rt,
4295: FA_CONVENTION_TYPES ctype,
4296: FA_METHODS mt,
4297: FA_BOOK_CONTROLS bc
4298: WHERE rt.date_retired between
4299: fy1.start_date and fy1.end_date
4300: AND bk.deprn_start_date between
4301: fy2.start_date and fy2.end_date

Line 4367: -- Get the Fiscal Year Name from FA_BOOK_CONTROLS cache

4363: */
4364: (h_same_fy = 1 and (not (h_depr_first_year_ret = 1)))) then
4365: if (h_same_fy = 1) then
4366:
4367: -- Get the Fiscal Year Name from FA_BOOK_CONTROLS cache
4368: if not fa_cache_pkg.fazcbc(book, p_log_level_rec => p_log_level_rec) then
4369: raise farboe_err;
4370:
4371: end if;

Line 5264: fa_book_controls bc,

5260: begin
5261: select fy.fiscal_year
5262: into l_first_fiscal_year
5263: from fa_fiscal_year fy,
5264: fa_book_controls bc,
5265: fa_books bks
5266: where bc.book_type_code = ret.book
5267: and bc.fiscal_year_name = fy.fiscal_year_name
5268: and bks.book_type_code = ret.book

Line 5413: fa_book_controls bc

5409: SELECT to_number (to_char (dcp.start_date, 'J'))
5410: INTO h_cpp_jstartdate
5411: FROM fa_calendar_periods dcp,
5412: fa_fiscal_year fy,
5413: fa_book_controls bc
5414: WHERE bc.book_type_code = h_book
5415: AND bc.fiscal_year_name = fy.fiscal_year_name
5416: AND dcp.calendar_type = h_d_cal
5417: AND fy.fiscal_year = h_current_fiscal_yr

Line 5624: fa_book_controls bc

5620: select facb.deprn_expense_acct
5621: into h_deprn_exp_acct
5622: from fa_additions_b faadd,
5623: fa_category_books facb,
5624: fa_book_controls bc
5625: where faadd.asset_id = h_asset_id
5626: and facb.category_id = faadd.asset_category_id
5627: and facb.book_type_code = h_book
5628: and bc.book_type_code = facb.book_type_code;

Line 6593: fa_book_controls bc

6589: h_impairment_rsv_acct,
6590: h_retire_reval_flag
6591: from fa_additions_b faadd,
6592: fa_category_books facb,
6593: fa_book_controls bc
6594: where faadd.asset_id = h_asset_id
6595: and facb.category_id = faadd.asset_category_id
6596: and facb.book_type_code = h_book
6597: and bc.book_type_code = facb.book_type_code;