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.OKS_BILL_SCH dependencies on OKC_K_LINES_B

Line 411: FROM okc_k_lines_b lin,

407: nvl(Lin.price_negotiated,0) total_amount, --bug#5359695
408: kln.price_uom,
409: kln.toplvl_uom_code,
410: nvl(kln.ubt_amount,0) ubt_amount --bug#5359695
411: FROM okc_k_lines_b lin,
412: Oks_k_lines_b kln,
413: Okc_k_items itm
414: WHERE kln.cle_id = lin.id and
415: itm.cle_id = lin.id and

Line 803: FROM OKC_K_LINES_b line, oks_k_lines_b det

799:
800: Cursor l_top_line_Csr(l_contract_id number, l_hdr_date date) Is
801: SELECT line.id id, line.inv_rule_id inv_rule_id, line.lse_id lse_id,
802: det.usage_type usage_type
803: FROM OKC_K_LINES_b line, oks_k_lines_b det
804: WHERE line.dnz_chr_id = l_contract_id
805: AND line.lse_id IN (1, 12, 14, 19, 46)
806: AND line.id = det.cle_id;
807:

Line 848: FROM okc_k_lines_b cle

844: l_acct_rule_id NUMBER;
845:
846: CURSOR c_subline_csr(c_topline_id IN NUMBER) IS
847: SELECT cle.id
848: FROM okc_k_lines_b cle
849: WHERE cle.cle_id = c_topline_id
850: AND cle.lse_id IN(7,8,9,10,11,13,25,35);
851: /* End Addition for bug fix 5945006 (FP Bug for 5926840) */
852:

Line 1059: UPDATE okc_k_lines_b SET inv_rule_id = nvl(l_line_inv_id,p_invoice_rule_id)

1055:
1056:
1057: IF (nvl(l_top_line_rec.inv_rule_id , 0 ) <> p_invoice_rule_id ) OR l_line_inv_id IS NOT NULL THEN
1058:
1059: UPDATE okc_k_lines_b SET inv_rule_id = nvl(l_line_inv_id,p_invoice_rule_id)
1060: WHERE id = l_top_line_rec.id;
1061:
1062:
1063: END IF;

Line 1189: FROM okc_k_lines_b line, oks_k_lines_b dtl

1185: dtl.billing_schedule_type billing_schedule_type,
1186: dtl.full_credit full_credit,
1187: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
1188: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) subline_amt
1189: FROM okc_k_lines_b line, oks_k_lines_b dtl
1190: WHERE line.cle_id = l_line_id
1191: AND line.date_cancelled is NULL
1192: AND line.id = dtl.cle_id
1193: AND ((l_style_id = 1 and line.lse_id in (35,7,8,9,10,11))

Line 1211: FROM okc_k_lines_b line, oks_k_lines_b dtl

1207: dtl.full_credit full_credit,
1208: price_uom,
1209: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
1210: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
1211: FROM okc_k_lines_b line, oks_k_lines_b dtl
1212: WHERE line.id = dtl.cle_id AND line.Id = l_line_id
1213: AND line.date_cancelled is NULL;
1214:
1215: CURSOR l_line_BS_csr(p_line_id NUMBER) IS

Line 1227: from okc_k_lines_b line

1223:
1224:
1225: Cursor l_line_amt_csr (p_id in number) IS
1226: Select line.price_negotiated
1227: from okc_k_lines_b line
1228: where line.id = p_id;
1229:
1230:
1231:

Line 1955: from okc_k_lines_b

1951: --Bug Fix 5185658
1952:
1953: Cursor get_lse_id_csr(p_cle_id number ) IS
1954: select lse_id
1955: from okc_k_lines_b
1956: where id = p_cle_id;
1957:
1958: l_lse_id number;
1959:

Line 2447: FROM okc_k_lines_b line, oks_k_lines_b dtl

2443:
2444: Cursor l_Line_Amt_Csr(p_line_id IN NUMBER) Is
2445: SELECT (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
2446: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
2447: FROM okc_k_lines_b line, oks_k_lines_b dtl
2448: WHERE line.id = p_line_id
2449: AND line.id = dtl.cle_id;
2450:
2451: l_cp_sll_out_tbl StrmLvl_Out_tbl;

Line 2738: select count(id) from okc_k_lines_b lin

2734: ----- Bug 5047257 End
2735:
2736:
2737: Cursor date_check_csr(p_sub_cle_id in number) is
2738: select count(id) from okc_k_lines_b lin
2739: where lin.id = p_sub_cle_id
2740: and lin.cle_id in (select top.id from okc_k_lines_b top
2741: where lin.start_date > top.start_date);
2742:

Line 2740: and lin.cle_id in (select top.id from okc_k_lines_b top

2736:
2737: Cursor date_check_csr(p_sub_cle_id in number) is
2738: select count(id) from okc_k_lines_b lin
2739: where lin.id = p_sub_cle_id
2740: and lin.cle_id in (select top.id from okc_k_lines_b top
2741: where lin.start_date > top.start_date);
2742:
2743: Cursor sll_csr(p_top_cle_id in number) is
2744: select count(id) from oks_stream_levels_b strm

Line 2976: from oks_k_lines_b dtl, okc_k_lines_b line

2972:
2973: CURSOR l_total_amt_csr IS
2974: select SUM(nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
2975: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) tot_amt
2976: from oks_k_lines_b dtl, okc_k_lines_b line
2977: where line.id = dtl.cle_id
2978: AND line.dnz_chr_id = p_contract_id
2979: AND lse_id IN(1,12,14,19,46);
2980:

Line 3966: FROM okc_k_headers_b contract, okc_k_lines_b line

3962: IS
3963:
3964: CURSOR l_line_cur IS
3965: SELECT contract.currency_code
3966: FROM okc_k_headers_b contract, okc_k_lines_b line
3967: WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
3968:
3969: CURSOR l_hdr_cur IS
3970: SELECT contract.currency_code

Line 4025: FROM okc_k_lines_b line, oks_k_lines_b dtl

4021: SELECT line.chr_id chr_id, line.dnz_chr_id dnz_chr_id, line.lse_id lse_id,
4022: TRUNC(line.start_date) line_start_dt, TRUNC(line.end_date) line_end_dt,
4023: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
4024: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
4025: FROM okc_k_lines_b line, oks_k_lines_b dtl
4026: WHERE line.id = dtl.cle_id AND line.Id = p_line_id ;
4027:
4028: CURSOR l_Line_Sll_Csr IS
4029: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,

Line 5077: FROM okc_k_lines_b line, oks_k_lines_b dtl

5073: TRUNC(line.end_date) cp_end_dt, TRUNC(line.date_terminated) cp_term_dt,
5074: dtl.full_credit full_credit,price_uom,lse_id cp_lse_id,
5075: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
5076: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) subline_amt
5077: FROM okc_k_lines_b line, oks_k_lines_b dtl
5078: WHERE line.id = p_cp_line_id
5079: AND line.date_cancelled is NULL
5080: AND line.id = dtl.cle_id;
5081:

Line 5090: FROM okc_k_lines_b line, oks_k_lines_b dtl

5086: line.inv_rule_id inv_id,
5087: nvl(dtl.billing_schedule_type,'T') billing_schedule_type,
5088: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
5089: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
5090: FROM okc_k_lines_b line, oks_k_lines_b dtl
5091: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id
5092: AND line.date_cancelled is NULL;
5093:
5094: CURSOR l_line_sll_csr IS

Line 5114: from okc_k_lines_b line

5110:
5111:
5112: Cursor l_line_amt_csr (p_id in number) IS
5113: Select line.price_negotiated
5114: from okc_k_lines_b line
5115: where line.id = p_id;
5116:
5117:
5118: l_index NUMBER;

Line 5577: FROM okc_k_lines_b line, oks_k_lines_b dtl

5573: line.inv_rule_id inv_id,
5574: nvl(dtl.billing_schedule_type,'T') billing_schedule_type,
5575: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
5576: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
5577: FROM okc_k_lines_b line, oks_k_lines_b dtl
5578: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id ;
5579:
5580: -------------------------------------------------------------------------
5581: -- Begin partial period computation logic

Line 6979: FROM OKC_K_LINES_B cp

6975:
6976: ----delete lvl elements for cp
6977: DELETE FROM OKS_LEVEL_ELEMENTS
6978: WHERE cle_id IN (SELECT id
6979: FROM OKC_K_LINES_B cp
6980: WHERE cp.cle_id = p_top_line_id
6981: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
6982:
6983:

Line 6994: FROM okc_k_lines_b cp

6990: ---delete sll of all cp
6991:
6992: DELETE FROM OKS_STREAM_LEVELS_B
6993: WHERE cle_id IN ( select id
6994: FROM okc_k_lines_b cp
6995: WHERE cp.cle_id = p_top_line_id
6996: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
6997:
6998:

Line 7162: FROM okc_k_lines_b line, oks_k_lines_b dtl

7158: nvl(trunc(line.date_terminated - 1),TRUNC(line.end_date)) end_dt,
7159: nvl(dtl.billing_schedule_type,'T') billing_schedule_type,
7160: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
7161: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
7162: FROM okc_k_lines_b line, oks_k_lines_b dtl
7163: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id ;
7164:
7165:
7166:

Line 7353: FROM OKC_k_LINES_B cp

7349:
7350: ----delete lvl elements for cp
7351: DELETE FROM OKS_LEVEL_ELEMENTS
7352: WHERE cle_id IN (SELECT cp.id
7353: FROM OKC_k_LINES_B cp
7354: WHERE cp.cle_id = p_top_line_id
7355: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7356:
7357:

Line 7367: FROM OKC_k_LINES_B cp

7363: ---delete sll of cp
7364:
7365: delete FROM OKS_STREAM_LEVELS_B
7366: WHERE cle_id IN (SELECT id
7367: FROM OKC_k_LINES_B cp
7368: WHERE cp.cle_id = p_top_line_id
7369: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7370:
7371: --DELETE sll of top line

Line 7380: FROM OKC_k_LINES_B cp

7376: --update billing type to null for cp
7377: UPDATE oks_k_lines_b
7378: set billing_schedule_type = NULL
7379: WHERE cle_id IN (SELECT id
7380: FROM OKC_k_LINES_B cp
7381: WHERE cp.cle_id = p_top_line_id
7382: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7383:
7384:

Line 7613: FROM okc_k_lines_b ln, oks_k_lines_b dtl

7609:
7610: CURSOR l_line_csr IS
7611: SELECT ln.id id, ln.lse_id lse_id, nvl(TRUNC(ln.date_terminated -1),ln.end_date) line_end_date,
7612: dtl.usage_type usage_type, dtl.billing_schedule_type billing_schedule_type
7613: FROM okc_k_lines_b ln, oks_k_lines_b dtl
7614: WHERE ln.id = p_top_line_id
7615: AND dtl.cle_id = ln.id;
7616:
7617:

Line 7620: FROM okc_k_lines_b

7616:
7617:
7618: Cursor l_subLine_Csr Is
7619: SELECT id ,nvl(TRUNC(date_terminated -1),end_date) cp_end_date, lse_id
7620: FROM okc_k_lines_b
7621: WHERE cle_id = p_top_line_id and lse_id in (35,7,8,9,10,11,13,18,25);
7622:
7623: CURSOR l_Line_BS_csr IS
7624: SELECT id, trunc(date_start) date_start,

Line 8069: FROM OKC_K_LINES_b

8065: IS
8066:
8067: CURSOR l_top_line_Csr Is
8068: SELECT id
8069: FROM OKC_K_LINES_b
8070: WHERE chr_id = p_contract_id
8071: AND lse_id IN (1, 12, 14, 19, 46);
8072:
8073: l_top_line_rec l_top_line_Csr%ROWTYPE;

Line 8607: FROM okc_k_lines_b line, oks_k_lines_b dtl

8603: TRUNC(line.date_terminated) line_term_dt, line.inv_rule_id inv_rule_id,
8604: nvl(dtl.billing_schedule_type,'E') billing_schedule_type,
8605: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
8606: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
8607: FROM okc_k_lines_b line, oks_k_lines_b dtl
8608: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id ;
8609:
8610:
8611:

Line 8959: FROM okc_k_lines_b line, oks_k_lines_b dtl

8955: line.inv_rule_id inv_rule_id, line.cle_id cle_id,
8956: dtl.billing_schedule_type billing_schedule_type,
8957: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
8958: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
8959: FROM okc_k_lines_b line, oks_k_lines_b dtl
8960: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id
8961: AND line.date_cancelled is null; -- 18-JAN-2006-maanand-Fixed Enhancement#4930700
8962: -- Ignore cancelled topline
8963:

Line 8974: FROM okc_k_lines_b line, oks_k_lines_b dtl

8970: dtl.billing_schedule_type billing_schedule_type,
8971: dtl.full_credit full_credit,lse_id cp_lse_id,dtl.price_uom,
8972: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
8973: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) subline_amt
8974: FROM okc_k_lines_b line, oks_k_lines_b dtl
8975: WHERE line.cle_id = l_line_id
8976: AND line.id = dtl.cle_id
8977: AND ((l_style_id = 1 and line.lse_id in (35,7,8,9,10,11))
8978: OR (l_style_id = 12 and line.lse_id = 13)

Line 8987: from okc_k_lines_b line

8983:
8984:
8985: Cursor l_subline_amt_csr (p_id in number) IS
8986: Select line.price_negotiated
8987: from okc_k_lines_b line
8988: where line.id = p_id;
8989:
8990: CURSOR l_line_BS_csr(p_line_id NUMBER) IS
8991: SELECT id, trunc(element.date_start) date_start,

Line 9005: FROM okc_k_lines_b line, oks_k_lines_b dtl

9001: SELECT line.id subline_id, TRUNC(line.start_date) cp_start_dt,
9002: TRUNC(line.end_date) cp_end_dt, dtl.billing_schedule_type billing_schedule_type,dtl.price_uom,
9003: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
9004: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) subline_amt
9005: FROM okc_k_lines_b line, oks_k_lines_b dtl
9006: WHERE line.id = p_sub_line_id
9007: AND line.id = dtl.cle_id
9008: AND line.date_cancelled is null; -- 18-JAN-2006-maanand-Fixed Enhancement#4930700
9009: -- Ignore cancelled subline

Line 11033: FROM okc_k_lines_b

11029: WHERE chr_id = p_chr_id;
11030:
11031: CURSOR l_line_csr IS
11032: SELECT TRUNC(end_date) end_date, trunc(date_terminated) date_terminated, lse_id
11033: FROM okc_k_lines_b
11034: WHERE id = p_line_id;
11035:
11036: CURSOR l_subline_csr IS
11037: SELECT ID,TRUNC(end_date) end_date, trunc(date_terminated) date_terminated

Line 11038: FROM okc_k_lines_b

11034: WHERE id = p_line_id;
11035:
11036: CURSOR l_subline_csr IS
11037: SELECT ID,TRUNC(end_date) end_date, trunc(date_terminated) date_terminated
11038: FROM okc_k_lines_b
11039: WHERE cle_id = p_line_id
11040: AND lse_id in(35,7,8,9,10,11,13,18,25);
11041:
11042: i NUMBER;

Line 11654: FROM okc_k_lines_b

11650: WHERE cle_id = p_old_cp_id;
11651:
11652: CURSOR l_new_cp_csr IS
11653: SELECT id,end_date
11654: FROM okc_k_lines_b
11655: WHERE id = p_new_cp_id;
11656:
11657:
11658:

Line 11903: FROM okc_k_lines_b line, oks_k_lines_b dtl

11899: line.cle_id parent_id,line.inv_rule_id inv_rule_id,
11900: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
11901: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt,
11902: dtl.billing_schedule_type billing_schedule_type
11903: FROM okc_k_lines_b line, oks_k_lines_b dtl
11904: WHERE line.id= p_line_id
11905: AND line.id = dtl.cle_id;
11906:
11907: CURSOR l_line_BS_csr(p_line_id NUMBER) IS

Line 11930: from okc_k_lines_b line

11926: WHERE cle_id = p_line_id;
11927:
11928: Cursor l_line_amt_csr (p_id in number) IS
11929: Select line.price_negotiated
11930: from okc_k_lines_b line
11931: where line.id = p_id;
11932:
11933: l_old_cp_rec Prod_Det_Type;
11934: l_new_cp_rec Prod_Det_Type;

Line 12881: from okc_k_lines_b

12877:
12878:
12879: CURSOR is_top_line_csr (p_cle_id number) IS
12880: select cle_id
12881: from okc_k_lines_b
12882: where id=p_cle_id;
12883:
12884:
12885: -- 18-JAN-2006-maanand-Fixed Enhancement#4930700

Line 12891: FROM okc_k_lines_b

12887: -- on billing form (table- oks_level_elements, column- amount)
12888:
12889: CURSOR csr_CheckBillSllAmount_PN (p_top_line_id number) IS
12890: SELECT 1
12891: FROM okc_k_lines_b
12892: WHERE id = p_top_line_id
12893: AND price_negotiated = (select sum(amount) from oks_level_elements ole1
12894: where ole1.parent_cle_id = p_top_line_id
12895: and ole1.object_version_number = ( select max(object_version_number)