DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on OKC_K_ITEMS_V

Line 4182: okc_k_items_v itm,

4178: FROM fa_deprn_summary fds,
4179: fa_deprn_periods fdp,
4180: fa_book_controls fbc,
4181: fa_calendar_periods fcp,
4182: okc_k_items_v itm,
4183: okc_k_lines_b kle,
4184: okc_line_styles_v lse
4185: WHERE fdp.book_type_code = fds.book_type_code
4186: AND fdp.period_counter = fds.period_counter

Line 4224: okc_k_items_v itm,

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
4227: WHERE fbc.book_class = 'CORPORATE'
4228: AND fab.book_type_code = fbc.book_type_code

Line 4582: okc_k_items_v itm,

4578: FROM fa_deprn_summary fds,
4579: fa_deprn_periods fdp,
4580: fa_book_controls fbc,
4581: fa_calendar_periods fcp,
4582: okc_k_items_v itm,
4583: okc_k_lines_b kle,
4584: okc_line_styles_v lse
4585: WHERE fdp.book_type_code = fds.book_type_code
4586: AND fdp.period_counter = fds.period_counter

Line 4624: okc_k_items_v itm,

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
4627: WHERE fbc.book_class = 'CORPORATE'
4628: AND fab.book_type_code = fbc.book_type_code