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 65: ,fa_book_controls bc

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

Line 525: FA_BOOK_CONTROLS bc

521: LOCATION_ID,
522: ASSIGNED_TO, -- bug 3519644
523: TRANSACTION_HEADER_ID_OUT
524: FROM FA_DISTRIBUTION_HISTORY dist,
525: FA_BOOK_CONTROLS bc
526: -- Bug 5149832 WHERE RETIREMENT_ID = ret.retirement_id
527: WHERE RETIREMENT_ID = nvl(l_ret_id_in_corp, ret.retirement_id)
528: AND ASSET_ID = ret.asset_id
529: -- Bug 5149832 AND BOOK_TYPE_CODE = ret.book;

Line 540: FA_BOOK_CONTROLS bc

536: c_assigned_to number, -- bug 3519644
537: c_th_id_out number) IS
538: SELECT DISTRIBUTION_ID
539: FROM FA_DISTRIBUTION_HISTORY dist,
540: FA_BOOK_CONTROLS bc
541: WHERE dist.TRANSACTION_HEADER_ID_IN = c_th_id_out
542: AND dist.TRANSACTION_HEADER_ID_OUT is NULL
543: AND dist.CODE_COMBINATION_ID = c_ccid
544: AND dist.LOCATION_ID = c_location_id

Line 559: FA_BOOK_CONTROLS bc

555: c_assigned_to number,
556: c_th_id_out number) IS
557: SELECT DISTRIBUTION_ID
558: FROM FA_DISTRIBUTION_HISTORY dist,
559: FA_BOOK_CONTROLS bc
560: WHERE
561: dist.CODE_COMBINATION_ID = c_ccid
562: AND dist.LOCATION_ID = c_location_id
563: AND dist.ASSET_ID = RET.asset_id

Line 592: FA_BOOK_CONTROLS bc

588: CURSOR c_ret_amount (c_asset_id number) is
589: SELECT DISTRIBUTION_ID,
590: CODE_COMBINATION_ID
591: FROM FA_DISTRIBUTION_HISTORY dist,
592: FA_BOOK_CONTROLS bc
593: WHERE TRANSACTION_HEADER_ID_OUT is NULL
594: AND ASSET_ID = c_asset_id
595: AND bc.book_type_code = ret.book
596: AND dist.book_type_code = bc.distribution_source_book;

Line 808: from fa_book_controls bc,

804: h_reval_rsv_retired_gain_acct,
805: h_reval_rsv_retired_loss_acct,
806: h_retire_reval_flag,
807: l_asset_cat_rec_m.category_id
808: from fa_book_controls bc,
809: fa_additions_b ad, fa_category_books cb
810: where ad.asset_id = h_asset_id
811: and cb.category_id = ad.asset_category_id
812: and cb.book_type_code = h_book

Line 1222: FA_BOOK_CONTROLS bc

1218:
1219: SELECT count(*)
1220: INTO tot_dist_lines
1221: FROM FA_DISTRIBUTION_HISTORY dist,
1222: FA_BOOK_CONTROLS bc
1223: WHERE TRANSACTION_HEADER_ID_OUT is NULL
1224: AND ASSET_ID = RET.asset_id
1225: AND bc.book_type_code = RET.book
1226: AND dist.book_type_code = bc.distribution_source_book;

Line 1233: FA_BOOK_CONTROLS bc

1229:
1230: SELECT count(*)
1231: INTO tot_dist_lines
1232: FROM FA_DISTRIBUTION_HISTORY dist,
1233: FA_BOOK_CONTROLS bc
1234: WHERE dist.RETIREMENT_ID = nvl(l_ret_id_in_corp, ret.retirement_id)
1235: AND dist.ASSET_ID = RET.asset_id
1236: AND bc.book_type_code = RET.book
1237: AND dist.book_type_code = bc.distribution_source_book;

Line 3268: fa_book_controls bc

3264: select facb.deprn_expense_acct
3265: into h_deprn_exp_acct
3266: from fa_additions_b faadd,
3267: fa_category_books facb,
3268: fa_book_controls bc
3269: where faadd.asset_id = h_asset_id
3270: and facb.category_id = faadd.asset_category_id
3271: and facb.book_type_code = h_book
3272: and bc.book_type_code = facb.book_type_code;

Line 3364: FA_BOOK_CONTROLS bc

3360: FA_BOOKS bk,
3361: FA_RETIREMENTS rt,
3362: FA_CONVENTION_TYPES ctype,
3363: FA_METHODS mt,
3364: FA_BOOK_CONTROLS bc
3365: WHERE rt.date_retired between
3366: fy1.start_date and fy1.end_date
3367: AND bk.deprn_start_date between
3368: fy2.start_date and fy2.end_date

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

3409: */
3410: (h_same_fy = 1 and (not (h_depr_first_year_ret = 1)))) then
3411: if (h_same_fy = 1) then
3412:
3413: -- Get the Fiscal Year Name from FA_BOOK_CONTROLS cache
3414: if not fa_cache_pkg.fazcbc(book) then
3415: raise farboe_err;
3416:
3417: end if;

Line 4091: fa_book_controls bc

4087: SELECT to_number (to_char (dcp.start_date, 'J'))
4088: INTO h_cpp_jstartdate
4089: FROM fa_calendar_periods dcp,
4090: fa_fiscal_year fy,
4091: fa_book_controls bc
4092: WHERE bc.book_type_code = h_book
4093: AND bc.fiscal_year_name = fy.fiscal_year_name
4094: AND dcp.calendar_type = h_d_cal
4095: AND fy.fiscal_year = h_current_fiscal_yr

Line 4272: fa_book_controls bc

4268: select facb.deprn_expense_acct
4269: into h_deprn_exp_acct
4270: from fa_additions_b faadd,
4271: fa_category_books facb,
4272: fa_book_controls bc
4273: where faadd.asset_id = h_asset_id
4274: and facb.category_id = faadd.asset_category_id
4275: and facb.book_type_code = h_book
4276: and bc.book_type_code = facb.book_type_code;

Line 4998: fa_book_controls bc

4994: h_bonus_deprn_rsv_acct,
4995: h_retire_reval_flag
4996: from fa_additions_b faadd,
4997: fa_category_books facb,
4998: fa_book_controls bc
4999: where faadd.asset_id = h_asset_id
5000: and facb.category_id = faadd.asset_category_id
5001: and facb.book_type_code = h_book
5002: and bc.book_type_code = facb.book_type_code;

Line 5040: from fa_book_controls bc

5036:
5037: begin
5038: select decode(RETIRE_REVAL_RESERVE_FLAG,'NO',0,1)
5039: into h_retire_reval_flag
5040: from fa_book_controls bc
5041: where bc.book_type_code = h_book;
5042:
5043: EXCEPTION
5044: when no_data_found then