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_CUST_TRX_TYPES_ALL

Line 114: RA_CUST_TRX_TYPES_ALL trx_type

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
117: AND batch.name = 'OKL_CONTRACTS'
118: AND line.line_type = 'LINE'

Line 135: RA_CUST_TRX_TYPES_ALL trx_type

131: SELECT count(*) cnt,
132: SUM(AMOUNT) Invoice_amt,
133: hdr.currency_code
134: FROM ra_interface_lines_all hdr,
135: RA_CUST_TRX_TYPES_ALL trx_type
136: WHERE hdr.CUST_TRX_TYPE_ID = trx_type.CUST_TRX_TYPE_ID
137: AND hdr.currency_code = p_currency_code
138: AND hdr.batch_source_name = 'OKL_CONTRACTS'
139: AND hdr.interface_line_attribute6

Line 247: RA_CUST_TRX_TYPES_ALL trx_type

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
250: AND batch.name = 'OKL_CONTRACTS'
251: AND line.line_type = 'LINE'

Line 277: RA_CUST_TRX_TYPES_ALL trx_type

273: hdr.currency_code,
274: interface_line_attribute6--,
275: --decode(trx_type.TYPE,'INV','Invoice','CM','Credit Memo') Invoice_Type
276: FROM ra_interface_lines_all hdr,
277: RA_CUST_TRX_TYPES_ALL trx_type
278: WHERE hdr.batch_source_name = 'OKL_CONTRACTS'
279: AND hdr.CUST_TRX_TYPE_ID = trx_type.CUST_TRX_TYPE_ID
280: AND hdr.INTERFACE_LINE_ATTRIBUTE6 =
281: NVL(rtrim(ltrim( p_in_contract_number)),hdr.INTERFACE_LINE_ATTRIBUTE6)

Line 344: RA_CUST_TRX_TYPES_ALL trx_type,

340: decode(trx_type.TYPE,'INV','Invoice','CM','Credit Memo') Invoice_Type,
341: trx_date due_date,
342: err.MESSAGE_TEXT remarks
343: FROM ra_interface_lines_all hdr,
344: RA_CUST_TRX_TYPES_ALL trx_type,
345: ra_interface_errors_all err
346: WHERE hdr.batch_source_name = 'OKL_CONTRACTS'
347: AND hdr.CUST_TRX_TYPE_ID = trx_type.CUST_TRX_TYPE_ID
348: AND hdr.INTERFACE_LINE_ATTRIBUTE6 =