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_CALC_DEPRN_BASIS2_PKG dependencies on FA_DEPRN_SUMMARY_MRC_V

Line 234: from fa_deprn_summary_mrc_v

230: and period_counter = l_amort_period;
231:
232: cursor GET_RESERVE_M is
233: select nvl(deprn_reserve,0), nvl(ytd_deprn,0)
234: from fa_deprn_summary_mrc_v
235: where asset_id = px_rule_in.asset_id
236: and period_counter = l_amort_period;
237:
238: -- Replace original queries to cursors

Line 340: from fa_deprn_summary_mrc_v

336:
337: cursor C_MTC_SUM_M (p_method_change_date date)
338: is
339: select nvl(deprn_reserve,0) - nvl(ytd_deprn,0)
340: from fa_deprn_summary_mrc_v
341: where book_type_code = px_rule_in.book_type_code
342: and asset_id = px_rule_in.asset_id
343: and period_counter =
344: (select period_counter

Line 428: FA_DEPRN_SUMMARY_MRC_V DS

424: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
425: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
426: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
427: from FA_BOOKS_MRC_V BK,
428: FA_DEPRN_SUMMARY_MRC_V DS
429: where BK.ASSET_ID = DS.ASSET_ID
430: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
431: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER
432: and BK.GROUP_ASSET_ID = px_rule_in.asset_id