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_ITEMS

Line 2371: okc_k_items cim_cov_asset,

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

Line 2651: okc_k_items cim_cov_asset,

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

Line 7252: FROM okc_k_items cim,

7248: p_kle_id NUMBER,
7249: p_vendor_id NUMBER
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

Line 7300: FROM okc_k_items cim,

7296: )
7297: -- end: okl.h: cklee -- add vendor_id as a parameter
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

Line 7348: FROM okc_k_items cim,

7344: p_khr_id NUMBER,
7345: p_kle_id NUMBER
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

Line 7415: FROM okc_k_items cim,

7411: CURSOR c_no_line_and_vendor(
7412: p_khr_id NUMBER
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

Line 9385: FROM okc_k_items cim,

9381: CURSOR c_rel_asset_amt (
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

Line 9405: FROM okc_k_items cim,

9401: CURSOR c_no_line_and_vendor(
9402: p_khr_id NUMBER
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