DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_ASSET_LINES_V

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

2549: --cursor to fetch the corporate and tax book for the given asset
2550: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS
2551: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
2552: o.dnz_chr_id ,a.book_type_code, b.book_class, a.prorate_convention_code
2553: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
2554: WHERE o.parent_line_id = p_kle_id
2555: AND o.asset_id = a.asset_id
2556: AND a.book_type_code = b.book_type_code
2557: AND a.date_ineffective IS NULL

Line 3043: FROM OKX_ASSET_LINES_V

3039: IN_USE_FLAG,
3040: OWNED_LEASED,
3041: INVENTORIAL,
3042: LINE_STATUS
3043: FROM OKX_ASSET_LINES_V
3044: WHERE parent_line_id = p_cle_id;
3045: l_ast_line_rec ast_line_rec_type;
3046: BEGIN
3047: x_no_data_found := TRUE;