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 OKS_K_LINES_B

Line 928: oks_k_lines_b rline

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
932: AND line.date_cancelled is null --LLC BUG FIX 4742661

Line 1088: oks_k_lines_b rline

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)
1092: AND line.date_cancelled is NULL --LLC BUG FIX 4742661

Line 1302: oks_k_lines_b rline

1298: Cursor line_billed_cur (p_id IN NUMBER) is
1299: SELECT bcl.id ,rline.termn_method,
1300: rline.usage_type, rline.usage_period
1301: FROM oks_bill_cont_lines bcl,
1302: oks_k_lines_b rline
1303: WHERE bcl.cle_id = p_id
1304: AND rline.cle_id = bcl.cle_id
1305: AND bcl.bill_action = 'RI';
1306:

Line 1324: oks_k_lines_b rline

1320: SELECT bsl.id ,rline.TERMN_METHOD ,bcl.cle_id,
1321: rline.usage_type, rline.usage_period
1322: FROM oks_bill_sub_lines bsl,
1323: oks_bill_cont_lines bcl,
1324: oks_k_lines_b rline
1325: WHERE bsl.cle_id = p_id
1326: AND bsl.bcl_id = bcl.id
1327: AND rline.cle_id = bcl.cle_id
1328: AND bcl.bill_action = 'RI';

Line 2666: oks_k_lines_b rline,

2662: rline.cc_expiry_date line_cc_exp_date,
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

Line 2779: UPDATE oks_k_lines_b

2775: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in getting bank account for line '||line_cur.line_id);
2776: x_status := 'E';
2777: Raise G_EXCEPTION_HALT_VALIDATION;
2778: ELSE
2779: UPDATE oks_k_lines_b
2780: SET cc_bank_acct_id = x_bank_account_id,
2781: cc_no = line_cur.line_cc_number,
2782: cc_expiry_date = line_Cur.line_cc_exp_date
2783: WHERE cle_id = line_cur.line_id;

Line 3229: FROM oks_k_lines_b

3225:
3226: --mchoudha 10-FEB
3227: Cursor l_usage_csr(p_id in NUMBER) is
3228: SELECT usage_type
3229: FROM oks_k_lines_b
3230: WHERE cle_id = p_id ;
3231:
3232: l_start_date_rec l_start_date_csr%ROWTYPE;
3233:

Line 4141: from oks_k_lines_b

4137: where id = p_bsl_id;
4138:
4139: Cursor sub_line_tax(p_sub_line_id in number ) is
4140: Select tax_amount
4141: from oks_k_lines_b
4142: where cle_id = p_sub_line_id;
4143:
4144: CURSOR l_line_max_bill_date( p_line_id in NUMBER ) is
4145: SELECT max(bsl.date_billed_to) max_bill_date

Line 4803: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from

4799: END IF;
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 )

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 5069: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from

5065: END IF;
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 )

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 5120: update oks_k_lines_b

5116: UPDATE oks_bill_cont_lines
5117: SET amount = l_bcl_credit_amount
5118: WHERE id = l_bcl_update_id ;
5119: If l_bcl_btn_id = -44 and l_bcl_bill_action = 'TR' then
5120: update oks_k_lines_b
5121: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5122: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5123: where cle_id = l_bsl_cle_id;
5124: If l_bcl_cle_id <> l_bsl_cle_id then

Line 5125: update oks_k_lines_b

5121: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5122: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5123: where cle_id = l_bsl_cle_id;
5124: If l_bcl_cle_id <> l_bsl_cle_id then
5125: update oks_k_lines_b
5126: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5127: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5128: where cle_id = l_bcl_cle_id;
5129: End If;

Line 5131: update oks_k_lines_b

5127: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5128: where cle_id = l_bcl_cle_id;
5129: End If;
5130: Elsif l_bcl_btn_id is null and l_bcl_bill_action = 'TR' then
5131: update oks_k_lines_b
5132: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5133: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5134: where cle_id = l_bsl_cle_id;
5135: If l_bcl_cle_id <> l_bsl_cle_id then

Line 5136: update oks_k_lines_b

5132: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5133: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5134: where cle_id = l_bsl_cle_id;
5135: If l_bcl_cle_id <> l_bsl_cle_id then
5136: update oks_k_lines_b
5137: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5138: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5139: where cle_id = l_bcl_cle_id;
5140: End If;

Line 5174: update oks_k_lines_b

5170: IF ( x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5171: RAISE G_EXCEPTION_HALT_VALIDATION;
5172: END IF;
5173: If G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG = 'N' then
5174: update oks_k_lines_b
5175: set tax_amount = G_RAIL_REC.tax_value
5176: where cle_id = l_bsl_cle_id;
5177:
5178: End If;

Line 5195: update oks_k_lines_b

5191: UPDATE oks_bill_cont_lines
5192: SET amount = l_bcl_credit_amount
5193: WHERE id = l_bcl_update_id ;
5194: If l_bcl_btn_id = -44 and l_bcl_bill_action = 'TR' then
5195: update oks_k_lines_b
5196: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5197: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5198: where cle_id = l_bsl_cle_id;
5199: If l_bcl_cle_id <> l_bsl_cle_id then

Line 5200: update oks_k_lines_b

5196: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5197: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5198: where cle_id = l_bsl_cle_id;
5199: If l_bcl_cle_id <> l_bsl_cle_id then
5200: update oks_k_lines_b
5201: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5202: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5203: where cle_id = l_bcl_cle_id;
5204: End If;

Line 5206: update oks_k_lines_b

5202: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5203: where cle_id = l_bcl_cle_id;
5204: End If;
5205: Elsif l_bcl_btn_id is null and l_bcl_bill_action = 'TR' then
5206: update oks_k_lines_b
5207: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5208: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5209: where cle_id = l_bsl_cle_id;
5210: If l_bcl_cle_id <> l_bsl_cle_id then

Line 5211: update oks_k_lines_b

5207: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5208: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5209: where cle_id = l_bsl_cle_id;
5210: If l_bcl_cle_id <> l_bsl_cle_id then
5211: update oks_k_lines_b
5212: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5213: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5214: where cle_id = l_bcl_cle_id;
5215: End If;

Line 5249: update oks_k_lines_b

5245: IF ( x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5246: RAISE G_EXCEPTION_HALT_VALIDATION;
5247: END IF;
5248: If G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG = 'N' then
5249: update oks_k_lines_b
5250: set tax_amount = G_RAIL_REC.tax_value
5251: where cle_id = l_bsl_cle_id;
5252:
5253: End If;

Line 5258: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from

5254: End If;
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 )

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 5383: oks_k_lines_b rline

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:
5387: CURSOR l_rel_csr Is

Line 6471: FROM oks_k_lines_b

6467:
6468:
6469: Cursor l_initial_csr Is
6470: SELECT nvl(base_Reading,0) Base_reading
6471: FROM oks_k_lines_b
6472: WHERE cle_id = p_cle_id;
6473:
6474:
6475: Cursor l_ctr_value_csr(p_counter_id Number,p_override_valid_flag Varchar) Is

Line 8137: oks_k_lines_b rline

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
8140: AND rline.cle_id = line2.id
8141: AND hdr.id = line1.dnz_chr_id

Line 8510: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from

8506:
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 )

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 8572: FROM oks_k_lines_b

8568:
8569:
8570: Cursor l_usage_csr(p_id in NUMBER) is
8571: SELECT usage_type
8572: FROM oks_k_lines_b
8573: WHERE cle_id = p_id ;
8574:
8575: -- BUG#3312595 mchoudha: Cursor to check for service request
8576: -- against the subline

Line 9013: ,OKS_K_LINES_B OKSL

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
9017: AND NOT exists (select 'x' from okc_k_lines_b cle,

Line 9018: oks_k_lines_b kln

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'));
9022:

Line 9036: oks_k_lines_b kln

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'));
9040:

Line 9051: ,OKS_K_LINES_B OKSL

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)
9055: AND OKCL.id = OKSL.cle_id

Line 9057: oks_k_lines_b kln

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'));
9061:

Line 9077: oks_k_lines_b kln

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'));
9081:

Line 9089: FROM OKS_K_LINES_B OKSL

9085: SELECT nvl(SUM(ubt_amount),0) unbilled
9086: ,nvl(SUM(credit_amount),0) credited
9087: ,nvl(SUM(suppressed_credit),0) suppressed
9088: ,nvl(SUM(override_amount),0) overridden
9089: FROM OKS_K_LINES_B OKSL
9090: WHERE OKSL.cle_id = p_id;
9091:
9092: CURSOR l_SUB_LINE_BILLED_CSR IS
9093: SELECT nvl(SUM(BSL.amount),0) billed

Line 9215: OKS_K_LINES_B OKS

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)
9219: and OKC.date_cancelled is NULL --LLC BUG FIX 4742661

Line 9230: oks_k_lines_b kln

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;
9234:

Line 9237: from oks_k_lines_b

9233: and kln.cle_id = cle2.id;
9234:
9235: Cursor l_usage_type_csr1(p_top_line_id in number) Is
9236: Select usage_type
9237: from oks_k_lines_b
9238: where cle_id = p_top_line_id;
9239:
9240: Cursor l_ubt_csr(p_id in number) IS
9241: SELECT ubt_amount

Line 9242: FROM OKS_K_LINES_B

9238: where cle_id = p_top_line_id;
9239:
9240: Cursor l_ubt_csr(p_id in number) IS
9241: SELECT ubt_amount
9242: FROM OKS_K_LINES_B
9243: WHERE cle_id = p_id;
9244:
9245:
9246:

Line 9454: UPDATE OKS_K_LINES_B

9450: l_currency_code);
9451: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9452: l_currency_code);
9453:
9454: UPDATE OKS_K_LINES_B
9455: SET UBT_AMOUNT = l_ubt_amount ,
9456: CREDIT_AMOUNT = l_credit ,
9457: SUPPRESSED_CREDIT = l_suppressed_credit ,
9458: OVERRIDE_AMOUNT = l_overridden ,

Line 9473: Update OKS_K_lines_b

9469:
9470: ---if only subline is terminated, then also update top line ubt, credit_amt,suppressed_credit field
9471: --so that actual line amt can be found.
9472:
9473: Update OKS_K_lines_b
9474: set ubt_amount = nvl(ubt_amount,0) + nvl(l_ubt_amount,0),
9475: CREDIT_AMOUNT = nvl(CREDIT_AMOUNT,0) + nvl(l_credit,0) ,
9476: SUPPRESSED_CREDIT = nvl(SUPPRESSED_CREDIT,0) + nvl(l_suppressed_credit,0)
9477: WHERE cle_id = l_top_line_id;

Line 9616: UPDATE OKS_K_LINES_B

9612: l_currency_code);
9613: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9614: l_currency_code);
9615:
9616: UPDATE OKS_K_LINES_B
9617: SET UBT_AMOUNT = l_ubt_amount ,
9618: CREDIT_AMOUNT = l_credit ,
9619: SUPPRESSED_CREDIT= l_suppressed_credit ,
9620: OVERRIDE_AMOUNT = l_overridden,

Line 9662: UPDATE OKS_K_LINES_B

9658: End If;
9659:
9660: -- Update of tax amount for top line is comented out as part of BUG#3278807
9661: --changed for copy bug.
9662: UPDATE OKS_K_LINES_B
9663: SET UBT_AMOUNT = nvl(UBT_AMOUNT,0) + nvl(l_tot_ubt_amount,0) ,
9664: CREDIT_AMOUNT = nvl(CREDIT_AMOUNT,0) + nvl(l_tot_credit,0) ,
9665: SUPPRESSED_CREDIT = nvl(SUPPRESSED_CREDIT,0) + nvl(l_tot_suppressed_credit,0) ,
9666: OVERRIDE_AMOUNT = l_tot_overridden,

Line 9747: UPDATE OKS_K_LINES_B

9743: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9744: l_currency_code);
9745:
9746:
9747: UPDATE OKS_K_LINES_B
9748: SET UBT_AMOUNT = l_tot_ubt_amount ,
9749: CREDIT_AMOUNT = l_tot_credit ,
9750: SUPPRESSED_CREDIT = l_tot_suppressed_credit ,
9751: OVERRIDE_AMOUNT = l_tot_overridden,

Line 9888: oks_k_lines_b rline,

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)
9892: AND line.id = nvl(p_cp_line_id,line.id)

Line 10180: UPDATE OKS_K_LINES_B

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
10181: SET UBT_AMOUNT = l_ubt_amount
10182: WHERE cle_id = cur.id;
10183:
10184:

Line 10336: oks_k_lines_b rline,

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
10340: AND itm.cle_id = line.id

Line 10354: oks_k_lines_b rline,

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
10358: AND rline.cle_id = line.id