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.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 281: FROM igi_iac_category_books

277: AND cal_price_index_link_id = (SELECT cal_price_index_link_id
278: FROM igi_iac_cal_price_indexes
279: WHERE calendar_type= n_calendar_type
280: AND price_index_id = (SELECT price_index_id
281: FROM igi_iac_category_books
282: WHERE book_type_code = n_book_code
283: AND category_id= n_category_id));
284:
285: l_prd_rec igi_iac_types.prd_rec;

Line 585: igi_iac_category_books fcb

581: IS
582: SELECT DISTINCT fh.asset_id asset_id
583: FROM fa_books fb,
584: fa_additions fh,
585: igi_iac_category_books fcb
586: WHERE fb.book_type_code = n_book_code
587: AND fb.book_type_code = fcb.book_type_code
588: AND fcb.category_id = fh.asset_category_id
589: AND fh.asset_category_id = n_category_id

Line 609: igi_iac_category_books fcb

605: IS
606: SELECT DISTINCT fh.asset_id asset_id
607: FROM fa_books fb,
608: fa_additions fh,
609: igi_iac_category_books fcb
610: WHERE fb.book_type_code = n_book_code
611: AND fb.book_type_code = fcb.book_type_code
612: AND fcb.category_id = fh.asset_category_id
613: AND fb.asset_id=fh.asset_id