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 3231: okc_k_lines_b cle

3227: IS
3228: SELECT '1'
3229: FROM okl_txd_assets_v tdas,
3230: okl_txl_assets_b tal,
3231: okc_k_lines_b cle
3232: WHERE cle.id = tal.kle_id
3233: AND tal.id = tdas.tal_id
3234: AND tal.tal_type = 'ALI'
3235: -- link from okl_pool_srch_v pol

Line 3260: FROM okc_k_lines_b cle,

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

Line 4185: okc_k_lines_b cleb

4181: AND EXISTS -- split assets, split assets components
4182: (SELECT '1'
4183: FROM okl_txd_assets_v tdas,
4184: okl_txl_assets_b talb,
4185: okc_k_lines_b cleb
4186: WHERE cleb.id = talb.kle_id
4187: AND talb.ID = tdas.TAL_ID
4188: AND talb.TAL_TYPE = 'ALI'
4189: AND cleb.cle_id = poc.kle_id -- top line id

Line 4208: okc_k_lines_b cleb,

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

Line 4371: okc_k_lines_b cleb

4367: AND EXISTS -- split assets, split assets components
4368: (SELECT '1'
4369: FROM okl_txd_assets_v tdas,
4370: okl_txl_assets_b talb,
4371: okc_k_lines_b cleb
4372: WHERE cleb.id = talb.kle_id
4373: AND talb.ID = tdas.TAL_ID
4374: AND talb.TAL_TYPE = 'ALI'
4375: AND cleb.cle_id = poc.kle_id -- top line id

Line 4394: okc_k_lines_b cleb,

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