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_ASSET_DISPOSE_PVT dependencies on FA_TRANSACTION_HEADERS

Line 1824: FROM fa_transaction_headers th

1820:
1821: -- This cursor is used to find out the period_of_addtion for the asset that is to be retired
1822: CURSOR l_periodofaddition_csr(p_asset_id NUMBER, p_book_type_code VARCHAR2, p_period_open_date DATE) IS
1823: SELECT count(*)
1824: FROM fa_transaction_headers th
1825: WHERE th.asset_id = p_asset_id
1826: AND th.book_type_code = p_book_type_code
1827: AND th.transaction_type_code = 'ADDITION'
1828: AND th.date_effective > p_period_open_date;

Line 3653: FROM fa_transaction_headers th

3649: --SECHAWLA 05-FEB-03 Bug # 2781557 : new cursor
3650: -- This cursor is used to find out the period_of_addtion for the asset that is to be retired
3651: CURSOR l_periodofaddition_csr(p_asset_id NUMBER, p_book_type_code VARCHAR2, p_period_open_date DATE) IS
3652: SELECT count(*)
3653: FROM fa_transaction_headers th
3654: WHERE th.asset_id = p_asset_id
3655: AND th.book_type_code = p_book_type_code
3656: AND th.transaction_type_code = 'ADDITION'
3657: AND th.date_effective > p_period_open_date;