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 579: oks_bill_sub_lines bsl,

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

Line 3497: oks_bill_sub_lines bsl,

3493: bsl.cle_id bsl_cle_id,
3494: abs(bsl.amount) bsl_amount,
3495: line.lse_id bcl_lse_id
3496: FROM okc_k_headers_b hdr,
3497: oks_bill_sub_lines bsl,
3498: oks_bill_cont_lines bcl,
3499: okc_k_lines_b line
3500: WHERE line.id = bcl.cle_id
3501: AND hdr.id = line.dnz_chr_id

Line 3523: oks_bill_sub_lines bsl,

3519: bsl.cle_id bsl_cle_id,
3520: abs(bsl.amount) bsl_amount,
3521: line.lse_id bcl_lse_id
3522: FROM okc_k_headers_b hdr,
3523: oks_bill_sub_lines bsl,
3524: oks_bill_cont_lines bcl,
3525: okc_k_lines_b line
3526: WHERE line.id = bcl.cle_id
3527: AND hdr.id = line.dnz_chr_id

Line 3547: oks_bill_sub_lines bsl,

3543: bsl.cle_id bsl_cle_id,
3544: abs(bsl.amount) bsl_amount,
3545: line.lse_id bcl_lse_id
3546: FROM okc_k_headers_b hdr,
3547: oks_bill_sub_lines bsl,
3548: oks_bill_cont_lines bcl,
3549: okc_k_lines_b line
3550: WHERE line.id = bcl.cle_id
3551: AND hdr.id = line.dnz_chr_id