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.JAI_AR_VALIDATE_DATA_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 480: ra_cust_trx_types_all rctta

476: IS
477: SELECT count(*)
478: FROM ra_customer_trx_all rcta,
479: ra_customer_trx_lines_all rctla,
480: ra_cust_trx_types_all rctta
481: WHERE rcta.customer_trx_id = rctla.customer_trx_id
482: AND rcta.cust_trx_type_id = rctta.cust_trx_type_id
483: AND rctta.type = 'CM'
484: AND rctla. previous_customer_trx_id IS NOT NULL

Line 577: ra_cust_trx_types_all rctta /* added by aiyer to check that only INV and CM type of transactions are picked up */

573: rcta.set_of_books_id ,
574: rctta.type
575: FROM ra_customer_trx_all rcta ,
576: JAI_AR_TRXS jrcta ,
577: ra_cust_trx_types_all rctta /* added by aiyer to check that only INV and CM type of transactions are picked up */
578: WHERE rcta.customer_trx_id = jrcta.customer_trx_id
579: AND rcta.cust_trx_type_id = rctta.cust_trx_type_id
580: AND nvl(rctta.type,'###') IN ('INV','CM')
581: AND jrcta.customer_trx_id = NVL(cp_customer_trx_id, jrcta.customer_trx_id)