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_B

Line 579: CURSOR orig_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS

575: SELECT *
576: FROM okl_strm_elements
577: WHERE stm_id = p_stm_id;
578:
579: CURSOR orig_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
580: SELECT orig_system_id1
581: FROM okc_k_lines_b
582: WHERE id = p_line_id;
583:

Line 581: FROM okc_k_lines_b

577: WHERE stm_id = p_stm_id;
578:
579: CURSOR orig_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
580: SELECT orig_system_id1
581: FROM okc_k_lines_b
582: WHERE id = p_line_id;
583:
584: CURSOR new_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
585: SELECT id

Line 584: CURSOR new_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS

580: SELECT orig_system_id1
581: FROM okc_k_lines_b
582: WHERE id = p_line_id;
583:
584: CURSOR new_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
585: SELECT id
586: FROM okc_k_lines_b
587: WHERE orig_system_id1 = p_line_id;
588:

Line 586: FROM okc_k_lines_b

582: WHERE id = p_line_id;
583:
584: CURSOR new_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
585: SELECT id
586: FROM okc_k_lines_b
587: WHERE orig_system_id1 = p_line_id;
588:
589: CURSOR unbill_adj_csr( khrId NUMBER,
590: kleid NUMBER ) IS

Line 632: l_orig_line_id OKC_K_LINES_B.ID%TYPE;

628: FROM okl_strm_type_v
629: WHERE id = p_sty_id;
630: */
631:
632: l_orig_line_id OKC_K_LINES_B.ID%TYPE;
633:
634: l_orig_strm_tbl stmv_tbl_type;
635: x_orig_strm_tbl stmv_tbl_type;
636:

Line 653: okc_k_lines_b cle,

649: SELECT orig_stm.id orig_stm_id,
650: sty.stream_type_purpose,
651: cle.lse_id
652: FROM okl_streams orig_stm,
653: okc_k_lines_b cle,
654: okl_strm_type_v sty
655: WHERE orig_stm.khr_id = p_orig_chr_id
656: AND orig_stm.say_code = 'CURR'
657: --AND orig_stm.sgn_code <> 'INTC' -- bug 4737555

Line 3183: FROM okc_k_lines_b okc,

3179: pth_failed EXCEPTION;
3180:
3181: CURSOR pth_csr (p_chr_id NUMBER) IS
3182: SELECT okc.id, okc.orig_system_id1, okc.lse_id
3183: FROM okc_k_lines_b okc,
3184: okl_k_lines okl
3185: WHERE dnz_chr_id = p_chr_id
3186: AND lse_id = 52 -- FEE top line
3187: AND okl.fee_type = 'PASSTHROUGH'

Line 3194: FROM okc_k_lines_b okc

3190: --Bug# 4959361
3191: AND okc.sts_code <> 'TERMINATED'
3192: UNION -- Service line
3193: SELECT okc.id, okc.orig_system_id1, okc.lse_id
3194: FROM okc_k_lines_b okc
3195: WHERE dnz_chr_id = p_chr_id
3196: AND lse_id = 48 -- SERVICE top line
3197: AND okc.orig_system_id1 IS NOT NULL -- only old lines
3198: --Bug# 4959361

Line 3202: FROM okc_k_lines_b okc

3198: --Bug# 4959361
3199: AND okc.sts_code <> 'TERMINATED'
3200: UNION -- Asset line
3201: SELECT okc.id, okc.orig_system_id1, okc.lse_id
3202: FROM okc_k_lines_b okc
3203: WHERE dnz_chr_id = p_chr_id
3204: AND lse_id = 33 -- Fin. Asset top line
3205: AND okc.orig_system_id1 IS NOT NULL -- only old lines
3206: --Bug# 4959361

Line 3604: l_cle_id OKC_K_LINES_B.ID%TYPE;

3600:
3601: l_cplv_rec cplv_rec_type;
3602: x_cplv_rec cplv_rec_type;
3603:
3604: l_cle_id OKC_K_LINES_B.ID%TYPE;
3605: l_trx_date okl_trx_contracts.date_transaction_occurred%TYPE;
3606:
3607: l_rgpv_rec rgpv_rec_type;
3608: x_rgpv_rec rgpv_rec_type;

Line 3659: FROM okc_k_lines_b okc

3655: ,okl.attribute12
3656: ,okl.attribute13
3657: ,okl.attribute14
3658: ,okl.attribute15
3659: FROM okc_k_lines_b okc
3660: ,okl_k_lines okl
3661: ,okc_k_items item
3662: ,okc_line_styles_b style
3663: --,okc_k_party_roles_b partyb -- change added for Rebook Change Control Enhancement

Line 3682: CURSOR c_fee_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS

3678: --AND partyb.cle_id (+) = okc.id; -- change added for Rebook Change Control Enhancement
3679:
3680: -- get fee top line info and optional supplier info from the original contract
3681: -- cursor added as part of rebook change control enhancement
3682: CURSOR c_fee_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS
3683: SELECT okc.id,
3684: item.id item_id,
3685: item.object1_id1,
3686: item.object1_id2,

Line 3716: FROM okc_k_lines_b okc,

3712: okl.attribute12,
3713: okl.attribute13,
3714: okl.attribute14,
3715: okl.attribute15
3716: FROM okc_k_lines_b okc,
3717: okl_k_lines okl,
3718: okc_k_items item,
3719: okc_line_styles_b style
3720: --okc_k_party_roles_b partyb

Line 3778: FROM okc_k_lines_b okc_cov_ast,

3774: p_chr_id NUMBER) IS
3775: 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,
3776: okl.capital_amount, okl.amount,
3777: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
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

Line 3826: from okc_k_lines_b origl,

3822: p_rbk_chr_id NUMBER) IS
3823: select origl.id orig_link_fee_id,
3824: origk.id orig_link_fee_item_id,
3825: origp.id orig_parent_fee_id
3826: from okc_k_lines_b origl,
3827: okc_k_lines_b origp,
3828: okc_k_items_v origk
3829: where origl.dnz_chr_id = p_orig_chr_id
3830: and origl.lse_id = 53 -- LINK_FEE_ASSET

Line 3827: okc_k_lines_b origp,

3823: select origl.id orig_link_fee_id,
3824: origk.id orig_link_fee_item_id,
3825: origp.id orig_parent_fee_id
3826: from okc_k_lines_b origl,
3827: okc_k_lines_b origp,
3828: okc_k_items_v origk
3829: where origl.dnz_chr_id = p_orig_chr_id
3830: and origl.lse_id = 53 -- LINK_FEE_ASSET
3831: and origl.cle_id = origp.id

Line 3839: from okc_k_lines_b rbkl

3835: and origl.id = origk.cle_id
3836: and origk.jtot_object1_code = 'OKX_COVASST'
3837: and not exists (
3838: select 'Y'
3839: from okc_k_lines_b rbkl
3840: where to_char(origl.id) = rbkl.orig_system_id1
3841: and rbkl.dnz_chr_id = p_rbk_chr_id
3842: );
3843:

Line 3880: FROM okc_k_lines_b okc,

3876: okl.attribute12,
3877: okl.attribute13,
3878: okl.attribute14,
3879: okl.attribute15
3880: FROM okc_k_lines_b okc,
3881: okl_k_lines okl,
3882: okc_line_styles_b style
3883: WHERE okc.id = okl.id
3884: AND okc.dnz_chr_id = p_rbk_chr_id

Line 4675: okc_k_lines_b parent_cle

4671: parent_cle.orig_system_id1 parent_orig_system_id1,
4672: parent_cle.start_date parent_orig_start_date
4673: FROM okl_k_lines_full_v line,
4674: okc_line_styles_v style,
4675: okc_k_lines_b parent_cle
4676: WHERE line.dnz_chr_id = p_chr_id
4677: AND line.lse_id = style.id
4678: AND style.lty_code = 'FREE_FORM2'
4679: AND line.orig_system_id1 IS NULL

Line 4698: FROM okc_k_lines_b

4694:
4695: CURSOR rebook_new_all_line_csr (p_top_line_id NUMBER) IS
4696: SELECT id,
4697: start_date
4698: FROM okc_k_lines_b
4699: CONNECT BY PRIOR id = cle_id
4700: START WITH id = p_top_line_id;
4701: --Bug# 5362977 start
4702: --Bug# 5207066 - bug start

Line 4712: okc_k_lines_b cle

4708: cim.object1_id2,
4709: cim.jtot_object1_code,
4710: cle.lse_id
4711: FROM okc_k_items cim,
4712: okc_k_lines_b cle
4713: WHERE cim.cle_id = cle.id
4714: AND cle.id = p_cle_id;
4715: l_items_rec items_csr%ROWTYPE;
4716: l_items_old_rec items_csr%ROWTYPE;

Line 6774: okc_k_lines_b cle,

6770: p_rbk_khr_id IN NUMBER,
6771: p_orig_khr_id IN NUMBER) IS
6772: SELECT orig_stm.id orig_stm_id
6773: FROM okl_streams new_stm,
6774: okc_k_lines_b cle,
6775: okl_streams orig_stm
6776: WHERE new_stm.id = p_new_stm_id
6777: AND cle.id = new_stm.kle_id
6778: AND cle.dnz_chr_id = p_rbk_khr_id

Line 7099: okc_k_lines_b cle,

7095: orig_stm.kle_id,
7096: cle.lse_id
7097: FROM okl_streams orig_stm,
7098: okl_strm_type_b sty,
7099: okc_k_lines_b cle,
7100: okl_party_payment_hdr pph
7101: WHERE orig_stm.khr_id = p_orig_khr_id
7102: AND orig_stm.say_code = 'CURR'
7103: AND orig_stm.sty_id = sty.id

Line 7451: okc_k_lines_b cle

7447: orig_stm.kle_id,
7448: cle.lse_id
7449: FROM okl_streams orig_stm,
7450: okl_strm_type_b sty,
7451: okc_k_lines_b cle
7452: WHERE orig_stm.khr_id = p_orig_khr_id
7453: AND orig_stm.say_code = 'CURR'
7454: AND orig_stm.sty_id = sty.id
7455: AND orig_stm.sgn_code NOT IN ('INTC','LATE_CALC') -- Bug 6472228

Line 7851: okc_k_lines_b cle,

7847: cle.lse_id
7848: FROM okl_streams orig_stm,
7849: okl_prod_strm_types psty,
7850: okl_k_headers khr,
7851: okc_k_lines_b cle,
7852: okl_strm_type_tl styt
7853: WHERE khr.id = p_orig_khr_id
7854: AND psty.pdt_id = khr.pdt_id
7855: AND psty.accrual_yn = 'Y'

Line 8212: okc_k_lines_b cle,

8208: --FROM okl_streams orig_stm,
8209: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041
8210: okl_prod_strm_types psty,
8211: okl_k_headers khr,
8212: okc_k_lines_b cle,
8213: okl_strm_type_v sty
8214: WHERE khr.id = p_orig_khr_id
8215: --AND psty.pdt_id = khr.pdt_id
8216: AND psty.pdt_id = DECODE(OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY,

Line 8555: FROM okc_k_lines_b cle

8551: l_api_version CONSTANT NUMBER := 1;
8552:
8553: CURSOR chr_assets_csr(p_khr_id IN NUMBER) IS
8554: SELECT id cle_id
8555: FROM okc_k_lines_b cle
8556: WHERE cle.chr_id = p_khr_id
8557: AND cle.dnz_chr_id = p_khr_id
8558: AND cle.lse_id = 33;
8559: