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

Line 111: from fa_books inbk

107:
108: -- Bug4958977: Introducing new cursor to trap dpis change only trx.
109: CURSOR c_check_dpis_change is
110: select inbk.transaction_header_id_in
111: from fa_books inbk
112: , fa_books outbk
113: where inbk.transaction_header_id_in = px_trans_rec.member_transaction_header_id
114: and outbk.asset_id = inbk.asset_id
115: and outbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 112: , fa_books outbk

108: -- Bug4958977: Introducing new cursor to trap dpis change only trx.
109: CURSOR c_check_dpis_change is
110: select inbk.transaction_header_id_in
111: from fa_books inbk
112: , fa_books outbk
113: where inbk.transaction_header_id_in = px_trans_rec.member_transaction_header_id
114: and outbk.asset_id = inbk.asset_id
115: and outbk.book_type_code = p_asset_hdr_rec.book_type_code
116: and outbk.transaction_header_id_out = px_trans_rec.member_transaction_header_id

Line 148: from fa_books inbk

144:
145: -- Bug 10097181
146: cursor c_group_rcl_out is
147: select inbk.asset_id
148: from fa_books inbk
149: , fa_books outbk
150: where inbk.transaction_header_id_in = px_trans_rec.member_transaction_header_id
151: and outbk.asset_id = inbk.asset_id
152: and outbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 149: , fa_books outbk

145: -- Bug 10097181
146: cursor c_group_rcl_out is
147: select inbk.asset_id
148: from fa_books inbk
149: , fa_books outbk
150: where inbk.transaction_header_id_in = px_trans_rec.member_transaction_header_id
151: and outbk.asset_id = inbk.asset_id
152: and outbk.book_type_code = p_asset_hdr_rec.book_type_code
153: and outbk.transaction_header_id_out = inbk.transaction_header_id_in

Line 1386: update fa_books

1382: fetch c_group_rcl_out into l_group_rcl_out_asset;
1383: close c_group_rcl_out;
1384: if (nvl(l_group_rcl_out_asset,-99) > 0) then
1385: if (p_mrc_sob_type_code <> 'R') then
1386: update fa_books
1387: set adjustment_required_status = 'GADJ'
1388: where asset_id = l_group_rcl_out_asset
1389: and book_type_code = p_asset_hdr_rec.book_type_code
1390: and transaction_header_id_out is null;

Line 1843: FROM fa_books bk

1839: AND ov.status = 'SELECTED'
1840: AND ov.transaction_header_id is null
1841: AND ov.asset_id IN
1842: (SELECT bk.asset_id
1843: FROM fa_books bk
1844: WHERE bk.book_type_code = ov.book_type_code
1845: AND bk.group_asset_id = p_asset_hdr_rec.asset_id
1846: AND bk.date_ineffective IS NULL);
1847: else

Line 2113: -- This is the one will use FA_BOOKS_SUMMARY table to calculate

2109:
2110:
2111: --
2112: -- Following faxama will return catch-up for group.
2113: -- This is the one will use FA_BOOKS_SUMMARY table to calculate
2114: -- and maintain FA_BOOKS_SUMMARY.
2115: --
2116: if (p_asset_type_rec.asset_type = 'GROUP') and
2117: (l_call_bs) then

Line 2114: -- and maintain FA_BOOKS_SUMMARY.

2110:
2111: --
2112: -- Following faxama will return catch-up for group.
2113: -- This is the one will use FA_BOOKS_SUMMARY table to calculate
2114: -- and maintain FA_BOOKS_SUMMARY.
2115: --
2116: if (p_asset_type_rec.asset_type = 'GROUP') and
2117: (l_call_bs) then
2118:

Line 3489: from fa_books bk,

3485: elsif (p_asset_fin_rec_old.deprn_limit_type <> 'SUM') then
3486: if (p_mrc_sob_type_code <> 'R') then
3487: select nvl(sum(allowed_deprn_limit_amount), 0)
3488: into px_asset_fin_rec_new.allowed_deprn_limit_amount
3489: from fa_books bk,
3490: fa_additions_b ad
3491: where bk.transaction_header_id_out is null
3492: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3493: and bk.asset_id = ad.asset_id

Line 3823: from fa_books bk,

3819: elsif (p_asset_fin_rec_old.salvage_type <> 'SUM') then
3820: if (p_mrc_sob_type_code <> 'R') then
3821: select nvl(sum(salvage_value), 0)
3822: into px_asset_fin_rec_new.salvage_value
3823: from fa_books bk,
3824: fa_additions_b ad
3825: where bk.transaction_header_id_out is null
3826: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3827: and bk.asset_id = ad.asset_id

Line 3939: from fa_books

3935: CURSOR LIFE1_DEF IS
3936: select nvl(life_in_months,0),
3937: nvl(life_in_months,0),
3938: prorate_date
3939: from fa_books
3940: where book_type_code = p_asset_hdr_rec.book_type_code
3941: and asset_id = p_asset_desc_rec.parent_asset_id
3942: and transaction_header_id_out is null;
3943:

Line 4366: from fa_books bk,

4362: select bk.depreciate_flag,
4363: bk.transaction_header_id_in
4364: into l_depreciate_flag,
4365: l_dep_flag_thid
4366: from fa_books bk,
4367: fa_transaction_headers th
4368: where th.asset_id = p_asset_hdr_rec.asset_id
4369: and th.book_type_code = p_asset_hdr_rec.book_type_code
4370: and th.transaction_type_code = 'ADDITION'

Line 4384: from fa_books

4380: begin
4381:
4382: select count(*)
4383: into l_count_dep_flag
4384: from fa_books
4385: where asset_id = p_asset_hdr_rec.asset_id
4386: and book_type_code = p_asset_hdr_rec.book_type_code
4387: and depreciate_flag = 'YES'
4388: and transaction_header_id_in >= l_dep_flag_thid

Line 4511: l_unit_of_measure FA_BOOKS.UNIT_OF_MEASURE%TYPE;

4507: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4508:
4509: l_count number;
4510: l_result boolean;
4511: l_unit_of_measure FA_BOOKS.UNIT_OF_MEASURE%TYPE;
4512:
4513: l_method_id number;
4514: l_rate_source_rule FA_METHODS.rate_source_rule%TYPE;
4515: l_deprn_basis_rule FA_METHODS.deprn_basis_rule%TYPE;

Line 4524: from fa_books

4520: h_prod_method number; -- added this for bug 3245984
4521:
4522: CURSOR unit_of_measure IS
4523: select unit_of_measure
4524: from fa_books
4525: where asset_id = p_asset_hdr_rec.asset_id
4526: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
4527: and transaction_header_id_out is NULL;
4528:

Line 4636: name => 'FA_BOOKS_NULL_PROD', p_log_level_rec => p_log_level_rec);

4632:
4633: if (px_asset_fin_rec_new.production_capacity is null) then
4634: fa_srvr_msg.add_message(
4635: calling_fn => l_calling_fn,
4636: name => 'FA_BOOKS_NULL_PROD', p_log_level_rec => p_log_level_rec);
4637: raise calc_err;
4638: else
4639: px_asset_fin_rec_new.life_in_months := NULL;
4640: px_asset_fin_rec_new.adjusted_rate := NULL;

Line 4659: from fa_books bk,

4655: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
4656:
4657: select count(1)
4658: into l_count
4659: from fa_books bk,
4660: fa_methods me
4661: where bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
4662: and bk.asset_id = p_asset_hdr_rec.asset_id
4663: and bk.transaction_header_id_out is null

Line 4827: FROM FA_BOOKS

4823: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
4824:
4825: CURSOR c_find_member_asset IS
4826: SELECT 'Y'
4827: FROM FA_BOOKS
4828: WHERE GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4829: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4830: AND TRANSACTION_HEADER_ID_OUT is NULL;
4831:

Line 5250: FROM FA_BOOKS

5246: reduce_adjustment_flag,
5247: reduce_retirement_flag,
5248: disabled_flag, --hh
5249: over_depreciate_option -- hh
5250: FROM FA_BOOKS
5251: WHERE ASSET_ID = px_asset_fin_rec_new.group_asset_id
5252: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5253: AND transaction_header_id_out is null;
5254:

Line 5282: -- get new tracking related columns from FA_BOOKS instead of copying

5278: BEGIN
5279:
5280: -- This function will copy the tracking related columns from old structure
5281: -- to new structure. And if the group assignment is changed,
5282: -- get new tracking related columns from FA_BOOKS instead of copying
5283: -- old to new.
5284:
5285: -- Only when this asset is assigned to group, this module will be available.
5286:

Line 5292: -- User cursor for now since we only need part of fa_books.

5288:
5289: --
5290: -- Get group information for reduction rate and tracking related values.
5291: -- If there will be more, this can be replaced with get_asset_fin_rec.
5292: -- User cursor for now since we only need part of fa_books.
5293: --
5294: open c_get_group_values;
5295: fetch c_get_group_values into l_recognize_gain_loss,
5296: l_recapture_reserve_flag,

Line 5354: -- tracking related columns from FA_BOOKS.

5350: if px_asset_fin_rec_new.group_asset_id <>
5351: nvl(p_asset_fin_rec_old.group_asset_id,-99) then
5352:
5353: -- In case the group asset is changed, need to replace with new
5354: -- tracking related columns from FA_BOOKS.
5355:
5356: if c_get_group_values%NOTFOUND then
5357:
5358: -- This is a case in which tracking method is not assigned to the group