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_BOOK_CONTROLS

Line 1748: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b

1744: --Added prorate_convention_code to the Select clause
1745: CURSOR l_okxassetlines_csr IS
1746: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
1747: o.dnz_chr_id ,a.book_type_code, b.book_class, prorate_convention_code
1748: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
1749: WHERE o.parent_line_id = p_financial_asset_id
1750: AND o.asset_id = a.asset_id
1751: AND a.book_type_code = b.book_type_code
1752: AND a.date_ineffective IS NULL

Line 1833: FROM fa_book_controls

1829:
1830: -- This cursor is used temporarily to get the fiscal year name till FA API is fixed
1831: CURSOR l_bookcontrols_csr(p_book_type_code VARCHAR2) IS
1832: SELECT fiscal_year_name
1833: FROM fa_book_controls
1834: WHERE book_type_code = p_book_type_code;
1835:
1836:
1837: --SECHAWLA 21-NOV-2003 3262519 : Added the following cursors

Line 3576: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b

3572: --Added prorate_convention_code to the Select clause
3573: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS
3574: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
3575: o.dnz_chr_id ,a.book_type_code, b.book_class, a.prorate_convention_code
3576: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
3577: WHERE o.parent_line_id = p_kle_id
3578: AND o.asset_id = a.asset_id
3579: AND a.book_type_code = b.book_type_code
3580: AND a.date_ineffective IS NULL

Line 3663: FROM fa_book_controls

3659: --SECHAWLA 05-FEB-03 Bug # 2781557 : new cursor
3660: -- This cursor is used temporarily to get the fiscal year name till FA API is fixed
3661: CURSOR l_bookcontrols_csr(p_book_type_code VARCHAR2) IS
3662: SELECT fiscal_year_name
3663: FROM fa_book_controls
3664: WHERE book_type_code = p_book_type_code;
3665:
3666: --SECHAWLA 21-NOV-2003 3262519 : Added the following cursor
3667: