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 HZ_PARTY_SITES

Line 312: hz_party_sites hps,

308: CURSOR c_installed_site_csr (p_kle_id NUMBER, p_khr_id NUMBER)
309: IS
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,

Line 333: AND csi.install_location_type_code = 'HZ_PARTY_SITES'

329: AND cim_ib.object1_id1 = csi.instance_id
330: AND cim_ib.object1_id2 = '#'
331: AND cim_ib.jtot_object1_code = 'OKX_IB_ITEM'
332: AND csi.install_location_id = hps.party_site_id
333: AND csi.install_location_type_code = 'HZ_PARTY_SITES'
334: AND hps.location_id = hl.location_id
335: AND cle_fin.dnz_chr_id = p_khr_id
336: AND cle_fin.id = p_kle_id;
337: