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 OKL_K_LINES

Line 2336: from OKL_K_LINES_FULL_V cle,

2332: IS
2333: select nvl(cle.AMOUNT,0),
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

Line 2370: okl_k_lines_full_v kle_cov_asset,

2366: CURSOR c_new_lin_amt (p_contract_id NUMBER,p_cle_id VARCHAR2)
2367: IS
2368: SELECT SUM(NVL(kle_cov_asset.capital_amount,0)) amount
2369: FROM okc_k_lines_b cleb_cov_asset,
2370: okl_k_lines_full_v kle_cov_asset,
2371: okc_k_items cim_cov_asset,
2372: okc_k_lines_b cleb_fin,
2373: okc_statuses_b sts,
2374: okl_k_lines kle

Line 2374: okl_k_lines kle

2370: okl_k_lines_full_v kle_cov_asset,
2371: okc_k_items cim_cov_asset,
2372: okc_k_lines_b cleb_fin,
2373: okc_statuses_b sts,
2374: okl_k_lines kle
2375: WHERE kle_cov_asset.id = cleb_cov_asset.id
2376: AND cim_cov_asset.cle_id = cleb_cov_asset.id
2377: AND cim_cov_asset.dnz_chr_id = cleb_cov_asset.dnz_chr_id
2378: AND cim_cov_asset.jtot_object1_code = 'OKX_COVASST'

Line 2412: OKL_K_LINES_FULL_V cle,

2408: --cklee end 10/3/2007 bug: 6128765
2409:
2410: from okc_rule_groups_v crg,
2411: okc_rules_v cr,
2412: OKL_K_LINES_FULL_V cle,
2413: okc_k_headers_b k
2414: where crg.dnz_chr_id = p_contract_id
2415: and cle.dnz_chr_id = k.id
2416: and crg.id = cr.rgp_id

Line 2615: from OKL_K_LINES_FULL_V cle,

2611: IS
2612: select nvl(cle.AMOUNT,0),
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

Line 2650: okl_k_lines_full_v kle_cov_asset,

2646: CURSOR c_new_lin_amt (p_contract_id NUMBER, p_cle_id VARCHAR2)
2647: IS
2648: SELECT SUM(NVL(kle_cov_asset.capital_amount,0)) amount
2649: FROM okc_k_lines_b cleb_cov_asset,
2650: okl_k_lines_full_v kle_cov_asset,
2651: okc_k_items cim_cov_asset,
2652: okc_k_lines_b cleb_fin,
2653: okc_statuses_b sts,
2654: okl_k_lines kle

Line 2654: okl_k_lines kle

2650: okl_k_lines_full_v kle_cov_asset,
2651: okc_k_items cim_cov_asset,
2652: okc_k_lines_b cleb_fin,
2653: okc_statuses_b sts,
2654: okl_k_lines kle
2655: WHERE kle_cov_asset.id = cleb_cov_asset.id
2656: AND cim_cov_asset.cle_id = cleb_cov_asset.id
2657: AND cim_cov_asset.dnz_chr_id = cleb_cov_asset.dnz_chr_id
2658: AND cim_cov_asset.jtot_object1_code = 'OKX_COVASST'

Line 2692: OKL_K_LINES_FULL_V cle,

2688: , months_between(trunc(p_due_date), nvl(cle.start_date, k.start_date))))
2689: --cklee end 10/3/2007 bug: 6128765
2690: from okc_rule_groups_v crg,
2691: okc_rules_v cr,
2692: OKL_K_LINES_FULL_V cle,
2693: okc_k_headers_b k
2694: where crg.dnz_chr_id = p_contract_id
2695: and cle.dnz_chr_id = k.id
2696: and crg.id = cr.rgp_id

Line 2906: ,okl_k_lines kle

2902: --Start Modification 120.67.12010000.8 Pratrao 5-Feb-2013
2903: /*SELECT nvl(kle.re_lease_yn,'N')
2904: FROM OKC_K_HEADERS_B chr
2905: ,okc_k_lines_b cle
2906: ,okl_k_lines kle
2907: WHERE chr.id = cle.chr_id
2908: and chr.id = cle.dnz_chr_id
2909: and cle.id = kle.id
2910: and chr.id = p_contract_id;

Line 7256: okl_k_lines kle_top

7252: FROM okc_k_items cim,
7253: okc_k_party_roles_b cpl,
7254: okc_k_lines_b cle,
7255: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement
7256: okl_k_lines kle_top
7257: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7258: WHERE
7259: --for model lines of vendor
7260: (

Line 7282: --FROM okl_k_lines lkl

7278: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7279: ); -- end of model lines
7280: -- re lease flag check
7281: --AND EXISTS(SELECT NULL
7282: --FROM okl_k_lines lkl
7283: --WHERE lkl.ID = cle.ID AND lkl.re_lease_yn IS NULL);
7284:
7285:
7286:

Line 7304: okl_k_lines kle_top

7300: FROM okc_k_items cim,
7301: okc_k_party_roles_b cpl,
7302: okc_k_lines_b cle,
7303: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement
7304: okl_k_lines kle_top
7305: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7306: WHERE
7307: --for add on lines: don't care the vendor association, but care if it has vendor association!
7308: (

Line 7336: --FROM okl_k_lines lkl

7332: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7333: ); -- end of add on lines
7334: -- re lease flag check
7335: --AND EXISTS(SELECT NULL
7336: --FROM okl_k_lines lkl
7337: --WHERE lkl.ID = cle.ID AND lkl.re_lease_yn IS NULL);
7338:
7339: --
7340: --

Line 7352: okl_k_lines kle_top

7348: FROM okc_k_items cim,
7349: okc_k_party_roles_b cpl,
7350: okc_k_lines_b cle,
7351: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement
7352: okl_k_lines kle_top
7353: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7354: WHERE
7355: --for model lines of vendor
7356: (

Line 7404: -- FROM okl_k_lines lkl

7400: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7401: ); -- end of add on lines
7402: -- re lease flag check
7403: -- AND EXISTS(SELECT NULL
7404: -- FROM okl_k_lines lkl
7405: -- WHERE lkl.ID = cle.ID AND lkl.re_lease_yn IS NULL);
7406:
7407: --
7408: --

Line 7419: okl_k_lines kle_top

7415: FROM okc_k_items cim,
7416: okc_k_party_roles_b cpl,
7417: okc_k_lines_b cle,
7418: --Bug# 15992711 : avsingh - New-Released asset ER
7419: okl_k_lines kle_top
7420: --End Bug# 15992711 : New-Released asset ER
7421: WHERE (
7422: cim.cle_id = cle.ID
7423: AND cim.dnz_chr_id = p_khr_id

Line 7455: FROM okl_k_lines kle_top1

7451: FROM okc_k_lines_b mdl_parent
7452: WHERE mdl_parent.ID = cle.cle_id
7453: --Bug# 15992711 : avsingh - New-Released asset ER
7454: AND EXISTS(SELECT NULL
7455: FROM okl_k_lines kle_top1
7456: WHERE kle_top1.id = mdl_parent.cle_id
7457: AND nvl(kle_top1.re_lease_yn,'N') = 'N')))
7458: --End Bug# 15992711 : New-Released asset ER
7459: --Bug# 13809564

Line 7463: --FROM okl_k_lines lkl

7459: --Bug# 13809564
7460: AND cle.sts_code <> 'ABANDONED'
7461: );
7462: --AND EXISTS(SELECT NULL
7463: --FROM okl_k_lines lkl
7464: --WHERE lkl.ID = cle.ID
7465: --AND lkl.re_lease_yn IS NULL);
7466:
7467: --

Line 7473: FROM okl_k_lines

7469: CURSOR downpymnt_recvr_csr(
7470: p_kle_id NUMBER
7471: ) IS
7472: SELECT down_payment_receiver_code
7473: FROM okl_k_lines
7474: WHERE ID = p_kle_id;
7475:
7476: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;
7477: -- bug 5384359 -- end

Line 7476: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;

7472: SELECT down_payment_receiver_code
7473: FROM okl_k_lines
7474: WHERE ID = p_kle_id;
7475:
7476: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;
7477: -- bug 5384359 -- end
7478: --
7479:
7480: --start:| 08-Feb-08 cklee Fixed bug: 6783566 |

Line 7488: okl_k_lines kle_k

7484: ) IS
7485: SELECT kle.cle_id kle_id,
7486: kle_k.down_payment_receiver_code downpymnt_recvr
7487: FROM okl_assets_lov_uv kle,
7488: okl_k_lines kle_k
7489: WHERE kle.cle_id = kle_k.ID
7490: AND kle.chr_id = p_khr_id;
7491: */
7492: CURSOR c_kle_id(

Line 7497: FROM okl_k_lines kle_k,

7493: p_khr_id okc_k_headers_b.id%TYPE
7494: ) IS
7495: SELECT kle_k.id kle_id,
7496: kle_k.down_payment_receiver_code downpymnt_recvr
7497: FROM okl_k_lines kle_k,
7498: okc_k_lines_b kle
7499: where kle_k.id = kle.id
7500: and kle.dnz_chr_id = p_khr_id
7501: --Bug# 15992711 : avsingh - New-Released asset ER

Line 8691: from OKL_K_LINES_FULL_V cle,

8687: IS
8688: select nvl(cle.AMOUNT,0),
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

Line 8739: OKL_K_LINES_FULL_V cle,

8735: , 'S', months_between(p_effective_date, nvl(cle.start_date, k.start_date))/6
8736: , months_between(p_effective_date, nvl(cle.start_date, k.start_date))))
8737: from okc_rule_groups_v crg,
8738: okc_rules_v cr,
8739: OKL_K_LINES_FULL_V cle,
8740: okc_k_headers_b k
8741: where crg.dnz_chr_id = p_contract_id
8742: and cle.dnz_chr_id = k.id
8743: and crg.id = cr.rgp_id

Line 9387: okl_k_lines kle_top

9383: ) IS
9384: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
9385: FROM okc_k_items cim,
9386: okc_k_lines_b cle,
9387: okl_k_lines kle_top
9388: WHERE (
9389: cim.cle_id = cle.ID
9390: AND cim.dnz_chr_id = p_khr_id
9391: AND cim.jtot_object1_code = 'OKX_ASSET'

Line 9409: okl_k_lines kle_top

9405: FROM okc_k_items cim,
9406: okc_k_party_roles_b cpl,
9407: okc_k_lines_b cle,
9408: --Bug# 15992711 : avsingh - New-Released asset ER
9409: okl_k_lines kle_top
9410: --End Bug# 15992711 : New-Released asset ER
9411: WHERE (
9412: cim.cle_id = cle.ID
9413: AND cim.dnz_chr_id = p_khr_id

Line 9445: FROM okl_k_lines kle_top1

9441: FROM okc_k_lines_b mdl_parent
9442: WHERE mdl_parent.ID = cle.cle_id
9443: --Bug# 15992711 : avsingh - New-Released asset ER
9444: AND EXISTS(SELECT NULL
9445: FROM okl_k_lines kle_top1
9446: WHERE kle_top1.id = mdl_parent.cle_id
9447: AND nvl(kle_top1.re_lease_yn,'N') = 'Y')))
9448: --End Bug# 15992711 : New-Released asset ER
9449: --Bug# 13809564

Line 9459: FROM okl_k_lines

9455: CURSOR downpymnt_recvr_csr(
9456: p_kle_id NUMBER
9457: ) IS
9458: SELECT down_payment_receiver_code
9459: FROM okl_k_lines
9460: WHERE ID = p_kle_id;
9461:
9462: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;
9463:

Line 9462: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;

9458: SELECT down_payment_receiver_code
9459: FROM okl_k_lines
9460: WHERE ID = p_kle_id;
9461:
9462: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;
9463:
9464: CURSOR c_kle_id(
9465: p_khr_id okc_k_headers_b.id%TYPE
9466: ) IS

Line 9469: FROM okl_k_lines kle_k,

9465: p_khr_id okc_k_headers_b.id%TYPE
9466: ) IS
9467: SELECT kle_k.id kle_id,
9468: kle_k.down_payment_receiver_code downpymnt_recvr
9469: FROM okl_k_lines kle_k,
9470: okc_k_lines_b kle
9471: where kle_k.id = kle.id
9472: and kle.dnz_chr_id = p_khr_id
9473: --Bug# 15992711 : avsingh - New-Released asset ER