APPS.OKL_AM_UTIL_PVT dependencies on OKC_K_ITEMS

Line 229: okc_k_items cim

225: CURSOR l_quantity_csr (cp_cle_id NUMBER) IS
226: SELECT cim.number_of_items asset_quantity
227: FROM okc_k_lines_b cle,
228: okc_line_styles_b lse,
229: okc_k_items cim
230: WHERE cle.cle_id = cp_cle_id
231: AND lse.id = cle.lse_id
232: AND lse.lty_code = 'ITEM'
233: AND cim.cle_id = cle.id;

Line 235: l_result okc_k_items.number_of_items%TYPE := NULL;

231: AND lse.id = cle.lse_id
232: AND lse.lty_code = 'ITEM'
233: AND cim.cle_id = cle.id;
234:
235: l_result okc_k_items.number_of_items%TYPE := NULL;
236:
237: BEGIN
238:
239: OPEN l_quantity_csr (p_cle_id);

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 4205: okc_k_items itm,

4201: select fds.deprn_reserve deprn_amt
4202: from fa_deprn_summary fds,
4203: fa_deprn_periods fdp,
4204: fa_book_controls fbc,
4205: okc_k_items itm,
4206: okc_k_lines_b kle,
4207: okc_line_styles_b lse
4208: where fdp.book_type_code = fds.book_type_code
4209: and fdp.period_counter - 1 = 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 4605: okc_k_items itm,

4601: SELECT nvl(fds.deprn_reserve,0) deprn_amt
4602: FROM fa_deprn_summary fds,
4603: fa_deprn_periods fdp,
4604: fa_book_controls fbc,
4605: okc_k_items itm,
4606: okc_k_lines_b kle,
4607: okc_line_styles_b lse
4608: WHERE fdp.book_type_code = fds.book_type_code
4609: AND fdp.period_counter - 1 = 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

Line 4990: okc_k_items kitem,

4986: CURSOR check_item_csr (p_line_id IN NUMBER) IS -- p_line_id is FREE_FORM1
4987: SELECT mtl.serial_number_control_code
4988: FROM okc_k_lines_b line,
4989: okc_line_styles_b style,
4990: okc_k_items kitem,
4991: mtl_system_items mtl
4992: WHERE line.lse_id = style.id
4993: AND style.lty_code = 'ITEM'
4994: AND line.id = kitem.cle_id