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_B

Line 1091: update fa_additions_b

1087: if not(l_status) then
1088: raise rein_err;
1089: end if;
1090:
1091: update fa_additions_b
1092: set current_units = current_units + p_asset_retire_rec.units_retired
1093: where asset_id = p_asset_hdr_rec.asset_id;
1094:
1095: end if; -- (l_asset_desc_rec_m.current_units > p_asset_retire_rec.units_retired)

Line 4714: , FA_ADDITIONS_B AD

4710: , BK.RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
4711: , BK.ADJUSTED_COST ADJUSTED_COST
4712: , BK.RECOVERABLE_COST RECOVERABLE_COST
4713: FROM FA_BOOKS BK
4714: , FA_ADDITIONS_B AD
4715: , fa_transaction_headers th
4716: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4717: AND BK.TRANSACTION_HEADER_ID_OUT is null
4718: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id

Line 4731: , FA_ADDITIONS_B AD

4727: , BK.RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
4728: , BK.ADJUSTED_COST ADJUSTED_COST
4729: , BK.RECOVERABLE_COST RECOVERABLE_COST
4730: FROM FA_MC_BOOKS BK
4731: , FA_ADDITIONS_B AD
4732: , fa_transaction_headers th
4733: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4734: AND BK.TRANSACTION_HEADER_ID_OUT is null
4735: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id

Line 4818: , FA_ADDITIONS_B AD

4814: , AD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
4815: , AD.CURRENT_UNITS CURRENT_UNITS
4816: , 'NO' REINS_ASSET_FLAG
4817: FROM FA_BOOKS BK
4818: , FA_ADDITIONS_B AD
4819: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4820: AND BK.TRANSACTION_HEADER_ID_OUT is null
4821: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4822: AND nvl(BK.CIP_COST, 0) = 0

Line 4840: , FA_ADDITIONS_B AD

4836: , AD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
4837: , AD.CURRENT_UNITS CURRENT_UNITS
4838: , 'YES' REINS_ASSET_FLAG
4839: FROM FA_BOOKS BK
4840: , FA_ADDITIONS_B AD
4841: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4842: AND BK.TRANSACTION_HEADER_ID_OUT is null
4843: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4844: AND nvl(BK.CIP_COST, 0) = 0

Line 4863: , FA_ADDITIONS_B AD

4859: , AD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
4860: , AD.CURRENT_UNITS CURRENT_UNITS
4861: , 'NO' REINS_ASSET_FLAG
4862: FROM FA_MC_BOOKS BK
4863: , FA_ADDITIONS_B AD
4864: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4865: AND BK.TRANSACTION_HEADER_ID_OUT is null
4866: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4867: AND nvl(BK.CIP_COST, 0) = 0

Line 4886: , FA_ADDITIONS_B AD

4882: , AD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
4883: , AD.CURRENT_UNITS CURRENT_UNITS
4884: , 'YES' REINS_ASSET_FLAG
4885: FROM FA_MC_BOOKS BK
4886: , FA_ADDITIONS_B AD
4887: WHERE BK.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4888: AND BK.TRANSACTION_HEADER_ID_OUT is null
4889: AND BK.GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4890: AND nvl(BK.CIP_COST, 0) = 0

Line 4963: , fa_additions_b ad

4959: from fa_transaction_headers th -- member
4960: , fa_transaction_headers gth -- group
4961: , fa_adjustments aj
4962: , fa_deprn_periods dp
4963: , fa_additions_b ad
4964: , fa_books bk
4965: where th.book_type_code = p_asset_hdr_rec.book_type_code
4966: -- and th.date_effective = gth.date_effective
4967: and th.source_transaction_header_id = gth.transaction_header_id

Line 5001: , fa_additions_b ad

4997: from fa_transaction_headers th -- member
4998: , fa_transaction_headers gth -- group
4999: , fa_mc_adjustments aj
5000: , fa_mc_deprn_periods dp
5001: , fa_additions_b ad
5002: , fa_mc_books bk
5003: where th.book_type_code = p_asset_hdr_rec.book_type_code
5004: -- and th.date_effective = gth.date_effective
5005: and th.source_transaction_header_id = gth.transaction_header_id