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_BOOKS

Line 1741: --Changed the cursor to select cost columns from fa_books instead of okx_asset_lines_v, as the latter has info for corporate book only

1737: --SECHAWLA 23-DEC-02 Bug # 2701440
1738: --Added Order By clause to select CORPORATE Book first
1739:
1740: --SECHAWLA 13-JAN-03 Bug # 2701440
1741: --Changed the cursor to select cost columns from fa_books instead of okx_asset_lines_v, as the latter has info for corporate book only
1742:
1743: --SECHAWLA 03-JUN-03 Bug # 2999419
1744: --Added prorate_convention_code to the Select clause
1745: CURSOR l_okxassetlines_csr IS

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 2381: --cost in fa_books. These 2 costs can be different, which will give error. So we are using units instead

2377: -- perform full retirement
2378:
2379: -- we are passing the total number of units and not the cost, for full retirements, because for
2380: -- Direct Finance Lease, okx_asset_lines_v, gives OEC as the cost. FA Retirements compares this cost with
2381: --cost in fa_books. These 2 costs can be different, which will give error. So we are using units instead
2382: -- of cost to avoid that validation check.
2383:
2384:
2385:

Line 3561: --Changed the cursor to select cost columns from fa_books instead of okx_asset_lines_v, as the latter has info for corporate book only

3557: --SECHAWLA 23_DEC-02 Bug # 2701440
3558: --Added Order By clause to selct CORPORATE Book first
3559:
3560: --SECHAWLA 13-JAN-03 Bug # 2701440
3561: --Changed the cursor to select cost columns from fa_books instead of okx_asset_lines_v, as the latter has info for corporate book only
3562:
3563: --SECHAWLA 06-JUN-03 Bug # 2999419
3564: --Added prorate_convention_code to the Select clause
3565: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS

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 4160: --cost in fa_books. These 2 costs can be different, which will give error. So we are using units instead

4156: IF l_non_retired_quantity = l_quantity THEN --distribution qty = orginal asset return qty
4157:
4158: -- we are passing the total number of units and not the cost, for full retirements, because for
4159: -- Direct Finance Lease, okx_asset_lines_v, gives OEC as the cost. FA Retirements compares this cost with
4160: --cost in fa_books. These 2 costs can be different, which will give error. So we are using units instead
4161: -- of cost to avoid that validation check.
4162:
4163: -- SECHAWLA 21-NOV-03, 3262519 : added tax owner and delta cost parameter to the following procedure
4164: do_full_units_retirement(