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.OKL_AM_PROCESS_ASSET_TRX_PVT dependencies on FA_BOOKS

Line 298: FROM fa_books fb, fa_additions_b fab

294: -- SECHAWLA 10-MAY-04 3578894 : added depreciate flag, deprn_method_code, fb.life_in_months to this cursor
295: CURSOR l_facostsv_csr(cp_asset_number IN VARCHAR2, cp_book_type_code IN VARCHAR2) IS
296: --SECHAWLA 28-MAY-04 3645574 : Added adjusted_rate
297: SELECT fb.cost, fb.salvage_value, fb.depreciate_flag, fb.deprn_method_code, fb.life_in_months, fb.adjusted_rate
298: FROM fa_books fb, fa_additions_b fab
299: WHERE fb.transaction_header_id_out is null
300: AND fb.book_type_code = cp_book_type_code
301: AND fab.asset_id = fb.asset_id
302: AND fab.asset_number = cp_asset_number;

Line 323: FROM fa_books a, fa_book_controls b

319: -- This cursor is used to find all the tax books that an asset belongs to
320: /* SECHAWLA 28-DEC-05 4374620 : do not process SVW transactions in tax books
321: CURSOR l_fabookcntrl_csr(p_asset_id IN NUMBER) IS
322: SELECT a.book_type_code
323: FROM fa_books a, fa_book_controls b
324: WHERE a.asset_id = p_asset_id
325: AND a.book_type_code = b.book_type_code
326: AND b.book_class = 'TAX'
327: AND a.date_ineffective IS NULL

Line 344: FROM fa_books

340:
341: -- SECHAWLA 14-FEB-05 3950089 : get the salvage type
342: CURSOR l_booksalvagetype_csr(cp_asset_id IN NUMBER, cp_booktype_code IN VARCHAR2) IS
343: SELECT salvage_type
344: FROM fa_books
345: WHERE asset_id = cp_asset_id
346: AND book_type_code = cp_booktype_code
347: AND transaction_header_id_out IS NULL
348: AND date_ineffective IS NULL;