DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_ASSET_LINES_V

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

2521: --cursor to fetch the corporate and tax book for the given asset
2522: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS
2523: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
2524: o.dnz_chr_id ,a.book_type_code, b.book_class, a.prorate_convention_code
2525: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
2526: WHERE o.parent_line_id = p_kle_id
2527: AND o.asset_id = a.asset_id
2528: AND a.book_type_code = b.book_type_code
2529: AND a.date_ineffective IS NULL

Line 3015: FROM OKX_ASSET_LINES_V

3011: IN_USE_FLAG,
3012: OWNED_LEASED,
3013: INVENTORIAL,
3014: LINE_STATUS
3015: FROM OKX_ASSET_LINES_V
3016: WHERE parent_line_id = p_cle_id;
3017: l_ast_line_rec ast_line_rec_type;
3018: BEGIN
3019: x_no_data_found := TRUE;