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_RETIREMENTS

Line 1766: FROM fa_retirements

1762:
1763: --SECHAWLA 13-JAN-03 Bug # 2701440 : Added Order By Clause to select the latest retirement record first
1764: CURSOR l_faretirement_csr(p_asset_id IN NUMBER, p_book_type_code IN VARCHAR2) IS
1765: SELECT cost_retired
1766: FROM fa_retirements
1767: WHERE asset_id = p_asset_id
1768: AND book_type_code = p_book_type_code
1769: ORDER BY last_update_date DESC;
1770: */

Line 2380: -- Direct Finance Lease, okx_asset_lines_v, gives OEC as the cost. FA Retirements compares this cost with

2376: -- user requested for full retirement and none of the units have been retired so far
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:

Line 3585: FROM fa_retirements

3581:
3582: --SECHAWLA 13-JAN-03 Bug # 2701440 : Added Order By Clause to select the latest retirement record first
3583: CURSOR l_faretirement_csr(p_asset_id IN NUMBER, p_book_type_code IN VARCHAR2) IS
3584: SELECT cost_retired
3585: FROM fa_retirements
3586: WHERE asset_id = p_asset_id
3587: AND book_type_code = p_book_type_code
3588: ORDER BY last_update_date DESC;
3589: */

Line 4159: -- Direct Finance Lease, okx_asset_lines_v, gives OEC as the cost. FA Retirements compares this cost with

4155: -- perform full retirement
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

Line 5223: FROM fa_retirements

5219:
5220: -- This cursor is used to validate the retirement ID
5221: CURSOR l_faretirement_csr(p_retirement_id NUMBER) IS
5222: SELECT 'x'
5223: FROM fa_retirements
5224: WHERE retirement_id = p_retirement_id;
5225:
5226: BEGIN
5227: l_return_status := OKL_API.START_ACTIVITY(l_api_name,