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.JA_CN_FA_ADI_EXPORT_PKG dependencies on FA_DEPRN_SUMMARY

Line 153: fa_deprn_summary fds,

149: fds.impairment_amount
150: FROM fa_retirements fr,
151: fa_books fb,
152: fa_books fbb,
153: fa_deprn_summary fds,
154: fa_deprn_periods fdp
155: WHERE fr.asset_id = ln_asset_id
156: AND fr.transaction_header_id_in = ln_transaction_header_id
157: AND fds.book_type_code = lv_book_type_code

Line 304: FROM fa_deprn_summary fds

300: ln_retired_unit := NVL(v_retire_row.units, v_retire_row.retired_factor * ln_total_unit);
301:
302: SELECT fds.deprn_reserve, fds.impairment_reserve
303: INTO ln_last_deprn_reserve, ln_last_impai_reserve
304: FROM fa_deprn_summary fds
305: WHERE fds.asset_id = v_row.asset_id
306: AND fds.book_type_code = v_row.book_type_code
307: AND fds.period_counter = (SELECT MAX(period_counter)
308: FROM fa_deprn_summary

Line 308: FROM fa_deprn_summary

304: FROM fa_deprn_summary fds
305: WHERE fds.asset_id = v_row.asset_id
306: AND fds.book_type_code = v_row.book_type_code
307: AND fds.period_counter = (SELECT MAX(period_counter)
308: FROM fa_deprn_summary
309: WHERE asset_id = v_row.asset_id
310: AND book_type_code = v_row.book_type_code
311: AND period_counter < v_retire_row.period_counter);
312: