APPS.OKS_BILLING_PUB dependencies on OKS_K_LINES_B

Line 92: FROM oks_k_lines_b

88: ,usage_duration usage_duration
89: ,level_yn level_yn
90: ,base_reading base_reading
91: ,usage_type usage_Type
92: FROM oks_k_lines_b
93: WHERE cle_id = p_id ;
94:
95: l_bill_qty_rec l_bill_qty_csr%rowtype;
96: l_from_date DATE;

Line 549: FROM OKS_K_LINES_B

545: usage_period Usage_period,
546: prorate Prorate,
547: locked_price_list_id locked_price_list_id,
548: locked_price_list_line_id locked_price_list_line_id
549: FROM OKS_K_LINES_B
550: WHERE cle_id = p_cle_id ;
551:
552: Cursor qty_uom_csr_sub(p_cle_id Number) Is
553: SELECT okc.Number_of_items

Line 578: oks_k_lines_b rline,

574: rline.locked_price_list_id,
575: rline.locked_price_list_line_id,
576: rline.dnz_chr_id
577: FROM
578: oks_k_lines_b rline,
579: oks_bill_sub_lines bsl,
580: oks_bill_sub_line_dtls bsd
581: WHERE bsl.bcl_id = p_bcl_id
582: AND bsl.id = bsd.bsl_id

Line 593: oks_k_lines_b rline,

589: rline.LOCKED_PRICE_LIST_ID,
590: rline.locked_price_list_line_id,
591: rline.dnz_chr_id
592: FROM
593: oks_k_lines_b rline,
594: oks_bsl_pr bsl,
595: oks_bsd_pr bsd
596: WHERE bsl.bcl_id = p_bcl_id
597: AND bsl.id = bsd.bsl_id

Line 625: OKS_K_LINES_B rul

621: ,rul.usage_est_yn usage_est_yn
622: ,rul.usage_est_method usage_est_method
623: ,rul.usage_est_start_date usage_est_start_date
624: FROM OKC_K_LINES_B sub_line ,
625: OKS_K_LINES_B rul
626: WHERE sub_line.cle_id = p_cle_id
627: AND sub_line.date_cancelled is NULL --[llc]
628: AND sub_line.id = rul.cle_id
629: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)

Line 2336: ,OKS_K_LINES_B rline

2332: ,rline.settlement_interval
2333: FROM
2334: OKC_K_PARTY_ROLES_B okp
2335: ,OKC_K_LINES_B line
2336: ,OKS_K_LINES_B rline
2337: ,OKC_K_HEADERS_B Hdr
2338: ,OKS_K_HEADERS_B rul
2339: WHERE Hdr.id = p_hdr_id
2340: AND line.id = p_line_id

Line 3591: UPDATE oks_k_lines_b

3587: LOOP
3588:
3589: /*Update subline info*/
3590: IF (cur.bcl_lse_id <> 46) THEN
3591: UPDATE oks_k_lines_b
3592: SET credit_amount = nvl(credit_amount,0) + nvl(cur.bsl_amount,0) ,
3593: suppressed_credit = nvl(suppressed_credit,0) - nvl(cur.bsl_amount,0)
3594: WHERE cle_id = cur.bsl_cle_id;
3595: END IF;

Line 3598: UPDATE oks_k_lines_b

3594: WHERE cle_id = cur.bsl_cle_id;
3595: END IF;
3596:
3597: /*Update topline info*/
3598: UPDATE oks_k_lines_b
3599: SET credit_amount = nvl(credit_amount,0) + nvl(cur.bsl_amount,0) ,
3600: suppressed_credit = nvl(suppressed_credit,0) - nvl(cur.bsl_amount,0)
3601: WHERE cle_id = cur.bcl_cle_id;
3602:

Line 3634: UPDATE oks_k_lines_b

3630: LOOP
3631:
3632: /*Update subline info*/
3633: IF (cur.bcl_lse_id <> 46) THEN
3634: UPDATE oks_k_lines_b
3635: SET credit_amount = nvl(credit_amount,0) + nvl(cur.bsl_amount,0) ,
3636: suppressed_credit = nvl(suppressed_credit,0) - nvl(cur.bsl_amount,0)
3637: WHERE cle_id = cur.bsl_cle_id;
3638: END IF;

Line 3641: UPDATE oks_k_lines_b

3637: WHERE cle_id = cur.bsl_cle_id;
3638: END IF;
3639:
3640: /*Update topline info*/
3641: UPDATE oks_k_lines_b
3642: SET credit_amount = nvl(credit_amount,0) + nvl(cur.bsl_amount,0) ,
3643: suppressed_credit = nvl(suppressed_credit,0) - nvl(cur.bsl_amount,0)
3644: WHERE cle_id = cur.bcl_cle_id;
3645: