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_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 632: FROM OKS_K_LINES_B

628: usage_period Usage_period,
629: prorate Prorate,
630: locked_price_list_id locked_price_list_id,
631: locked_price_list_line_id locked_price_list_line_id
632: FROM OKS_K_LINES_B
633: WHERE cle_id = p_cle_id ;
634:
635: Cursor qty_uom_csr_sub(p_cle_id Number) Is
636: SELECT okc.Number_of_items

Line 661: oks_k_lines_b rline,

657: rline.locked_price_list_id,
658: rline.locked_price_list_line_id,
659: rline.dnz_chr_id
660: FROM
661: oks_k_lines_b rline,
662: oks_bill_sub_lines bsl,
663: oks_bill_sub_line_dtls bsd
664: WHERE bsl.bcl_id = p_bcl_id
665: AND bsl.id = bsd.bsl_id

Line 676: oks_k_lines_b rline,

672: rline.LOCKED_PRICE_LIST_ID,
673: rline.locked_price_list_line_id,
674: rline.dnz_chr_id
675: FROM
676: oks_k_lines_b rline,
677: oks_bsl_pr bsl,
678: oks_bsd_pr bsd
679: WHERE bsl.bcl_id = p_bcl_id
680: AND bsl.id = bsd.bsl_id

Line 708: OKS_K_LINES_B rul

704: ,rul.usage_est_yn usage_est_yn
705: ,rul.usage_est_method usage_est_method
706: ,rul.usage_est_start_date usage_est_start_date
707: FROM OKC_K_LINES_B sub_line ,
708: OKS_K_LINES_B rul
709: WHERE sub_line.cle_id = p_cle_id
710: AND sub_line.date_cancelled is NULL --[llc]
711: AND sub_line.id = rul.cle_id
712: AND sub_line.lse_id in (8,7,9,10,11,13,25,35);

Line 3653: FROM OKS_K_LINES_B

3649: usage_period Usage_period,
3650: prorate Prorate,
3651: locked_price_list_id locked_price_list_id,
3652: locked_price_list_line_id locked_price_list_line_id
3653: FROM OKS_K_LINES_B
3654: WHERE cle_id = p_cle_id ;
3655:
3656: Cursor qty_uom_csr_sub(p_cle_id Number) Is
3657: SELECT okc.Number_of_items

Line 3682: oks_k_lines_b rline,

3678: rline.locked_price_list_id,
3679: rline.locked_price_list_line_id,
3680: rline.dnz_chr_id
3681: FROM
3682: oks_k_lines_b rline,
3683: oks_bill_sub_lines bsl,
3684: oks_bill_sub_line_dtls bsd
3685: WHERE bsl.bcl_id = p_bcl_id
3686: AND bsl.id = bsd.bsl_id

Line 3697: oks_k_lines_b rline,

3693: rline.LOCKED_PRICE_LIST_ID,
3694: rline.locked_price_list_line_id,
3695: rline.dnz_chr_id
3696: FROM
3697: oks_k_lines_b rline,
3698: oks_bsl_pr bsl,
3699: oks_bsd_pr bsd
3700: WHERE bsl.bcl_id = p_bcl_id
3701: AND bsl.id = bsd.bsl_id

Line 3729: OKS_K_LINES_B rul

3725: ,rul.usage_est_yn usage_est_yn
3726: ,rul.usage_est_method usage_est_method
3727: ,rul.usage_est_start_date usage_est_start_date
3728: FROM OKC_K_LINES_B sub_line ,
3729: OKS_K_LINES_B rul
3730: WHERE sub_line.cle_id = p_cle_id
3731: AND sub_line.date_cancelled is NULL --[llc]
3732: AND sub_line.id = rul.cle_id
3733: AND sub_line.lse_id in (8,7,9,10,11,13,25,35);

Line 5397: ,OKS_K_LINES_B rline

5393: ,rline.settlement_interval
5394: FROM
5395: OKC_K_PARTY_ROLES_B okp
5396: ,OKC_K_LINES_B line
5397: ,OKS_K_LINES_B rline
5398: ,OKC_K_HEADERS_B Hdr
5399: ,OKS_K_HEADERS_B rul
5400: WHERE Hdr.id = p_hdr_id
5401: AND line.id = p_line_id

Line 7093: UPDATE oks_k_lines_b

7089: LOOP
7090:
7091: /*Update subline info*/
7092: IF (cur.bcl_lse_id <> 46) THEN
7093: UPDATE oks_k_lines_b
7094: SET credit_amount = nvl(credit_amount,0) + nvl(cur.bsl_amount,0) ,
7095: suppressed_credit = nvl(suppressed_credit,0) - nvl(cur.bsl_amount,0)
7096: WHERE cle_id = cur.bsl_cle_id;
7097: END IF;

Line 7100: UPDATE oks_k_lines_b

7096: WHERE cle_id = cur.bsl_cle_id;
7097: END IF;
7098:
7099: /*Update topline info*/
7100: UPDATE oks_k_lines_b
7101: SET credit_amount = nvl(credit_amount,0) + nvl(cur.bsl_amount,0) ,
7102: suppressed_credit = nvl(suppressed_credit,0) - nvl(cur.bsl_amount,0)
7103: WHERE cle_id = cur.bcl_cle_id;
7104:

Line 7136: UPDATE oks_k_lines_b

7132: LOOP
7133:
7134: /*Update subline info*/
7135: IF (cur.bcl_lse_id <> 46) THEN
7136: UPDATE oks_k_lines_b
7137: SET credit_amount = nvl(credit_amount,0) + nvl(cur.bsl_amount,0) ,
7138: suppressed_credit = nvl(suppressed_credit,0) - nvl(cur.bsl_amount,0)
7139: WHERE cle_id = cur.bsl_cle_id;
7140: END IF;

Line 7143: UPDATE oks_k_lines_b

7139: WHERE cle_id = cur.bsl_cle_id;
7140: END IF;
7141:
7142: /*Update topline info*/
7143: UPDATE oks_k_lines_b
7144: SET credit_amount = nvl(credit_amount,0) + nvl(cur.bsl_amount,0) ,
7145: suppressed_credit = nvl(suppressed_credit,0) - nvl(cur.bsl_amount,0)
7146: WHERE cle_id = cur.bcl_cle_id;
7147: