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_BILL_SUB_LINES

Line 257: oks_bill_sub_lines bsl

253: Cursor l_date_csr Is
254: SELECT Min(bsl.DATE_BILLED_FROM)
255: ,Max(bsl.DATE_BILLED_TO)
256: FROM oks_bill_cont_lines bcl ,
257: oks_bill_sub_lines bsl
258: WHERE bsl.cle_id = p_cle_id
259: AND bsl.bcl_id = bcl.id
260: AND bcl.bill_action <> 'AVG';
261:

Line 265: oks_bill_sub_lines bsl,

261:
262: Cursor l_tot_csr Is
263: SELECT NVL(Sum(NVL(bsd.Result,0)),0)
264: FROM oks_bill_cont_lines bcl,
265: oks_bill_sub_lines bsl,
266: oks_bill_sub_line_dtls bsd
267: WHERE bsl.cle_id = p_cle_id
268: AND bsl.bcl_id = bcl.id
269: AND bcl.bill_action <> 'AVG'

Line 662: oks_bill_sub_lines bsl,

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
666: AND rline.cle_id = bsl.cle_id

Line 1481: Delete from OKS_BILL_SUB_LINES

1477: Delete from OKS_BILL_SUB_LINE_DTLS
1478: where bsl_id in
1479: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1480:
1481: Delete from OKS_BILL_SUB_LINES
1482: where id in
1483: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1484:
1485: Delete from OKS_BILL_CONT_LINES

Line 3683: oks_bill_sub_lines bsl,

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
3687: AND rline.cle_id = bsl.cle_id

Line 6999: oks_bill_sub_lines bsl,

6995: bsl.cle_id bsl_cle_id,
6996: abs(bsl.amount) bsl_amount,
6997: line.lse_id bcl_lse_id
6998: FROM okc_k_headers_b hdr,
6999: oks_bill_sub_lines bsl,
7000: oks_bill_cont_lines bcl,
7001: okc_k_lines_b line
7002: WHERE line.id = bcl.cle_id
7003: AND hdr.id = line.dnz_chr_id

Line 7025: oks_bill_sub_lines bsl,

7021: bsl.cle_id bsl_cle_id,
7022: abs(bsl.amount) bsl_amount,
7023: line.lse_id bcl_lse_id
7024: FROM okc_k_headers_b hdr,
7025: oks_bill_sub_lines bsl,
7026: oks_bill_cont_lines bcl,
7027: okc_k_lines_b line
7028: WHERE line.id = bcl.cle_id
7029: AND hdr.id = line.dnz_chr_id

Line 7049: oks_bill_sub_lines bsl,

7045: bsl.cle_id bsl_cle_id,
7046: abs(bsl.amount) bsl_amount,
7047: line.lse_id bcl_lse_id
7048: FROM okc_k_headers_b hdr,
7049: oks_bill_sub_lines bsl,
7050: oks_bill_cont_lines bcl,
7051: okc_k_lines_b line
7052: WHERE line.id = bcl.cle_id
7053: AND hdr.id = line.dnz_chr_id