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.

[Home] [Help]

APPS.FA_REC_PVT_PKG1 dependencies on FA_CATEGORY_BOOKS

Line 218: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc

214:
215: -- Make sure the new category is defined in all the books the asset belongs to.
216: -- Get the number of books in which the new category is defined for the asset.
217: SELECT count(*) INTO l_check_count1
218: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc
219: WHERE bk.asset_id = p_asset_id
220: AND bk.date_ineffective IS NULL
221: AND bk.book_type_code = cb.book_type_code
222: AND cb.category_id = p_new_category_id