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_FULL_V

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