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 OKX_ASSET_LINES_V

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 2388: -- Direct Finance Lease, okx_asset_lines_v, gives OEC as the cost. FA Retirements compares this cost with

2384: -- user requested for full retirement and none of the units have been retired so far
2385: -- perform full retirement
2386:
2387: -- we are passing the total number of units and not the cost, for full retirements, because for
2388: -- Direct Finance Lease, okx_asset_lines_v, gives OEC as the cost. FA Retirements compares this cost with
2389: --cost in fa_books. These 2 costs can be different, which will give error. So we are using units instead
2390: -- of cost to avoid that validation check.
2391:
2392:

Line 3569: --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

3565: --SECHAWLA 23_DEC-02 Bug # 2701440
3566: --Added Order By clause to selct CORPORATE Book first
3567:
3568: --SECHAWLA 13-JAN-03 Bug # 2701440
3569: --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
3570:
3571: --SECHAWLA 06-JUN-03 Bug # 2999419
3572: --Added prorate_convention_code to the Select clause
3573: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS

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 4174: -- Direct Finance Lease, okx_asset_lines_v, gives OEC as the cost. FA Retirements compares this cost with

4170: -- perform full retirement
4171: IF l_non_retired_quantity = l_quantity THEN --distribution qty = orginal asset return qty
4172:
4173: -- we are passing the total number of units and not the cost, for full retirements, because for
4174: -- Direct Finance Lease, okx_asset_lines_v, gives OEC as the cost. FA Retirements compares this cost with
4175: --cost in fa_books. These 2 costs can be different, which will give error. So we are using units instead
4176: -- of cost to avoid that validation check.
4177:
4178: -- SECHAWLA 21-NOV-03, 3262519 : added tax owner and delta cost parameter to the following procedure