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 OKL_K_LINES

Line 2937: okl_k_lines okl

2933:
2934: CURSOR pth_csr (p_chr_id NUMBER) IS
2935: SELECT okc.id, okc.orig_system_id1, okc.lse_id
2936: FROM okc_k_lines_b okc,
2937: okl_k_lines okl
2938: WHERE dnz_chr_id = p_chr_id
2939: AND lse_id = 52 -- FEE top line
2940: AND okl.fee_type = 'PASSTHROUGH'
2941: AND okc.id = okl.id

Line 3289: FROM okl_k_Lines_full_v line,

3285: ) IS
3286:
3287: CURSOR fee_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3288: SELECT line.*
3289: FROM okl_k_Lines_full_v line,
3290: okc_line_styles_v style
3291: WHERE line.sts_code = 'BOOKED'
3292: AND style.lty_code = 'FEE'
3293: AND line.dnz_chr_id = p_chr_id

Line 3305: FROM okl_k_Lines_full_v line,

3301: AND sts_code = 'BOOKED';
3302:
3303: CURSOR rbk_new_fee_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3304: SELECT line.*
3305: FROM okl_k_Lines_full_v line,
3306: okc_line_styles_v style
3307: WHERE style.lty_code = 'FEE'
3308: AND line.dnz_chr_id = p_chr_id
3309: AND line.lse_id = style.id

Line 3417: ,okl_k_lines okl

3413: ,okl.attribute15
3414: -- Bug 12938353: RGOOTY: Income Fee Enhancement
3415: ,okl.origination_income
3416: FROM okc_k_lines_b okc
3417: ,okl_k_lines okl
3418: ,okc_k_items item
3419: ,okc_line_styles_b style
3420: --,okc_k_party_roles_b partyb -- change added for Rebook Change Control Enhancement
3421: WHERE okc.id = okl.id

Line 3476: okl_k_lines okl,

3472: okl.attribute15,
3473: -- Bug 12938353: RGOOTY: Income Fee Enhancement
3474: okl.origination_income
3475: FROM okc_k_lines_b okc,
3476: okl_k_lines okl,
3477: okc_k_items item,
3478: okc_line_styles_b style
3479: --okc_k_party_roles_b partyb
3480: WHERE okc.id = okl.id

Line 3538: okl_k_lines okl,

3534: SELECT okc_cov_ast.orig_system_id1, okc_cov_ast.id line_id, okc_fin.name, SUBSTR(okc_fin.item_description,1,200) item_description,
3535: okl.capital_amount, okl.amount,
3536: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
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

Line 3562: okl_k_lines okl,

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
3566: AND okc.dnz_chr_id = p_chr_id

Line 4379: ,okl_k_lines okl

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
4383: AND okc.id = item.cle_id

Line 4432: okl_k_lines okl,

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
4436: AND okc.id = item.cle_id

Line 4454: okl_k_lines okl,

4450: SELECT okc_cov_ast.orig_system_id1, okc_cov_ast.id line_id, okc_fin.name, SUBSTR(okc_fin.item_description,1,200) item_description,
4451: okl.capital_amount, okl.amount,
4452: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
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

Line 4477: okl_k_lines okl,

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
4481: AND okc.dnz_chr_id = p_chr_id

Line 5539: FROM okl_k_lines_full_v

5535:
5536: -- Sync only Financial Asset and child lines
5537: CURSOR rebook_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5538: SELECT *
5539: FROM okl_k_lines_full_v
5540: WHERE dnz_chr_id = p_chr_id
5541: AND orig_system_id1 IS NOT NULL
5542: AND lse_id in (33,34,42,43,44,45,70)
5543: --Bug# 8766336

Line 5548: FROM okl_k_lines_full_v line,

5544: AND sts_code <> 'ABANDONED';
5545:
5546: CURSOR rebook_new_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5547: SELECT line.*
5548: FROM okl_k_lines_full_v line,
5549: okc_line_styles_v style
5550: WHERE line.dnz_chr_id = p_chr_id
5551: AND line.lse_id = style.id
5552: AND style.lty_code = 'FREE_FORM1'

Line 5562: FROM okl_k_lines_full_v line,

5558: CURSOR rebook_new_ib_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5559: SELECT line.*,
5560: parent_cle.orig_system_id1 parent_orig_system_id1,
5561: parent_cle.start_date parent_orig_start_date
5562: FROM okl_k_lines_full_v line,
5563: okc_line_styles_v style,
5564: okc_k_lines_b parent_cle
5565: WHERE line.dnz_chr_id = p_chr_id
5566: AND line.lse_id = style.id

Line 5671: FROM okl_k_lines_full_v line,

5667: CURSOR rebook_new_addon_line_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5668: SELECT line.*,
5669: parent_cle.orig_system_id1 parent_orig_system_id1,
5670: parent_cle.start_date parent_orig_start_date
5671: FROM okl_k_lines_full_v line,
5672: okc_line_styles_v style,
5673: okc_k_lines_b parent_cle
5674: WHERE line.dnz_chr_id = p_chr_id
5675: AND line.lse_id = style.id