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_FUNDING_PVT dependencies on OKC_LINE_STYLES_B

Line 2338: okc_line_styles_b ls,

2334: cle.id,
2335: nvl(cle.start_date,k.start_date)
2336: from OKL_K_LINES_FULL_V cle,
2337: okc_k_party_roles_b cpl,
2338: okc_line_styles_b ls,
2339: okc_k_headers_b k
2340: where k.id = cle.dnz_chr_id
2341: and cle.dnz_chr_id = p_contract_id
2342: and cle.lse_id = ls.id

Line 2617: okc_line_styles_b ls,

2613: cle.id,
2614: nvl(cle.start_date,k.start_date)
2615: from OKL_K_LINES_FULL_V cle,
2616: okc_k_party_roles_b cpl,
2617: okc_line_styles_b ls,
2618: okc_k_headers_b k
2619: where k.id = cle.dnz_chr_id
2620: and cle.dnz_chr_id = p_contract_id
2621: and cle.lse_id = ls.id

Line 7270: FROM okc_line_styles_b model_lse

7266: AND cpl.rle_code = 'OKL_VENDOR'
7267: AND cpl.object1_id1 = TO_CHAR(p_vendor_id)
7268: AND cpl.object1_id2 = '#'
7269: AND EXISTS(SELECT NULL
7270: FROM okc_line_styles_b model_lse
7271: WHERE model_lse.ID = cle.lse_id AND model_lse.lty_code = 'ITEM' AND cle.cle_id = p_kle_id)
7272: --Bug# 13809564
7273: AND cle.sts_code <> 'ABANDONED'
7274: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement

Line 7320: FROM okc_line_styles_b adon_lse

7316: AND cpl.object1_id1 = TO_CHAR(p_vendor_id)
7317: AND cpl.object1_id2 = '#'
7318: -- end: okl.h: cklee
7319: AND EXISTS(SELECT NULL
7320: FROM okc_line_styles_b adon_lse
7321: WHERE adon_lse.ID = cle.lse_id AND adon_lse.lty_code = 'ADD_ITEM'
7322: -- ADD_ITEM has one parent ITEM only
7323: AND EXISTS(SELECT NULL
7324: FROM okc_k_lines_b mdl_parent

Line 7366: FROM okc_line_styles_b model_lse

7362: AND cpl.rle_code = 'OKL_VENDOR'
7363: --and cpl.object1_id1 = to_char(p_vendor_id)
7364: --and cpl.object1_id2 = '#'
7365: AND EXISTS(SELECT NULL
7366: FROM okc_line_styles_b model_lse
7367: WHERE model_lse.ID = cle.lse_id AND model_lse.lty_code = 'ITEM' AND cle.cle_id = p_kle_id)
7368: --Bug# 13809564
7369: AND cle.sts_code <> 'ABANDONED'
7370: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement

Line 7388: FROM okc_line_styles_b adon_lse

7384: AND cpl.rle_code = 'OKL_VENDOR'
7385: --and cpl.object1_id1 = to_char(p_vendor_id)
7386: --and cpl.object1_id2 = '#'
7387: AND EXISTS(SELECT NULL
7388: FROM okc_line_styles_b adon_lse
7389: WHERE adon_lse.ID = cle.lse_id AND adon_lse.lty_code = 'ADD_ITEM'
7390: -- ADD_ITEM has one parent ITEM only
7391: AND EXISTS(SELECT NULL
7392: FROM okc_k_lines_b mdl_parent

Line 7429: FROM okc_line_styles_b model_lse

7425: AND cpl.dnz_chr_id = p_khr_id
7426: AND cpl.chr_id IS NULL
7427: AND cpl.rle_code = 'OKL_VENDOR'
7428: AND EXISTS(SELECT NULL
7429: FROM okc_line_styles_b model_lse
7430: WHERE model_lse.ID = cle.lse_id
7431: AND model_lse.lty_code = 'ITEM')
7432: --Bug# 13809564
7433: AND cle.sts_code <> 'ABANDONED'

Line 7447: FROM okc_line_styles_b adon_lse

7443: AND cpl.dnz_chr_id = p_khr_id
7444: AND cpl.chr_id IS NULL
7445: AND cpl.rle_code = 'OKL_VENDOR'
7446: AND EXISTS(SELECT NULL
7447: FROM okc_line_styles_b adon_lse
7448: WHERE adon_lse.ID = cle.lse_id
7449: AND adon_lse.lty_code = 'ADD_ITEM'
7450: AND EXISTS(SELECT NULL
7451: FROM okc_k_lines_b mdl_parent

Line 7511: okc_line_styles_b model_lse

7507: and exists (
7508: SELECT 1
7509: FROM okc_k_party_roles_b cpl,
7510: okc_k_lines_b cle,
7511: okc_line_styles_b model_lse
7512: WHERE cpl.rle_code = 'OKL_VENDOR'
7513: AND cpl.chr_id IS NULL
7514: and model_lse.ID = cle.lse_id
7515: and model_lse.lty_code = 'ITEM'

Line 8693: okc_line_styles_b ls,

8689: cle.id,
8690: nvl(cle.start_date,k.start_date)
8691: from OKL_K_LINES_FULL_V cle,
8692: okc_k_party_roles_b cpl,
8693: okc_line_styles_b ls,
8694: okc_k_headers_b k
8695: where k.id = cle.dnz_chr_id
8696: and cle.dnz_chr_id = p_contract_id
8697: and cle.lse_id = ls.id

Line 9419: FROM okc_line_styles_b model_lse

9415: AND cpl.dnz_chr_id = p_khr_id
9416: AND cpl.chr_id IS NULL
9417: AND cpl.rle_code = 'OKL_VENDOR'
9418: AND EXISTS(SELECT NULL
9419: FROM okc_line_styles_b model_lse
9420: WHERE model_lse.ID = cle.lse_id
9421: AND model_lse.lty_code = 'ITEM')
9422: --Bug# 13809564
9423: AND cle.sts_code <> 'ABANDONED'

Line 9437: FROM okc_line_styles_b adon_lse

9433: AND cpl.dnz_chr_id = p_khr_id
9434: AND cpl.chr_id IS NULL
9435: AND cpl.rle_code = 'OKL_VENDOR'
9436: AND EXISTS(SELECT NULL
9437: FROM okc_line_styles_b adon_lse
9438: WHERE adon_lse.ID = cle.lse_id
9439: AND adon_lse.lty_code = 'ADD_ITEM'
9440: AND EXISTS(SELECT NULL
9441: FROM okc_k_lines_b mdl_parent

Line 9483: --okc_line_styles_b model_lse

9479: --and exists (
9480: --SELECT 1
9481: --FROM okc_k_party_roles_b cpl,
9482: --okc_k_lines_b cle,
9483: --okc_line_styles_b model_lse
9484: --WHERE cpl.rle_code = 'OKL_VENDOR'
9485: --AND cpl.chr_id IS NULL
9486: --and model_lse.ID = cle.lse_id
9487: --and model_lse.lty_code = 'ITEM'