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.FA_TRANSFER_PUB dependencies on FA_DEPRN_PERIODS

Line 407: FA_DEPRN_PERIODS dp

403:
404: SELECT count(1)
405: INTO l_count
406: FROM FA_TRANSACTION_HEADERS th,
407: FA_DEPRN_PERIODS dp
408: WHERE th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
409: AND th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
410: AND th.transaction_type_code||'' = 'TRANSFER'
411: AND th.transaction_date_entered < dp.calendar_period_open_date

Line 429: FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp

425: -- prior period tfr is not allowed after assets' normal life complete
426:
427: SELECT count(1)
428: INTO l_count
429: FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp
430: WHERE bk.asset_id = p_asset_hdr_rec.asset_id
431: AND bk.book_type_code = p_asset_hdr_rec.book_type_code
432: AND nvl(period_counter_fully_reserved, 99) <>
433: nvl(period_counter_life_complete, 99)

Line 453: FA_DEPRN_PERIODS dp,

449: if (g_release = 11) then --Brahma
450: SELECT count(1)
451: INTO l_count
452: FROM FA_TRANSACTION_HEADERS th,
453: FA_DEPRN_PERIODS dp,
454: FA_BOOK_CONTROLS bc
455: WHERE th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
456: AND th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
457: AND th.transaction_type_code||'' = 'TRANSFER'