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_ITEMS

Line 314: okc_k_items cim_ib,

310: SELECT hl.location_id installed_site_id
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

Line 440: ,okc_k_items cim

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
443: AND cleb_fa.dnz_chr_id = p_khr_id
444: AND cleb_fa.lse_id = 42

Line 457: ,okc_k_items cim

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
460: AND cleb_loc.lse_id = 42
461: AND cim.cle_id = cleb_loc.id

Line 8077: ,okc_k_items okc_item

8073: ,ast.dnz_chr_id khr_id
8074: ,ast.cle_id kle_id
8075: ,fa_dep.asset_id asset_id
8076: FROM fa_deprn_summary fa_dep
8077: ,okc_k_items okc_item
8078: ,okc_k_lines_b ast
8079: ,okl_parallel_processes opp
8080: WHERE fa_dep.book_type_code = p_book_type_code
8081: AND fa_dep.period_counter = p_period_counter