eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKC_K_LINES_B

Line 282: FROM okc_k_lines_b cleb

278: 1, 'SERVICE', -- Service
279: 48, 'SERVICE',
280: 52, 'FEE', -- Fee
281: NULL) contract_line_type
282: FROM okc_k_lines_b cleb
283: ,okl_k_lines kle
284: ,okc_k_lines_tl clet
285: WHERE cleb.id = p_kle_id
286: AND kle.id = cleb.id

Line 296: FROM okc_k_lines_b cleb_vendor

292: CURSOR c_vendor_name_csr (p_kle_id NUMBER, p_khr_id NUMBER)
293: IS
294: SELECT pov.vendor_id
295: ,pov.vendor_name
296: FROM okc_k_lines_b cleb_vendor
297: ,po_vendors pov
298: ,okc_k_party_roles_b pty
299: WHERE cleb_vendor.cle_id = p_kle_id
300: AND cleb_vendor.dnz_chr_id = p_khr_id

Line 315: okc_k_lines_b cle_ib,

311: FROM hz_locations hl,
312: hz_party_sites hps,
313: csi_item_instances csi,
314: okc_k_items cim_ib,
315: okc_k_lines_b cle_ib,
316: okc_k_lines_b cle_inst,
317: okc_k_lines_b cle_fin
318: WHERE cle_fin.cle_id is null
319: AND cle_fin.chr_id = cle_fin.dnz_chr_id

Line 316: okc_k_lines_b cle_inst,

312: hz_party_sites hps,
313: csi_item_instances csi,
314: okc_k_items cim_ib,
315: okc_k_lines_b cle_ib,
316: okc_k_lines_b cle_inst,
317: okc_k_lines_b cle_fin
318: WHERE cle_fin.cle_id is null
319: AND cle_fin.chr_id = cle_fin.dnz_chr_id
320: AND cle_fin.lse_id = 33

Line 317: okc_k_lines_b cle_fin

313: csi_item_instances csi,
314: okc_k_items cim_ib,
315: okc_k_lines_b cle_ib,
316: okc_k_lines_b cle_inst,
317: okc_k_lines_b cle_fin
318: WHERE cle_fin.cle_id is null
319: AND cle_fin.chr_id = cle_fin.dnz_chr_id
320: AND cle_fin.lse_id = 33
321: AND cle_inst.cle_id = cle_fin.id

Line 438: FROM okc_k_lines_b cleb_fa

434: SELECT fac.category_id category_id
435: ,fab.manufacturer_name manufacturer_name
436: ,fab.model_number model_number
437: ,fac.SEGMENT1 || '-' || fac.SEGMENT2 asset_category_name
438: FROM okc_k_lines_b cleb_fa
439: ,fa_additions_b fab
440: ,okc_k_items cim
441: ,fa_categories fac
442: WHERE cleb_fa.cle_id = p_kle_id

Line 455: FROM okc_k_lines_b cleb_loc

451: -- Cursor to fetch the Asset Location Id
452: CURSOR c_location_id_csr (p_kle_id NUMBER, p_khr_id NUMBER )
453: IS
454: SELECT fdh.location_id
455: FROM okc_k_lines_b cleb_loc
456: ,fa_distribution_history fdh
457: ,okc_k_items cim
458: WHERE cleb_loc.cle_id = p_kle_id
459: AND cleb_loc.dnz_chr_id = p_khr_id

Line 514: okc_k_lines_b cleb_year

510: CURSOR c_asset_year_manufactured_csr (p_kle_id NUMBER, p_khr_id NUMBER)
511: IS
512: SELECT kle.Year_built year_of_manufacture
513: FROM okl_k_lines kle,
514: okc_k_lines_b cleb_year
515: WHERE kle.id = cleb_year.id
516: AND cleb_year.cle_id = p_kle_id
517: AND cleb_year.dnz_chr_id = p_khr_id
518: AND cleb_year.lse_id = 42;

Line 639: FROM okc_k_lines_b cle

635: CURSOR get_line_style_csr(p_kle_id IN NUMBER)
636: IS
637: SELECT lse.lty_code line_style
638: ,cle.cle_id parent_line_id
639: FROM okc_k_lines_b cle
640: ,okc_line_styles_b lse
641: WHERE cle.lse_id = lse.id
642: AND cle.id = p_kle_id;
643:

Line 696: ,okc_k_lines_b cleb

692: (
693: SELECT 1
694: FROM okl_trx_assets tas
695: ,okl_txl_assets_b tal
696: ,okc_k_lines_b cleb
697: WHERE cleb.id = tql.kle_id
698: AND cleb.cle_id = tal.kle_id
699: AND tal.tas_id = tas.id
700: AND tas.id = p_split_asset_trx_id

Line 7963: ,okc_k_lines_b ast

7959: ,ast.cle_id kle_id
7960: ,fa_dep.asset_id asset_id
7961: FROM fa_deprn_summary fa_dep
7962: ,okc_k_items okc_item
7963: ,okc_k_lines_b ast
7964: ,okl_parallel_processes opp
7965: WHERE fa_dep.book_type_code = p_book_type_code
7966: AND fa_dep.period_counter = p_period_counter
7967: AND fa_dep.deprn_source_code = 'DEPRN'