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

943: rline.usage_est_method,
944: rline.default_quantity,
945: rline.usage_est_start_date usage_est_start_date
946: FROM okc_k_lines_b line,
947: oks_k_lines_b rline
948: WHERE line.cle_id = p_top_id
949: AND line.id = nvl(p_cov_id,line.id)
950: AND line.lse_id = 13
951: AND line.date_cancelled is null --LLC BUG FIX 4742661

Line 1107: oks_k_lines_b rline

1103: line.start_date,
1104: rline.usage_est_yn,
1105: rline.usage_est_method
1106: FROM okc_k_lines_b line,
1107: oks_k_lines_b rline
1108: WHERE line.cle_id = p_cle_id
1109: AND line.lse_id = 13
1110: AND line.id = nvl(p_cp_line_id,line.id)
1111: AND line.date_cancelled is NULL --LLC BUG FIX 4742661

Line 1322: oks_k_lines_b rline

1318: Cursor line_billed_cur (p_id IN NUMBER) is
1319: SELECT bcl.id ,rline.termn_method,
1320: rline.usage_type, rline.usage_period
1321: FROM oks_bill_cont_lines bcl,
1322: oks_k_lines_b rline
1323: WHERE bcl.cle_id = p_id
1324: AND rline.cle_id = bcl.cle_id
1325: AND bcl.bill_action = 'RI';
1326:

Line 1344: oks_k_lines_b rline

1340: SELECT bsl.id ,rline.TERMN_METHOD ,bcl.cle_id,
1341: rline.usage_type, rline.usage_period
1342: FROM oks_bill_sub_lines bsl,
1343: oks_bill_cont_lines bcl,
1344: oks_k_lines_b rline
1345: WHERE bsl.cle_id = p_id
1346: AND bsl.bcl_id = bcl.id
1347: AND rline.cle_id = bcl.cle_id
1348: AND bcl.bill_action = 'RI';

Line 2680: oks_k_lines_b rline,

2676: rline.cc_expiry_date line_cc_exp_date,
2677: rline.cc_bank_acct_id line_bank_number,
2678: line.bill_to_site_use_id site_use_id
2679: FROM
2680: oks_k_lines_b rline,
2681: okc_k_lines_b line
2682: WHERE line.dnz_chr_id = p_hdr_id
2683: AND line.lse_id in (1,12,19)
2684: AND line.date_cancelled is NULL --LLC BUG FIX 4742661

Line 2793: UPDATE oks_k_lines_b

2789: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in getting bank account for line '||line_cur.line_id);
2790: x_status := 'E';
2791: Raise G_EXCEPTION_HALT_VALIDATION;
2792: ELSE
2793: UPDATE oks_k_lines_b
2794: SET cc_bank_acct_id = x_bank_account_id,
2795: cc_no = line_cur.line_cc_number,
2796: cc_expiry_date = line_Cur.line_cc_exp_date
2797: WHERE cle_id = line_cur.line_id;

Line 3251: FROM oks_k_lines_b s, okc_k_lines_b c

3247: --mchoudha 10-FEB
3248: /* Modified cursor for Bug#14647106 */
3249: Cursor l_usage_csr(p_id in NUMBER) is
3250: SELECT s.usage_type,c.lse_id
3251: FROM oks_k_lines_b s, okc_k_lines_b c
3252: WHERE c.id = p_id
3253: AND s.cle_id = c.id;
3254:
3255: l_start_date_rec l_start_date_csr%ROWTYPE;

Line 4167: from oks_k_lines_b

4163: where id = p_bsl_id;
4164:
4165: Cursor sub_line_tax(p_sub_line_id in number ) is
4166: Select tax_amount
4167: from oks_k_lines_b
4168: where cle_id = p_sub_line_id;
4169:
4170: CURSOR l_line_max_bill_date( p_line_id in NUMBER ) is
4171: SELECT max(bsl.date_billed_to) max_bill_date

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

4825: END IF;
4826: CLOSE check_all_sublines_terminated;
4827: END IF;
4828:
4829: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
4830: oks_k_lines_b oksline, okc_k_lines_b okcline
4831: where okcline.id = oksline.cle_id
4832: and okcline.cle_id = p_id
4833: and okcline.date_cancelled is null )

Line 4830: oks_k_lines_b oksline, okc_k_lines_b okcline

4826: CLOSE check_all_sublines_terminated;
4827: END IF;
4828:
4829: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
4830: oks_k_lines_b oksline, okc_k_lines_b okcline
4831: where okcline.id = oksline.cle_id
4832: and okcline.cle_id = p_id
4833: and okcline.date_cancelled is null )
4834: where topline.cle_id = p_id;

Line 4837: oks_k_lines_b oksline, okc_k_lines_b okcline

4833: and okcline.date_cancelled is null )
4834: where topline.cle_id = p_id;
4835:
4836: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
4837: oks_k_lines_b oksline, okc_k_lines_b okcline
4838: where okcline.id = oksline.cle_id
4839: and okcline.dnz_chr_id = l_line_parameter_rec.p_dnz_chr_id
4840: and okcline.date_cancelled is null
4841: and lse_id in (1,12,19,46) )

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

5091: END IF;
5092:
5093: END IF;
5094:
5095: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
5096: oks_k_lines_b oksline, okc_k_lines_b okcline
5097: where okcline.id = oksline.cle_id
5098: and okcline.cle_id = line_rec.id
5099: and okcline.date_cancelled is null )

Line 5096: oks_k_lines_b oksline, okc_k_lines_b okcline

5092:
5093: END IF;
5094:
5095: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
5096: oks_k_lines_b oksline, okc_k_lines_b okcline
5097: where okcline.id = oksline.cle_id
5098: and okcline.cle_id = line_rec.id
5099: and okcline.date_cancelled is null )
5100: where topline.cle_id = line_rec.id;

Line 5146: update oks_k_lines_b

5142: UPDATE oks_bill_cont_lines
5143: SET amount = l_bcl_credit_amount
5144: WHERE id = l_bcl_update_id ;
5145: If l_bcl_btn_id = -44 and l_bcl_bill_action = 'TR' then
5146: update oks_k_lines_b
5147: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5148: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5149: where cle_id = l_bsl_cle_id;
5150: If l_bcl_cle_id <> l_bsl_cle_id then

Line 5151: update oks_k_lines_b

5147: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5148: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5149: where cle_id = l_bsl_cle_id;
5150: If l_bcl_cle_id <> l_bsl_cle_id then
5151: update oks_k_lines_b
5152: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5153: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5154: where cle_id = l_bcl_cle_id;
5155: End If;

Line 5157: update oks_k_lines_b

5153: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5154: where cle_id = l_bcl_cle_id;
5155: End If;
5156: Elsif l_bcl_btn_id is null and l_bcl_bill_action = 'TR' then
5157: update oks_k_lines_b
5158: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5159: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5160: where cle_id = l_bsl_cle_id;
5161: If l_bcl_cle_id <> l_bsl_cle_id then

Line 5162: update oks_k_lines_b

5158: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5159: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5160: where cle_id = l_bsl_cle_id;
5161: If l_bcl_cle_id <> l_bsl_cle_id then
5162: update oks_k_lines_b
5163: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5164: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5165: where cle_id = l_bcl_cle_id;
5166: End If;

Line 5200: update oks_k_lines_b

5196: IF ( x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5197: RAISE G_EXCEPTION_HALT_VALIDATION;
5198: END IF;
5199: If G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG = 'N' then
5200: update oks_k_lines_b
5201: set tax_amount = G_RAIL_REC.tax_value
5202: where cle_id = l_bsl_cle_id;
5203:
5204: End If;

Line 5221: update oks_k_lines_b

5217: UPDATE oks_bill_cont_lines
5218: SET amount = l_bcl_credit_amount
5219: WHERE id = l_bcl_update_id ;
5220: If l_bcl_btn_id = -44 and l_bcl_bill_action = 'TR' then
5221: update oks_k_lines_b
5222: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5223: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5224: where cle_id = l_bsl_cle_id;
5225: If l_bcl_cle_id <> l_bsl_cle_id then

Line 5226: update oks_k_lines_b

5222: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5223: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5224: where cle_id = l_bsl_cle_id;
5225: If l_bcl_cle_id <> l_bsl_cle_id then
5226: update oks_k_lines_b
5227: set suppressed_credit = suppressed_credit + (l_termination_amount - g_credit_amount)
5228: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5229: where cle_id = l_bcl_cle_id;
5230: End If;

Line 5232: update oks_k_lines_b

5228: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5229: where cle_id = l_bcl_cle_id;
5230: End If;
5231: Elsif l_bcl_btn_id is null and l_bcl_bill_action = 'TR' then
5232: update oks_k_lines_b
5233: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5234: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5235: where cle_id = l_bsl_cle_id;
5236: If l_bcl_cle_id <> l_bsl_cle_id then

Line 5237: update oks_k_lines_b

5233: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5234: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5235: where cle_id = l_bsl_cle_id;
5236: If l_bcl_cle_id <> l_bsl_cle_id then
5237: update oks_k_lines_b
5238: set credit_amount = credit_amount + (l_termination_amount - g_credit_amount)
5239: , override_amount = override_amount - (l_termination_amount - g_credit_amount)
5240: where cle_id = l_bcl_cle_id;
5241: End If;

Line 5275: update oks_k_lines_b

5271: IF ( x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5272: RAISE G_EXCEPTION_HALT_VALIDATION;
5273: END IF;
5274: If G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG = 'N' then
5275: update oks_k_lines_b
5276: set tax_amount = G_RAIL_REC.tax_value
5277: where cle_id = l_bsl_cle_id;
5278:
5279: End If;

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

5280: End If;
5281: End If;
5282: END IF;
5283:
5284: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
5285: oks_k_lines_b oksline, okc_k_lines_b okcline
5286: where okcline.id = oksline.cle_id
5287: and okcline.cle_id = l_bcl_cle_id
5288: and okcline.date_cancelled is null )

Line 5285: oks_k_lines_b oksline, okc_k_lines_b okcline

5281: End If;
5282: END IF;
5283:
5284: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
5285: oks_k_lines_b oksline, okc_k_lines_b okcline
5286: where okcline.id = oksline.cle_id
5287: and okcline.cle_id = l_bcl_cle_id
5288: and okcline.date_cancelled is null )
5289: where topline.cle_id = l_bcl_cle_id;

Line 5359: oks_k_lines_b oksline, okc_k_lines_b okcline

5355:
5356: END IF ; -- l_terminate = TRUE|| ((l_terminate = FALSE) AND (check_all_lines_terminated%NOTFOUND)))
5357:
5358: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
5359: oks_k_lines_b oksline, okc_k_lines_b okcline
5360: where okcline.id = oksline.cle_id
5361: and okcline.dnz_chr_id = p_id
5362: and okcline.date_cancelled is null
5363: and lse_id in (1,12,19,46) )

Line 5409: oks_k_lines_b rline

5405: rline.termn_method,
5406: rline.usage_type,
5407: rline.usage_period
5408: FROM okc_k_lines_b line,
5409: oks_k_lines_b rline
5410: WHERE line.id = p_k_line_id
5411: AND rline.cle_id = line.id;
5412:
5413: CURSOR l_rel_csr Is

Line 6497: FROM oks_k_lines_b okslin, Cs_ctr_counter_values_v ccr

6493:
6494: /*modified for ER 16432647*/
6495: Cursor l_initial_csr Is
6496: SELECT nvl(okslin.base_Reading,0) Base_reading
6497: FROM oks_k_lines_b okslin, Cs_ctr_counter_values_v ccr
6498: WHERE okslin.cle_id = p_cle_id
6499: AND okslin.counter_value_id = ccr.counter_value_id (+)
6500: AND nvl(ccr.valid_flag,'N') = 'N';
6501:

Line 8169: oks_k_lines_b rline

8165: hdr.id
8166: FROM okc_k_lines_b line2,
8167: okc_k_lines_b line1,
8168: okc_k_headers_b hdr,
8169: oks_k_lines_b rline
8170: WHERE line1.id = p_cle_id
8171: AND line2.id = line1.cle_id
8172: AND rline.cle_id = line2.id
8173: AND hdr.id = line1.dnz_chr_id

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

8543:
8544: END IF; -- check_term_cur%NOTFOUND
8545: CLOSE check_term_cur;
8546:
8547: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
8548: oks_k_lines_b oksline, okc_k_lines_b okcline
8549: where okcline.id = oksline.cle_id
8550: and okcline.cle_id = l_top_line_id
8551: and okcline.date_cancelled is null )

Line 8548: oks_k_lines_b oksline, okc_k_lines_b okcline

8544: END IF; -- check_term_cur%NOTFOUND
8545: CLOSE check_term_cur;
8546:
8547: update oks_k_lines_b topline set topline.tax_amount = ( select sum(tax_amount) from
8548: oks_k_lines_b oksline, okc_k_lines_b okcline
8549: where okcline.id = oksline.cle_id
8550: and okcline.cle_id = l_top_line_id
8551: and okcline.date_cancelled is null )
8552: where topline.cle_id = l_top_line_id;

Line 8555: oks_k_lines_b oksline, okc_k_lines_b okcline

8551: and okcline.date_cancelled is null )
8552: where topline.cle_id = l_top_line_id;
8553:
8554: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
8555: oks_k_lines_b oksline, okc_k_lines_b okcline
8556: where okcline.id = oksline.cle_id
8557: and okcline.dnz_chr_id = l_hdr_id
8558: and okcline.date_cancelled is null
8559: and lse_id in (1,12,19,46) )

Line 8612: FROM oks_k_lines_b

8608:
8609:
8610: Cursor l_usage_csr(p_id in NUMBER) is
8611: SELECT usage_type
8612: FROM oks_k_lines_b
8613: WHERE cle_id = p_id ;
8614:
8615: -- BUG#3312595 mchoudha: Cursor to check for service request
8616: -- against the subline

Line 9055: ,OKS_K_LINES_B OKSL

9051: ,nvl(SUM(credit_amount),0) credited
9052: ,nvl(SUM(suppressed_credit),0) suppressed
9053: ,nvl(SUM(override_amount),0) overridden
9054: FROM OKC_K_LINES_B OKCL
9055: ,OKS_K_LINES_B OKSL
9056: WHERE OKCL.dnz_chr_id = p_id
9057: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9058: AND OKCL.id = OKSL.cle_id
9059: AND NOT exists (select 'x' from okc_k_lines_b cle,

Line 9060: oks_k_lines_b kln

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

Line 9078: oks_k_lines_b kln

9074: AND OKCL.id = BSL.cle_id
9075: AND BSL.bcl_id = BCL.id
9076: AND BCL.bill_action = 'RI'
9077: AND NOT exists (select 'x' from okc_k_lines_b cle,
9078: oks_k_lines_b kln
9079: where cle.id = OKCL.cle_id
9080: and kln.cle_id = cle.id
9081: and kln.usage_type in ('VRT','QTY','FRT'));
9082:

Line 9093: ,OKS_K_LINES_B OKSL

9089: ,nvl(SUM(credit_amount),0) credited
9090: ,nvl(SUM(suppressed_credit),0) suppressed
9091: ,nvl(SUM(override_amount),0) overridden
9092: FROM OKC_K_LINES_B OKCL
9093: ,OKS_K_LINES_B OKSL
9094: WHERE ( OKCL.cle_id = p_id
9095: OR (OKCL.id = p_id and OKCL.lse_id = 46 ))
9096: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9097: AND OKCL.id = OKSL.cle_id

Line 9099: oks_k_lines_b kln

9095: OR (OKCL.id = p_id and OKCL.lse_id = 46 ))
9096: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9097: AND OKCL.id = OKSL.cle_id
9098: AND NOT exists (select 'x' from okc_k_lines_b cle,
9099: oks_k_lines_b kln
9100: where cle.id = OKCL.cle_id
9101: and kln.cle_id = cle.id
9102: and kln.usage_type in ('VRT','QTY','FRT'));
9103:

Line 9119: oks_k_lines_b kln

9115: AND OKCL.id = BSL.cle_id
9116: AND BSL.bcl_id = BCL.id
9117: AND BCL.bill_action = 'RI'
9118: AND NOT exists (select 'x' from okc_k_lines_b cle,
9119: oks_k_lines_b kln
9120: where cle.id = OKCL.cle_id
9121: and kln.cle_id = cle.id
9122: and kln.usage_type in ('VRT','QTY','FRT'));
9123:

Line 9131: FROM OKS_K_LINES_B OKSL

9127: SELECT nvl(SUM(ubt_amount),0) unbilled
9128: ,nvl(SUM(credit_amount),0) credited
9129: ,nvl(SUM(suppressed_credit),0) suppressed
9130: ,nvl(SUM(override_amount),0) overridden
9131: FROM OKS_K_LINES_B OKSL
9132: WHERE OKSL.cle_id = p_id;
9133:
9134: CURSOR l_SUB_LINE_BILLED_CSR IS
9135: SELECT nvl(SUM(BSL.amount),0) billed

Line 9257: OKS_K_LINES_B OKS

9253:
9254: CURSOR l_check_for_full_credit(p_top_line_id in NUMBER ) is
9255: SELECT count(oks.full_credit)
9256: FROM OKC_K_LINES_B OKC,
9257: OKS_K_LINES_B OKS
9258: WHERE OKC.cle_ID = p_top_line_id
9259: AND OKC.id = OKS.CLE_id
9260: and OKC.lse_id in (7,8,9,10,11,13,18,25,35)
9261: and OKC.date_cancelled is NULL --LLC BUG FIX 4742661

Line 9272: oks_k_lines_b kln

9268: Cursor l_usage_type_csr(p_sub_line_id in number) Is
9269: Select kln.usage_type
9270: from okc_k_lines_b cle1,
9271: okc_k_lines_b cle2,
9272: oks_k_lines_b kln
9273: where cle1.id = p_sub_line_id
9274: and cle2.id = cle1.cle_id
9275: and kln.cle_id = cle2.id;
9276:

Line 9279: from oks_k_lines_b

9275: and kln.cle_id = cle2.id;
9276:
9277: Cursor l_usage_type_csr1(p_top_line_id in number) Is
9278: Select usage_type
9279: from oks_k_lines_b
9280: where cle_id = p_top_line_id;
9281:
9282: Cursor l_ubt_csr(p_id in number) IS
9283: SELECT ubt_amount

Line 9284: FROM OKS_K_LINES_B

9280: where cle_id = p_top_line_id;
9281:
9282: Cursor l_ubt_csr(p_id in number) IS
9283: SELECT ubt_amount
9284: FROM OKS_K_LINES_B
9285: WHERE cle_id = p_id;
9286:
9287: /*Added for bug:10285124*/
9288: Cursor sub_line_tax_check(p_sub_line_id in number ) is

Line 9290: from oks_k_lines_b

9286:
9287: /*Added for bug:10285124*/
9288: Cursor sub_line_tax_check(p_sub_line_id in number ) is
9289: Select tax_amount
9290: from oks_k_lines_b
9291: where cle_id = p_sub_line_id;
9292:
9293:
9294:

Line 9516: UPDATE OKS_K_LINES_B

9512: l_currency_code);
9513: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9514: l_currency_code);
9515:
9516: UPDATE OKS_K_LINES_B
9517: SET UBT_AMOUNT = l_ubt_amount ,
9518: CREDIT_AMOUNT = l_credit ,
9519: SUPPRESSED_CREDIT = l_suppressed_credit ,
9520: OVERRIDE_AMOUNT = l_overridden ,

Line 9535: Update OKS_K_lines_b

9531:
9532: ---if only subline is terminated, then also update top line ubt, credit_amt,suppressed_credit field
9533: --so that actual line amt can be found.
9534:
9535: Update OKS_K_lines_b
9536: set ubt_amount = nvl(ubt_amount,0) + nvl(l_ubt_amount,0),
9537: CREDIT_AMOUNT = nvl(CREDIT_AMOUNT,0) + nvl(l_credit,0) ,
9538: SUPPRESSED_CREDIT = nvl(SUPPRESSED_CREDIT,0) + nvl(l_suppressed_credit,0)
9539: WHERE cle_id = l_top_line_id;

Line 9695: UPDATE OKS_K_LINES_B

9691: l_currency_code);
9692: l_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_overridden,
9693: l_currency_code);
9694:
9695: UPDATE OKS_K_LINES_B
9696: SET UBT_AMOUNT = l_ubt_amount ,
9697: CREDIT_AMOUNT = l_credit ,
9698: SUPPRESSED_CREDIT= l_suppressed_credit ,
9699: OVERRIDE_AMOUNT = l_overridden,

Line 9741: UPDATE OKS_K_LINES_B

9737: End If;
9738:
9739: -- Update of tax amount for top line is comented out as part of BUG#3278807
9740: --changed for copy bug.
9741: UPDATE OKS_K_LINES_B
9742: SET UBT_AMOUNT = nvl(UBT_AMOUNT,0) + nvl(l_tot_ubt_amount,0) ,
9743: CREDIT_AMOUNT = nvl(CREDIT_AMOUNT,0) + nvl(l_tot_credit,0) ,
9744: SUPPRESSED_CREDIT = nvl(SUPPRESSED_CREDIT,0) + nvl(l_tot_suppressed_credit,0) ,
9745: OVERRIDE_AMOUNT = l_tot_overridden,

Line 9834: UPDATE OKS_K_LINES_B

9830: l_tot_overridden := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_tot_overridden,
9831: l_currency_code);
9832:
9833:
9834: UPDATE OKS_K_LINES_B
9835: SET UBT_AMOUNT = l_tot_ubt_amount ,
9836: CREDIT_AMOUNT = l_tot_credit ,
9837: SUPPRESSED_CREDIT = l_tot_suppressed_credit ,
9838: OVERRIDE_AMOUNT = l_tot_overridden,

Line 9978: oks_k_lines_b rline,

9974: rline.price_uom,
9975: line.price_negotiated total_amount,
9976: rline.toplvl_uom_code
9977: FROM okc_k_lines_b line,
9978: oks_k_lines_b rline,
9979: okc_k_items itm
9980: WHERE line.cle_id = p_cle_id
9981: AND line.lse_id in (7,8,9,10,11,13,25,35)
9982: AND line.id = nvl(p_cp_line_id,line.id)

Line 10272: UPDATE OKS_K_LINES_B

10268: UPDATE OKC_K_LINES_B
10269: SET price_negotiated = l_new_price
10270: WHERE id = cur.id;
10271:
10272: UPDATE OKS_K_LINES_B
10273: SET UBT_AMOUNT = l_ubt_amount
10274: WHERE cle_id = cur.id;
10275:
10276:

Line 10454: oks_k_lines_b rline,

10450: rline.price_uom,
10451: rline.toplvl_uom_code,
10452: line.price_negotiated total_amount
10453: FROM okc_k_lines_b line,
10454: oks_k_lines_b rline,
10455: okc_k_items itm
10456: WHERE line.id = p_id
10457: AND rline.cle_id = line.id
10458: AND itm.cle_id = line.id

Line 10472: oks_k_lines_b rline,

10468: rline.price_uom,
10469: rline.toplvl_uom_code,
10470: line.price_negotiated total_amount
10471: FROM okc_k_lines_b line,
10472: oks_k_lines_b rline,
10473: okc_k_items itm
10474: WHERE line.cle_id = p_cle_id
10475: AND itm.cle_id = line.id
10476: AND rline.cle_id = line.id