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_ADJUSTMENTS_MRC_V

Line 653: from fa_adjustments_mrc_v

649: and transaction_header_id = l_transaction_header_id;
650:
651: CURSOR c_mc_adj IS
652: select rowid
653: from fa_adjustments_mrc_v
654: where transaction_header_id = l_transaction_header_id;
655:
656: l_calling_fn VARCHAR2(100) := 'fa_group_retirement_pvt.undo_retirement_reinstatement';
657:

Line 2246: FROM FA_ADJUSTMENTS_MRC_V

2242: ANNUALIZED_ADJUSTMENT,
2243: PERIOD_COUNTER_ADJUSTED,
2244: PERIOD_COUNTER_CREATED,
2245: ASSET_INVOICE_ID
2246: FROM FA_ADJUSTMENTS_MRC_V
2247: WHERE TRANSACTION_HEADER_ID = l_group_thid
2248: AND ASSET_ID = l_group_asset_id
2249: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
2250: AND PERIOD_COUNTER_CREATED = l_period_rec.period_counter

Line 3181: UPDATE FA_ADJUSTMENTS_MRC_V

3177: end if;
3178:
3179:
3180: if (p_mrc_sob_type_code = 'R') then
3181: UPDATE FA_ADJUSTMENTS_MRC_V
3182: SET TRANSACTION_HEADER_ID = l_trans_rec.transaction_header_id
3183: WHERE TRANSACTION_HEADER_ID = l_trans_rec.member_transaction_header_id
3184: AND ASSET_ID = l_asset_hdr_rec.asset_id
3185: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code;

Line 5554: UPDATE FA_ADJUSTMENTS_MRC_V

5550:
5551: -- Need to backout some reserve so do that from last processed asset
5552:
5553: if (p_mrc_sob_type_code = 'R') then
5554: UPDATE FA_ADJUSTMENTS_MRC_V
5555: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5556: WHERE ASSET_ID = l_last_asset_id
5557: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5558: AND TRANSACTION_HEADER_ID = l_last_thid

Line 5560: FROM FA_ADJUSTMENTS_MRC_V

5556: WHERE ASSET_ID = l_last_asset_id
5557: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5558: AND TRANSACTION_HEADER_ID = l_last_thid
5559: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5560: FROM FA_ADJUSTMENTS_MRC_V
5561: WHERE ASSET_ID = l_last_asset_id
5562: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5563: AND TRANSACTION_HEADER_ID = l_last_thid);
5564:

Line 5617: UPDATE FA_ADJUSTMENTS_MRC_V

5613:
5614: -- This asset can take all hit
5615:
5616: if (p_mrc_sob_type_code = 'R') then
5617: UPDATE FA_ADJUSTMENTS_MRC_V
5618: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5619: WHERE ASSET_ID = t_asset_id(i)
5620: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5621: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5623: FROM FA_ADJUSTMENTS_MRC_V

5619: WHERE ASSET_ID = t_asset_id(i)
5620: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5621: AND TRANSACTION_HEADER_ID = t_thid(i)
5622: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5623: FROM FA_ADJUSTMENTS_MRC_V
5624: WHERE ASSET_ID = t_asset_id(i)
5625: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5626: AND TRANSACTION_HEADER_ID = t_thid(i));
5627:

Line 5679: UPDATE FA_ADJUSTMENTS_MRC_V

5675: -- fully reserved. After this, still need to look for another asset to allocate
5676: -- remaining excess amount.
5677:
5678: if (p_mrc_sob_type_code = 'R') then
5679: UPDATE FA_ADJUSTMENTS_MRC_V
5680: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + t_adjusted_recoverable_cost(i) - t_new_deprn_reserve(i)
5681: WHERE ASSET_ID = t_asset_id(i)
5682: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5683: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5685: FROM FA_ADJUSTMENTS_MRC_V

5681: WHERE ASSET_ID = t_asset_id(i)
5682: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5683: AND TRANSACTION_HEADER_ID = t_thid(i)
5684: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5685: FROM FA_ADJUSTMENTS_MRC_V
5686: WHERE ASSET_ID = t_asset_id(i)
5687: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5688: AND TRANSACTION_HEADER_ID = t_thid(i));
5689:

Line 5796: UPDATE FA_ADJUSTMENTS_MRC_V

5792:
5793: if (t_adjusted_cost(i) >= l_reallocate_amount) then
5794:
5795: if (p_mrc_sob_type_code = 'R') then
5796: UPDATE FA_ADJUSTMENTS_MRC_V
5797: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5798: WHERE ASSET_ID = t_asset_id(i)
5799: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5800: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5802: FROM FA_ADJUSTMENTS_MRC_V

5798: WHERE ASSET_ID = t_asset_id(i)
5799: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5800: AND TRANSACTION_HEADER_ID = t_thid(i)
5801: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5802: FROM FA_ADJUSTMENTS_MRC_V
5803: WHERE ASSET_ID = t_asset_id(i)
5804: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5805: AND TRANSACTION_HEADER_ID = t_thid(i));
5806:

Line 5852: UPDATE FA_ADJUSTMENTS_MRC_V

5848:
5849: else
5850:
5851: if (p_mrc_sob_type_code = 'R') then
5852: UPDATE FA_ADJUSTMENTS_MRC_V
5853: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
5854: WHERE ASSET_ID = t_asset_id(i)
5855: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5856: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5858: FROM FA_ADJUSTMENTS_MRC_V

5854: WHERE ASSET_ID = t_asset_id(i)
5855: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5856: AND TRANSACTION_HEADER_ID = t_thid(i)
5857: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5858: FROM FA_ADJUSTMENTS_MRC_V
5859: WHERE ASSET_ID = t_asset_id(i)
5860: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5861: AND TRANSACTION_HEADER_ID = t_thid(i));
5862: