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

Line 282: fa_books fb

278: --Used to determine if Parent Asset ID is valid for Book specified
279: CURSOR parent_asset_book_cur IS
280: SELECT 'Parent Asset Number Exists in Book'
281: FROM fa_additions fa,
282: fa_books fb
283: WHERE fa.asset_id = p_parent_asset_id
284: AND fa.asset_type <> 'GROUP'
285: AND fa.asset_id = fb.asset_id
286: AND fb.book_type_code = l_asset_in_rec.book_type_code

Line 295: FROM fa_books fb,

291:
292: --Used to determine if the Ret Target Asset ID is a valid GROUP asset in the book
293: CURSOR ret_target_cur IS
294: SELECT fa.asset_category_id
295: FROM fa_books fb,
296: fa_additions fa
297: WHERE fa.asset_id = p_ret_target_asset_id
298: AND fa.asset_type = 'GROUP'
299: AND fa.asset_id = fb.asset_id

Line 3025: fa_books fb

3021: --Used to determine if Parent Asset ID is valid for Book specified
3022: CURSOR parent_asset_book_cur(x_parent_asset_id NUMBER) IS
3023: SELECT 'Parent Asset Number Exists in Book'
3024: FROM fa_additions fa,
3025: fa_books fb
3026: WHERE fa.asset_id = x_parent_asset_id
3027: AND fa.asset_type <> 'GROUP'
3028: AND fa.asset_id = fb.asset_id
3029: AND fb.book_type_code = l_book_type_code

Line 3084: FROM fa_books fb,

3080:
3081: --Used to determine if the Ret Target Asset ID is a valid GROUP asset in the book
3082: CURSOR ret_target_cur IS
3083: SELECT fa.asset_category_id
3084: FROM fa_books fb,
3085: fa_additions fa
3086: WHERE fa.asset_id = p_ret_target_asset_id
3087: AND fa.asset_type = 'GROUP'
3088: AND fa.asset_id = fb.asset_id