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_BOOKS_MRC_V

Line 3709: from fa_books_mrc_v

3705: and mth.transaction_header_id = gth.member_transaction_header_id;
3706:
3707: cursor c_mc_member_exists IS
3708: select 'Y'
3709: from fa_books_mrc_v
3710: where book_type_code = p_book_type_code
3711: and group_asset_id = p_asset_id
3712: and period_counter_fully_retired is null
3713: and transaction_header_id_out is null;

Line 3720: fa_books_mrc_v bk

3716: select max(gth.transaction_header_id)
3717: from fa_transaction_headers gth,
3718: fa_transaction_headers mth,
3719: fa_retirements_mrc_v ret,
3720: fa_books_mrc_v bk
3721: where bk.group_asset_id = p_asset_id
3722: and bk.book_type_code = p_book_type_code
3723: and ret.asset_id = bk.asset_id
3724: and ret.book_type_code = p_book_type_code

Line 4132: from fa_books_mrc_v

4128: and transaction_header_id_out is null;
4129:
4130: CURSOR c_find_mc_member IS
4131: select asset_id
4132: from fa_books_mrc_v
4133: where group_asset_id = p_asset_hdr_rec.asset_id
4134: and book_type_code = p_asset_hdr_rec.book_type_code
4135: and period_counter_fully_retired is null
4136: and transaction_header_id_out is null;

Line 4249: UPDATE FA_BOOKS_MRC_V

4245: -- processed during depreciation
4246: --
4247: if (p_mrc_sob_type_code = 'R') then
4248:
4249: UPDATE FA_BOOKS_MRC_V
4250: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4251: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4252: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4253: AND TRANSACTION_HEADER_ID_OUT is null;

Line 4339: FROM FA_BOOKS_MRC_V

4335:
4336:
4337: CURSOR C_MC_GET_SUM_REC_COST IS
4338: SELECT SUM(RECOVERABLE_COST)
4339: FROM FA_BOOKS_MRC_V
4340: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4341: AND TRANSACTION_HEADER_ID_OUT is null
4342: AND PERIOD_COUNTER_FULLY_RESERVED is null
4343: AND PERIOD_COUNTER_FULLY_RETIRED is null

Line 4415: FROM FA_BOOKS_MRC_V BK

4411: , BK.RECOVERABLE_COST RECOVERABLE_COST
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

Line 4443: FROM FA_BOOKS_MRC_V

4439: CURSOR C_MC_DIST_EXCESS IS
4440: SELECT ASSET_ID
4441: , TRANSACTION_HEADER_ID_IN
4442: , ADJUSTED_COST
4443: FROM FA_BOOKS_MRC_V
4444: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4445: AND TRANSACTION_HEADER_ID_OUT is null
4446: AND GROUP_ASSET_ID = p_asset_hdr_rec.asset_id
4447: AND PERIOD_COUNTER_FULLY_RESERVED is null

Line 4500: from fa_books_mrc_v

4496: and transaction_header_id_out is null;
4497:
4498: CURSOR c_mc_get_thid (c_asset_id number) IS
4499: select transaction_header_id_in
4500: from fa_books_mrc_v
4501: where book_type_code = p_asset_hdr_rec.book_type_code
4502: and asset_id = c_asset_id
4503: and transaction_header_id_out is null;
4504:

Line 4959: UPDATE FA_BOOKS_MRC_V

4955:
4956: l_loc := 'Before Books';
4957: -- Deactivate FA_BOOKS row for processed assets
4958: FORALL i in t_asset_id.first..t_asset_id.last
4959: UPDATE FA_BOOKS_MRC_V
4960: SET DATE_INEFFECTIVE = p_trans_rec.who_info.last_update_date
4961: , TRANSACTION_HEADER_ID_OUT = t_thid(i)
4962: WHERE TRANSACTION_HEADER_ID_IN = t_transaction_header_id_in(i);
4963:

Line 4967: INSERT INTO FA_BOOKS_MRC_V( BOOK_TYPE_CODE

4963:
4964:
4965: -- Insert new FA_BOOKS records for processed assets
4966: FORALL i in t_asset_id.first..t_asset_id.last
4967: INSERT INTO FA_BOOKS_MRC_V( BOOK_TYPE_CODE
4968: , ASSET_ID
4969: , DATE_PLACED_IN_SERVICE
4970: , DATE_EFFECTIVE
4971: , DEPRN_START_DATE

Line 5195: FROM FA_BOOKS_MRC_V

5191: , TERMINAL_GAIN_LOSS_FLAG
5192: , SUPER_GROUP_ID
5193: , OVER_DEPRECIATE_OPTION
5194: , DISABLED_FLAG
5195: FROM FA_BOOKS_MRC_V
5196: WHERE TRANSACTION_HEADER_ID_IN = t_transaction_header_id_in(i);
5197:
5198: else
5199: l_loc := 'Before BS';

Line 5575: UPDATE FA_BOOKS_MRC_V

5571: AND PERIOD_COUNTER = p_period_rec.period_counter
5572: AND TRANSACTION_HEADER_ID_OUT IS NULL;
5573:
5574:
5575: UPDATE FA_BOOKS_MRC_V
5576: SET ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
5577: WHERE TRANSACTION_HEADER_ID_IN = l_last_thid;
5578: else
5579: UPDATE FA_ADJUSTMENTS

Line 5638: UPDATE FA_BOOKS_MRC_V

5634: AND PERIOD_COUNTER = p_period_rec.period_counter
5635: AND TRANSACTION_HEADER_ID_OUT IS NULL;
5636:
5637:
5638: UPDATE FA_BOOKS_MRC_V
5639: SET ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
5640: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i);
5641: else
5642: UPDATE FA_ADJUSTMENTS

Line 5701: UPDATE FA_BOOKS_MRC_V

5697: AND PERIOD_COUNTER = p_period_rec.period_counter
5698: AND TRANSACTION_HEADER_ID_OUT IS NULL;
5699:
5700:
5701: UPDATE FA_BOOKS_MRC_V
5702: SET ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
5703: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i);
5704: else
5705: UPDATE FA_ADJUSTMENTS

Line 5817: UPDATE FA_BOOKS_MRC_V

5813: AND PERIOD_COUNTER = p_period_rec.period_counter
5814: AND TRANSACTION_HEADER_ID_OUT is null;
5815:
5816:
5817: UPDATE FA_BOOKS_MRC_V
5818: SET ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
5819: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i);
5820: else
5821: UPDATE FA_ADJUSTMENTS

Line 5872: UPDATE FA_BOOKS_MRC_V

5868: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5869: AND PERIOD_COUNTER = p_period_rec.period_counter;
5870:
5871:
5872: UPDATE FA_BOOKS_MRC_V
5873: SET ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
5874: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i);
5875: else
5876: UPDATE FA_ADJUSTMENTS