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 590: p_kle_id OKC_K_LINES_V.ID%TYPE,

586:
587:
588: -- Bug# 2857333
589: CURSOR orig_strm_csr (p_khr_id OKC_K_HEADERS_V.ID%TYPE,
590: p_kle_id OKC_K_LINES_V.ID%TYPE,
591: p_sty_id OKL_STREAMS.sty_id%TYPE,
592: p_purpose_code OKL_STREAMS.PURPOSE_CODE%TYPE) IS
593: SELECT id
594: FROM okl_streams

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

1934: FROM okc_rule_groups_v
1935: WHERE dnz_chr_id = p_chr_id
1936: AND rgd_code = 'LALEVL';
1937:
1938: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1939: SELECT orig_system_id1
1940: FROM okc_k_lines_v
1941: WHERE id = p_cle_id;
1942:

Line 1940: FROM okc_k_lines_v

1936: AND rgd_code = 'LALEVL';
1937:
1938: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1939: SELECT orig_system_id1
1940: FROM okc_k_lines_v
1941: WHERE id = p_cle_id;
1942:
1943: CURSOR orig_rgp_csr(p_cle_id OKC_K_LINES_V.ID%TYPE,
1944: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

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

1939: SELECT orig_system_id1
1940: FROM okc_k_lines_v
1941: WHERE id = p_cle_id;
1942:
1943: CURSOR orig_rgp_csr(p_cle_id OKC_K_LINES_V.ID%TYPE,
1944: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1945: SELECT id
1946: FROM okc_rule_groups_v
1947: WHERE dnz_chr_id = p_chr_id

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

3293: AND line.dnz_chr_id = p_chr_id
3294: AND line.lse_id = style.id
3295: AND line.fee_type = 'GENERAL';
3296:
3297: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
3298: SELECT id
3299: FROM okc_k_lines_v
3300: WHERE cle_id = p_cle_id
3301: AND sts_code = 'BOOKED';

Line 3299: FROM okc_k_lines_v

3295: AND line.fee_type = 'GENERAL';
3296:
3297: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
3298: SELECT id
3299: FROM okc_k_lines_v
3300: WHERE cle_id = p_cle_id
3301: AND sts_code = 'BOOKED';
3302:
3303: CURSOR rbk_new_fee_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

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

3310: AND line.orig_system_id1 IS NULL
3311: --Bug# 8766336
3312: AND line.sts_code <> 'ABANDONED';
3313:
3314: CURSOR orig_fee_strm_csr (p_kle_id OKC_K_LINES_V.ID%TYPE) IS
3315: SELECT id
3316: FROM okl_streams
3317: WHERE kle_id = p_kle_id
3318: AND say_code <> 'HIST';

Line 3541: okc_k_lines_v okc_fin

3537: FROM okc_k_lines_b okc_cov_ast,
3538: okl_k_lines okl,
3539: okc_line_styles_b style,
3540: okc_k_items item,
3541: okc_k_lines_v okc_fin
3542: WHERE okc_cov_ast.cle_id = p_top_line_id
3543: AND okc_cov_ast.dnz_chr_id = p_chr_id
3544: AND okc_cov_ast.id = okl.id
3545: AND okc_cov_ast.id = item.cle_id

Line 3561: FROM okc_k_lines_v okc,

3557: p_chr_id NUMBER) IS
3558: SELECT okc.orig_system_id1, okc.id line_id, okc.name, okc.item_description,
3559: okl.capital_amount,
3560: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3561: FROM okc_k_lines_v okc,
3562: okl_k_lines okl,
3563: okc_line_styles_b style,
3564: okc_k_items item
3565: WHERE okc.id = p_sub_line_id

Line 4378: FROM okc_k_lines_v okc

4374: ,okl.attribute12
4375: ,okl.attribute13
4376: ,okl.attribute14
4377: ,okl.attribute15
4378: FROM okc_k_lines_v okc
4379: ,okl_k_lines okl
4380: ,okc_k_items item
4381: ,okc_line_styles_b style
4382: WHERE okc.id = okl.id

Line 4431: FROM okc_k_lines_v okc,

4427: okl.attribute12,
4428: okl.attribute13,
4429: okl.attribute14,
4430: okl.attribute15
4431: FROM okc_k_lines_v okc,
4432: okl_k_lines okl,
4433: okc_k_items item,
4434: okc_line_styles_b style
4435: WHERE okc.id = okl.id

Line 4457: okc_k_lines_v okc_fin

4453: FROM okc_k_lines_b okc_cov_ast,
4454: okl_k_lines okl,
4455: okc_line_styles_b style,
4456: okc_k_items item,
4457: okc_k_lines_v okc_fin
4458: WHERE okc_cov_ast.cle_id = p_top_line_id
4459: AND okc_cov_ast.dnz_chr_id = p_chr_id
4460: AND okc_cov_ast.id = okl.id
4461: AND okc_cov_ast.id = item.cle_id

Line 4476: FROM okc_k_lines_v okc,

4472: p_chr_id NUMBER) IS
4473: SELECT okc.orig_system_id1, okc.id line_id, okc.name, okc.item_description,
4474: okl.capital_amount,
4475: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
4476: FROM okc_k_lines_v okc,
4477: okl_k_lines okl,
4478: okc_line_styles_b style,
4479: okc_k_items item
4480: WHERE okc.id = p_sub_line_id

Line 5653: x_cle_id OKC_K_LINES_V.ID%TYPE;

5649: x_klev_tbl klev_tbl_type;
5650:
5651: l_new_klev_tbl klev_tbl_type;
5652: lx_new_klev_tbl klev_tbl_type;
5653: x_cle_id OKC_K_LINES_V.ID%TYPE;
5654: i NUMBER := 0;
5655: j NUMBER := 0;
5656: k NUMBER := 0;
5657: m NUMBER := 0;

Line 8144: x_cle_id OKC_K_LINES_V.ID%TYPE;

8140: l_khrv_rec khrv_rec_type;
8141: x_khrv_rec khrv_rec_type;
8142: l_chrv_rec chrv_rec_type;
8143: x_chrv_rec chrv_rec_type;
8144: x_cle_id OKC_K_LINES_V.ID%TYPE;
8145: l_from_cle_id_tbl okl_kle_pvt.klev_tbl_type;
8146: x_cle_id_tbl okl_kle_pvt.klev_tbl_type;
8147: i NUMBER := 1;
8148:

Line 8163: FROM okc_k_lines_v

8159: --end:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
8160:
8161: CURSOR top_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
8162: SELECT id
8163: FROM okc_k_lines_v
8164: WHERE chr_id = p_chr_id;
8165: --AND lse_id = 33; -- ??? Temporary , Fin Asset Line Only
8166:
8167: l_orig_chr_id NUMBER;