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_K_LINES_B

Line 2369: FROM okc_k_lines_b cleb_cov_asset,

2365: -- Added a new cursor to fetch amounts at line level
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,

Line 2372: okc_k_lines_b cleb_fin,

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
2375: WHERE kle_cov_asset.id = cleb_cov_asset.id
2376: AND cim_cov_asset.cle_id = cleb_cov_asset.id

Line 2649: FROM okc_k_lines_b cleb_cov_asset,

2645: -- Modifying the cursor to fetch fee related to new asset lines only
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,

Line 2652: okc_k_lines_b cleb_fin,

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
2655: WHERE kle_cov_asset.id = cleb_cov_asset.id
2656: AND cim_cov_asset.cle_id = cleb_cov_asset.id

Line 2905: ,okc_k_lines_b cle

2901: -- Cursor modified to include validation at asset line level
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

Line 6351: okc_k_lines_b LN,

6347: p_vendor_site_id
6348: ) kle_amt
6349: FROM okl_assets_lov_uv a,
6350: okc_k_party_roles_b cpl,
6351: okc_k_lines_b LN,
6352: okx_vendor_sites_v sites
6353: WHERE a.chr_id = p_khr_id
6354: AND cpl.rle_code = 'OKL_VENDOR'
6355: AND cpl.chr_id IS NULL

Line 7254: okc_k_lines_b cle,

7250: ) IS
7251: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
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

Line 7302: okc_k_lines_b cle,

7298: IS
7299: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
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

Line 7324: FROM okc_k_lines_b mdl_parent

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
7325: WHERE mdl_parent.ID = cle.cle_id AND mdl_parent.cle_id = p_kle_id))
7326: --Bug# 13809564
7327: AND cle.sts_code <> 'ABANDONED'
7328: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement

Line 7350: okc_k_lines_b cle,

7346: ) IS
7347: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
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

Line 7392: FROM okc_k_lines_b mdl_parent

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
7393: WHERE mdl_parent.ID = cle.cle_id AND mdl_parent.cle_id = p_kle_id))
7394: --Bug# 13809564
7395: AND cle.sts_code <> 'ABANDONED'
7396: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement

Line 7417: okc_k_lines_b cle,

7413: ) IS
7414: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
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 (

Line 7451: FROM okc_k_lines_b mdl_parent

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
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

Line 7498: okc_k_lines_b kle

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
7502: and nvl(kle_k.re_lease_yn,'N') = 'N' -- re lease flag check

Line 7510: okc_k_lines_b cle,

7506: -- only asset lines associated with Lease Vendor (Supplier Invoice)
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

Line 9386: okc_k_lines_b cle,

9382: p_khr_id NUMBER
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

Line 9407: okc_k_lines_b cle,

9403: ) IS
9404: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
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 (

Line 9441: FROM okc_k_lines_b mdl_parent

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
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

Line 9470: okc_k_lines_b kle

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
9474: and nvl(kle_k.re_lease_yn,'N') = 'Y' -- re lease flag check

Line 9482: --okc_k_lines_b cle,

9478: -- only asset lines associated with Lease Vendor (Supplier Invoice)
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