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.AR_INVOICE_SQL_FUNC_PUB dependencies on RA_CUST_TRX_TYPES

Line 180: ra_cust_trx_types type,

176:
177: SELECT NVL(SUM(adj.amount),0)
178: INTO commit_adjustments
179: FROM ra_customer_trx trx,
180: ra_cust_trx_types type,
181: ar_adjustments adj
182: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
183: AND type.type in ('INV', 'CM')
184: AND trx.complete_flag ='Y'

Line 197: ra_cust_trx_types type,

193:
194: SELECT NVL(SUM(line.extended_amount),0)
195: INTO commit_total_activity
196: FROM ra_customer_trx trx,
197: ra_cust_trx_types type,
198: ra_customer_trx_lines line
199: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
200: AND trx.customer_trx_id = line.customer_trx_id
201: AND type.type = 'CM'

Line 352: ra_cust_trx_types type,

348:
349: SELECT NVL(SUM(adj.amount),0)
350: INTO commit_adjustments
351: FROM ra_customer_trx trx,
352: ra_cust_trx_types type,
353: ar_adjustments adj
354: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
355: AND type.type in ('INV', 'CM')
356: AND trx.complete_flag ='Y'

Line 369: ra_cust_trx_types type,

365:
366: SELECT NVL(SUM(line.extended_amount),0)
367: INTO commit_total_activity
368: FROM ra_customer_trx trx,
369: ra_cust_trx_types type,
370: ra_customer_trx_lines line
371: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
372: AND trx.customer_trx_id = line.customer_trx_id
373: AND type.type = 'CM'