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_CONTRACT_REBOOK_PVT dependencies on OKC_K_LINES_V

Line 561: p_kle_id OKC_K_LINES_V.ID%TYPE,

557:
558:
559: -- Bug# 2857333
560: CURSOR orig_strm_csr (p_khr_id OKC_K_HEADERS_V.ID%TYPE,
561: p_kle_id OKC_K_LINES_V.ID%TYPE,
562: p_sty_id OKL_STREAMS.sty_id%TYPE,
563: p_purpose_code OKL_STREAMS.PURPOSE_CODE%TYPE) IS
564: SELECT id
565: FROM okl_streams

Line 1909: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS

1905: FROM okc_rule_groups_v
1906: WHERE dnz_chr_id = p_chr_id
1907: AND rgd_code = 'LALEVL';
1908:
1909: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1910: SELECT orig_system_id1
1911: FROM okc_k_lines_v
1912: WHERE id = p_cle_id;
1913:

Line 1911: FROM okc_k_lines_v

1907: AND rgd_code = 'LALEVL';
1908:
1909: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1910: SELECT orig_system_id1
1911: FROM okc_k_lines_v
1912: WHERE id = p_cle_id;
1913:
1914: CURSOR orig_rgp_csr(p_cle_id OKC_K_LINES_V.ID%TYPE,
1915: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 1914: CURSOR orig_rgp_csr(p_cle_id OKC_K_LINES_V.ID%TYPE,

1910: SELECT orig_system_id1
1911: FROM okc_k_lines_v
1912: WHERE id = p_cle_id;
1913:
1914: CURSOR orig_rgp_csr(p_cle_id OKC_K_LINES_V.ID%TYPE,
1915: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1916: SELECT id
1917: FROM okc_rule_groups_v
1918: WHERE dnz_chr_id = p_chr_id

Line 3544: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS

3540: AND line.dnz_chr_id = p_chr_id
3541: AND line.lse_id = style.id
3542: AND line.fee_type = 'GENERAL';
3543:
3544: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
3545: SELECT id
3546: FROM okc_k_lines_v
3547: WHERE cle_id = p_cle_id
3548: AND sts_code = 'BOOKED';

Line 3546: FROM okc_k_lines_v

3542: AND line.fee_type = 'GENERAL';
3543:
3544: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
3545: SELECT id
3546: FROM okc_k_lines_v
3547: WHERE cle_id = p_cle_id
3548: AND sts_code = 'BOOKED';
3549:
3550: CURSOR rbk_new_fee_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 3559: CURSOR orig_fee_strm_csr (p_kle_id OKC_K_LINES_V.ID%TYPE) IS

3555: AND line.dnz_chr_id = p_chr_id
3556: AND line.lse_id = style.id
3557: AND line.orig_system_id1 IS NULL;
3558:
3559: CURSOR orig_fee_strm_csr (p_kle_id OKC_K_LINES_V.ID%TYPE) IS
3560: SELECT id
3561: FROM okl_streams
3562: WHERE kle_id = p_kle_id
3563: AND say_code <> 'HIST';

Line 3782: okc_k_lines_v okc_fin

3778: FROM okc_k_lines_b okc_cov_ast,
3779: okl_k_lines okl,
3780: okc_line_styles_b style,
3781: okc_k_items item,
3782: okc_k_lines_v okc_fin
3783: WHERE okc_cov_ast.cle_id = p_top_line_id
3784: AND okc_cov_ast.dnz_chr_id = p_chr_id
3785: AND okc_cov_ast.id = okl.id
3786: AND okc_cov_ast.id = item.cle_id

Line 3801: FROM okc_k_lines_v okc,

3797: p_chr_id NUMBER) IS
3798: SELECT okc.orig_system_id1, okc.id line_id, okc.name, okc.item_description,
3799: okl.capital_amount,
3800: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3801: FROM okc_k_lines_v okc,
3802: okl_k_lines okl,
3803: okc_line_styles_b style,
3804: okc_k_items item
3805: WHERE okc.id = p_sub_line_id

Line 4762: x_cle_id OKC_K_LINES_V.ID%TYPE;

4758: x_klev_tbl klev_tbl_type;
4759:
4760: l_new_klev_tbl klev_tbl_type;
4761: lx_new_klev_tbl klev_tbl_type;
4762: x_cle_id OKC_K_LINES_V.ID%TYPE;
4763: i NUMBER := 0;
4764: j NUMBER := 0;
4765: k NUMBER := 0;
4766: m NUMBER := 0;

Line 6475: x_cle_id OKC_K_LINES_V.ID%TYPE;

6471: l_khrv_rec khrv_rec_type;
6472: x_khrv_rec khrv_rec_type;
6473: l_chrv_rec chrv_rec_type;
6474: x_chrv_rec chrv_rec_type;
6475: x_cle_id OKC_K_LINES_V.ID%TYPE;
6476: l_from_cle_id_tbl okl_kle_pvt.klev_tbl_type;
6477: x_cle_id_tbl okl_kle_pvt.klev_tbl_type;
6478: i NUMBER := 1;
6479:

Line 6494: FROM okc_k_lines_v

6490: --end:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6491:
6492: CURSOR top_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6493: SELECT id
6494: FROM okc_k_lines_v
6495: WHERE chr_id = p_chr_id;
6496: --AND lse_id = 33; -- ??? Temporary , Fin Asset Line Only
6497:
6498: l_orig_chr_id NUMBER;