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_ALL

Line 111: FROM ra_customer_trx_all hdr,

107: SELECT
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

Line 244: FROM ra_customer_trx_all hdr,

240: SUM(NVL(line.EXTENDED_AMOUNT,0)) Invoice_Amount,
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