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_RETIREMENT_PVT dependencies on FA_ADDITIONS

Line 1003: update fa_additions_b

999: if not(l_status) then
1000: raise rein_err;
1001: end if;
1002:
1003: update fa_additions_b
1004: set current_units = current_units + p_asset_retire_rec.units_retired
1005: where asset_id = p_asset_hdr_rec.asset_id;
1006:
1007: end if; -- (l_asset_desc_rec_m.current_units > p_asset_retire_rec.units_retired)

Line 3949: fa_additions ad

3945:
3946: cursor c_get_groups is
3947: select bk.asset_id asset_id
3948: from fa_books bk,
3949: fa_additions ad
3950: where bk.book_type_code = p_book_type_code
3951: and bk.transaction_header_id_out is null
3952: and bk.asset_id = ad.asset_id
3953: and ad.asset_type = 'GROUP'

Line 3961: fa_additions ad

3957:
3958: cursor c_get_eofy_groups is
3959: select bk.asset_id asset_id
3960: from fa_books bk,
3961: fa_additions ad
3962: where bk.book_type_code = p_book_type_code
3963: and bk.transaction_header_id_out is null
3964: and bk.asset_id = ad.asset_id
3965: and ad.asset_type = 'GROUP'

Line 4395: , FA_ADDITIONS_B AD

4391: , BK.ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST
4392: , AD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
4393: , AD.CURRENT_UNITS CURRENT_UNITS
4394: FROM FA_BOOKS BK
4395: , FA_ADDITIONS_B AD
4396: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4397: AND BK.TRANSACTION_HEADER_ID_OUT is null
4398: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4399: AND nvl(BK.CIP_COST, 0) = 0

Line 4416: , FA_ADDITIONS_B AD

4412: , BK.ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST
4413: , AD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
4414: , AD.CURRENT_UNITS CURRENT_UNITS
4415: FROM FA_BOOKS_MRC_V BK
4416: , FA_ADDITIONS_B AD
4417: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4418: AND BK.TRANSACTION_HEADER_ID_OUT is null
4419: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4420: AND nvl(BK.CIP_COST, 0) = 0

Line 4466: , fa_additions_b ad

4462: from fa_transaction_headers th -- member
4463: , fa_transaction_headers gth -- group
4464: , fa_adjustments aj
4465: , fa_deprn_periods dp
4466: , fa_additions_b ad
4467: , fa_books bk
4468: where th.book_type_code = p_asset_hdr_rec.book_type_code
4469: -- and th.date_effective = gth.date_effective
4470: and th.source_transaction_header_id = gth.transaction_header_id