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 608: CURSOR orig_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS

604: SELECT *
605: FROM okl_strm_elements
606: WHERE stm_id = p_stm_id;
607:
608: CURSOR orig_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
609: SELECT orig_system_id1
610: FROM okc_k_lines_b
611: WHERE id = p_line_id;
612:

Line 610: FROM okc_k_lines_b

606: WHERE stm_id = p_stm_id;
607:
608: CURSOR orig_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
609: SELECT orig_system_id1
610: FROM okc_k_lines_b
611: WHERE id = p_line_id;
612:
613: CURSOR new_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
614: SELECT id

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

609: SELECT orig_system_id1
610: FROM okc_k_lines_b
611: WHERE id = p_line_id;
612:
613: CURSOR new_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
614: SELECT id
615: FROM okc_k_lines_b
616: WHERE orig_system_id1 = p_line_id;
617:

Line 615: FROM okc_k_lines_b

611: WHERE id = p_line_id;
612:
613: CURSOR new_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
614: SELECT id
615: FROM okc_k_lines_b
616: WHERE orig_system_id1 = p_line_id;
617:
618: CURSOR unbill_adj_csr( khrId NUMBER,
619: kleid NUMBER ) IS

Line 661: l_orig_line_id OKC_K_LINES_B.ID%TYPE;

657: FROM okl_strm_type_v
658: WHERE id = p_sty_id;
659: */
660:
661: l_orig_line_id OKC_K_LINES_B.ID%TYPE;
662:
663: l_orig_strm_tbl stmv_tbl_type;
664: x_orig_strm_tbl stmv_tbl_type;
665:

Line 682: okc_k_lines_b cle,

678: SELECT orig_stm.id orig_stm_id,
679: sty.stream_type_purpose,
680: cle.lse_id
681: FROM okl_streams orig_stm,
682: okc_k_lines_b cle,
683: okl_strm_type_v sty
684: WHERE orig_stm.khr_id = p_orig_chr_id
685: AND orig_stm.say_code = 'CURR'
686: --AND orig_stm.sgn_code <> 'INTC' -- bug 4737555

Line 2936: FROM okc_k_lines_b okc,

2932: pth_failed EXCEPTION;
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'

Line 2947: FROM okc_k_lines_b okc

2943: --Bug# 4959361
2944: AND okc.sts_code <> 'TERMINATED'
2945: UNION -- Service line
2946: SELECT okc.id, okc.orig_system_id1, okc.lse_id
2947: FROM okc_k_lines_b okc
2948: WHERE dnz_chr_id = p_chr_id
2949: AND lse_id = 48 -- SERVICE top line
2950: AND okc.orig_system_id1 IS NOT NULL -- only old lines
2951: --Bug# 4959361

Line 2955: FROM okc_k_lines_b okc

2951: --Bug# 4959361
2952: AND okc.sts_code <> 'TERMINATED'
2953: UNION -- Asset line
2954: SELECT okc.id, okc.orig_system_id1, okc.lse_id
2955: FROM okc_k_lines_b okc
2956: WHERE dnz_chr_id = p_chr_id
2957: AND lse_id = 33 -- Fin. Asset top line
2958: AND okc.orig_system_id1 IS NOT NULL -- only old lines
2959: --Bug# 4959361

Line 3359: l_cle_id OKC_K_LINES_B.ID%TYPE;

3355:
3356: l_cplv_rec cplv_rec_type;
3357: x_cplv_rec cplv_rec_type;
3358:
3359: l_cle_id OKC_K_LINES_B.ID%TYPE;
3360: l_trx_date okl_trx_contracts.date_transaction_occurred%TYPE;
3361:
3362: l_rgpv_rec rgpv_rec_type;
3363: x_rgpv_rec rgpv_rec_type;

Line 3416: FROM okc_k_lines_b okc

3412: ,okl.attribute14
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

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

3435: --AND partyb.cle_id (+) = okc.id; -- change added for Rebook Change Control Enhancement
3436:
3437: -- get fee top line info and optional supplier info from the original contract
3438: -- cursor added as part of rebook change control enhancement
3439: CURSOR c_fee_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS
3440: SELECT okc.id,
3441: item.id item_id,
3442: item.object1_id1,
3443: item.object1_id2,

Line 3475: FROM okc_k_lines_b okc,

3471: okl.attribute14,
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

Line 3537: FROM okc_k_lines_b okc_cov_ast,

3533: p_chr_id NUMBER) IS
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

Line 3586: from okc_k_lines_b origl,

3582: p_rbk_chr_id NUMBER) IS
3583: select origl.id orig_link_fee_id,
3584: origk.id orig_link_fee_item_id,
3585: origp.id orig_parent_fee_id
3586: from okc_k_lines_b origl,
3587: okc_k_lines_b origp,
3588: okc_k_items_v origk
3589: where origl.dnz_chr_id = p_orig_chr_id
3590: and origl.lse_id = 53 -- LINK_FEE_ASSET

Line 3587: okc_k_lines_b origp,

3583: select origl.id orig_link_fee_id,
3584: origk.id orig_link_fee_item_id,
3585: origp.id orig_parent_fee_id
3586: from okc_k_lines_b origl,
3587: okc_k_lines_b origp,
3588: okc_k_items_v origk
3589: where origl.dnz_chr_id = p_orig_chr_id
3590: and origl.lse_id = 53 -- LINK_FEE_ASSET
3591: and origl.cle_id = origp.id

Line 3599: from okc_k_lines_b rbkl

3595: and origl.id = origk.cle_id
3596: and origk.jtot_object1_code = 'OKX_COVASST'
3597: and not exists (
3598: select 'Y'
3599: from okc_k_lines_b rbkl
3600: where to_char(origl.id) = rbkl.orig_system_id1
3601: and rbkl.dnz_chr_id = p_rbk_chr_id
3602: );
3603:

Line 4321: FROM okc_k_lines_b line,

4317:
4318:
4319: CURSOR rbk_new_service_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4320: SELECT line.id
4321: FROM okc_k_lines_b line,
4322: okc_line_styles_b style
4323: WHERE style.lty_code = 'SOLD_SERVICE'
4324: AND line.dnz_chr_id = p_chr_id
4325: AND line.chr_id = p_chr_id

Line 4394: CURSOR c_service_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS

4390: AND style.lty_code = 'SOLD_SERVICE'
4391: AND okc.orig_system_id1 IS NOT NULL
4392: AND okc.sts_code <> 'TERMINATED';
4393:
4394: CURSOR c_service_orig_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cle_id okc_k_lines_b.id%TYPE) IS
4395: SELECT okc.id,
4396: okc.dnz_chr_id,
4397: okc.line_number,
4398: okc.exception_yn,

Line 4453: FROM okc_k_lines_b okc_cov_ast,

4449: p_chr_id NUMBER) IS
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

Line 4491: p_cle_id IN OKC_K_LINES_B.ID%TYPE) IS

4487: AND style.lty_code = 'LINK_SERV_ASSET';
4488:
4489: -- Bug#9689536 - Start
4490: CURSOR chk_expense_info (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
4491: p_cle_id IN OKC_K_LINES_B.ID%TYPE) IS
4492: SELECT 'Y'
4493: FROM OKC_RULE_GROUPS_B rgp,
4494: OKC_RULES_B rule
4495: WHERE rgp.id = rule.rgp_id

Line 5072: okc_k_lines_b cle

5068: p_rgd_code IN VARCHAR2,
5069: p_orig_cle_id IN NUMBER) IS
5070: SELECT rgp.id
5071: FROM okc_rule_groups_b rgp,
5072: okc_k_lines_b cle
5073: WHERE cle.dnz_chr_id = p_chr_id
5074: AND cle.chr_id = p_chr_id
5075: AND cle.orig_system_id1 = p_orig_cle_id
5076: AND rgp.dnz_chr_id = cle.chr_id

Line 5223: okc_k_lines_b cle_rbk

5219: p_rebook_chr_id IN NUMBER) IS
5220: SELECT rgp_rbk.id,
5221: cle_rbk.orig_system_id1
5222: FROM okc_rule_groups_b rgp_rbk,
5223: okc_k_lines_b cle_rbk
5224: WHERE cle_rbk.dnz_chr_id = p_rebook_chr_id
5225: AND cle_rbk.chr_id = p_rebook_chr_id
5226: AND cle_rbk.orig_system_id1 IS NOT NULL
5227: AND rgp_rbk.dnz_chr_id = cle_rbk.chr_id

Line 5564: okc_k_lines_b parent_cle

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
5567: AND style.lty_code = 'FREE_FORM2'
5568: AND line.orig_system_id1 IS NULL

Line 5589: FROM okc_k_lines_b

5585:
5586: CURSOR rebook_new_all_line_csr (p_top_line_id NUMBER) IS
5587: SELECT id,
5588: start_date
5589: FROM okc_k_lines_b
5590: CONNECT BY PRIOR id = cle_id
5591: START WITH id = p_top_line_id;
5592: --Bug# 5362977 start
5593: --Bug# 5207066 - bug start

Line 5603: okc_k_lines_b cle

5599: cim.object1_id2,
5600: cim.jtot_object1_code,
5601: cle.lse_id
5602: FROM okc_k_items cim,
5603: okc_k_lines_b cle
5604: WHERE cim.cle_id = cle.id
5605: AND cle.id = p_cle_id;
5606: l_items_rec items_csr%ROWTYPE;
5607: l_items_old_rec items_csr%ROWTYPE;

Line 5673: okc_k_lines_b parent_cle

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
5676: AND style.lty_code = 'ADD_ITEM'
5677: AND line.orig_system_id1 IS NULL

Line 5688: CURSOR supp_invoice_dtls_csr(p_cle_id OKC_K_LINES_B.ID%TYPE) IS

5684: l_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5685: x_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5686: l_sidv_temp_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5687:
5688: CURSOR supp_invoice_dtls_csr(p_cle_id OKC_K_LINES_B.ID%TYPE) IS
5689: SELECT id,
5690: cle_id,
5691: fa_cle_id,
5692: invoice_number,

Line 5700: CURSOR orig_fa_cle_csr(p_rbk_fa_cle_id OKC_K_LINES_B.ID%TYPE) IS

5696: shipping_address_code
5697: FROM okl_supp_invoice_dtls
5698: WHERE cle_id = p_cle_id;
5699:
5700: CURSOR orig_fa_cle_csr(p_rbk_fa_cle_id OKC_K_LINES_B.ID%TYPE) IS
5701: SELECT orig_system_id1
5702: FROM okc_k_lines_b cleb_fa
5703: WHERE id = p_rbk_fa_cle_id;
5704:

Line 5702: FROM okc_k_lines_b cleb_fa

5698: WHERE cle_id = p_cle_id;
5699:
5700: CURSOR orig_fa_cle_csr(p_rbk_fa_cle_id OKC_K_LINES_B.ID%TYPE) IS
5701: SELECT orig_system_id1
5702: FROM okc_k_lines_b cleb_fa
5703: WHERE id = p_rbk_fa_cle_id;
5704:
5705: l_orig_fa_cle_id OKC_K_LINES_B.id%TYPE;
5706: l_supp_invoice_old_rec supp_invoice_dtls_csr%ROWTYPE;

Line 5705: l_orig_fa_cle_id OKC_K_LINES_B.id%TYPE;

5701: SELECT orig_system_id1
5702: FROM okc_k_lines_b cleb_fa
5703: WHERE id = p_rbk_fa_cle_id;
5704:
5705: l_orig_fa_cle_id OKC_K_LINES_B.id%TYPE;
5706: l_supp_invoice_old_rec supp_invoice_dtls_csr%ROWTYPE;
5707: l_supp_invoice_new_rec supp_invoice_dtls_csr%ROWTYPE;
5708: --Bug# 8652738
5709:

Line 8443: okc_k_lines_b cle,

8439: p_rbk_khr_id IN NUMBER,
8440: p_orig_khr_id IN NUMBER) IS
8441: SELECT orig_stm.id orig_stm_id
8442: FROM okl_streams new_stm,
8443: okc_k_lines_b cle,
8444: okl_streams orig_stm
8445: WHERE new_stm.id = p_new_stm_id
8446: AND cle.id = new_stm.kle_id
8447: AND cle.dnz_chr_id = p_rbk_khr_id

Line 8768: okc_k_lines_b cle,

8764: orig_stm.kle_id,
8765: cle.lse_id
8766: FROM okl_streams orig_stm,
8767: okl_strm_type_b sty,
8768: okc_k_lines_b cle,
8769: okl_party_payment_hdr pph
8770: WHERE orig_stm.khr_id = p_orig_khr_id
8771: AND orig_stm.say_code = 'CURR'
8772: AND orig_stm.sty_id = sty.id

Line 9122: okc_k_lines_b cle

9118: orig_stm.kle_id,
9119: cle.lse_id
9120: FROM okl_streams orig_stm,
9121: okl_strm_type_b sty,
9122: okc_k_lines_b cle
9123: WHERE orig_stm.khr_id = p_orig_khr_id
9124: AND orig_stm.say_code = 'CURR'
9125:
9126: AND orig_stm.sty_id = sty.id

Line 9525: okc_k_lines_b cle,

9521: cle.lse_id
9522: FROM okl_streams orig_stm,
9523: okl_prod_strm_types psty,
9524: okl_k_headers khr,
9525: okc_k_lines_b cle,
9526: okl_strm_type_tl styt
9527: WHERE khr.id = p_orig_khr_id
9528: AND psty.pdt_id = khr.pdt_id
9529: AND psty.accrual_yn = 'Y'

Line 9886: okc_k_lines_b cle,

9882: --FROM okl_streams orig_stm,
9883: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041
9884: okl_prod_strm_types psty,
9885: okl_k_headers khr,
9886: okc_k_lines_b cle,
9887: okl_strm_type_v sty
9888: WHERE khr.id = p_orig_khr_id
9889: --AND psty.pdt_id = khr.pdt_id
9890: AND psty.pdt_id = DECODE(OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY,

Line 10229: FROM okc_k_lines_b cle

10225: l_api_version CONSTANT NUMBER := 1;
10226:
10227: CURSOR chr_assets_csr(p_khr_id IN NUMBER) IS
10228: SELECT id cle_id
10229: FROM okc_k_lines_b cle
10230: WHERE cle.chr_id = p_khr_id
10231: AND cle.dnz_chr_id = p_khr_id
10232: AND cle.lse_id = 33;
10233: