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_BILLING_RECON_RPT_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 112: ra_customer_trx_lines_all line,

108: count(*) cnt,
109: SUM(NVL(line.EXTENDED_AMOUNT,0)) Invoice_Amount,
110: hdr.invoice_currency_code
111: FROM ra_customer_trx_all hdr,
112: ra_customer_trx_lines_all line,
113: ra_batch_sources_all batch,
114: RA_CUST_TRX_TYPES_ALL trx_type
115: WHERE line.customer_trx_id = hdr.customer_trx_id
116: AND hdr.batch_source_id = batch.batch_source_id

Line 245: ra_customer_trx_lines_all line,

241: hdr.invoice_currency_code,
242: hdr.INTERFACE_HEADER_ATTRIBUTE6 Contract_Number--,
243: -- decode(trx_type.TYPE,'INV','Invoice','CM','Credit Memo') Invoice_Type
244: FROM ra_customer_trx_all hdr,
245: ra_customer_trx_lines_all line,
246: ra_batch_sources_all batch,
247: RA_CUST_TRX_TYPES_ALL trx_type
248: WHERE line.customer_trx_id = hdr.customer_trx_id
249: AND hdr.batch_source_id = batch.batch_source_id