DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on FA_BOOKS

Line 4222: FROM fa_books fab,

4218:
4219: -- get asset cost
4220: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
4221: SELECT fab.original_cost
4222: FROM fa_books fab,
4223: fa_book_controls fbc,
4224: okc_k_items_v itm,
4225: okc_k_lines_b kle,
4226: okc_line_styles_v lse

Line 4255: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b

4251: -- rmunjulu 3735773
4252: -- get asset cost for corporate book (RMUNJULU)
4253: CURSOR get_corp_book_cost_csr (p_kle_id IN NUMBER) IS
4254: SELECT a.COST cost
4255: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
4256: WHERE o.parent_line_id = p_kle_id
4257: AND o.asset_id = a.asset_id
4258: AND a.book_type_code = b.book_type_code
4259: AND a.date_ineffective IS NULL

Line 4622: FROM fa_books fab,

4618:
4619: -- get asset cost
4620: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
4621: SELECT nvl(fab.cost,0) current_cost
4622: FROM fa_books fab,
4623: fa_book_controls fbc,
4624: okc_k_items_v itm,
4625: okc_k_lines_b kle,
4626: okc_line_styles_v lse