APPS.OKL_AM_UTIL_PVT dependencies on OKC_K_LINES_B

Line 227: FROM okc_k_lines_b cle,

223:
224: -- Get asset quantity
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

Line 3707: OKC_K_LINES_B KLE,

3703: QTE.qst_code qst_code,
3704: QTE.qtp_code qtp_code
3705: FROM OKL_TRX_QUOTES_B QTE,
3706: OKL_TXL_QTE_LINES_ALL_B TQL,
3707: OKC_K_LINES_B KLE,
3708: OKC_K_HEADERS_ALL_B KHR
3709: WHERE TQL.kle_id = KLE.id
3710: AND TQL.qte_id = QTE.id
3711: AND KLE.chr_id = KHR.id

Line 4138: FROM OKC_K_LINES_B kle

4134:
4135: -- get asset termination date
4136: CURSOR get_term_date_csr (p_kle_id IN NUMBER) IS
4137: SELECT kle.date_terminated
4138: FROM OKC_K_LINES_B kle
4139: WHERE kle.id = p_kle_id;
4140:
4141: -- get termination trn for the contract and asset
4142: CURSOR get_quote_type_csr (p_khr_id IN NUMBER, p_kle_id IN NUMBER) IS

Line 4183: okc_k_lines_b kle,

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
4187: AND fbc.book_class = 'CORPORATE'

Line 4206: okc_k_lines_b kle,

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
4210: and fdp.period_close_date is null

Line 4225: okc_k_lines_b kle,

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
4229: AND fab.asset_id = itm.object1_id1

Line 4583: okc_k_lines_b kle,

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
4587: AND fbc.book_class = 'CORPORATE'

Line 4606: okc_k_lines_b kle,

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
4610: AND fdp.period_close_date IS NULL

Line 4625: okc_k_lines_b kle,

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
4629: AND fab.asset_id = itm.object1_id1

Line 4988: FROM okc_k_lines_b line,

4984: p_top_line_id IN NUMBER) RETURN VARCHAR2 IS
4985:
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