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 3261: okc_statuses_b sts

3257: CURSOR l_okl_poc_kle_csr(p_kle_id IN NUMBER)
3258: IS
3259: SELECT '1'
3260: FROM okc_k_lines_b cle,
3261: okc_statuses_b sts
3262: WHERE sts.code = cle.sts_code
3263: AND sts.ste_code IN ('HOLD','EXPIRED','TERMINATED','CANCELLED')
3264: AND cle.id = p_kle_id;
3265:

Line 4209: okc_statuses_b stsb

4205: IN
4206: (SELECT poc.khr_id
4207: FROM okl_pool_contents poc,
4208: okc_k_lines_b cleb,
4209: okc_statuses_b stsb
4210: WHERE poc.pol_id = p_pol_id
4211: AND poc.kle_id = cleb.id
4212: AND cleb.sts_code = stsb.code
4213: -- cklee 04/10/2003 never reconcile historical data

Line 4395: okc_statuses_b stsb

4391: IN
4392: (SELECT poc.khr_id
4393: FROM okl_pool_contents poc,
4394: okc_k_lines_b cleb,
4395: okc_statuses_b stsb
4396: WHERE poc.pol_id = p_pol_id
4397: AND poc.kle_id = cleb.id
4398: AND cleb.sts_code = stsb.code
4399: -- cklee 04/10/2003 never reconcile historical data