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_REC_PUB dependencies on OKC_K_LINES_B

Line 162: okc_k_lines_b line

158: ) RETURN Date IS
159: Cursor check_hold(p_cle_id IN NUMBER) Is
160: SELECT hold_billing
161: FROM oks_k_headers_b hdr,
162: okc_k_lines_b line
163: WHERE line.id = p_cle_id
164: AND line.dnz_chr_id = hdr.chr_id;
165:
166:

Line 270: okc_k_lines_b line,

266: ,line.start_date cov_start_date
267: ,line.end_date cov_end_date
268: ,line.price_negotiated cov_price_negotiated
269: FROM
270: okc_k_lines_b line,
271: oks_bill_cont_lines bcl,
272: oks_bill_sub_lines bsl
273: WHERE bcl.Cle_id = p_top_line_id
274: AND bsl.cle_id = nvl(p_cov_line_id,bsl.cle_id)

Line 354: okc_k_lines_B line

350: ,line.line_number
351: ,hdr.currency_code
352: ,hdr.id
353: FROM okc_k_headers_b hdr ,
354: okc_k_lines_B line
355: WHERE line.id = p_cle_id
356: AND line.dnz_chr_id = hdr.id;
357:
358: Cursor qty_uom_csr(p_cle_id IN NUMBER) Is

Line 371: ,okc_k_lines_b line

367: CURSOR inv_item_csr(p_cle_id IN NUMBER) Is
368: SELECT primary_uom_code
369: FROM Okc_K_items Item
370: ,mtl_system_items mtl
371: ,okc_k_lines_b line
372: ,okc_k_headers_b hdr
373: WHERE item.cle_id = p_cle_id
374: AND line.id = item.cle_id
375: AND hdr.id = line.dnz_chr_id

Line 908: ,okc_k_lines_b line

904: line.dnz_chr_id
905: FROM Okc_K_items Item
906: ,mtl_system_items_b mtl --Okx_system_items_v mtl
907: ,okc_k_headers_b hdr
908: ,okc_k_lines_b line
909: WHERE item.cle_id = line.id --p_cle_id
910: AND line.id = p_cle_id
911: AND line.dnz_chr_id = hdr.id
912: --AND mtl.id1 = item.object1_id1

Line 927: FROM okc_k_lines_b line,

923: rline.usage_est_yn,
924: rline.usage_est_method,
925: rline.default_quantity,
926: rline.usage_est_start_date usage_est_start_date
927: FROM okc_k_lines_b line,
928: oks_k_lines_b rline
929: WHERE line.cle_id = p_top_id
930: AND line.id = nvl(p_cov_id,line.id)
931: AND line.lse_id = 13

Line 1087: FROM okc_k_lines_b line,

1083: SELECT line.id,
1084: line.start_date,
1085: rline.usage_est_yn,
1086: rline.usage_est_method
1087: FROM okc_k_lines_b line,
1088: oks_k_lines_b rline
1089: WHERE line.cle_id = p_cle_id
1090: AND line.lse_id = 13
1091: AND line.id = nvl(p_cp_line_id,line.id)

Line 1268: FROM okc_k_lines_b okl,

1264: okl.price_negotiated,
1265: okh.currency_code,
1266: okh.contract_number,
1267: okh.contract_number_modifier
1268: FROM okc_k_lines_b okl,
1269: okc_k_headers_b okh
1270: WHERE okh.id = p_hdr_id
1271: AND okl.dnz_chr_id = okh.id
1272: AND okl.cle_id is null

Line 1293: okc_k_lines_b okl

1289: okh.contract_number,
1290: okh.contract_number_modifier,
1291: okh.billed_at_source
1292: FROM okc_k_headers_all_b okh,
1293: okc_k_lines_b okl
1294: WHERE okl.id = p_id
1295: AND okh.id = okl.dnz_chr_id;
1296:
1297:

Line 1937: okc_k_lines_b okl2,

1933:
1934: Cursor get_future_period_amount is
1935: SELECT nvl(sum(bsl.amount),0) amount
1936: FROM
1937: okc_k_lines_b okl2,
1938: oks_bill_sub_lines bsl,
1939: oks_bill_cont_lines bcl,
1940: okc_k_lines_b okl1
1941: WHERE okl1.id = p_line_id

Line 1940: okc_k_lines_b okl1

1936: FROM
1937: okc_k_lines_b okl2,
1938: oks_bill_sub_lines bsl,
1939: oks_bill_cont_lines bcl,
1940: okc_k_lines_b okl1
1941: WHERE okl1.id = p_line_id
1942: AND bcl.cle_id = okl1.id
1943: AND bsl.bcl_id = bcl.id
1944: AND bsl.cle_id = okl2.id

Line 1951: okc_k_lines_b okl,

1947:
1948: Cursor get_future_prd_amt_covlvl is
1949: SELECT nvl(sum(bsl.amount),0) amount
1950: FROM
1951: okc_k_lines_b okl,
1952: oks_bill_sub_lines bsl
1953: WHERE okl.id = p_line_id
1954: AND bsl.cle_id = okl.id
1955: AND okl.date_terminated is NULL

Line 1967: okc_k_lines_b okl

1963: okl.end_date end_date,
1964: okl.id id
1965: FROM
1966: oks_bill_sub_lines bsl,
1967: okc_k_lines_b okl
1968: WHERE okl.id = p_line_id
1969: AND okl.id = bsl.cle_id
1970: AND okl.date_terminated is null
1971: AND trunc(bsl.date_billed_to) >= trunc(p_terminate_date)

Line 1982: okc_k_lines_b okl2,

1978: okl1.start_date start_date,
1979: okl1.end_date end_date,
1980: okl1.id id
1981: FROM
1982: okc_k_lines_b okl2,
1983: oks_bill_sub_lines bsl,
1984: oks_bill_cont_lines bcl,
1985: okc_k_lines_b okl1
1986: WHERE okl1.id = p_line_id

Line 1985: okc_k_lines_b okl1

1981: FROM
1982: okc_k_lines_b okl2,
1983: oks_bill_sub_lines bsl,
1984: oks_bill_cont_lines bcl,
1985: okc_k_lines_b okl1
1986: WHERE okl1.id = p_line_id
1987: AND bcl.cle_id = okl1.id
1988: AND bsl.bcl_id = bcl.id
1989: AND okl2.id = bsl.cle_id

Line 2010: OKC_K_LINES_B ln

2006: WHERE cle_id = p_line_id;
2007:
2008: Cursor l_rel_csr (p_line_id in NUMBER) Is
2009: SELECT obj.id FROM OKC_K_REL_OBJS_V obj,
2010: OKC_K_LINES_B ln
2011: WHERE obj.cle_id = ln.id
2012: AND ln.cle_id = p_line_id;
2013:
2014: Cursor line_extwar_cur( p_line_id in NUMBER) is

Line 2019: FROM Okc_k_lines_b

2015: SELECT price_negotiated
2016: ,start_date
2017: ,end_date
2018: ,dnz_chr_id
2019: FROM Okc_k_lines_b
2020: WHERE cle_id = p_line_id
2021: AND lse_id = 25
2022: AND date_cancelled is NULL --LLC BUG FIX 4742661
2023: AND date_terminated is NULL;

Line 2031: FROM Okc_k_lines_b

2027: SELECT price_negotiated
2028: ,start_date
2029: ,end_date
2030: ,dnz_chr_id
2031: FROM Okc_k_lines_b
2032: WHERE id = p_line_id
2033: AND lse_id = 25
2034: AND date_cancelled is NULL --LLC BUG FIX 4742661
2035: AND date_terminated is NULL;

Line 2039: FROM okc_k_lines_b

2035: AND date_terminated is NULL;
2036:
2037: Cursor line_lse_id_cur (p_id IN NUMBER) is
2038: SELECT lse_id
2039: FROM okc_k_lines_b
2040: WHERE id = p_id;
2041:
2042:
2043: cur_rec get_current_period_amount%ROWTYPE;

Line 2319: okc_k_lines_b okl

2315: ,bsl.Attribute13
2316: ,bsl.Attribute14
2317: ,bsl.Attribute15
2318: FROM oks_bill_sub_lines bsl,
2319: okc_k_lines_b okl
2320: WHERE bcl_id = id_in
2321: AND bsl.cle_id = okl.id
2322: AND okl.date_cancelled is null --LLC BUG FIX 4742661
2323: AND okl.date_terminated is null;

Line 2667: okc_k_lines_b line

2663: rline.cc_bank_acct_id line_bank_number,
2664: line.bill_to_site_use_id site_use_id
2665: FROM
2666: oks_k_lines_b rline,
2667: okc_k_lines_b line
2668: WHERE line.dnz_chr_id = p_hdr_id
2669: AND line.lse_id in (1,12,19)
2670: AND line.date_cancelled is NULL --LLC BUG FIX 4742661
2671: AND line.id = rline.cle_id;

Line 2831: FROM Okc_k_lines_b cle,

2827: ,cle.end_date
2828: ,cle.price_negotiated
2829: ,cle.cle_id
2830: ,TO_NUMBER(cim.object1_id1) instance_id
2831: FROM Okc_k_lines_b cle,
2832: okc_k_items cim
2833: WHERE cle.id = p_line_id
2834: AND cle.lse_id = 25
2835: AND cle.id = cim.cle_id;

Line 2843: FROM Okc_k_lines_b

2839: ,start_date
2840: ,end_date
2841: ,price_negotiated
2842: ,cle_id
2843: FROM Okc_k_lines_b
2844: WHERE (cle_id = p_line_id
2845: And lse_id = 25
2846: AND date_cancelled is null --LLC BUG FIX 4742661
2847: And date_terminated is null) OR

Line 2860: FROM Okc_k_lines_b okl1

2856: ,okl1.start_date
2857: ,okl1.end_date
2858: ,okl1.dnz_chr_id
2859: ,okl1.id
2860: FROM Okc_k_lines_b okl1
2861: WHERE okl1.id = p_line_id
2862: AND okl1.lse_id = 19
2863: AND exists (Select 1 from okc_k_lines_b okl2
2864: Where okl2.cle_id = okl1.id

Line 2863: AND exists (Select 1 from okc_k_lines_b okl2

2859: ,okl1.id
2860: FROM Okc_k_lines_b okl1
2861: WHERE okl1.id = p_line_id
2862: AND okl1.lse_id = 19
2863: AND exists (Select 1 from okc_k_lines_b okl2
2864: Where okl2.cle_id = okl1.id
2865: And okl2.lse_id = 25
2866: AND okl2.date_cancelled is null --LLC BUG FIX 4742661
2867: And okl2.date_terminated is null);

Line 2900: FROM okc_k_lines_b p,

2896:
2897: Cursor cur_lineno(p_id IN NUMBER) IS
2898: SELECT p.line_number||'.'||s.line_number,
2899: hdr.contract_number
2900: FROM okc_k_lines_b p,
2901: okc_k_lines_b s,
2902: okc_k_headers_b hdr
2903: WHERE s.id=p_id
2904: AND p.id=s.cle_id

Line 2901: okc_k_lines_b s,

2897: Cursor cur_lineno(p_id IN NUMBER) IS
2898: SELECT p.line_number||'.'||s.line_number,
2899: hdr.contract_number
2900: FROM okc_k_lines_b p,
2901: okc_k_lines_b s,
2902: okc_k_headers_b hdr
2903: WHERE s.id=p_id
2904: AND p.id=s.cle_id
2905: AND hdr.id=p.dnz_chr_id;

Line 2914: FROM OKC_K_LINES_B

2910:
2911:
2912: CURSOR l_hdr_csr(p_id in NUMBER ) is
2913: SELECT dnz_chr_id
2914: FROM OKC_K_LINES_B
2915: WHERE id = p_id;
2916:
2917:
2918: l_extwar_rec l_extwar_csr%rowtype;

Line 3193: From Okc_k_lines_b

3189: Select Start_date
3190: ,End_date
3191: ,Price_negotiated
3192: ,Date_terminated
3193: From Okc_k_lines_b
3194: Where cle_id = p_k_line_id
3195: And date_cancelled is null --LLC BUG FIX 4742661
3196: And date_terminated IS NULL
3197: And lse_id in (7,8,9,10,11,13,35,25);

Line 3208: FROM Okc_k_lines_B line,

3204: ,line.Date_Terminated
3205: ,line.dnz_chr_id
3206: ,line.lse_id
3207: ,hdr.currency_code
3208: FROM Okc_k_lines_B line,
3209: okc_k_headers_b hdr
3210: WHERE line.Cle_id = p_k_line_id
3211: AND line.dnz_chr_id = hdr.id;
3212:

Line 3217: FROM OKC_K_LINES_B

3213:
3214:
3215: CURSOR l_start_date_csr(p_id in NUMBER ) is
3216: SELECT start_date,lse_id
3217: FROM OKC_K_LINES_B
3218: WHERE id = p_k_line_id;
3219:
3220:
3221: CURSOR l_hdr_csr(p_id in NUMBER ) is

Line 3223: FROM OKC_K_LINES_B

3219:
3220:
3221: CURSOR l_hdr_csr(p_id in NUMBER ) is
3222: SELECT dnz_chr_id
3223: FROM OKC_K_LINES_B
3224: WHERE id = p_id;
3225:
3226: --mchoudha 10-FEB
3227: Cursor l_usage_csr(p_id in NUMBER) is

Line 3534: FROM okc_k_lines_b

3530: and trunc(date_billed_to) >= trunc(l_termination_date);
3531:
3532: CURSOR l_lines_csr( p_id NUMBER ) is
3533: SELECT start_date
3534: FROM okc_k_lines_b
3535: WHERE id = p_id ;
3536:
3537: SUBTYPE l_bclv_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;
3538: l_bclv_tbl_in l_bclv_tbl_type_in;

Line 4024: FROM okc_k_lines_b

4020: /*******************Modified this cursor as below for BUG # 3029249 ***
4021: Cursor line_cur(p_hdr_id IN NUMBER) is
4022: SELECT id,
4023: lse_id
4024: FROM okc_k_lines_b
4025: WHERE dnz_chr_id = p_hdr_id
4026: AND cle_id is null
4027: AND date_terminated is null --Sts_cd can be active for future terminate
4028: AND sts_code in ('ACTIVE','SIGNED');

Line 4037: FROM okc_k_lines_b lines,

4033: lines.lse_id,
4034: /* Start Addition for bug fix 6012384 (FP for 5469820) */
4035: lines.end_date
4036: /* End Addition for bug fix 6012384 (FP for 5469820) */
4037: FROM okc_k_lines_b lines,
4038: okc_k_headers_b hdr
4039: WHERE hdr.id = p_hdr_id
4040: AND lines.dnz_chr_id = hdr.id
4041: AND lines.date_cancelled is null --LLC BUG FIX 4742661

Line 4066: okc_k_lines_b lines

4062: lines.lse_id,
4063: lines.line_number,
4064: lines.date_terminated
4065: FROM okc_k_headers_b hdr,
4066: okc_k_lines_b lines
4067: WHERE lines.id = p_line_id
4068: AND hdr.id = lines.dnz_chr_id
4069: AND hdr.sts_code <> 'QA_HOLD'
4070: AND (exists ( SELECT 1 from okc_assents a

Line 4154: FROM okc_k_lines_b

4150: AND bcl.id = bsl.bcl_id ;
4151:
4152: CURSOR l_get_line_start_date(p_id in number ) is
4153: SELECT start_date
4154: FROM okc_k_lines_b
4155: WHERE id = p_id ;
4156:
4157:
4158: /* Added for BUG 3364773 */

Line 4161: FROM okc_k_lines_b

4157:
4158: /* Added for BUG 3364773 */
4159: Cursor check_all_sublines_terminated(p_cle_id IN NUMBER) is
4160: SELECT id
4161: FROM okc_k_lines_b
4162: WHERE cle_id = p_cle_id
4163: AND lse_id in (7,8,9,10,11,13,35,25)
4164: /* Start changes For bug fix 6012384 (FP for 5990067) */
4165: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED'));

Line 4172: FROM okc_k_lines_b

4168:
4169: /* Added for BUG 3364773 */
4170: Cursor check_all_lines_terminated(p_hdr_id IN NUMBER) is
4171: SELECT id
4172: FROM okc_k_lines_b
4173: WHERE dnz_chr_id = p_hdr_id
4174: /* Start changes For bug fix 6012384 (FP for 5990067) */
4175: AND lse_id in (1,12,14,19,46)
4176: --AND lse_id in (1,12,14,19)

Line 4195: FROM okc_k_lines_b lin,

4191: AND sr.status_flag = 'O';
4192:
4193: Cursor cur_lineno(p_id IN NUMBER) IS
4194: SELECT lin.line_number,hdr.contract_number
4195: FROM okc_k_lines_b lin,
4196: okc_k_headers_b hdr
4197: WHERE lin.id=p_id
4198: AND hdr.id=lin.dnz_chr_id;
4199:

Line 4269: okc_k_lines_b line

4265: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4266: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4267: from oks_bill_cont_lines bcl,
4268: oks_bill_sub_lines bsl,
4269: okc_k_lines_b line
4270: where bsl.bcl_id = bcl.id
4271: and line.id = bcl.cle_id
4272: and bcl.bill_action <> 'TR'
4273: and line.dnz_chr_id = p_hdr_id

Line 4285: okc_k_lines_b line

4281: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4282: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4283: from oks_bill_cont_lines bcl,
4284: oks_bill_sub_lines bsl,
4285: okc_k_lines_b line
4286: where bsl.bcl_id = bcl.id
4287: and line.id = bcl.cle_id
4288: and bcl.bill_action <> 'TR'
4289: and line.dnz_chr_id = p_hdr_id

Line 4804: oks_k_lines_b oksline, okc_k_lines_b okcline

4800: CLOSE check_all_sublines_terminated;
4801: END IF;
4802:
4803: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
4804: oks_k_lines_b oksline, okc_k_lines_b okcline
4805: where okcline.id = oksline.cle_id
4806: and okcline.cle_id = p_id
4807: and okcline.date_cancelled is null )
4808: where topline.cle_id = p_id;

Line 4811: oks_k_lines_b oksline, okc_k_lines_b okcline

4807: and okcline.date_cancelled is null )
4808: where topline.cle_id = p_id;
4809:
4810: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
4811: oks_k_lines_b oksline, okc_k_lines_b okcline
4812: where okcline.id = oksline.cle_id
4813: and okcline.dnz_chr_id = l_line_parameter_rec.p_dnz_chr_id
4814: and okcline.date_cancelled is null
4815: and lse_id in (1,12,19,46) )

Line 5070: oks_k_lines_b oksline, okc_k_lines_b okcline

5066:
5067: END IF;
5068:
5069: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
5070: oks_k_lines_b oksline, okc_k_lines_b okcline
5071: where okcline.id = oksline.cle_id
5072: and okcline.cle_id = line_rec.id
5073: and okcline.date_cancelled is null )
5074: where topline.cle_id = line_rec.id;

Line 5142: update okc_k_lines_b

5138: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5139: where cle_id = l_bcl_cle_id;
5140: End If;
5141: End If;
5142: update okc_k_lines_b
5143: set price_negotiated = price_negotiated - ( l_termination_amount - g_credit_amount )
5144: where id = l_bcl_cle_id
5145: and lse_id <> 12;
5146: If l_bsl_cle_id <> l_bcl_cle_id then

Line 5147: update okc_k_lines_b

5143: set price_negotiated = price_negotiated - ( l_termination_amount - g_credit_amount )
5144: where id = l_bcl_cle_id
5145: and lse_id <> 12;
5146: If l_bsl_cle_id <> l_bcl_cle_id then
5147: update okc_k_lines_b
5148: set price_negotiated = price_negotiated - ( l_termination_amount - g_credit_amount )
5149: where id = l_bsl_cle_id
5150: and lse_id <>13;
5151: End If;

Line 5217: update okc_k_lines_b

5213: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5214: where cle_id = l_bcl_cle_id;
5215: End If;
5216: End If;
5217: update okc_k_lines_b
5218: set price_negotiated = price_negotiated + ( g_credit_amount - l_termination_amount )
5219: where id = l_bcl_cle_id
5220: and lse_id <> 12;
5221: If l_bsl_cle_id <> l_bcl_cle_id then

Line 5222: update okc_k_lines_b

5218: set price_negotiated = price_negotiated + ( g_credit_amount - l_termination_amount )
5219: where id = l_bcl_cle_id
5220: and lse_id <> 12;
5221: If l_bsl_cle_id <> l_bcl_cle_id then
5222: update okc_k_lines_b
5223: set price_negotiated = price_negotiated + ( g_credit_amount - l_termination_amount )
5224: where id = l_bsl_cle_id
5225: and lse_id <>13;
5226: End If;

Line 5259: oks_k_lines_b oksline, okc_k_lines_b okcline

5255: End If;
5256: END IF;
5257:
5258: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
5259: oks_k_lines_b oksline, okc_k_lines_b okcline
5260: where okcline.id = oksline.cle_id
5261: and okcline.cle_id = l_bcl_cle_id
5262: and okcline.date_cancelled is null )
5263: where topline.cle_id = l_bcl_cle_id;

Line 5333: oks_k_lines_b oksline, okc_k_lines_b okcline

5329:
5330: END IF ; -- l_terminate = TRUE|| ((l_terminate = FALSE) AND (check_all_lines_terminated%NOTFOUND)))
5331:
5332: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
5333: oks_k_lines_b oksline, okc_k_lines_b okcline
5334: where okcline.id = oksline.cle_id
5335: and okcline.dnz_chr_id = p_id
5336: and okcline.date_cancelled is null
5337: and lse_id in (1,12,19,46) )

Line 5382: FROM okc_k_lines_b line,

5378: SELECT LIne.lse_id,
5379: rline.termn_method,
5380: rline.usage_type,
5381: rline.usage_period
5382: FROM okc_k_lines_b line,
5383: oks_k_lines_b rline
5384: WHERE line.id = p_k_line_id
5385: AND rline.cle_id = line.id;
5386:

Line 5390: OKC_K_LINES_B ln

5386:
5387: CURSOR l_rel_csr Is
5388: SELECT obj.id
5389: From OKC_K_REL_OBJS_V obj,
5390: OKC_K_LINES_B ln
5391: Where obj.cle_id = ln.id
5392: And ln.cle_id = p_k_line_id;
5393:
5394: CURSOR l_line_csr (p_id in NUMBER ) is

Line 5396: FROM okc_k_lines_b

5392: And ln.cle_id = p_k_line_id;
5393:
5394: CURSOR l_line_csr (p_id in NUMBER ) is
5395: SELECT start_date
5396: FROM okc_k_lines_b
5397: WHERE id = p_id ;
5398:
5399:
5400: l_lse_id NUMBER;

Line 7752: From OKC_K_LINES_B line,

7748: rules.rule_information7 Secondary_dur,
7749: rules.rule_information6 Primary_period,
7750: rules.rule_information8 Secondary_period
7751:
7752: From OKC_K_LINES_B line,
7753: OKC_K_HEADERS_B Hdr,
7754: OKC_RULES_B rules,
7755: OKC_RULE_GROUPS_B rlgrp
7756:

Line 7781: From OKC_K_LINES_B

7777: price_negotiated,
7778: start_date,
7779: end_date,
7780: date_terminated
7781: From OKC_K_LINES_B
7782: Where cle_id = p_cle_id
7783: And lse_id in (8,7,9,10,11,13,35);
7784:
7785: CURSOR l_billed_csr (p_cle_id IN NUMBER)

Line 8134: FROM okc_k_lines_b line2,

8130: SELECT line1.lse_id, line1.cle_id ,rline.termn_method,
8131: rline.usage_type, rline.usage_period,
8132: line1.end_date,line1.sts_code,
8133: hdr.id
8134: FROM okc_k_lines_b line2,
8135: okc_k_lines_b line1,
8136: okc_k_headers_b hdr,
8137: oks_k_lines_b rline
8138: WHERE line1.id = p_cle_id

Line 8135: okc_k_lines_b line1,

8131: rline.usage_type, rline.usage_period,
8132: line1.end_date,line1.sts_code,
8133: hdr.id
8134: FROM okc_k_lines_b line2,
8135: okc_k_lines_b line1,
8136: okc_k_headers_b hdr,
8137: oks_k_lines_b rline
8138: WHERE line1.id = p_cle_id
8139: AND line2.id = line1.cle_id

Line 8226: l_lse_id OKC_K_LINES_B.lse_id%TYPE;

8222: l_msg_data VARCHAR2(2000);
8223: l_return_status VARCHAR2(10);
8224:
8225: l_check_term_cur CHECK_TERM_CUR%ROWTYPE;
8226: l_lse_id OKC_K_LINES_B.lse_id%TYPE;
8227: l_id NUMBER;
8228: l_amount NUMBER;
8229: l_term_date DATE;
8230: l_ctr BOOLEAN;

Line 8396: -- update to okc_k_lines_b was done directly.

8392: -- Code change for bug # 3393329 starts --
8393: -- The following code was added as part of bug #3393329.Since
8394: -- the direct update was done before , the minor version number
8395: -- were not getting updated in contract. Before this code was added
8396: -- update to okc_k_lines_b was done directly.
8397: l_clev_tbl_in( 1 ).id := p_cle_id;
8398: l_clev_tbl_in( 1 ).date_terminated := p_termination_date;
8399: l_clev_tbl_in( 1 ).trn_code := p_terminate_reason;
8400: l_clev_tbl_in( 1 ).term_cancel_source := P_Term_Cancel_source;

Line 8511: oks_k_lines_b oksline, okc_k_lines_b okcline

8507: END IF; -- check_term_cur%NOTFOUND
8508: CLOSE check_term_cur;
8509:
8510: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
8511: oks_k_lines_b oksline, okc_k_lines_b okcline
8512: where okcline.id = oksline.cle_id
8513: and okcline.cle_id = l_top_line_id
8514: and okcline.date_cancelled is null )
8515: where topline.cle_id = l_top_line_id;

Line 8518: oks_k_lines_b oksline, okc_k_lines_b okcline

8514: and okcline.date_cancelled is null )
8515: where topline.cle_id = l_top_line_id;
8516:
8517: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
8518: oks_k_lines_b oksline, okc_k_lines_b okcline
8519: where okcline.id = oksline.cle_id
8520: and okcline.dnz_chr_id = l_hdr_id
8521: and okcline.date_cancelled is null
8522: and lse_id in (1,12,19,46) )

Line 8566: FROM okc_k_lines_b

8562: Cursor l_line_csr(p_id in NUMBER) is
8563: SELECT start_date,end_date,sts_code,
8564: lse_id,
8565: dnz_chr_id
8566: FROM okc_k_lines_b
8567: WHERE id = p_id ;
8568:
8569:
8570: Cursor l_usage_csr(p_id in NUMBER) is

Line 8600: FROM okc_k_lines_b p,

8596:
8597: Cursor cur_lineno(p_id IN NUMBER) IS
8598: SELECT p.line_number||'.'||s.line_number,
8599: hdr.contract_number
8600: FROM okc_k_lines_b p,
8601: okc_k_lines_b s,
8602: okc_k_headers_b hdr
8603: WHERE s.id=p_id
8604: AND p.id=s.cle_id

Line 8601: okc_k_lines_b s,

8597: Cursor cur_lineno(p_id IN NUMBER) IS
8598: SELECT p.line_number||'.'||s.line_number,
8599: hdr.contract_number
8600: FROM okc_k_lines_b p,
8601: okc_k_lines_b s,
8602: okc_k_headers_b hdr
8603: WHERE s.id=p_id
8604: AND p.id=s.cle_id
8605: AND hdr.id=p.dnz_chr_id;

Line 8904: -- update to okc_k_lines_b was done directly.

8900: -- Code change for bug # 3393329 starts --
8901: -- The following code was added as part of bug #3393329.Since
8902: -- the direct update was done before , the minor version number
8903: -- were not getting updated in contract. Before this code was added
8904: -- update to okc_k_lines_b was done directly.
8905: l_clev_tbl_in( 1 ).id := p_cp_line_id;
8906: l_clev_tbl_in( 1 ).date_terminated := p_termination_date;
8907: l_clev_tbl_in( 1 ).trn_code := p_terminate_reason;
8908: l_clev_tbl_in( 1 ).term_cancel_source := P_Term_Cancel_source;

Line 9012: FROM OKC_K_LINES_B OKCL

9008: SELECT nvl(SUM(ubt_amount),0) unbilled
9009: ,nvl(SUM(credit_amount),0) credited
9010: ,nvl(SUM(suppressed_credit),0) suppressed
9011: ,nvl(SUM(override_amount),0) overridden
9012: FROM OKC_K_LINES_B OKCL
9013: ,OKS_K_LINES_B OKSL
9014: WHERE OKCL.dnz_chr_id = p_id
9015: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9016: AND OKCL.id = OKSL.cle_id

Line 9017: AND NOT exists (select 'x' from okc_k_lines_b cle,

9013: ,OKS_K_LINES_B OKSL
9014: WHERE OKCL.dnz_chr_id = p_id
9015: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9016: AND OKCL.id = OKSL.cle_id
9017: AND NOT exists (select 'x' from okc_k_lines_b cle,
9018: oks_k_lines_b kln
9019: where cle.id = OKCL.cle_id
9020: and kln.cle_id = cle.id
9021: and kln.usage_type in ('VRT','QTY','FRT'));

Line 9027: FROM OKC_K_LINES_B OKCL

9023: --mchoudha 11510+ Usage Tax and Price Display
9024: --added NOT Exists clause and lse_id 13
9025: CURSOR L_HDR_BILLED_CSR IS
9026: SELECT nvl(SUM(BSL.amount),0) billed
9027: FROM OKC_K_LINES_B OKCL
9028: ,OKS_BILL_CONT_LINES BCL
9029: ,OKS_BILL_SUB_LINES BSL
9030: WHERE OKCL.dnz_chr_id = p_id
9031: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)

Line 9035: AND NOT exists (select 'x' from okc_k_lines_b cle,

9031: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9032: AND OKCL.id = BSL.cle_id
9033: AND BSL.bcl_id = BCL.id
9034: AND BCL.bill_action = 'RI'
9035: AND NOT exists (select 'x' from okc_k_lines_b cle,
9036: oks_k_lines_b kln
9037: where cle.id = OKCL.cle_id
9038: and kln.cle_id = cle.id
9039: and kln.usage_type in ('VRT','QTY','FRT'));

Line 9050: FROM OKC_K_LINES_B OKCL

9046: SELECT nvl(SUM(ubt_amount),0) unbilled
9047: ,nvl(SUM(credit_amount),0) credited
9048: ,nvl(SUM(suppressed_credit),0) suppressed
9049: ,nvl(SUM(override_amount),0) overridden
9050: FROM OKC_K_LINES_B OKCL
9051: ,OKS_K_LINES_B OKSL
9052: WHERE ( OKCL.cle_id = p_id
9053: OR (OKCL.id = p_id and OKCL.lse_id = 46 ))
9054: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)

Line 9056: AND NOT exists (select 'x' from okc_k_lines_b cle,

9052: WHERE ( OKCL.cle_id = p_id
9053: OR (OKCL.id = p_id and OKCL.lse_id = 46 ))
9054: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9055: AND OKCL.id = OKSL.cle_id
9056: AND NOT exists (select 'x' from okc_k_lines_b cle,
9057: oks_k_lines_b kln
9058: where cle.id = OKCL.cle_id
9059: and kln.cle_id = cle.id
9060: and kln.usage_type in ('VRT','QTY','FRT'));

Line 9067: FROM OKC_K_LINES_B OKCL

9063: --mchoudha 11510+ Usage Tax and Price Display
9064: --added NOT Exists clause and lse_id 13
9065: CURSOR l_TOP_LINE_BILLED_CSR IS
9066: SELECT nvl(SUM(BSL.amount),0) billed
9067: FROM OKC_K_LINES_B OKCL
9068: ,OKS_BILL_CONT_LINES BCL
9069: ,OKS_BILL_SUB_LINES BSL
9070: WHERE ( OKCL.cle_id = p_id
9071: OR ( OKCL.ID = p_id and OKCL.lse_id = 46))

Line 9076: AND NOT exists (select 'x' from okc_k_lines_b cle,

9072: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9073: AND OKCL.id = BSL.cle_id
9074: AND BSL.bcl_id = BCL.id
9075: AND BCL.bill_action = 'RI'
9076: AND NOT exists (select 'x' from okc_k_lines_b cle,
9077: oks_k_lines_b kln
9078: where cle.id = OKCL.cle_id
9079: and kln.cle_id = cle.id
9080: and kln.usage_type in ('VRT','QTY','FRT'));

Line 9145: FROM okc_k_lines_b okcl

9141: SELECT id top_line_id ,
9142: dnz_chr_id hdr_id,
9143: lse_id lse_id,
9144: price_negotiated price_negotiated
9145: FROM okc_k_lines_b okcl
9146: WHERE dnz_chr_id = p_top_line_id
9147: AND okcl.lse_id in (1,12,14,19,46)
9148: AND okcl.date_cancelled is null --LLC BUG FIX 4742661
9149: AND okcl.date_terminated is null ;

Line 9157: FROM okc_k_lines_b okcl

9153: CURSOR l_top_line_csr (p_top_line_id in NUMBER ) is
9154: SELECT id sub_line_id ,
9155: dnz_chr_id hdr_id,
9156: start_date start_date
9157: FROM okc_k_lines_b okcl
9158: WHERE cle_id = p_top_line_id
9159: AND okcl.lse_id in (7,8,9,10,11,13,35,25)
9160: AND okcl.date_cancelled is NULL --LLC BUG FIX 4742661
9161: AND okcl.date_terminated is null ;

Line 9167: FROM okc_k_lines_b okcl

9163: CURSOR l_sub_line_csr (p_sub_line_id in NUMBER ) is
9164: SELECT Price_negotiated orginal_amount ,
9165: cle_id top_line_id ,
9166: dnz_chr_id hdr_id
9167: FROM okc_k_lines_b okcl
9168: WHERE id = p_sub_line_id ;
9169:
9170: CURSOR l_bill_amount_csr(p_sub_line_id in NUMBER ) is
9171: SELECT sum(nvl(amount,0)) bill_amount

Line 9197: FROM OKC_K_LINES_B OKCL

9193: CURSOR l_lse_id_csr (p_id IN number )is
9194: SELECT lse_id ,
9195: price_negotiated,
9196: dnz_chr_id
9197: FROM OKC_K_LINES_B OKCL
9198: WHERE OKCL.id = p_id ;
9199:
9200: CURSOR L_HDR_CURR_CODE (p_id in number ) is
9201: SELECT currency_code

Line 9207: FROM okc_k_lines_b lines,

9203: WHERE id = p_id;
9204:
9205: CURSOR l_line_curr_code (p_id in number ) is
9206: SELECT hdr.currency_code ,hdr.id
9207: FROM okc_k_lines_b lines,
9208: okc_k_headers_b hdr
9209: WHERE lines.id = p_id
9210: AND hdr.id = lines.dnz_chr_id;
9211:

Line 9214: FROM OKC_K_LINES_B OKC,

9210: AND hdr.id = lines.dnz_chr_id;
9211:
9212: CURSOR l_check_for_full_credit(p_top_line_id in NUMBER ) is
9213: SELECT count(oks.full_credit)
9214: FROM OKC_K_LINES_B OKC,
9215: OKS_K_LINES_B OKS
9216: WHERE OKC.cle_ID = p_top_line_id
9217: AND OKC.id = OKS.CLE_id
9218: and OKC.lse_id in (7,8,9,10,11,13,18,25,35)

Line 9228: from okc_k_lines_b cle1,

9224: --mchoudha 11510+ Usage Tax and Price Display
9225: --added the following two cursors to retrieve the usage type
9226: Cursor l_usage_type_csr(p_sub_line_id in number) Is
9227: Select kln.usage_type
9228: from okc_k_lines_b cle1,
9229: okc_k_lines_b cle2,
9230: oks_k_lines_b kln
9231: where cle1.id = p_sub_line_id
9232: and cle2.id = cle1.cle_id

Line 9229: okc_k_lines_b cle2,

9225: --added the following two cursors to retrieve the usage type
9226: Cursor l_usage_type_csr(p_sub_line_id in number) Is
9227: Select kln.usage_type
9228: from okc_k_lines_b cle1,
9229: okc_k_lines_b cle2,
9230: oks_k_lines_b kln
9231: where cle1.id = p_sub_line_id
9232: and cle2.id = cle1.cle_id
9233: and kln.cle_id = cle2.id;

Line 9408: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);

9404: l_true_value := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,l_currency_code);
9405:
9406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9407: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9408: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);
9409: END IF;
9410:
9411: UPDATE OKC_K_LINES_B
9412: SET price_negotiated = l_true_value

Line 9411: UPDATE OKC_K_LINES_B

9407: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9408: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);
9409: END IF;
9410:
9411: UPDATE OKC_K_LINES_B
9412: SET price_negotiated = l_true_value
9413: WHERE id = p_true_value_tbl(1).p_cp_line_id;
9414: If l_credit < 0 then
9415: l_credit := l_credit * -1;

Line 9463: UPDATE OKC_K_LINES_B

9459: TAX_AMOUNT = l_tax_value,
9460: FULL_CREDIT = nvl(p_true_value_tbl(1).p_full_credit,'N')
9461: WHERE cle_id = p_true_value_tbl(1).p_cp_line_id;
9462:
9463: UPDATE OKC_K_LINES_B
9464: SET price_negotiated=(SELECT SUM(price_negotiated)
9465: FROM okc_k_lines_b
9466: WHERE cle_id = l_top_line_id
9467: AND date_cancelled is null) --LLC BUG FIX 4742661

Line 9465: FROM okc_k_lines_b

9461: WHERE cle_id = p_true_value_tbl(1).p_cp_line_id;
9462:
9463: UPDATE OKC_K_LINES_B
9464: SET price_negotiated=(SELECT SUM(price_negotiated)
9465: FROM okc_k_lines_b
9466: WHERE cle_id = l_top_line_id
9467: AND date_cancelled is null) --LLC BUG FIX 4742661
9468: WHERE id = l_top_line_id ;
9469:

Line 9481: FROM OKC_K_LINES_B

9477: WHERE cle_id = l_top_line_id;
9478:
9479: UPDATE OKC_K_HEADERS_B
9480: SET estimated_amount=(SELECT SUM(price_negotiated)
9481: FROM OKC_K_LINES_B
9482: WHERE dnz_chr_id = l_hdr_id
9483: AND lse_id in ( 1,12,14,19,46))
9484: WHERE id = l_hdr_id ;
9485: End If;

Line 9570: UPDATE OKC_K_LINES_B

9566: END IF;
9567:
9568: l_true_value :=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,
9569: l_currency_code);
9570: UPDATE OKC_K_LINES_B
9571: SET price_negotiated = l_true_value
9572: WHERE id = l_top_line_rec.sub_line_id;
9573:
9574: G_RAIL_REC.AMOUNT := l_true_value;

Line 9634: UPDATE OKC_K_LINES_B

9630:
9631: END LOOP;
9632:
9633: If l_process then
9634: UPDATE OKC_K_LINES_B
9635: SET price_negotiated=(SELECT SUM(price_negotiated)
9636: FROM okc_k_lines_b
9637: WHERE cle_id = l_top_line_id
9638: AND date_cancelled is null) --LLC BUG FIX 4742661

Line 9636: FROM okc_k_lines_b

9632:
9633: If l_process then
9634: UPDATE OKC_K_LINES_B
9635: SET price_negotiated=(SELECT SUM(price_negotiated)
9636: FROM okc_k_lines_b
9637: WHERE cle_id = l_top_line_id
9638: AND date_cancelled is null) --LLC BUG FIX 4742661
9639: WHERE id = p_true_value_tbl(1).p_top_line_id ;
9640:

Line 9707: UPDATE OKC_K_LINES_B

9703: nvl(l_tot_credit,0) - nvl(l_tot_suppressed_credit,0);
9704:
9705: l_tot_true_value:=OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_true_value,
9706: l_currency_code);
9707: UPDATE OKC_K_LINES_B
9708: SET price_negotiated = l_tot_true_value
9709: WHERE id = p_true_value_tbl(1).p_top_line_id;
9710:
9711: G_RAIL_REC.AMOUNT := l_true_value;

Line 9764: FROM OKC_K_LINES_B

9760: IF p_true_value_tbl(1).p_hdr_id = 0 then
9761: IF l_lse_id_rec.lse_id in ( 1,12,19,46 ) then
9762: UPDATE OKC_K_HEADERS_B
9763: SET estimated_amount=(SELECT SUM(price_negotiated)
9764: FROM OKC_K_LINES_B
9765: WHERE dnz_chr_id = l_hdr_id
9766: AND lse_id in ( 1,12,14,19,46))
9767: WHERE id = l_hdr_id ;
9768: END IF;

Line 9781: FROM OKC_K_LINES_B

9777: -- True value processing for Header Termination --
9778: -------------------------------------------------------------------------
9779: UPDATE OKC_K_HEADERS_B
9780: SET estimated_amount=(SELECT SUM(price_negotiated)
9781: FROM OKC_K_LINES_B
9782: WHERE dnz_chr_id = p_true_value_tbl(1).p_hdr_id
9783: AND lse_id in ( 1,12,14,19,46))
9784: WHERE id = p_true_value_tbl(1).p_hdr_id ;
9785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 9887: FROM okc_k_lines_b line,

9883: line.price_unit*itm.number_of_items unit_price,
9884: rline.price_uom,
9885: line.price_negotiated total_amount,
9886: rline.toplvl_uom_code
9887: FROM okc_k_lines_b line,
9888: oks_k_lines_b rline,
9889: okc_k_items itm
9890: WHERE line.cle_id = p_cle_id
9891: AND line.lse_id in (7,8,9,10,11,13,25,35)

Line 10176: UPDATE OKC_K_LINES_B

10172:
10173: l_new_price := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_new_price,l_currency_code);
10174: l_ubt_amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_ubt_amount,l_currency_code);
10175:
10176: UPDATE OKC_K_LINES_B
10177: SET price_negotiated = l_new_price
10178: WHERE id = cur.id;
10179:
10180: UPDATE OKS_K_LINES_B

Line 10335: FROM okc_k_lines_b line,

10331: line.price_unit*itm.number_of_items unit_price,
10332: rline.price_uom,
10333: rline.toplvl_uom_code,
10334: line.price_negotiated total_amount
10335: FROM okc_k_lines_b line,
10336: oks_k_lines_b rline,
10337: okc_k_items itm
10338: WHERE line.id = p_id
10339: AND rline.cle_id = line.id

Line 10353: FROM okc_k_lines_b line,

10349: line.price_unit*itm.number_of_items unit_price,
10350: rline.price_uom,
10351: rline.toplvl_uom_code,
10352: line.price_negotiated total_amount
10353: FROM okc_k_lines_b line,
10354: oks_k_lines_b rline,
10355: okc_k_items itm
10356: WHERE line.cle_id = p_cle_id
10357: AND itm.cle_id = line.id