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 2430: FROM okc_k_lines_b line, oks_k_lines_b dtl

2426:
2427: Cursor l_Line_Amt_Csr(p_line_id IN NUMBER) Is
2428: SELECT (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
2429: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
2430: FROM okc_k_lines_b line, oks_k_lines_b dtl
2431: WHERE line.id = p_line_id
2432: AND line.id = dtl.cle_id;
2433:
2434: l_cp_sll_out_tbl StrmLvl_Out_tbl;

Line 2721: select count(id) from okc_k_lines_b lin

2717: ----- Bug 5047257 End
2718:
2719:
2720: Cursor date_check_csr(p_sub_cle_id in number) is
2721: select count(id) from okc_k_lines_b lin
2722: where lin.id = p_sub_cle_id
2723: and lin.cle_id in (select top.id from okc_k_lines_b top
2724: where lin.start_date > top.start_date);
2725:

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

2719:
2720: Cursor date_check_csr(p_sub_cle_id in number) is
2721: select count(id) from okc_k_lines_b lin
2722: where lin.id = p_sub_cle_id
2723: and lin.cle_id in (select top.id from okc_k_lines_b top
2724: where lin.start_date > top.start_date);
2725:
2726: Cursor sll_csr(p_top_cle_id in number) is
2727: select count(id) from oks_stream_levels_b strm

Line 2959: from oks_k_lines_b dtl, okc_k_lines_b line

2955:
2956: CURSOR l_total_amt_csr IS
2957: select SUM(nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
2958: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) tot_amt
2959: from oks_k_lines_b dtl, okc_k_lines_b line
2960: where line.id = dtl.cle_id
2961: AND line.dnz_chr_id = p_contract_id
2962: AND lse_id IN(1,12,14,19,46);
2963:

Line 3949: FROM okc_k_headers_b contract, okc_k_lines_b line

3945: IS
3946:
3947: CURSOR l_line_cur IS
3948: SELECT contract.currency_code
3949: FROM okc_k_headers_b contract, okc_k_lines_b line
3950: WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
3951:
3952: CURSOR l_hdr_cur IS
3953: SELECT contract.currency_code

Line 4008: FROM okc_k_lines_b line, oks_k_lines_b dtl

4004: SELECT line.chr_id chr_id, line.dnz_chr_id dnz_chr_id, line.lse_id lse_id,
4005: TRUNC(line.start_date) line_start_dt, TRUNC(line.end_date) line_end_dt,
4006: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
4007: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
4008: FROM okc_k_lines_b line, oks_k_lines_b dtl
4009: WHERE line.id = dtl.cle_id AND line.Id = p_line_id ;
4010:
4011: CURSOR l_Line_Sll_Csr IS
4012: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,

Line 5060: FROM okc_k_lines_b line, oks_k_lines_b dtl

5056: TRUNC(line.end_date) cp_end_dt, TRUNC(line.date_terminated) cp_term_dt,
5057: dtl.full_credit full_credit,price_uom,lse_id cp_lse_id,
5058: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
5059: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) subline_amt
5060: FROM okc_k_lines_b line, oks_k_lines_b dtl
5061: WHERE line.id = p_cp_line_id
5062: AND line.date_cancelled is NULL
5063: AND line.id = dtl.cle_id;
5064:

Line 5073: FROM okc_k_lines_b line, oks_k_lines_b dtl

5069: line.inv_rule_id inv_id,
5070: nvl(dtl.billing_schedule_type,'T') billing_schedule_type,
5071: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
5072: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
5073: FROM okc_k_lines_b line, oks_k_lines_b dtl
5074: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id
5075: AND line.date_cancelled is NULL;
5076:
5077: CURSOR l_line_sll_csr IS

Line 5097: from okc_k_lines_b line

5093:
5094:
5095: Cursor l_line_amt_csr (p_id in number) IS
5096: Select line.price_negotiated
5097: from okc_k_lines_b line
5098: where line.id = p_id;
5099:
5100:
5101: l_index NUMBER;

Line 5560: FROM okc_k_lines_b line, oks_k_lines_b dtl

5556: line.inv_rule_id inv_id,
5557: nvl(dtl.billing_schedule_type,'T') billing_schedule_type,
5558: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
5559: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
5560: FROM okc_k_lines_b line, oks_k_lines_b dtl
5561: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id ;
5562:
5563: -------------------------------------------------------------------------
5564: -- Begin partial period computation logic

Line 6767: FROM OKC_K_LINES_B cp

6763:
6764: ----delete lvl elements for cp
6765: DELETE FROM OKS_LEVEL_ELEMENTS
6766: WHERE cle_id IN (SELECT id
6767: FROM OKC_K_LINES_B cp
6768: WHERE cp.cle_id = p_top_line_id
6769: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
6770:
6771:

Line 6782: FROM okc_k_lines_b cp

6778: ---delete sll of all cp
6779:
6780: DELETE FROM OKS_STREAM_LEVELS_B
6781: WHERE cle_id IN ( select id
6782: FROM okc_k_lines_b cp
6783: WHERE cp.cle_id = p_top_line_id
6784: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
6785:
6786:

Line 6950: FROM okc_k_lines_b line, oks_k_lines_b dtl

6946: nvl(trunc(line.date_terminated - 1),TRUNC(line.end_date)) end_dt,
6947: nvl(dtl.billing_schedule_type,'T') billing_schedule_type,
6948: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
6949: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
6950: FROM okc_k_lines_b line, oks_k_lines_b dtl
6951: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id ;
6952:
6953:
6954:

Line 7141: FROM OKC_k_LINES_B cp

7137:
7138: ----delete lvl elements for cp
7139: DELETE FROM OKS_LEVEL_ELEMENTS
7140: WHERE cle_id IN (SELECT cp.id
7141: FROM OKC_k_LINES_B cp
7142: WHERE cp.cle_id = p_top_line_id
7143: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7144:
7145:

Line 7155: FROM OKC_k_LINES_B cp

7151: ---delete sll of cp
7152:
7153: delete FROM OKS_STREAM_LEVELS_B
7154: WHERE cle_id IN (SELECT id
7155: FROM OKC_k_LINES_B cp
7156: WHERE cp.cle_id = p_top_line_id
7157: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7158:
7159: --DELETE sll of top line

Line 7168: FROM OKC_k_LINES_B cp

7164: --update billing type to null for cp
7165: UPDATE oks_k_lines_b
7166: set billing_schedule_type = NULL
7167: WHERE cle_id IN (SELECT id
7168: FROM OKC_k_LINES_B cp
7169: WHERE cp.cle_id = p_top_line_id
7170: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7171:
7172:

Line 7400: FROM okc_k_lines_b ln, oks_k_lines_b dtl

7396:
7397: CURSOR l_line_csr IS
7398: SELECT ln.id id, ln.lse_id lse_id, nvl(TRUNC(ln.date_terminated -1),ln.end_date) line_end_date,
7399: dtl.usage_type usage_type, dtl.billing_schedule_type billing_schedule_type
7400: FROM okc_k_lines_b ln, oks_k_lines_b dtl
7401: WHERE ln.id = p_top_line_id
7402: AND dtl.cle_id = ln.id;
7403:
7404:

Line 7407: FROM okc_k_lines_b

7403:
7404:
7405: Cursor l_subLine_Csr Is
7406: SELECT id ,nvl(TRUNC(date_terminated -1),end_date) cp_end_date, lse_id
7407: FROM okc_k_lines_b
7408: WHERE cle_id = p_top_line_id and lse_id in (35,7,8,9,10,11,13,18,25);
7409:
7410: CURSOR l_Line_BS_csr IS
7411: SELECT id, trunc(date_start) date_start,

Line 7856: FROM OKC_K_LINES_b

7852: IS
7853:
7854: CURSOR l_top_line_Csr Is
7855: SELECT id
7856: FROM OKC_K_LINES_b
7857: WHERE chr_id = p_contract_id
7858: AND lse_id IN (1, 12, 14, 19, 46);
7859:
7860: l_top_line_rec l_top_line_Csr%ROWTYPE;

Line 8394: FROM okc_k_lines_b line, oks_k_lines_b dtl

8390: TRUNC(line.date_terminated) line_term_dt, line.inv_rule_id inv_rule_id,
8391: nvl(dtl.billing_schedule_type,'E') billing_schedule_type,
8392: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
8393: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
8394: FROM okc_k_lines_b line, oks_k_lines_b dtl
8395: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id ;
8396:
8397:
8398:

Line 8746: FROM okc_k_lines_b line, oks_k_lines_b dtl

8742: line.inv_rule_id inv_rule_id, line.cle_id cle_id,
8743: dtl.billing_schedule_type billing_schedule_type,
8744: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
8745: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
8746: FROM okc_k_lines_b line, oks_k_lines_b dtl
8747: WHERE line.id = dtl.cle_id AND line.Id = p_top_line_id
8748: AND line.date_cancelled is null; -- 18-JAN-2006-maanand-Fixed Enhancement#4930700
8749: -- Ignore cancelled topline
8750:

Line 8761: FROM okc_k_lines_b line, oks_k_lines_b dtl

8757: dtl.billing_schedule_type billing_schedule_type,
8758: dtl.full_credit full_credit,lse_id cp_lse_id,dtl.price_uom,
8759: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
8760: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) subline_amt
8761: FROM okc_k_lines_b line, oks_k_lines_b dtl
8762: WHERE line.cle_id = l_line_id
8763: AND line.id = dtl.cle_id
8764: AND ((l_style_id = 1 and line.lse_id in (35,7,8,9,10,11))
8765: OR (l_style_id = 12 and line.lse_id = 13)

Line 8774: from okc_k_lines_b line

8770:
8771:
8772: Cursor l_subline_amt_csr (p_id in number) IS
8773: Select line.price_negotiated
8774: from okc_k_lines_b line
8775: where line.id = p_id;
8776:
8777: CURSOR l_line_BS_csr(p_line_id NUMBER) IS
8778: SELECT id, trunc(element.date_start) date_start,

Line 8792: FROM okc_k_lines_b line, oks_k_lines_b dtl

8788: SELECT line.id subline_id, TRUNC(line.start_date) cp_start_dt,
8789: TRUNC(line.end_date) cp_end_dt, dtl.billing_schedule_type billing_schedule_type,dtl.price_uom,
8790: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
8791: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) subline_amt
8792: FROM okc_k_lines_b line, oks_k_lines_b dtl
8793: WHERE line.id = p_sub_line_id
8794: AND line.id = dtl.cle_id
8795: AND line.date_cancelled is null; -- 18-JAN-2006-maanand-Fixed Enhancement#4930700
8796: -- Ignore cancelled subline

Line 10790: FROM okc_k_lines_b

10786: WHERE chr_id = p_chr_id;
10787:
10788: CURSOR l_line_csr IS
10789: SELECT TRUNC(end_date) end_date, trunc(date_terminated) date_terminated, lse_id
10790: FROM okc_k_lines_b
10791: WHERE id = p_line_id;
10792:
10793: CURSOR l_subline_csr IS
10794: SELECT ID,TRUNC(end_date) end_date, trunc(date_terminated) date_terminated

Line 10795: FROM okc_k_lines_b

10791: WHERE id = p_line_id;
10792:
10793: CURSOR l_subline_csr IS
10794: SELECT ID,TRUNC(end_date) end_date, trunc(date_terminated) date_terminated
10795: FROM okc_k_lines_b
10796: WHERE cle_id = p_line_id
10797: AND lse_id in(35,7,8,9,10,11,13,18,25);
10798:
10799: i NUMBER;

Line 11411: FROM okc_k_lines_b

11407: WHERE cle_id = p_old_cp_id;
11408:
11409: CURSOR l_new_cp_csr IS
11410: SELECT id,end_date
11411: FROM okc_k_lines_b
11412: WHERE id = p_new_cp_id;
11413:
11414:
11415:

Line 11660: FROM okc_k_lines_b line, oks_k_lines_b dtl

11656: line.cle_id parent_id,line.inv_rule_id inv_rule_id,
11657: (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
11658: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt,
11659: dtl.billing_schedule_type billing_schedule_type
11660: FROM okc_k_lines_b line, oks_k_lines_b dtl
11661: WHERE line.id= p_line_id
11662: AND line.id = dtl.cle_id;
11663:
11664: CURSOR l_line_BS_csr(p_line_id NUMBER) IS

Line 11687: from okc_k_lines_b line

11683: WHERE cle_id = p_line_id;
11684:
11685: Cursor l_line_amt_csr (p_id in number) IS
11686: Select line.price_negotiated
11687: from okc_k_lines_b line
11688: where line.id = p_id;
11689:
11690: l_old_cp_rec Prod_Det_Type;
11691: l_new_cp_rec Prod_Det_Type;

Line 12615: from okc_k_lines_b

12611:
12612:
12613: CURSOR is_top_line_csr (p_cle_id number) IS
12614: select cle_id
12615: from okc_k_lines_b
12616: where id=p_cle_id;
12617:
12618:
12619: -- 18-JAN-2006-maanand-Fixed Enhancement#4930700

Line 12625: FROM okc_k_lines_b

12621: -- on billing form (table- oks_level_elements, column- amount)
12622:
12623: CURSOR csr_CheckBillSllAmount_PN (p_top_line_id number) IS
12624: SELECT 1
12625: FROM okc_k_lines_b
12626: WHERE id = p_top_line_id
12627: AND price_negotiated = (select sum(amount) from oks_level_elements ole1
12628: where ole1.parent_cle_id = p_top_line_id
12629: and ole1.object_version_number = ( select max(object_version_number)