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_POOLS

Line 111: FROM okl_pools polb

107: IS
108: SELECT chrb.contract_number agreement_number
109: ,polb.pool_number pool_number
110: ,polb.currency_code currency_code
111: FROM okl_pools polb
112: ,okc_k_headers_b chrb
113: WHERE polb.khr_id = chrb.id
114: AND polb.khr_id = p_khr_id;
115:

Line 125: ,okl_pools polb

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
129: WHERE pocb.pol_id = polb.id

Line 158: ,okl_pools polb

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;
162:

Line 171: ,okl_pools polb

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
175: AND pocb.sty_id = styb.id