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 3568: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b

3564: --Added prorate_convention_code to the Select clause
3565: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS
3566: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
3567: o.dnz_chr_id ,a.book_type_code, b.book_class, a.prorate_convention_code
3568: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
3569: WHERE o.parent_line_id = p_kle_id
3570: AND o.asset_id = a.asset_id
3571: AND a.book_type_code = b.book_type_code
3572: AND a.date_ineffective IS NULL

Line 3655: FROM fa_book_controls

3651: --SECHAWLA 05-FEB-03 Bug # 2781557 : new cursor
3652: -- This cursor is used temporarily to get the fiscal year name till FA API is fixed
3653: CURSOR l_bookcontrols_csr(p_book_type_code VARCHAR2) IS
3654: SELECT fiscal_year_name
3655: FROM fa_book_controls
3656: WHERE book_type_code = p_book_type_code;
3657:
3658: --SECHAWLA 21-NOV-2003 3262519 : Added the following cursor
3659: