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_K_LINES_B

Line 2688: okc_k_lines_b cle

2684: AND NOT EXISTS -- split assets, split assets components
2685: (SELECT '1'
2686: FROM okl_txd_assets_v tdas,
2687: okl_txl_assets_b tal,
2688: okc_k_lines_b cle
2689: WHERE cle.id = tal.kle_id
2690: AND tal.id = tdas.tal_id
2691: AND tal.tal_type = 'ALI'
2692: -- link from okl_pool_srch_v pol

Line 2710: FROM okc_k_lines_b cle,

2706: AND del.status ='DELINQUENT'
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)

Line 2815: okc_k_lines_b cle

2811: AND NOT EXISTS -- split assets, split assets components
2812: (SELECT '1'
2813: FROM okl_txd_assets_v tdas,
2814: okl_txl_assets_b tal,
2815: okc_k_lines_b cle
2816: WHERE cle.id = tal.kle_id
2817: AND tal.id = tdas.tal_id
2818: AND tal.tal_type = 'ALI'
2819: -- link from okl_pool_srch_v pol

Line 2837: FROM okc_k_lines_b cle,

2833: AND del.status ='DELINQUENT'
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)

Line 3225: okc_k_lines_b cle

3221: IS
3222: SELECT '1'
3223: FROM okl_txd_assets_v tdas,
3224: okl_txl_assets_b tal,
3225: okc_k_lines_b cle
3226: WHERE cle.id = tal.kle_id
3227: AND tal.id = tdas.tal_id
3228: AND tal.tal_type = 'ALI'
3229: -- link from okl_pool_srch_v pol

Line 3254: FROM okc_k_lines_b cle,

3250: -- contract line has been terminated
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;

Line 4179: okc_k_lines_b cleb

4175: AND EXISTS -- split assets, split assets components
4176: (SELECT '1'
4177: FROM okl_txd_assets_v tdas,
4178: okl_txl_assets_b talb,
4179: okc_k_lines_b cleb
4180: WHERE cleb.id = talb.kle_id
4181: AND talb.ID = tdas.TAL_ID
4182: AND talb.TAL_TYPE = 'ALI'
4183: AND cleb.cle_id = poc.kle_id -- top line id

Line 4202: okc_k_lines_b cleb,

4198: WHERE poc.khr_id
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

Line 4364: okc_k_lines_b cleb

4360: AND EXISTS -- split assets, split assets components
4361: (SELECT '1'
4362: FROM okl_txd_assets_v tdas,
4363: okl_txl_assets_b talb,
4364: okc_k_lines_b cleb
4365: WHERE cleb.id = talb.kle_id
4366: AND talb.ID = tdas.TAL_ID
4367: AND talb.TAL_TYPE = 'ALI'
4368: AND cleb.cle_id = poc.kle_id -- top line id

Line 4387: okc_k_lines_b cleb,

4383: WHERE poc.khr_id
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