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 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 3593: FROM fa_retirements

3589:
3590: --SECHAWLA 13-JAN-03 Bug # 2701440 : Added Order By Clause to select the latest retirement record first
3591: CURSOR l_faretirement_csr(p_asset_id IN NUMBER, p_book_type_code IN VARCHAR2) IS
3592: SELECT cost_retired
3593: FROM fa_retirements
3594: WHERE asset_id = p_asset_id
3595: AND book_type_code = p_book_type_code
3596: ORDER BY last_update_date DESC;
3597: */

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

Line 5238: FROM fa_retirements

5234:
5235: -- This cursor is used to validate the retirement ID
5236: CURSOR l_faretirement_csr(p_retirement_id NUMBER) IS
5237: SELECT 'x'
5238: FROM fa_retirements
5239: WHERE retirement_id = p_retirement_id;
5240:
5241: BEGIN
5242: l_return_status := OKL_API.START_ACTIVITY(l_api_name,