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.OKL_STREAM_BILLING_PUB dependencies on OKL_TXL_AR_INV_LNS_V

Line 185: okl_txl_ar_inv_lns_v b,

181:
182: CURSOR txd_cnt_succ_csr( p_req_id NUMBER ) IS
183: SELECT count(*)
184: FROM okl_trx_ar_invoices_v a,
185: okl_txl_ar_inv_lns_v b,
186: okl_txd_ar_ln_dtls_v c
187: WHERE a.id = b.tai_id AND
188: b.id = c.til_id_details AND
189: a.trx_status_code = 'PROCESSED' AND

Line 195: okl_txl_ar_inv_lns_v b,

191:
192: CURSOR txd_cnt_err_csr( p_req_id NUMBER ) IS
193: SELECT count(*)
194: FROM okl_trx_ar_invoices_v a,
195: okl_txl_ar_inv_lns_v b,
196: okl_txd_ar_ln_dtls_v c
197: WHERE a.id = b.tai_id AND
198: b.id = c.til_id_details AND
199: a.trx_status_code = 'ERROR' AND