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_CONT_LINES

Line 256: FROM oks_bill_cont_lines bcl ,

252:
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';

Line 264: FROM oks_bill_cont_lines bcl,

260: AND bcl.bill_action <> 'AVG';
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

Line 3498: oks_bill_cont_lines bcl,

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
3502: AND hdr.id = nvl(p_contract_hdr_id,hdr.id) --Full Table Scan due to nvl condition

Line 3524: oks_bill_cont_lines bcl,

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
3528: AND hdr.id = p_contract_hdr_id

Line 3548: oks_bill_cont_lines bcl,

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
3552: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 3612: UPDATE oks_bill_cont_lines bcl

3608: To avoid process these records bill_action = 'TR' condition is added
3609: in below where clause
3610: */
3611:
3612: UPDATE oks_bill_cont_lines bcl
3613: SET bcl.btn_id = NULL
3614: WHERE bcl.btn_id = -44
3615: AND bcl.bill_Action = 'TR'
3616: AND EXISTS

Line 3655: UPDATE oks_bill_cont_lines bcl

3651: To avoid process these records bill_action = 'TR' condition is added
3652: in below where clause
3653: */
3654:
3655: UPDATE oks_bill_cont_lines bcl
3656: SET bcl.btn_id = NULL
3657: WHERE bcl.btn_id = -44
3658: AND bcl.bill_Action = 'TR'
3659: AND EXISTS

Line 3679: UPDATE oks_bill_cont_lines bcl

3675: --To avoid process these records bill_action = 'TR' condition is added
3676: --in below where clause
3677:
3678:
3679: UPDATE oks_bill_cont_lines bcl
3680: SET bcl.btn_id = NULL
3681: WHERE bcl.btn_id = -44
3682: AND bcl.bill_Action = 'TR'
3683: AND EXISTS