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_POOL_PVT dependencies on OKC_STATUSES_B

Line 2711: okc_statuses_b sts

2707: AND ico.object_id = pol.dnz_chr_id)
2708: AND NOT EXISTS -- contract line has been terminated
2709: (SELECT '1'
2710: FROM okc_k_lines_b cle,
2711: okc_statuses_b sts
2712: WHERE sts.code = cle.sts_code
2713: AND sts.ste_code IN ('HOLD','EXPIRED','TERMINATED','CANCELLED')
2714: AND cle.id = pol.kle_id)
2715: GROUP BY

Line 2838: okc_statuses_b sts

2834: AND ico.object_id = pol.dnz_chr_id)
2835: AND NOT EXISTS -- contract line has been terminated
2836: (SELECT '1'
2837: FROM okc_k_lines_b cle,
2838: okc_statuses_b sts
2839: WHERE sts.code = cle.sts_code
2840: AND sts.ste_code IN ('HOLD','EXPIRED','TERMINATED','CANCELLED')
2841: AND cle.id = pol.kle_id)
2842: GROUP BY

Line 3255: okc_statuses_b sts

3251: CURSOR l_okl_poc_kle_csr(p_kle_id IN NUMBER)
3252: IS
3253: SELECT '1'
3254: FROM okc_k_lines_b cle,
3255: okc_statuses_b sts
3256: WHERE sts.code = cle.sts_code
3257: AND sts.ste_code IN ('HOLD','EXPIRED','TERMINATED','CANCELLED')
3258: AND cle.id = p_kle_id;
3259:

Line 4203: okc_statuses_b stsb

4199: IN
4200: (SELECT poc.khr_id
4201: FROM okl_pool_contents poc,
4202: okc_k_lines_b cleb,
4203: okc_statuses_b stsb
4204: WHERE poc.pol_id = p_pol_id
4205: AND poc.kle_id = cleb.id
4206: AND cleb.sts_code = stsb.code
4207: -- cklee 04/10/2003 never reconcile historical data

Line 4388: okc_statuses_b stsb

4384: IN
4385: (SELECT poc.khr_id
4386: FROM okl_pool_contents poc,
4387: okc_k_lines_b cleb,
4388: okc_statuses_b stsb
4389: WHERE poc.pol_id = p_pol_id
4390: AND poc.kle_id = cleb.id
4391: AND cleb.sts_code = stsb.code
4392: -- cklee 04/10/2003 never reconcile historical data