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_SEC_CONCURRENT_PVT dependencies on OKL_POOL_CONTENTS

Line 124: FROM okl_pool_contents pocb

120: SELECT pocb.id id
121: ,chrb.contract_number contract_number
122: ,clet.name asset_number
123: ,styv.name stream_type_name
124: FROM okl_pool_contents pocb
125: ,okl_pools polb
126: ,okc_k_headers_b chrb
127: ,okc_k_lines_tl clet
128: ,okl_strm_type_v styv

Line 157: FROM okl_pool_contents pocb

153: CURSOR l_okl_dnz_chrs_csr (p_khr_id IN NUMBER)
154: IS
155: SELECT DISTINCT
156: pocb.khr_id dnz_chr_id
157: FROM okl_pool_contents pocb
158: ,okl_pools polb
159: WHERE pocb.pol_id = polb.id
160: AND polb.khr_id = p_khr_id
161: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE;

Line 170: FROM okl_pool_contents pocb

166: SELECT DISTINCT
167: pocb.pol_id
168: ,pocb.khr_id
169: ,styb.stream_type_subclass
170: FROM okl_pool_contents pocb
171: ,okl_pools polb
172: ,okl_strm_type_b styb
173: WHERE pocb.pol_id = polb.id
174: AND polb.khr_id = p_khr_id